Protecting Against Delete without Where
If I’m doing any manual work with T-SQL, I always begin every set of data change operations with BEGIN TRAN...
2016-06-13 (first published: 2016-06-09)
3,645 reads
SQL Prompt Prevents Stupidity
I upgraded my SQL Prompt recently, mostly as a habit. The team led by David and Aaron are always adding...
2016-06-17 (first published: 2016-06-09)
2,509 reads
A Different Type of Currency
Recently, a member of the community lamented that folks weren’t willing to provide an email address for free training. This...
2016-06-09
456 reads
Presenting for Edmonton SQL Server Users Group June 16th
It’s a wonderfully busy speaking month! I’m going to be remotely speaking for the Edmonton SQL Server User Group at 5:00pm...
2016-06-09
415 reads
My first SQL Server 2016 POC
Very, very recently I did my first Proof Of Concept (POC) with SQL Server 2016. At an actual client of...
2016-06-14 (first published: 2016-06-09)
4,754 reads
OBJECT_ID()–#SQLNewBlogger
One of the things that is needed in quite a few functions is the object_id of a particular table/view/procedure/function in...
2016-06-08
1,159 reads
Book Review: Sapiens: A Brief History of Humankind
Sapiens: A Brief History of Humankind, by Yuval Harari, made it on my reading list after hearing about Mark Zuckerberg’s list of books everyone should read. And since then,...
2016-06-08
19 reads
Book Review: Sapiens: A Brief History of Humankind
Sapiens: A Brief History of Humankind, by Yuval Harari, made it on my reading list after hearing about Mark Zuckerberg’s...
2016-06-08
843 reads
Comparing the contents of two tables Redux
I did a post the other day on comparing two tables. It was meant as a general overview but I...
2016-06-08
493 reads
Share custom solutions in the MinionWare Community Zone
Since we released Minion Reindex over a year and a half ago, we’ve had a ton of wonderful feedback, praise, questions, and...
2016-06-07
633 reads
Blogs
The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering
By James Serra
(This post starts a three-part series on how AI is changing the way we...
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Forums
Managed Instance vs Azure Database - is this a good option?
We're currently in Azure, however as we had a very tight migration timeline when...
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers