Tag Archives: Renato Buda

SSIS Configurations – Best Practice

SSIS provides flexible and varied methods for configuring its packages. These allow operators or developers to change a package’s behaviour at run time to adapt to changing environments. While SSIS is flexible, I personally found there was a lack of … Continue reading

Posted in Data Focus | Tagged , , , , | 1 Comment

A Technique for Auditing User Initiated Batch Updates on SQL Server

Overview Auditing of user actions is a common business requirement. Typically users change data on a record-at-a-time basis using an interface that allows maintenance of a single record. In this case each change results in a single entry in an … Continue reading

Posted in Data Focus | Tagged , , , , | Leave a comment

Issues Importing Data from Excel

Sometimes data needs to be imported into systems using an Excel file format. This article is about understanding the problems encountered when using Excel for data import, and some ways to avoid them. Let me say straight up that while … Continue reading

Posted in Data Focus | Tagged , , , , | 2 Comments

Source Control for Database

Thursday, 17 March 2011 I have spent a lot of time migrating database changes between environments to support the various stages in the sofware development lifecycle. I have succeeded in automating aspects of this, and it has always been something … Continue reading

Posted in Data Focus | Tagged , , | Leave a comment

LinqPad

LinqPad looks great! http://linqpad.net/ http://www.linqpad.net/WhyLINQBeatsSQL.aspx       This tool lets you develop LINQ queries by playing with them against live data!   I find that the ability to quickly dev/test queries live is hugely productive, and that’s one reason … Continue reading

Posted in Data Focus | Tagged , , , , | Leave a comment