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
Blog Posts
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
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
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
Go, Go, Golang!
WHAT!
Yep, you read that right. I’m building tools in Go.
I can hear you now…. But Wes you are a SQL...
2016-08-26 (first published: 2016-08-17)
1,782 reads
Install ReadyRoll via Command Line
command line install options
ReadyRoll has some great features, including the ability to use without cost on a build server. If...
2016-08-26 (first published: 2016-08-18)
1,118 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
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
RBAR vs Batch
Many years ago Jeff Moden (of SQL Server Central fame) came up with the concept of RBAR. Row-By-Agonizing-Row. At it’s...
2016-08-25 (first published: 2016-08-17)
2,721 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers