Category Archives: SQL Database

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

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

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

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

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

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

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

  8. Copying an on-premise Database to an Azure SQL Database

    4

    August 24, 2016 by Kenneth Fisher

    Continuing my exploration of Azure the next logical step seemed to be copying an on-premise database up to the cloud. …
    Continue reading

  9. Azure: What’s the difference between SQL Database and SQL Server?

    5

    August 9, 2016 by Kenneth Fisher

    If you want to blog T-SQL Tuesday is a great way to get started. On the first Tuesday of each …
    Continue reading

  10. Connecting to Azure SQL Database

    2

    May 25, 2016 by Kenneth Fisher

    Recently I created my first Azure SQL Database. But now I need to connect to it. You can connect using …
    Continue reading

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

Join 3,087 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013