Dave does Data
Tutorials, Performance Tuning, Tips & Techniques on SQL Server & its ecosystem.
Translate This Page
Translate this page
SQL Analysis Services (SSAS)
SQL Data Mining (SSAS-DM)
SQL Integration Services (SSIS)
SQL Management Studio (SSMS)
SQL Reporting (SSRS)
SQL Server Analysis Services
SQL Server Intergration Services
SQL Server Spatial
Visual Studio DBPro
Browse by Tags
Dave does Data
Tagged Content List
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...
3 Jan 2010
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...
7 Mar 2009
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?...
8 Nov 2008
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,...
21 Oct 2008
Page 1 of 1 (4 items)
© 2015 Microsoft Corporation.
Privacy & Cookies