For the second T-SQL Tuesday ever — again, hosted by Adam Machanic — we were asked one of three options, and I elected to go with the first one:...
2020-11-02 (first published: 2020-10-28)
315 reads
T-SQL Tuesday is a fantastic series of blog posts derived from over 130 topics over the past 11 years, inviting bloggers to share their thoughts on a particular theme...
2020-10-21
16 reads
This — like last week’s post — is not about SQL Server or Azure SQL Database. In a way, it hearkens back to a post I wrote a few years...
2020-10-14
26 reads
This post is brought to you — indirectly — from a boss I loved working for, on a project which almost killed me, at a company which I had...
2020-10-07
435 reads
This post looks at a curious data type that isn’t really a data type. Instead, sql_variant tries to be all things to all people. As with most things in...
2020-09-30
227 reads
Tencent Security has released a report (written in Chinese) describing a new malware attack by the name of “MrbMiner” on SQL Server instances exposed to the Internet with passwords that can...
2020-09-23
383 reads
[Content Warning: this post contains references to subjects that may trigger a trauma response. Read with caution.] This is not a technical post. I was going to write about...
2020-09-16
49 reads
This week we’re looking at how the database engine stores the XML data type in SQL Server and Azure SQL Database. If you would like to read about storage of...
2020-09-09
152 reads
Two years ago I wrote a post that got a lot of traction in the comments at the time. Last month there was renewed interest because one of the...
2020-09-02
18 reads
This is not a post about SQL Server, but I need to write about something that I’ve been struggling with for a number of weeks so that other people...
2020-08-26
241 reads
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
By Steve Jones
As I use containers more and more to run various things, I decided I...
By Kevin3NF
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...
The Spirit Airlines Newark Liberty Airport Terminal is well integrated into the broader transportation...
I maintain an application written years ago, where the database is on a Windows...
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers