Tag Archives: Microsoft SQL Server

  1. SQL Homework – April 2020 – Continuity planning.

    Leave a comment

    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

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

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

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

  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

  8. Set a variable and update a column at the same time.

    11

    February 19, 2020 by Kenneth Fisher

    The other day I saw a weird option for the UPDATE command in a stack overflow answer. Basically it looked …
    Continue reading

  9. SQL Homework – February 2020 – Write a blog post.

    1

    February 3, 2020 by Kenneth Fisher

    Following along with last month’s documentation homework this month I want you to write a blog post. But Ken, what …
    Continue reading

  10. CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))

    Leave a comment

    January 27, 2020 by Kenneth Fisher

    If you read the title to this post and your first thought was That’s not SQL is it? then you …
    Continue reading

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

Join 3,116 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013