Using SQL Agent Job Categories to Automate SQL Agent Job Enabling with Database Mirroring
Microsoft’s Kevin Cox (from SQLCAT) and I co-authored a blog post titled Using SQL Agent Job Categories to Automate SQL...
2010-04-01
930 reads
Blog Posts
An Introduction to SQL Server 2008 Audit
Excerpted from Brad’s Sure Guide to SQL Server 2008, which is available as a free eBook.
Previous versions of SQL Server...
2010-03-31
2,880 reads
Growing the Pool of SQL Speakers – Part 3
Continuing on from Part 2, I want to continue this time with two points I left open last time:
How to...
2010-03-31
1,670 reads
How Many DBAs Use the Maintenance Plan Wizard/Designer?
When I wrote my most recent free eBook, Brad’s Sure Guide to SQL Server Maintenance Plans, some of the DBAs...
2010-03-31
2,299 reads
HP Data Protector - SQL Server 2008 Supported, but Compatibility Pack 2005 Required
Recently, we found out that HP Data Protector had an update, and I took for granted that this update would...
2010-03-31
12,445 reads
Index Info
I recently came across an interesting script to help show index info and usage. As I began to dissect the...
2010-03-31
2,001 reads
Intel Xeon 7500 Series aka Nehalem-EX
Intel has finally released the long awaited (at least by me) 45nm Xeon 7500 series processor. This beast has eight...
2010-03-31
2,010 reads
The Vacation Crash
The family returned back from the UK last night, after traveling for something like 14 hours, plus an early morning...
2010-03-31
1,548 reads
Auditing Report Executions with Free Source Code
Have you been looking for a way to measure report performance? Want to know who accesses your reports most frequently? ...
2010-03-30
1,717 reads
Building a Wiki
I’ve long admired the value that I get from Wikipedia and like the concept of crowd sourcing knowledge, just never...
2010-03-30
1,649 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