A banking DBA quizzed me about TDE on SQL Server 2008 R2. Here are the Transparent Data Encryption questions and answers from that 30 minute chat.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – SPID is KILLED/ROLLBACK state. What to Do Next?
Your SPID shows KILLED/ROLLBACK and never seems to finish. Here is what that state means, why SQL Server sometimes cannot undo the work and what to do next.
Interview Question of the Week #034 – What is the Difference Between Distinct and Group By
Answer Interview Question of the Week #034 with runnable DISTINCT and GROUP BY examples, grouped totals, NULL rules, and a COUNT follow-up.
SQL SERVER – Remove All Characters From a String Using T-SQL
A follow up on how to remove all characters from a string, now handling special characters too. The trick: keep only ASCII 48 to 57 and join the digits.
SQL SERVER – Different Methods to Extract Scale Part From Decimal Number
Need only the digits after the decimal point? Here are different methods to extract scale part from decimal numbers, using ABS with CAST or string functions.
SQL SERVER – Are Power Options Slowing You Down? – Notes from the Field #095
John Sterrett explains how Windows power options, like the default balanced power plan, can slow SQL Server down. Notes from the Field #095.
SQL SERVER – Script: Finding queries without JOIN Predicates
During a code review I spotted a query missing its join condition. Here is a script for finding queries without JOIN predicates in SQL Server.
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.