Dave does Data

Tutorials, Performance Tuning, Tips & Techniques on SQL Server & its ecosystem.

Browse by Tags

Tagged Content List
  • Blog Post: Ultimate Resource for File Extensions

    Occasionally, especially in large corporate clients, I find myself looking at a file extension wondering “what sort of application created that?”. Most often the file is intended to be a source of data for an SSIS extract & no-one can recall the legacy system that created it. I found the following...
  • Blog Post: Boost your Bottomline – BI Breakfast with New Horizons

    Recently I’ve been flying around Australia delivering a 90 min seminar called Boost your BottomLine with SQL Server BI. This post is purely to make the Slides available for the audience. The audience was predominantly technical managers & architects in companies who owned SQL Server. The goal was...
  • Blog Post: Resource Recommendations - Integration Services (SSIS & DTS)

    I'm often asked "what references should I have for ... <Insert Technology here>. " For Integration Services (SSIS), the MUST HAVE "bible" text book is... Professional SQL Server 2005 Integration Services (See the link for ISBN & similar details) Why do I love this book?...
  • Blog Post: Handy sample Connection Strings

    Remembering the exact syntax of a connection string is a pain. The following are links to my favourite articles on making a connection string.   Connection Strings.Com   Another great site for developers is The Code Project: ADO Connection Strings & of course RTFM is also a great idea,...
Page 1 of 1 (4 items)