Copying Databases Across SQL Managed Instances
It only seems like yesterday since it was my turn to write a blog. And yet, here we are again,
April 23, 2024
Author: Scott Klein
The Right Tool for the Right Job
I’m looking forward to 2024. From many perspectives, I think we are going to see great advancements, including in technology, that on one hand will make our lives easier, but also make our decisions a bit harder.
January 15, 2024
PolyBase vs Linked Servers
PolyBase vs. Linked Servers … which wins? Recently we have had several clients reach out to us about a data
October 19, 2023
Index Maintenance: Automating Azure with Elastic Jobs
We often see companies not doing index maintenance in Azure. This will get you started because Index Maintenance with Elastic Jobs is easy.
August 21, 2023
How To: Running SQL Jobs with Azure Functions
In my previous blog post I introduced Azure Automation and Runbooks and showed how to automate index maintenance using these
March 15, 2023
How To: Azure Automation and Runbooks
In my previous “prologue” blog post I introduced a small handful of topics that discuss how to automate things in
February 15, 2023
Run SQL Jobs in Azure: A Prologue
This is an introduction to an upcoming series of posts dedicated to supporting you and addressing the different ways to
January 20, 2023
SQL Migration Steps: #1 Why Migrate SQL Server?
At SSG, our clients run many different versions of SQL Server, even as far back as 2008. This post is
July 20, 2021
How To: Configure Read-Only Routing for Availability Groups
At SSG, we work with Always On availability groups (AGs) every day. Most of our clients who have implemented AGs
March 10, 2021
SQL Server Management Studio vs. Azure Data Studio
The other day I opened SQL Server Management Studio (SSMS) on my laptop. It had been some time since I
February 23, 2021