With SQL Server versions 2008R2 and 2012, you can access the registry to get the settings for the current instance of SQL Server. Here is how… Read More »Accessing the registry from TSQL on SQL Server 2012 and 2008R2
First for this example, and a few to follow we need to create the database that we are going to play around in. Next a… Read More »ROWS PRECEDING and FOLLOWING in TSQL 2012
One of the new Dynamic Management Views introduced in SQL Server 2012 is the dm_server_services which returns info on the services running that are associated with SQL… Read More »New DMV in SQL Server 2012 sys.dm_server_services
There is no more Business Intelligence Development Studio (BIDS) in SQL Server 2012, instead it has been replaced with the SQL Server Data Tools that… Read More »No more Business Intelligence Development Studio in SQL 2012
After several attempts to install SQL Server 2012 on Windows 7, I was getting the following error. “SQL Server Setup has encountered the following error:… Read More »SQL Server 2012 – Setup Problems – Value Cannot Be Null
I added 2 new reports Top Cache Queries and Top CPU Queries into the Server Health Reports. Here is a screen shot of the latest report, the Top CPU… Read More »2 New Reports Added to the SQL Server Health Reports
I spent the day today at SQL Saturday in Vancouver BC. I met some fabulous SQL Server professionals, and presented 2 sessions. The first… Read More »A great day at SQL Saturday in Vancouver BC
In preparation for my presentation at SQL Saturday in Vancouver BC tomorrow, I have updated the SQL Server Health Reports. As I was preparing for… Read More »SQL Server Health Reports – Updated
It has been a busy week getting ready for SQL Saturday Vancouver, planning sessions to present at future training’s and determining new material to present.… Read More »4 Sessions Submitted to Seattle Code Camp
The SQL Server Health Reports have been updated. As part of preparing for my SQL Saturday 114 presentation next weekend in Vancouver BC, I have… Read More »SQL Server Health Reports Updated