A tempdb mistake left SQL Server unable to start. Here is the error while starting SQL Server, a failed assertion on logFileSize, and the fix.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Error: Msg 4305, Level 16, State 1 – The log in this backup set terminates at LSN, which is too early to apply to the database.
Msg 4305 says the log in this backup set is too early or too recent to apply. I build a sample database with backups to show why it happens during a log restore.
Interview Question of the Week #031 – How to do Case Sensitive SQL Query Search
Run a case sensitive SQL query search with explicit collations, inspect current settings, and design an index for repeated exact matches.
SQL SERVER – Adding File to Database in AlwaysOn Availability Group
A classic interview question: what happens when adding file to database in an AlwaysOn Availability Group? Here is the answer, with the basics first.
SQL SERVER – How to do IF…THEN in SQL SERVER?
How do you write IF…THEN in SQL Server? Use a CASE statement, or IIF from SQL Server 2012. Here are simple examples of both for a .NET developer.
SQL SERVER – A Stored Procedure for Executing SSIS Packages in the SSIS Catalog – Notes from the Field #092
SSIS expert Andy Leonard shares a stored procedure for executing SSIS packages in the SSIS Catalog, from the book SSIS Design Patterns. Notes from the Field #092.
SQL SERVER – Knowing Which Database is Consuming My Memory
Which database is consuming my memory? This query on sys.dm_os_buffer_descriptors counts buffer pool pages per database and page type.
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.