BLOGS

ByDr. SubraMANI Paramasivam

How to enable/disable Resource Governor

A simple screenshot below shows you how you can easily enable/disable resource governor. By using SQL Server Management studio, connect to the instance where you need to enable Resource Governor. Then navigate down to Management and expand to see resource governor. There you can simply right click and choose Enable from the pop up menu. You can also enable by using T-SQL by simply passing below command.

ALTER RESOURCE GOVERNOR RECONFIGURE;

GO

EnableDisableRG

To disable via GUI, using your SSMS navigate to the management again and then right click on Resource Governor and choose Disable from the pop-up box. Alternatively, you can pass below T-SQL command to disable.

ALTER RESOURCE GOVERNOR DISABLE;

GO

 

ByDr. SubraMANI Paramasivam

Evolution of data warehouses

Evolution in organization use of data warehouses

Organizations generally start off with relatively simple use of data warehousing. Over time, more sophisticated use of data warehousing evolves. The following general stages of use of the data warehouse can be distinguished:

Off line Operational Databases

Data warehouses in this initial stage are developed by simply copying the data of an operational system to another server where the processing load of reporting against the copied data does not impact the operational system’s performance.

Off line Data Warehouse

Data warehouses at this stage are updated from data in the operational systems on a regular basis and the data warehouse data is stored in a data structure designed to facilitate reporting.

Real Time Data Warehouse

Data warehouses at this stage are updated every time an operational system performs a transaction (e.g., an order or a delivery or a booking.)

Integrated Data Warehouse

Data warehouses at this stage are updated every time an operational system performs a transaction. The data warehouses then generate transactions that are passed back into the operational systems.

ByDr. SubraMANI Paramasivam

SQL Server Version, Release Year and Codenames

In the Data Awareness Programme to students, I have shown below slide to let them know on how many versions have released, so far. As you can see below, the first ever version released was in 1989 and we are in 2014 now. SQL 2016 CTP versions are available but expected to release in beginning of 2016. There were totally 13 releases in last 25 years and the product has become very much stronger than ever. SQL 2016 is going to be a huge one with easy integration to cloud.

SQLServer_Versions_Codenames

ByDr. SubraMANI Paramasivam

SQL Server Features from 2000 to 2014

In my Data Awareness Programmes, I also spread the available SQL Server features from 2000 to 2014 in below slide formats. This will also give a quick glimpse on all SQL Server releases with available features in one single article. Note: These slides covers only a noticeable features and does not cover every single feature on it.

SS2000_Features SS2005_Features SS2008_Features SS2008R2_Features SS2012_Features SS2014_Features

ByDr. SubraMANI Paramasivam

SQL Server Editions from 2000 to 2014

In my Data Awareness Programmes, I also spread the available SQL Server Editions from 2000 to 2014 in below slide formats. This will also give a quick glimpse on all SQL Server releases with available Editions in one single article.

SS2000_Edition SS2005_Edition SS2008_Edition SS2008R2_Edition SS2012_Edition SS2014_Edition