Pre-code review tips for DBAs: why I check stored procedures on our development server every day for coding standards, with a link to my full article.
SQL SERVER – T-SQL Script to Add Clustered Primary Key
A Jr. DBA asked me three times in one day how to create a clustered primary key, so I gave him this ALTER TABLE example. He never asked again.
SQL SERVER – UDF vs. Stored Procedures and Having vs. WHERE
My first article in SQL Server Magazine, October 2007, covered UDF vs. stored procedures and HAVING vs. WHERE. The article has moved, so its links are off.
SQL SERVER – 2005 – Sample Example of RANKING Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE
SQL Server 2005 has four ranking functions: ROW_NUMBER, RANK, DENSE_RANK and NTILE. I explain what each returns and show a sample example of all four.
SQL SERVER – 2005 – Connection Property of SQL Server Management Studio SSMS
How to change connection properties in SSMS as you connect, like using named pipes instead of TCP/IP, as I do for one of our servers. Screenshots show each step.
Why You Should Name Default Constraints
Name default constraints so deployments can find them reliably, and replace system-generated names through a reviewed migration.
SQL SERVER – Executing Remote Stored Procedure – Calling Stored Procedure on Linked Server
Two ways to call a remote stored procedure on a linked server: a four part name with EXEC, or the OPENQUERY distributed query function.
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.