VMware vExpert 2015
VMware has announced the list of 2015 recipients of the vExpert award, and I am humbled and honored to have been...
2015-02-18
376 reads
Triggering a System Center Configuration Manager deployment task
A slightly different topic today.
Once you have built up knowledge, you become the person that people ask to solve things....
2015-03-02 (first published: 2015-02-18)
6,607 reads
Free Video for Accidental DBA’s
Recently, Mike Walsh and John Sterrett teamed up with Embarcadero to give a 60 minute presentation focusing on the skills...
2015-02-18
1,846 reads
Test your UPDATEs and DELETEs before you run them
This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you...
2015-02-18
2,234 reads
Clustered Columnstore Indexes – part 48 (“Improving Dictionary Pressure”)
Continuation from the previous 47 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is dedicated to one of the most complex problems in...
2015-02-18
1,892 reads
The Vacation Conundrum
Would I want unlimited time off? It’s an interesting question. I think I might like something more like a minimum...
2015-02-17
879 reads
SQL Code Guard v2.7 released
Hola!
SqlCodeGuard v2.7 is just released.
To be brief - major changes:1. Added command line utility
2. Added scgallow(issue)/scgignore(issue`)to control which issues should be...
2015-02-17
1,582 reads
Last Execution of a Proc
SQL Server is full of good stuff. There are plenty of features to be used. Plenty of applications to help it. And there is even plenty of metadata within...
2015-02-17
9 reads
Last Execution of a Proc
SQL Server is full of good stuff. There are plenty of features to be used. Plenty of applications to help...
2015-02-17
2,052 reads
Q and A With SQL MVP Chris Shaw
This has been a long time in the making, back in 2011 I attended a session at PASS Summit by...
2015-02-17
960 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers