When Deadlocks Become Art
We’ve all had to solve deadlock issues. Identify the two conflicting pieces of code, work out an appropriate change to...
2017-09-19
702 reads
Blog Posts
Adding Replicas into existing Availability Groups
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-09-18
387 reads
dataMinds Connect 2017 (win a ticket!)
Within two weeks the wait is over: the first edition of dataMinds Connect! For those of you wondering what I’m...
2017-09-18
339 reads
DevOps Basics–Git Clients
This is also a part of a basic series on git and how to use it.
There are lots of git...
2017-09-18 (first published: 2017-09-07)
1,884 reads
Experimenting with VSCode instead of the ISE
I’ve been playing with PowerShell here and there, learning a few things. As I use the dbatools project, or
I...
2017-09-18
536 reads
Generate Markdown Table of Contents based on files within a folder with PowerShell
Last week I was talking with Constantine Kokkinos (b | t) about generating a Table Of Contents (TOC) for a GitHub repository.
He wrote a cool blog post - Generating...
2017-09-18
17 reads
Monday Coffee: Should I learn powershell?
This month’s T-SQL Tuesday’s topic was set by Rob Sewell (b|t) and entitled Let’s all get PoSH
It had a massive...
2017-09-18
817 reads
Please Don’t Do This!
Please, please, please Admins do not leave your default index fill factor at 0. This means you are telling SQL...
2017-09-18 (first published: 2017-09-06)
3,900 reads
SQL Server Schema Compare
A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition...
2017-09-18
756 reads
SQL Server database basics
So today I'll talk about some of the basic items for SQL server that helps to understand the reason of some performance recommendations. This first post will list and...
2017-09-16
19 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers