Category Archives: SQL Database

  1. Azure SQL Database Query Editor

    3

    June 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

  2. Connecting to Azure SQL Database: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid.

    Leave a comment

    May 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

  3. Is there an easy way to tell what pricing tier my Azure SQL DB/DW is using T-SQL?

    3

    April 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

  4. Viewing Azure SQL DB security with sp_AzSQLDBPermissions

    2

    December 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

  5. Introducing sp_AzSQLDBPermissions (Beta)

    9

    June 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

  6. What do you get with a Free account in #Azure?

    Leave a comment

    April 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

  7. Moving to Azure: A change in processes – TSQL Tuesday 103

    3

    June 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

  8. Increasing and decreasing the performance level of your Azure SQL Database

    Leave a comment

    March 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

  9. Azure quick start

    1

    January 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

  10. Azure: Creating a BACPAC from an On-Premises SQL Server Database

    1

    September 13, 2016 by Kenneth Fisher

    So to start, what’s a BACPAC? Per the Azure documentation When you need to create an archive of an Azure …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,136 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013