Category Archives: Cloud
-
Copying an Azure SQL database between two Azure SQL Instances in two different subscriptions.
3July 14, 2025 by Kenneth Fisher
I recently had to copy an Azure SQL database (SQL db) from one subscription to an Azure SQL Server instance …
Continue reading -
What’s in a SQL Server Managed Instance?
Leave a commentAugust 3, 2023 by Kenneth Fisher
My current position involves a lot of work with SQL Server Managed Instances so you’ll probably be hearing a lot …
Continue reading -
SQL Agent job history on a Managed Instance
4July 25, 2023 by Kenneth Fisher
The defaults for saving SQL Agent Job history are ok (at best), so you should probably check and update them …
Continue reading -
#PowershellBasics: Warnings and how to hide them.
1December 8, 2022 by Kenneth Fisher
One of my favorite parts of having a new job is that I learn a ton. (No really, my brain …
Continue reading -
Getting a list of the articles in a publication.
5May 17, 2022 by Kenneth Fisher
The other day I was asked to supply a list of all of the tables being replicated into a given …
Continue reading -
My journey with hybrid technologies. Where it started, how it’s going, and where it ends. : T-SQL Tuesday #139
Leave a commentJune 8, 2021 by Kenneth Fisher
One of my favorite people is hosting TSQL Tuesday this month. Ben Weissman (blog|twitter). He wants us to talk about …
Continue reading -
Adding a user to an Azure SQL DB
1November 5, 2020 by Kenneth Fisher
Creating a user is simple right? Yes and no. First of all, at least in SSMS it appears you don’t …
Continue reading -
SQL Virtual Machines
Leave a commentOctober 22, 2020 by Kenneth Fisher
I was recently watching the first session of the Azure SQL Bootcamp by Anna Hoffman (twitter) and Bob Ward (blog|twitter) …
Continue reading -
Permissions script for Azure Synapse
3October 15, 2020 by Kenneth Fisher
I was recently asked to add on to my permissions stored procedures (sp_SrvPermissions, sp_DBPermissions and sp_AzSQLDBPermissions) and create one for …
Continue reading -
Azure SQL Database Query Editor
3June 24, 2020 by Kenneth Fisher
I was working on a couple of Azure databases the other day. One was an Azure SQL DB and the …
Continue reading
SQL Studies 