SQL Server DB Migration – Cloning a database to another collation
Database migration is a vital task in any environment, complex or otherwise. Seamless migrations are the goal but the efforts...
2017-09-19
336 reads
Blog Posts
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
704 reads
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
391 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
340 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,885 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
26 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
818 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,902 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
783 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers