Tag Archives: ServiceBlog

Free download: Blog Yearbook 2016

I have made a compilation of all my blog posts of the past year, and it was more work than you would think.
Especially because it also contains a non-published new article.

After filling in the form you can download the e-book for free.

    I promise you the following:

    • I will not give or sell your email address to any third party.
    • I will not spam you.
    • If I start with a newsletter, you can easily unsubscribe or change the frequency.

    (c) 2016 hansmichiels.com – Do not steal the contents – spread the link instead – thank you.

    It’s patch & update time! (Updates on previous posts)

    Introduction

    As you might have noticed I have had a lack of time over the past weeks, this is why my posts are a bit irregular. Sorry for that.
    Today a listing of some updates that I did lately.

    The updates

    How to copy a database table structure (T-SQL Scripting Series)

    This script was last updated on 14 July, 2016. If you use it, make sure it is the most recent version.

    Using alternate (non-time) triggers to start a SQL Agent job (SQL Server Series)

    This article and open source code on Github was updated a few days ago. Please check it if you are interested.

    How to protect your stored procedures against multiple concurrent executions (SQL Server Series)

    This article is just updated. Thanks to very useful comments some of you gave me on the initial article (thank you for that) I have added examples of using sp_getapplock and sp_releaseapplock.

    Conclusion / Wrap up

    Nobody is perfect, this why updates exist.

    (c) 2016 hansmichiels.com – Do not steal the contents – spread the link instead – thank you.