SQL Saturday #53 – Kansas City Wrap Up
Another weekend, another new city, another SQL Saturday. This was my first trip to Kansas City, and it was a...
Gender Differences in the Workplace
Today we have a guest editorial from MVP Jessica Moss that talks about the gender differences in the workplace, and how you can work to get beyond them.
Potential Issue with Re-Naming Stored Procedures
In this article Mohammad Meimandi explains an issue faced while using SQL-DMO to copy database objects.
Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 2
Part 2 of the series on using MAP 5.0 looks at using the toolkit to inventory servers, preparing audit reports and server virtualization planning.
Transactional Replication Setup (by Abi Chapagai)
As I discussed in my first part of replication SQL Server 2008 Replication: High Availability Solution Part One, replication is...
Why are we still talking about Women in Tech?
Today we have a guest editorial from Jen McCown, one half of the Midnight DBAs. Jen wonders why we are still talking about women in technology? Women do the same jobs as men in this field.
Writing Nearly Codeless Apps: Part 1
A new series from David Ziffer describes a way of building applications in a more standardized fashion, and it provides a basic review of some software that can help.
Scripts to use XML to insert and update rows in a SQL Server table
The following production code is what I used for inserting and updating database tables using XML as the input. These scripts are for processing data for any table to insert or update data. The support functions provided, retrieve the table schema with their data types, functions to deal with XML dates, primary keys of the table and what fields can be updated. The following article breaks down this process from beginning to end.
Strange but True - Report Parameter Label Blank
Here is another one of those strange but true things that I come across every so often which I thought...
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