Connecting to SQL Server from Linux requires the right Microsoft ODBC packages, a Kerberos plan, and certificate trust that matches the server name.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SSIS Project and Package Deployment Explained
Understand SSIS deployment models, catalog environments, parameter bindings, and the checks that keep package execution predictable after deployment.
SQL SERVER – Effect of SET NOCOUNT on @@ROWCOUNT
Does SET NOCOUNT change @@ROWCOUNT? I ran a quick demo in a session and ten hands went up before I even hit execute. The script and what it shows.
Storing Email Addresses: Length, Case and Unique Keys
Two accounts for one customer usually means nobody wrote down the case rule. Build the table, break each rule, and see what the database can promise.
SQL SERVER – Fix: Error: File Cannot be Loaded Because the Execution of Scripts is Disabled on This System
After a fresh install, PowerShell stopped me with an error: execution of scripts is disabled on this system. The fix takes two lines with Set-ExecutionPolicy.
Handling the Row That Arrives Late
Handle late arriving data with explicit event dates, inferred dimension members, replay windows, and a clear policy for correcting published history.
Listing Server Logins Not Mapped to Any Database User
A login with no database user is not automatically unused. Build the report, compare by SID, and check server roles before you touch anything.
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.