SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Learn how you can add transactional replication to an AG to move data to an Azure SQL Database.
Why disabling the SQL Server sa account still matters in 2026
Every few years, someone asks a familiar question: do we really still need to disable the sa account in SQL Server? After all, it’s 2026. SQL Server has better encryption, better auditing, better defaults, and more security features than ever before. Surely this old guidance belongs in the past?
Answering Questions On Dropped Columns
Answering a couple of questions from the previous posts about dropping columns.
Changing Data Types
Steve had to deal with a customer that changed data types in columns often. Is that something you experience?
Query Hint Recommendation Tool in SSMS 22
SQL Server Management Studio keeps adding features, but unless you look you probably don’t notice. In this article, we look at the new Query Hint Recommendation Tool in SSMS 2022 and how this can be used.
Webinar: Compliance Without Compromise: Test Data Management That Finally Fits
You know you shouldn't have production data in test environments. But every time you look at fixing it, the options feel impossible: enterprise tools that cost six figures and take months to implement, or DIY scripts that sort of work until they don't. Join this webinar on Mar 18 to learn more.
Breaking Down Your Work
Self-assessment and self-examination can be important in many fields, especially technology in the age of AI.
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Last time we turned SQL Server into a Christmas tree. Every year around St Patrick's Day I find myself doing something I can't fully justify. This year that thing was using SQL Server's spatial viewer to draw a shamrock and a pint of Guinness. Hope you have a happy St Patrick's Day and a few […]
I’m Not Gonna Waste Time Debunking Crap on LinkedIn.
LinkedIn is full of absolute trash these days. Just flat out b****** garbage. (Oh yeah, that – this post should probably come with a language disclaimer, because this stuff makes me mad.)
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
This article explains how I use sqlpackage to detect schema drift and generate a delta script that shows exactly what’s different.
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
BCA KCP Kas Cikini Gold Center Hub/Wa 08216977701
Jl. Pegangsaan Timur, Menteng Gedung Cikini Gold Center LGF/A/AKS032, RT.1/RW.1, Pegangsaan, Menteng, Central Jakarta...
BCA KCP KEM Tower TLP/WA (0821)6977701
Kem Tower, Gedung, Jl. Landas Pacu Barat No.Blok B Kav. 2, Daerah Khusus Ibukota...
BCA KCP Plaza Sentral Hub/Wa (08216977701)
Jl. Jend. Sudirman No.Kav.47, Karet Semanggi, Kecamatan Setiabudi, Kota Jakarta Selatan, Daerah Khusus Ibukota...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers