Starting to Program
This Friday Steve Jones asks what resources might help the new DBA learn to program better. Pick the language of your choice and let us know what resources have worked well for you.
Trash Destination Adapter
The Trash Destination and this article came from early experiences of using SSIS and community feedback at the time. When developing a package it is very useful to have a destination adapter that does nothing but consume rows with no setup requirement. You often want run a package part way through development, or just add a path so you can set a Data Viewer. There are stock tasks that can be used, but with the Trash Destination all columns are treated as selected automatically (usage type of read-only), so the pipeline knows they are required.
Advanced SSIS Fuzzy Matching via Record Linkage Methodology
Greatly improve SSIS Fuzzy Grouping performance by using a Conditional Split and Multi Cast.
Clouds, Costs, and Data Analytics
The cloud can be good or bad for your company, but it can easily be a costly endeavor that doesn't save you money. Steve Jones some data analysis is needed to ensure you have a cost effective cloud infrastructure.
Steps to clean up orphaned replication settings in SQL Server
Learn how to clean up your orphaned replication settings.
Indexes, Indexes, Indexes
This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.
TSQL Challenge 81 - Create a Game schedule generator in TSQL
This challenge is to generate a game scheduler based on the Teams given in a table.
Fix Failures Fast
A new study from Microsoft Research looks at failures in PCs. Steve Jones thinks there are a few things worth talking about for DBAs.
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...
BCA KCU BANDUNG
PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
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