Data Growth
Today Steve Jones talks about the pace of data growth looking to outpace the IT budget changes. As data professionals, we need to learn to do more with less.
Stairway to SQL Server Replication - Level 9: The Replication Monitor
Introducing the replication monitor and how to use it to monitor replication health. It also introduces tracer tokens.
Attracting Talent
How can a company attract talent? First, be a good company to work for, and then be real.
SQL Saturday Precon - SSIS Design Patterns
SQL Saturday is hitting Dublin for the first time on March 24th.
Tips for Upgrading a Cluster to SQL 2008 - Part 2
This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008
SQL Server Ranking Functions
SQL Server includes a subset of four ranking functions that can be used to rank the rows of your result set over a partition. This article presents those functions and examples of their use.
Disconnected database development: solving a problem that needn't exist
A disconnected model is only really needed in the absence of a properly-defined database interface. We, as developers, create a rod for our own backs by insisting on treating a database in a way we wouldn't treat an object, let alone an assembly or namespace.
Financial Rounding of Allocations
When rounded detail quantities are created by an allocation, often the total must foot back exactly to the allocated amount.
Tabs or Spaces
Today Steve Jones talks about one of the classic software developer debates. When formatting code, how should you do it?
TSQL Challenge 78 - Parse single field into multiple fields
The database field contains long string with data for Quantity and Parts. The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report.
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
We Are Eating Our Own Seed Corn
Comments posted to this topic are about the item We Are Eating Our Own...
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...
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