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
542 reads
Blog Posts
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
774 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
491 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,768 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,111 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
435 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
436 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,715 reads
Speaking at SQLSaturday #555, Munich 2016
I am very honoured to share that I have been picked up to speak at the German SQLSaturday in Munich...
2016-08-25
484 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers