Category Archives: SQL Database

  1. Copying an Azure SQL database between two Azure SQL Instances in two different subscriptions.

    3

    July 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

    Category: Cloud, Microsoft SQL Server, Powershell, SQL Database, SQLServerPedia Syndication, T-SQL | Tags: , , , , , ,

  2. What’s in a SQL Server Managed Instance?

    Leave a comment

    August 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

    Category: Cloud, Managed Instance, Microsoft SQL Server, SQL Database, SQLServerPedia Syndication | Tags: , , ,

  3. Adding a user to an Azure SQL DB

    1

    November 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

    Category: Cloud, Microsoft SQL Server, Security, SQL Database, SQLServerPedia Syndication | Tags: , , ,

  4. 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

    Category: Cloud, Microsoft SQL Server, SQL Database, SQLServerPedia Syndication, Synapse | Tags: , , ,

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

    5

    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

    Category: Cloud, Microsoft SQL Server, Problem Resolution, SQL Database, SQLServerPedia Syndication | Tags: ,

  6. 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

    Category: Cloud, Microsoft SQL Server, SQL Database, SQLServerPedia Syndication, T-SQL | Tags: , , ,

  7. 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

    Category: Microsoft SQL Server, Security, SQL Database, SQLServerPedia Syndication

  8. 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

    Category: Microsoft SQL Server, Security, SQL Database, SQLServerPedia Syndication | Tags: , ,

  9. 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

    Category: Cloud, SQL Database, SQLServerPedia Syndication | Tags: , ,

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

    5

    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

    Category: Cloud, SQL Database, SQLServerPedia Syndication, T-SQL Tuesday | Tags: , ,

« Older Entries

Follow me via RSS

RSS Feed RSS - Posts

RSS Feed RSS - Comments

Join 3,975 other subscribers

Follow me on Twitter

@sqlstudent144