Most candidates in a senior developer interview could not create a scenario that shows schema locks. Here is a simple demo with a TRANSACTION and DML.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
How to Learn a New SQL Server Release Quickly
Evaluate new SQL Server features with a focused reading plan, version checks, three relevant experiments, and a record of operational tradeoffs.
Sequence Gaps: Why NEXT VALUE FOR Skips Numbers
Explain sequence gaps, inspect cached values, test rollback behavior, and separate SQL Server identifiers from gapless numbering.
SQLAuthority News – Interview with SQL Server MVP Madhivanan – A Real Problem Solver
SQL Server MVP Madhivanan has left over 1000 helpful comments on this blog. In this interview he talks about his work and his life outside SQL.
SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache
What is in your memory cache? A query on sys.dm_os_buffer_descriptors shows the data pages in buffer pool for each table and index.
SQL SERVER – Find Largest Supported DML Operation – Question to You
Best practice says the log should be twice the size of the largest supported DML operation. But how do you measure that? Share your ideas with me.
SQL SERVER – Shrinking Database NDF and MDF Files
Previously, I had written a blog post about SQL SERVER. I am posting this blog post here about Shrinking Database.
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.