Monthly Archives: March 2020

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

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

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

  4. There needs to be a win

    Leave a comment

    March 19, 2020 by Kenneth Fisher

    A while back a company I worked for had two teams. One was a development team and the other was …
    Continue reading

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

  6. Change the size of the grid results view in SSMS

    1

    March 4, 2020 by Kenneth Fisher

    After my post last month about configuring your tools I’ve been on a make my life easier kick and one …
    Continue reading

  7. SQL Homework – March 2020 – Database Configurations.

    Leave a comment

    March 2, 2020 by Kenneth Fisher

    A little while back we tried configuring the instance. Sometimes though, instance settings are a bit heavy handed, so this …
    Continue reading

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

Join 3,155 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013