Category Archives: SQL Database
-
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 -
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 -
Connecting to Azure SQL Database: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid.
4May 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 -
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 -
Viewing Azure SQL DB security with sp_AzSQLDBPermissions
2December 18, 2019 by Kenneth Fisher
A few months back I put the Azure SQL DB version of my permissions script into beta. I’m not sure …
Continue reading -
Introducing sp_AzSQLDBPermissions (Beta)
9June 27, 2019 by Kenneth Fisher
I’ve written a version of my permissions scripts for Azure SQL Database. It’s still in Beta but I’m confident enough …
Continue reading -
What do you get with a Free account in #Azure?
Leave a commentApril 29, 2019 by Kenneth Fisher
The first thing I want to do is say thank you to Michael Crump (b/t). He tweeted out this: What …
Continue reading -
Moving to Azure: A change in processes – TSQL Tuesday 103
3June 12, 2018 by Kenneth Fisher
For this month’s t-sql Tuesday our host Bjoern Peters (b/t) wants us to describe our experiences with Azure SQL Database …
Continue reading -
Increasing and decreasing the performance level of your Azure SQL Database
Leave a commentMarch 29, 2017 by Kenneth Fisher
One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability …
Continue reading -
Azure quick start
1January 30, 2017 by Kenneth Fisher
In case you hadn’t noticed, I love built in help. DBCC HELP, the script button in SSMS, even BOL. Well …
Continue reading
SQL Studies 