Azure Data Studio and XEvents
Azure Data Studio (ADS) is getting all sorts of love and attention these days. So much so that they have...
2018-11-21
864 reads
Blog Posts
Cannot Use the Special Principal – Back to Basics
I recently had a client call me out of the blue because he happened to be getting an error while...
2018-11-21 (first published: 2018-11-07)
2,581 reads
Dates and Times in SQL Server: DATEDIFF() and DATEDIFF_BIG()
Last time we looked at adding or subtracting date parts using the DATEADD() T-SQL system function. This week we see...
2018-11-21
381 reads
Join me for an upcoming webinar, “Data Masking: Insights & Actions”
There has never been a better time to start a project to champion data privacy In a recent Harris poll sponsored by the payment company Stripe, over 1,000 C-level...
2018-11-21
10 reads
Learning from PASS Summit Feedback
I got my feedback the other day, and was a bit surprised by a comment. I wasn’t having a great...
2018-11-21
762 reads
The Cloud and Shadow IT.
Shadow IT has been, well, maybe not the bane of the IT department, but certainly a pain in the neck....
2018-11-21
939 reads
T-SQL Tuesday #108: New Horizons Beyond SQL Server
There comes a point in one’s career when a change is requisite. Big or small there always seems to be...
2018-11-21 (first published: 2018-11-13)
2,130 reads
4 SQL Injection Techniques For Stealing Data
Watch this week's video on YouTube
I'm not advocating that you start using SQL injection to start stealing other people's data.
However, I do think that you should familiarize...
2018-11-20
18 reads
4 SQL Injection Techniques For Stealing Data
Watch this week's video on YouTube
I'm not advocating that you start using SQL injection to start stealing other people's data.
However, I do think that you should familiarize...
2018-11-20
7 reads
A Problem with POWER()
I ran into an interesting problem while working with the POWER() function. I was trying to do some binary conversions...
2018-11-20
810 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers