SQL Code Formatting matters, and every DBA has a preference; I like uppercase keywords. I ran one script through online formatters and two were worth sharing.
SQL SERVER – Script/Function to Find Last Day of Month
A one line DATEADD query to find the last day of month for any date. It handles leap years: February 2008 gives the 29th and 2007 the 28th.
SQL SERVER – ASCII to Decimal and Decimal to ASCII Conversion
In this blog post we will see how we can convert ASCII to Decimal and Decimal to ASCII. In simple words, we will see the decimal and ASCII conversion.
SQL SERVER – Math Functions Available in SQL Server
One list of the Math Functions available in SQL Server, from ABS and CEILING to SQRT and TAN, and why RAND is the only nondeterministic one among them.
SQL SERVER – 2005 Understanding Trigger Recursion and Nesting with examples
How trigger recursion and nesting work in SQL Server 2005: triggers nest up to 32 levels, recursive triggers fire themselves, and both can be turned off.
SQL SERVER – 2005 – SSMS Change T-SQL Batch Separator
A big script used EndBatch instead of GO. Rather than a risky mass replace, I changed the Batch Separator in SSMS under Tools, Options, and it ran as is.
SQLAuthority News – Limited Edition T-Shirts Arrived
The limited edition T-shirts from SQLAuthority.com arrived, and a few loyal readers get theirs tomorrow. Thank you for all your emails and suggestions.
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.