My friend changed SQL Agent parameters and then the service would not start: failed to initialize SQL Agent log. Here is where to look and how we fixed it.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Interview Question of the Week #060 – What is the Difference Between EXCEPT Keyword and NOT IN?
Even 11 years after SQL Server 2005, few people I interview know the EXCEPT keyword. Here is how EXCEPT differs from NOT IN, with simple examples.
SQL SERVER – AlwaysOn Availability Group Stuck in Resolving State For Long time
Why does an AlwaysOn availability group get stuck in resolving state for a long time? Here is what that state means and where to look for the cause.
SQL SERVER – 2016 – Check Value as JSON With ISJSON()
Before you store JSON sent from the front end, make sure it is valid. Here is how the ISJSON() function in SQL Server 2016 checks a value as JSON.
SQL SERVER – Boosting User Experience with Analysis Services Perspectives – Notes from the Field #116
Analysis Services Perspectives let a designer show users only the parts of a data model they need. Notes from the Field #116 explains how they help users.
A T-SQL Formatting Style Guide for Teams
Adopt a short T-SQL formatting style with clear columns, joins, aliases, semicolons and comments, and keep review focused on query behavior.
SQL SERVER – How to Start SQL Server Service Without tempdb?
During a live demo, SQL Server refused to connect after a config change. Here is how to start SQL Server Service without tempdb. Never try this in production.
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.