Build an ordered columnstore index in SQL Server 2022, inspect segment bounds, and compare range-query reads on your own data.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – FIX : Error : Windows Update; Error Code 8000FFFF
Windows Update kept failing with Error Code 8000FFFF on my Vista machine, so SQL Server 2008 Books Online stayed out of date. Here is how I fixed it.
A Weekly Routine for SQL Server Administration
A weekly routine for SQL Server Administration checks recovery, failures, capacity, integrity, security, and pending changes in a practical order.
Adaptive Joins: When the Plan Picks Its Join at Run Time
Understand adaptive joins in SQL Server, read their runtime threshold, inspect the actual choice, and test a query hint safely.
SQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications
A roadmap of Microsoft SQL Server certifications to help you pick the right exam and prove your skills in a tough job market. Download the full article.
SQL SERVER – Add or Remove Identity Property on Column
There is no direct T-SQL to add or remove the identity property on an existing column. Imran Mohammed shows how SSMS does it and what happens behind it.
SQL SERVER – Example of DDL, DML, DCL and TCL Commands
Simple examples of DDL, DML, DCL and TCL commands: SELECT, INSERT, CREATE, ALTER, GRANT, REVOKE, COMMIT, ROLLBACK and what each one does.
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.