Binary conversion styles control hexadecimal prefixes. Pair the output and input styles, preserve empty bytes and verify a complete round trip.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Shrinking Truncate Log File – Log Full – Part 2
About a year ago, I wrote SQL SERVER – Shrinking Truncate Log File – Log Full. I was just going through some of the earlier posts and comments.
SQL SERVER – Generate Incremented Linear Number Sequence
A reader asked how to generate an incremented linear number sequence in SQL Server, like a sequence in Oracle. A short WHILE loop script does it.
DEGREES: Preserve Fractions When Converting Angles
DEGREES converts radians into degrees. An integer radian argument can narrow the output, while a float argument retains an approximate fractional degree value.
Preview Builds: What You May and May Not Do With Them
Preview Builds are useful for SQL Server evaluation when you check license terms, isolate test data, and plan for disposal instead of upgrade.
Onboarding a New DBA
Onboarding a new DBA starts with safe access, a server map, tested runbooks, and a first month of supervised operational tasks.
SQL SERVER – 2005 – Best Practices for SQL Server Health Check
Best practices for a SQL Server Health Check: run one every 6 to 12 months, document everything, and plan fixes afterward instead of fixing during the check.
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.