Demystifying the use of CASE in an ORDER BY statement
Chuck Hoffman exposes the mysteries of getting CASE statements to work in dynamic ORDER BY statements.
2015-06-05 (first published: 2012-04-26)
25,967 reads
Chuck Hoffman
Selecting from hierarchies like Managers and Employees
Chuck Hoffman shows a technique using sets for selecting records from hierarchies such as Manager / Employee structures.
2012-05-03
8,874 reads
TSQL TestBits function for rapidly testing multiple switch settings
Are multiple binary switches becoming hard to manage? The TestBits function can help with that.
2012-04-09
4,060 reads
Blogs
Restoring Backups from Azure Blob with dbatools
Recently I needed to write a PowerShell script that could build a backup set...
Good to see you at Houston Tech Fest 2019!
By Will Assaf
It was awesome to see a great crowd at the triumphant return of Houston...
Using kubectl logs to read the SQL Server Error Log in Kubernetes
When working with SQL Server running containers the Error Log is written to standard...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
Primary server stay on resolving state- Always ON
Hi All , In my case we’re Looking the cause why in our Always...
fail over database in high availability - Always On
Hi All, Currently we have configured Always on - High Availability in our SQL...
Ask SSC