A junior DBA was fired for dropping a table on production. Here is how to customize the New Query window in SSMS so it opens with the commands you need.
SQL SERVER – User Defined Audit with SQL Server
Bank security checks taught me patience about audits. Here is how a user defined Audit in SQL Server lets you write your own events to the audit log.
Why SELECT 28F3 Returns 28: Float Literals and Hidden Aliases
Explain float literals, why SELECT 28F3 creates an alias, how 28E3 uses scientific notation, and why explicit AS prevents confusion.
Linked Server Logins: Stop Mapping Everyone to sa
Audit linked server logins for blanket remote sysadmin mappings, test with a low-privilege identity, and replace broad access safely.
SQL SERVER – What are my Trace Flags Enabled on SQL Server?
A DBA friend wanted to see the trace flags enabled on his production servers. Here is how to find them easily, and a word of caution about using them.
Choosing a Database IDE
Choosing a database IDE means testing SQL editing, plans, schema work, security, and team workflow across SSMS, VS Code, and other tools.
SQL SERVER – How to Flip Value of Bit Field in SQL Server? – Part 2
Five expressions flip a bit value in SQL Server without a CASE statement. This post runs Vinod Kumar’s four methods and the readers’ answers on SQL Server 2025, shows what each one returns for 0, 1 and NULL, and explains how to flip value of bit field data stored in an integer column.