SQL Server setup warned on the Microsoft .NET Application Security rule because the computer cannot access the Internet. Here is what it means and what to do.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Parse and Compile Time: Reading the First Line of STATISTICS TIME
Someone pastes a compile time of 24 ms and asks if the server is slow. Run it twice and watch the plan cache do its job.
SQL SERVER – Unable to Start SQL When Service Account is Removed From Local Administrators Group. Why?
When the service account is removed from local Administrators group, SQL Server may not start. Here is why, and the minimal permissions it needs.
How to Pass Parameters to a Stored Procedure in SQL Server
To pass parameters to a stored procedure, write the values after EXEC without parentheses, and name each parameter so the order can’t matter. This post builds a small order procedure and calls it by position and by name, with defaults, an OUTPUT value and a table-valued parameter. It also shows the three errors people hit first and what each one means.
SQL SERVER – Running CHECKDB with Minimum Repair Level
CHECKDB found 39 consistency errors and said repair_allow_data_loss is the Minimum Repair Level, but the reader could not finish the repair. Here is my reply.
What does BACKUP WITH NAME Command do? – Interview Question of the Week #130
What does BACKUP WITH NAME do? It simply names your backup, and you can then find that name in the msdb backupset table. Here is a quick example.
SQL SERVER – An Error Occurred While Obtaining the Dedicated Administrator Connection (DAC) Port
A student could not connect with the Dedicated Administrator Connection (DAC) after my class. Here is the port error he saw and how to fix it.
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.