CISL 1.3.1 is released
I am happy to share that the newest release of the CISL (Columnstore Indexes Script Library) – 1.3.1 is live!
Do...
2016-08-28
601 reads
When should I use a CTE?
If I had a dollar for every CTE solution to a simple query in the forums (pick any SQL forum), I’d...
2016-08-27
777 reads
Understanding the Different States of SQL Database
Overview
There are multiple numbers states of a SQL Database. These states determine the current status or mode of database in...
2016-08-27
546 reads
Organizing a SQL Saturday – Part 1 – Why Do It?
To kick off this series, I thought it would be worthwhile to discuss why it is I step up to...
2016-08-26
442 reads
An MCM teaches COMMENTS at SQL Saturday OKC
Edit: SQL Sat OKC has come and gone, but the new session on comments is recorded and up on the MidnightDBA Events...
2016-08-26
498 reads
TGI SQL Friday – Weekly round up 26th August 2016
The SQL Server news this week is there is no news!
http://news.bbc.co.uk/1/shared/spl/hi/newswatch/history/noflash/html/1930s.stm
No this is not the 1930’s BBC.
There are no...
2016-08-26
346 reads
I’m speaking at SQL Saturday 563 in Dallas
This will be my second time speaking at SQL Saturday in Dallas. My first was last year and it was...
2016-08-25
438 reads
PASS Board Update
Time for another update.
The minutes for the June in-person meeting have been approved and are now ready for your information....
2016-09-07 (first published: 2016-08-25)
1,134 reads
SQL Saturday–Viking Edition
I’m off to the Viking Ship Museum for SQL Saturday #532. Actually, the Viking Museum will (hopefully) be a side...
2016-08-25
3,767 reads
Talking of checkpoint
I was having a conversation with someone over a disgusting vanilla latte and we talked about shutting down a machine...
2016-08-25
190 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