Archive for month: April, 2010

My Top Ten Lessons From SQL Saturday #31 Chicago

19 April, 2010 (11:50) | SQL, SQLSaturday | By: Mark V

I attended SQL Saturday Chicago this weekend. I had an awesome time and attended great sessions. While I got something good out of every one of the sessions, I decided to distill the entire experience into a top ten list with some of the highlights. 10. According to Google Maps, the distance from Grand station […]

Making Your SSIS Configuration Files More Readable

15 April, 2010 (10:45) | SSIS, XML | By: Mark V

When you first create a configuration file in your Integration Services project, the XML contents of the file are just laid out in one long line. This makes reading and/or modifying this file more challenging than it needs to be. There is an easy way to format your file to alleviate this issue. In BIDS, […]

A Hint on Using Indexed Views For Read Performance

13 April, 2010 (13:13) | SQL, T-SQL | By: Mark V

Some time ago, I was on a project in which we implemented a report model. The data was located in several different databases, none of which were very conducive to reporting. The consequence was that the views upon which we based our entities for the model required lots of joins and performed poorly. We decided […]