Category Archives: Cloud
-
Getting a list of the articles in a publication.
1May 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 -
The Azure Portal search bar : T-SQL Tuesday #127
Leave a commentJune 9, 2020 by Kenneth Fisher
Happy T-SQL Tuesday! Number 127. Wow. Over 10 and a half years. Talk about incredible. I’m actually hosting this time …
Continue reading -
Connecting to Azure SQL Database: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid.
Leave a commentMay 20, 2020 by Kenneth Fisher
The other day I got this rather interesting error while connecting to an Azure SQL DB. I was connecting using …
Continue reading -
Running Azure from my android phone
1May 13, 2020 by Kenneth Fisher
The other day I had a random thought. I wonder if there is a version of Azure Portal for Android. …
Continue reading -
Is there an easy way to tell what pricing tier my Azure SQL DB/DW is using T-SQL?
3April 22, 2020 by Kenneth Fisher
I ran into an interesting problem today. I needed to find out the pricing tier of an Azure SQL DB …
Continue reading
SQL Studies 