An introduction to sqlcmd, the SQL Server 2005 command prompt utility that runs ad hoc T-SQL statements and scripts, and how it improves on isql and osql.
Testing a Cumulative Update Before Production
Testing a Cumulative Update means restoring real data, replaying key jobs, comparing plans and timings, and signing off before production.
Funny SQL Server Error Messages and What They Really Mean
Some real SQL Server error messages read like jokes. Here are my favorite funny SQL Server error messages and what each one is really telling you.
RADIANS: Cast Integer Degrees Before Conversion
RADIANS changes degrees into radians, but its input type affects the result. The example contrasts integer and float arguments while keeping the original degree values.
SQL SERVER – 2005 – Find Tables With Primary Key Constraint in Database
A script to find tables with primary key constraint in a SQL Server 2005 database, listing the index name, table name and column name from sys.indexes.
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database
A foreign key inventory needs both the constraint and its column pairings. I include schema names to identify each table clearly.
SQL SERVER – 2005 – Search Stored Procedure Code – Search Stored Procedure Text
How to search stored procedure code in SQL Server 2005 for a table or column name, using sys.procedures and OBJECT_DEFINITION instead of sp_depends.
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.