Daily Coping 14 Jan 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-14
22 reads
Replacing VS Code with Vim
OK so maybe not replacing, this is more like emulating VS Code in Vim. Disclaimer – I like VS Code and I won’t be uninstalling it anytime soon and...
2022-01-14
139 reads
Hubbard Family Recovery–A Friend
Today’s post will not be your regular tech or leadership blog from me today. The Hubbard family suffered a tragic loss on January 12th, 2022. They lost their home,...
2022-01-14
26 reads
How to install PowerShell SQLServer module in a specific directory
Troubleshoot error - Install-Module: Administrator rights are required to install modules in 'C:Program FilesWindowsPowerShellModules.'
2022-01-13
95 reads
Troubleshoot PowerShell-No match was found for the specified search criteria,module FailoverClusters
Troubleshoot PowerShell-No match was found for the specified search criteria, module FailoverClusters
2022-01-13
70 reads
Daily Coping 13 Jan 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-13
24 reads
Database projects with SQL Server Data Tools (SSDT)
Last Year (2021) I released a full and comprehensive course about SSDT: developing and maintenance SQL Server database within SQL Server Data Tools in Visual Studio. Thank you to...
2022-01-13
24 reads
Database projects with SQL Server Data Tools (SSDT)
Last Year (2021) I released a full and comprehensive course about SSDT: developing and maintenance SQL Server database within SQL Server Data Tools in Visual Studio. Thank you to...
2022-01-13
136 reads
Azure Data Explorer – Setting up a Cluster
I’ve worked with Log Analytics quite a bit over the years and that’s taken me down the road of the Kusto Query Language – or KQL So, using Azure...
2022-01-13
54 reads
Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
2022-01-12
152 reads
Blogs
The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering
By James Serra
(This post starts a three-part series on how AI is changing the way we...
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Forums
Managed Instance vs Azure Database - is this a good option?
We're currently in Azure, however as we had a very tight migration timeline when...
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers