Playing with affinity settings, I broke SQL Server startup with error 17120: could not spawn lazy writer thread. Here is what the ERRORLOG showed and how I recovered.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Increase Characters Displayed in Text Results
A reader’s JSON output looked cut off compared to my blog post. Here is how to increase characters displayed in text results using Query Options in SSMS.
Interview Question of the Week #030 – Retrieve Last Inserted Identity of Record
Retrieve the last inserted identity of record safely, compare identity functions with a trigger, and capture multi-row values using OUTPUT.
SQL SERVER – How to Remove All Characters From a String Using T-SQL?
A reader wanted only the digits from a string like ab123ce234fe. Here is a simple T-SQL loop to remove all characters from a string and keep the numbers.
SQL SERVER – Puzzle – Inside Working of Datatype smalldatetime
A developer got odd results when casting strings sent from an app. This puzzle looks at how the smalldatetime datatype works inside SQL Server.
SQL SERVER – DevOps for the DBA – Notes from the Field #091
DevOps is a buzz word with real substance behind it. In Notes from the Field #091, Stuart Ainsworth explains what DevOps means for a DBA’s daily job.
SQL SERVER – Error: Msg 245 – Conversion failed when converting the varchar value ‘Inactive’ to data type int
Mixing text and numbers in a CASE statement can throw Msg 245: conversion failed when converting the varchar value to data type int. Here is why 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.