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.
Using Feature Flags
Feature flags are being used in modern software development. Steve thinks these should also be a staple of database changes.
Introduction to GitHub Actions Part 1: Getting Started
This article series will teach you what you need to know to take advantage of GitHub Actions, especially for deploying database code.
Feeling your age? How would you know?
As this idea is being born, I am sitting in a dueling piano bar and I have never felt so old ever. And I don’t mean physically. I have only recognized about 1/4 of the songs being played, and everyone just seems younger than me. Even the people I think are older seem younger as […]
A Domain for Data
A SQL DDL statement that Steve never knew about is the subject of today's editorial.
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCU MENARA BCA TLP/CS 08216977701
Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1 Lt. 28, RT.1/RW.5, Menteng, Kec. Menteng,...
BCA KCP Telepon Kota HUB/CS 08216977701
Jl. Ps. Pagi Raya No.9, Roa Malaka, Kec. Tambora, Kota Jakarta Barat, Daerah Khusus...
BCA KCP Tanah Abang Zona 3 Tlp/Wa 08216977701
Gedung Tanah Abang Zona III Lantai 3A L03A, Jl. KH. Fachrudin, Kp. Bali, Kecamatan...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers