Certificate Based Application Roles
What if I told you that you could sign an assembly that your Windows application uses with a certificate, load...
2010-11-30
1,602 reads
Adventures in SQL
Using DMVs to Find the Ports that SQL Server is Listening On
The other day I was asked to provide the port number that a SQL Server instance was listening on. As...
2010-11-29
3,393 reads
How Do I Change SSRS Report Credentials with Powershell?
Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial...
2010-11-24
7,205 reads
Careful with the New MCM Requirements
Ever since I first heard about the Microsoft Certified Master program I have been interested. The prestige of the certification...
2010-11-23
682 reads
Want to Make Your SQL Server Run Faster for Free?
I know I do!
The trick is to properly manage your VLFs.
What are VLFs? The short anser is that VLF...
2010-11-19
2,222 reads
Get Drive Space Including Mount Points
Today’s post is a quick one that came out of a conversation on Twitter. To make a long story short,...
2010-11-15
2,860 reads
Troubleshooting SQL Server Error: 18456, Severity: 14, State: 16
I recently had to track down a rogue process that was failing to log in on one of my servers....
2010-11-12
890 reads
A Brute Force Way to Compress a Database
There are a handful of scripts out there to compress all of of the objects in your SQL 2008 database...
2010-11-05
2,034 reads
When is that Restore Going to Finish?
I spent a good portion of last weekend restoring databases from backup due to a large release. Nothing went wrong,...
2010-10-27
862 reads
Stop Forgetting the DAC
From time to time I hear of DBAs that had to restart the SQL Server service on a 2005 or...
2010-10-06
970 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers