How do you count Week Days between two dates in SQL Server? Here is a short script I built from scratch using spt_values and DATEPART.
Finding Which Network Protocol Each Session Uses
Before you switch off a protocol, find out who still uses it. Two short queries show how each session connected, and why the address is not a person.
SQL SERVER – Invalid Object Name ‘master.dbo.spt_values’ in Management Studio
A client ran U_tables.sql from the Install folder by hand and then hit Invalid Object Name ‘master.dbo.spt_values’ in Management Studio. Here is why.
SQL SERVER – Can I Delete Always On Availability Groups Initial Sync Folder?
Can you delete the shared folder used for the initial sync of Always On availability groups? A client asked, and yes, you can remove it without any impact.
SQL SERVER – Interesting Observation – Count of Temporary Table Re-generations
A workshop attendee asked how to know the count of temporary table re-generations for a single temp table. Here is how I find it.
SQL SERVER – How to See Scripts Executing in sp_executesql?
How can you see the scripts executing in sp_executesql without an extra SELECT result set? A reader asked me, and here is the simple answer.
Azure SQL Elastic Pools: Sharing Resources Across Many Databases
Evaluate Azure SQL elastic pools using overlapping database demand, pool limits, per-database bounds, and measured workload performance.