A postal code like 00501 turns into 501 in a spreadsheet. See where the zero is lost, how to build a correct CSV line, and why quotes alone do not help.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Working with Business Days in SQL Server – A Different Approach
I recommend that you download XLeratorDB and try this problem along with me, this is going to be a fun exercise and something new to learn about Business Days.
SQL SERVER – How to Allow Only Alphabets in Column – Create Check Constraint to Insert Only Alphabets
Allow only alphabets in a SQL Server column with an explicit ASCII-letter rule. These tested examples reject empty strings, NULL, spaces, digits, and punctuation while explaining collation and existing-data checks.
SQLLive 360 Orlando 2013: Notes from a Great Experience
I presented three sessions at SQLLive 360 in Orlando, Florida, on November 19 and 20, 2013. It was my first time in Orlando. These are my notes from the event, with a few photos.
Scheduling an Agent Job for Weekday Office Hours Only
Stop a monitoring job from waking anyone at 3 AM. Build the schedule, decode the weekday mask, and see what the window does not cover.
SQL SERVER – Wrap on Series of Temporary Statistics
The final post on temporary statistics answers reader questions, like whether you can update them. Only SQL Server can, but you can drop them.
SQL SERVER – Finding Frequently Running Query and Elapsed Time – Notes from the Field #005
When the server is slow, first see what is running. Brian Kelley shows how to find a frequently running query and its elapsed time, two key facts for tuning.
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.