Easily Check Database Integrity (DBCC CHECKDB) For All Databases On A Server — Parv The IT Geek

Today I was doing my daily checks on one of my biggest SQL instances which has over 1,000 databases and noticed that SQL Agent was stopped. I couldn’t see any errors and was able to simply start it without any problems but I was concerned that the daily integrity check jobs had not run andContinue reading “Easily Check Database Integrity (DBCC CHECKDB) For All Databases On A Server — Parv The IT Geek”

What are the SQL Server System databases? — Parv The IT Geek

SQL Server System databases SQL Server has 5 very default system databases which are Master As the name implies this is one of the most important databases on the system and without it SQL Server will not start. It stores all the configuration of the instance and all other databases which are subsequently created. TheContinue reading “What are the SQL Server System databases? — Parv The IT Geek”

What is Business Intelligence ( BI )?

What is Business Intelligence ( BI )? Business Intelligence Development Studio ( BIDS )? SQL Server Reporting Services ( SSRS )? SQL Server Integration Services ( SSIS )? SQL Server Analysis Services ( SSAS )? What is Business Intelligence ( BI )? Business intelligence is simply using software to manage large amounts of data toContinue reading “What is Business Intelligence ( BI )?”

How can I find out what SQL Server version is running? — Parv The IT Geek

I was asked by someone which SQL Server version a server was running and was surprised when my DBA colleague said to run a stored procedure I had never heard of. I had not thought that there would be more than one way as the usual method I used below was so simple I didn’tContinue reading “How can I find out what SQL Server version is running? — Parv The IT Geek”

What are DDL , DML, DCL and TCL ? — Parv The IT Geek

These are used to create and manage the structure of objects within a database. For example, CREATE, DROP, ALTER commands ON tables, views, indexes, keys… DML — Data Manipulation Language These are the commands used to actually query, modify and delete data within a database. For example SELECT, INSERT, UPDATE, DELETE. DCL — Data Control Language These are usedContinue reading “What are DDL , DML, DCL and TCL ? — Parv The IT Geek”

Create a new column with an Expression — Parv The IT Geek

Sometimes there may be a requirement to create a new column based upon existing columns with a minor manipulation. For example in the AdventureWorks database the table TransactionHistoryArchive shows the quantity and the actual cost of each unit but not the total value of the order. That would be achieved by multiplying the Quantity andContinue reading “Create a new column with an Expression — Parv The IT Geek”

AS — Rename output columns — Parv The IT Geek

Sometimes when you run a query you may want to rename the columns in the results. This is quite a simple process within SQL. First you will need to know the source column names. For example USE AdventureWorks SELECT * FROM [HumanResources].[Department] Or you can open up the table which gives the column names. YouContinue reading “AS — Rename output columns — Parv The IT Geek”

SELECT — Returning specific columns — Parv The IT Geek

There are many times where returning all the data held within all the columns in a table are unnecessary and inefficient. For example. SELECT * FROM HumanResources.Department If you expand out the HumanResources.Department then you will get a list of the columns as well as some information on the columns. To get only the DepartmentIDContinue reading “SELECT — Returning specific columns — Parv The IT Geek”