Remote Desktop Workflow Improvements
Remote server management is a fact of life for folks involved with sql server. Since we work so often with...
2016-08-29
665 reads
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
547 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
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
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...
Forums
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers