How Much AI Code Would You Use?
Today Steve asks the question of how much of your code could be written by GenAI.
How to Remove Constraints from a SQL Server Table
I need to drop constraints on a number of my SQL Server tables. Most of our constraints are primary key and foreign keys, but there are other constraints too. How can we script it so it will deploy with a pipeline in a repeatable manner?
Two Events, Two Worlds: A Week in the Life of a Technologist
Last week, I had the chance to speak at two very different events, and the contrast between them really stuck with me. The first was all a traditional vendor conference- enterprise-level, built around a well-established product with over 40 years of vendor-driven development. Think polished sponsor tables, polished shoes, and more than a few suits […]
Elements of the SQL Server Update Statement
Learn how to use the UPDATE statement, along with a few things to be aware of when changing data.
The Changing Nature of Data
The way we look at data is changing, especially when data privacy and protection is considered. Today Steve has some thoughts on address data and the implications for cities as well as databases.
The complexity of using Power BI in US Sovereign Clouds
If you do a search for “sovereign cloud,” you will find that most of the cloud providers have their own Sovereign Cloud if you are interested in the concept for any other cloud services you need to use. In this article, I am going to look specifically at how you extend this support to Power BI, and make a few suggestions for how I think it could work better.
Killing a SPID and Checking Rollback progress in SQL Server
From time to time, I encounter blocking situations where I end up issuing a SQL KILL command against the blocking SPID. When I run sp_who2, I can see the killed SPID is in a ROLLBACK state. Is there any way I can get an idea of how long the rollback for the SPID will take?
Create Raw Zone Tables using Generative AI: The Fabric Modern Data Platform
In this first article on the Fabric Modern Data Platform, we look at how to use Generative AI to build tables.
Understanding UNION and UNION ALL in SQL Server
A short look at the differences in UNION and UNION ALL in a SELECT query.
Blogs
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
The FinOps Lifecycle: From Budgeting to Reporting
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers