Greed Is Good (for IT)
Can greedy executives be good for IT? Steve Jones thinks so and gives us a few reasons today.
SQL Server Index Maintenance Performance Tuning for Large Tables
This article describes a real-world example of performance tuning index maintenance for a large table of approximately 1 billion rows.
Nominations open for Exceptional DBA of 2011
The Exceptional DBA contest is running again in 2011 and nominations are now open. Please submit yourself or a colleague for a chance to win some great prizes and be recognized as an amazing data professional.
Treat People Like People
Steve Jones thinks that the Millennials have the right approach to work. There are many things that are more important than money.
TIME Gentlemen please! The SQL Server temporal datatypes
If you are still using the old Sybase DateTime datatype, it is a good idea to move your code to the more standard datatypes that were introduced in SQL Server 2008. Joe Celko explains why, and walks through some of the history of the TSQL way of storing and manipulating dates and times.
Parsing Log Files and Summarizing Results with PowerShell
This article takes a look at how PowerShell can speed up the process of parsing large log files.
Why and How of being a SQL Saturday Volunteer
Here is how to make the most of being a volunteer for SQL Saturday!
FILESTREAM Design and Implementation Considerations
This white paper is a companion to the information about FILESTREAM found on TechNet. This paper delves deeply into selected topics that should be considered when implementing a solution that uses FILESTREAM, including design considerations, maintenance, and management of a FILESTREAM environment.
Hints Are Not Always Better
This week Steve Jones reminds us that improving performance in T-SQL is not always obvious. Those little nuggets of knowledge can be very handy, which is why you should be regularly looking to acquire more of them.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Detecting Deadlocks Quickly
Comments posted to this topic are about the item Detecting Deadlocks Quickly
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers