There are many ways to know SQL Server version, but did you know two system procedures, sp_server_info and xp_msver, also return it?
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Find the Growth Size for All files in All Databases
Auto growth should be a safety net, not a routine. Here is a script to find the growth size for all files in all databases and spot risky 10% settings.
SQL SERVER – Mistake to Avoid: Duplicate and Overlapping Indexes – Notes from the Field #073
Indexes do not always improve performance. Kathi Kellenberger explains why duplicate and overlapping indexes are a mistake to avoid.
SQL SERVER – Knowing Nested Transactions Behavior with SQL Server
Does SQL Server start a new transaction for every BEGIN TRAN inside another? I show nested transactions behavior with a simple demo for a reader.
SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location
When readers report a strange error, I first ask for the SQL Server ERRORLOG. Here are the various ways to find the ERRORLOG Location on your server.
SQL SERVER – Backup and Restore Behavior of ReadOnly Filegroup Databases
How do backups behave for a database with a ReadOnly filegroup, and does a restore keep that setting? I walk through it with simple T-SQL scripts.
Interview Question of the Week #012 – Steps to Restore Bak File to Database
Restore bak file backups safely with header and file inspection, complete Windows paths, conditional access changes, and recovery options.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.