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.

Hans Michiels

Hans is an Independent Business Intelligence and Datawarehouse Consultant & Microsoft SQL Server Consultant, working in the Netherlands. He has been working in the software industry since 1996, with SQL Server since the year 2001, and since 2008 he has a primary focus on datawarehouse- and business intelligence projects using Microsoft technology, using a Datavault and Kimball architecture. He has a special interest in Datawarehouse Automation and Metadata driven solutions. * Certified in Data Vault Modeling: Certified Data Vault 2.0 Practitioner, CDVDM (aka Data Vault 1.0) * Certified in MS SQL Server: * MCSA (Microsoft Certified Solutions Associate) SQL Server 2012 - MCITP Business Intelligence Developer 2005/2008 - MCITP Database Developer 2005/2008 - MCITP Database Administrator 2005/2008

More Posts