How do you assign Multiple Variables in a single T-SQL query? Here are three ways, from separate SET statements to my preferred one-line style.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Startup Error – Your SQL Server Installation is Either Corrupt or Has Been Tampered With
After I broke a named instance in my lab, sqlservr.exe gave a startup error: your installation is either corrupt or has been tampered with. Here is the fix.
RDP Logoff Message: Please Wait for the System Event Notification Service
The RDP logoff message “Please wait for the System Event Notification Service” can have many causes. A client’s users hit it at logon and logoff, and a reboot was the only cure. Here is the SQL Server related cause and two workarounds.
SQL SERVER – Msg 7399, Level 16 – The OLE DB Provider “ADsDSOObject” for Linked Server “AD” Reported an Error
An LDAP query through a linked server worked in one domain but failed in another with Msg 7399 from the ADsDSOObject provider. Here is the fix.
SQL SERVER – The Description for Event ID 18456 From Source MSSQLSERVER Cannot be Found
A client’s event log said the description for Event ID 18456 from source MSSQLSERVER cannot be found. Here is what it means and where to see the real error.
SQL SERVER – Error While Enabling Windows Feature: NetFx3, Error Code: 2146498298
A SQL Server 2012 install failed with an error while enabling windows feature NetFx3. Here are the steps to turn on .NET Framework 3.5 in Server Manager.
SQL SERVER – Assembly ‘ISSERVER’ Was Not Found in the SQL Catalog of Database ‘SSISDB’
After a patch, SQL Server would not start: assembly ISSERVER was not found in the SQL Catalog of database SSISDB. Here is what the ERRORLOG showed and the fix.
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.