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
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
Forums
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Cannot get KB959420
Hi, since we lost our sql server 2000 server we are trying to restore...
Do You Really Need HA?
Comments posted to this topic are about the item Do You Really Need HA?
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers