Tricky TSQL: NOT IN (NULL)
We’ve done this before, but we can go one better this time. Let’s take this step by step. NULL means...
2016-08-11
1,048 reads
Opening .SQL Files in SSMS 2016 by Default #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-08-11
10,992 reads
Write-Only permissions
Yep, that’s right, you heard me. Write-Only not Read-Only. I was presenting SQL Server Security Basics at NTSSUG the other...
2016-08-11
617 reads
Do YOU Checksum?
I am going to show you why you should be using checksum options on your backups (and restores). I AM...
2016-08-11
203 reads
Regex With SQL Server - SQLSharp
In the context of my developer machine, I had log files I wanted to parse through. I setup a log...
2016-08-11
176 reads
Regex With SQL Server - SQLSharp
In the context of my developer machine, I had log files I wanted to parse through. I setup a log...
2016-08-17 (first published: 2016-08-11)
3,370 reads
Azure SQL Database vs SQL Data Warehouse
I am sometimes asked to compare Azure SQL Database (SQL DB) to Azure SQL Data Warehouse (SQL DW). The most important...
2016-08-17 (first published: 2016-08-10)
1,943 reads
What’s a Database Pipeline?
One of the things I ran into a few years ago was the idea of a software pipeline. A set...
2016-08-19 (first published: 2016-08-10)
2,817 reads
Inside the mind of a c# developer
I’ve been working with SQL Server for 18 years and over that long span I’ve seen a lot of different...
2016-08-10
626 reads
SQL Server Newsletter @LearningTree
As many of you know I have been delivering Learning Tree training courses since way back in 2010. Combing training...
2016-08-10
435 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers