SQL University Post Coming Tomorrow
This is a short note to say that the SQL University post will arrive tomorrow. Today we're dealing with the...
2010-04-28
1,447 reads
Blog Posts
Undocumented Capabilities of Extended Event Objects
Undocumented Capabilities of Extended Event Objects
The extended event objects (objects exposed by an event package) are listed in the system...
2010-04-28
2,175 reads
A DMV a Day – Day 27
The DMV for Day 27 is sys.dm_tran_locks, which is described by BOL as:
Returns information about currently active lock manager resources....
2010-04-27
7,553 reads
BLOB Index Columns
For the April T-SQL Tuesday, I blogged about a report to find information on the BLOBs in a database. I...
2010-04-27
1,231 reads
In, Exists and join – a roundup
Over the last several months I’ve had a look at IN, Exists, Join and their opposites to see how they...
2010-04-27
1,350 reads
Latest Issue of The SQL Server Standard – Volume 7 Issue 3
Available for download by all PASS members (membership is free), this issue has Techies Talking to Non-Techies by Don Gabor....
2010-04-27
627 reads
One Trip Booked – TechEd 2010
Tia thinks I’m crazy to book early, but I like to have a choice of flights, and I like to...
2010-04-27
781 reads
PASS Summit, Kilt Wednesday
Last year at the PASS Summit we held a silly little event called Kilt Wednesday. Only three people took part,...
2010-04-27
1,403 reads
SQL Saturday - Columbia, SC - October 2, 2010
This is the official announcement that we are officially scheduled for holding a SQL Saturday in Columbia, SC, on October...
2010-04-27
891 reads
SQL Server 2008 and 2008R2 Diagnostic Information Queries
Since SQL Server 2008 R2 has gone RTM, and will be available on MSDN Subscribers on May 3, I thought...
2010-04-27
1,928 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage
Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL...
DBCC CHECKDB Limits II
Comments posted to this topic are about the item DBCC CHECKDB Limits II
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