A reader’s database kept switching back to compatibility level 80 every day. Here is how a DDL trigger can catch who ALTERed the database and when.
Interview Question of the Week #018 – Script to Remove Special Characters – Script to Parse Alpha Numerics
Remove special characters with a corrected SQL Server loop and a 2025 regex expression, while defining ASCII and collation rules.
.jpg)
Great Indian Developer Summit 2015: Three SQL Sessions and a CPU Check
Great Indian Developer Summit 2015 brought me to Bangalore and Hyderabad for three SQL Server sessions. This page keeps the dates, topics and photos. It also adds a CPU check I would start with today, tested on SQL Server 2025, because one session was about CPU performance.
SQL AZURE – How to Disable and Enable All Constraint for Table and Database
sp_msforeachtable does not work in Azure SQL Database. Here is how to disable and enable all constraint for table and database in SQL Azure using DMVs.
SQL SERVER – Recovering from Snapshots – Notes from the Field #078
Data deleted by accident? John Sterrett explains recovering from snapshots, a very useful but less used feature, without panic making things worse.
SQL SERVER – Finding Tables with Primary or Foreign Keys
How do you find which tables have a primary key or foreign key? Here are simple queries for finding tables with primary or foreign keys in a database.
SQL SERVER – Script: Knowing Data and Log Files Are On the Same Drive
At GIDS I talked about keeping data and log files on separate drives. Here is a script that shows which databases have data and Log Files on the same drive.