2026-04-13
575 reads
Database Administration
Everything you should know about the SQL Server Resource database
Every SQL Server instance contains a database that most people never query, never back up, and never even see in Object Explorer. Yet, without it, SQL Server would not start. Enter the SQL Server Resource database.
2026-04-13
Why use a Composite Index in SQL Server
SQL queries can take a long time to run, especially on large tables if not properly indexed. Full table scans can be costly operations when all a user wants is to fetch a few rows based on multiple columns and a WHERE filter. How can we properly index our tables to support multi-column queries?
2026-04-08
Doing the Little Things
There are a lot of tasks that DBAs and developers struggle to get done. These little things can be important, and perhaps AI can help us keep on top of them.
2026-03-25
106 reads
2026-03-16
882 reads
2026-03-09
956 reads
2026-03-04 (first published: 2026-03-02)
1,061 reads
2026-02-16
699 reads
2026-02-09
510 reads
Troubleshooting Common SQL Server Errors: 823, and 824
Learn about the critical 823 and 824 errors in SQL Server and how to deal with them in this article.
2025-12-01
1,602 reads
Blogs
Lean Six Sigma – Brief
By Vinay Thakur
When you have a project or system, it has to be optimized, tuned, and...
T-SQL Tuesday #200: Bad Query signals
NO AI was used to generate this content. Grammarly was used to check and...
Project Management – Part 1
By Vinay Thakur
The soul of project management is Process Group(PG) and Knowledge Area(KA). they are related...
Forums
Reading Parquet using openrowset
Hi, We are looking out to read parquet file directly from on premise shared...
Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers