A client could query a table but was unable to see tables in SSMS Object Explorer. A DENY permission was the cause. Here is how I tracked it down.
Slow Database Creation in SQL Server: Causes and Fixes
Slow database creation in SQL Server comes down to its files: how big they are, and whether SQL Server must zero every byte. This post checks the three usual suspects, the size of the model database, instant file initialization and the log file, and times each one with a script. It also shows the wait type to look for while a large CREATE DATABASE runs.
How to do Pagination in SQL Server? – Interview Question of the Week #111
How do you do pagination in SQL Server? A popular interview question. Instead of pulling every row into the app, here is a method that returns just one page.
How to Keep Certain Records on Top While Ordering Data? – Interview Question of the Week #110
An interview question: how do you keep one city on top while ordering data by name for the rest? The answer is a small trick in the ORDER BY clause.
Old SQL Backup Files in Azure Storage: PowerShell Inventory Before You Remove Anything
Old SQL backup files pile up in Azure Storage after a SQL Agent job runs for a while. An age cutoff finds candidates, but it cannot tell you what a restore still needs. This post gives a read-only PowerShell inventory and an msdb query that shows the backup chain.






