Tag Archives: Microsoft SQL Server

  1. Call to action: What do you own?

    2

    April 29, 2020 by Kenneth Fisher

    You restored that database, did you remember to change the owner or is it still you? How about that job …
    Continue reading

  2. What is (local)?

    Leave a comment

    April 27, 2020 by Kenneth Fisher

    When connecting to a SQL Server instance sometimes you’ll see (local), localhost or even just a single period (hard to …
    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. What is the datatype SQL_VARIANT

    3

    April 16, 2020 by Kenneth Fisher

    The SQL_VARIANT data type is an interesting beast. It is a data type that can store most types of data. …
    Continue reading

  5. Has this login been used recently?

    3

    April 8, 2020 by Kenneth Fisher

    I get asked this every now and again, along with the companion When was the last time this login was …
    Continue reading

  6. SQL Homework – April 2020 – Continuity planning.

    3

    April 1, 2020 by Kenneth Fisher

    Normally for April 1st I’d try to post something a bit more lighthearted but with the state of the world …
    Continue reading

  7. Error handling protip: @@Error resets after the next command

    Leave a comment

    March 30, 2020 by Kenneth Fisher

    The system variable @@ERROR is a quick and easy way to retrieve the error number from the last statement run …
    Continue reading

  8. Why you should never use default string lengths.

    Leave a comment

    March 25, 2020 by Kenneth Fisher

    TL;DR; You probably don’t know what you’re going to get. Even if you do know the person maintaining your code …
    Continue reading

  9. DROP IF EXISTS

    Leave a comment

    March 23, 2020 by Kenneth Fisher

    It’s amazing the things that SQL can do these days. It’s also amazing how many of them I’ve managed to …
    Continue reading

  10. Using SQL Server on Azure Virtual Machines to ease your way into the cloud

    Leave a comment

    March 17, 2020 by Kenneth Fisher

    When it comes to migrating applications to Azure, there are a number of paths available. But if you’re migrating on-premises …
    Continue reading

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

Join 3,142 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013