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
Hey Network installers, need a Cool way to cut a square hole in a skirting board?
While this has little to do with Data & I am far from a DIY dude. Just thought I’d mention the Bosch PMF180E All Rounder . Just cause it is such a handy tool. I had some rot in my wooden deck & needed to cut out some wooden panels precisely on the joists. I tried a chisel & a whole lot of...
7 Apr 2010
Get the Data Mining Add-ins made for you
Action Please consider taking this 1 page survey. & give your feedback to this team. http://survey.constantcontact.com/survey/a07e2shn6xwg6n3fotc/start Why? Recently a number of the Microsoft Data Mining folks decided to start up their own company Predixion Software . This includes two of the 3 authors...
31 Mar 2010
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
Review: Programming MS SQL Server 2008 – Holistic coverage for an App Developer
Following on from my review of my library. This week, Programming Microsoft SQL Server 2008. Summary: It appears to me that the authors started this book with the premise “There is a lot in SQL2008 that can dramatically change the way you architect solutions. Many features elegantly remove some of the...
3 Oct 2009
Review: MS SQL Server 2008 Internals – Core knowledge for all DBA’s
Following on from my review of my library. This week, Microsoft SQL Server 2008 Internals. Summary: This is not as the title might suggest, “special” information for elite DBA’s. It contains the base knowledge that all DBA’s need in order to understand what is happening under the covers. It may stop...
26 Sep 2009
Review: MS SQL Server 2008 T-SQL Fundamentals – a must have for most people.
At Tech-Ed Aust last week I had an interesting evening with a few people chatting about finding information & how hard it is to judge the value of textbooks when you are looking online. As I am an avid reader & have a huge library a few of my colleagues asked me to post my 2 cents about the books...
16 Sep 2009
Using TSQL Variables: Subtle BUG when assigning values to Variables via a Query
I’m unsure if this is a BUG or “By Design” but for me it is unexpected & likely to cause your application to hang if you aren’t aware of it. So one more article in my “TSQL Best Practise” or “Good TSQL Coding Standards” posts. Summary: If you assign a value to a variable using a SELECT statement...
22 Aug 2009
Get SQL Server 2008 for FREE: FREE Database, FREE Reporting Solution, FREE Spatial
If you are a Student, Teacher or anyone on a budget, don’t feel pushed to use Open Source databases like MySQL just because they have an entry level offering for free. You may be one of many who expressed concern for its quality & design which suffered when SUN purchased MySQL. Who knows what will...
20 Apr 2009
How do I get FREE Software from Microsoft?
It is common to hear students & small start-up businesses state “I use Open Source because it is free” or they download pirate Microsoft from really dodgy, spyware prone sites to get it free. The irony is that many of these people qualify to get the software for FREE or at least heavily discounted...
20 Apr 2009
Teach your Kids to Program these school Holidays
If you know Primary, High School aged kids OR know a teacher who struggles to keep up with Technology. Point them at Kid's Corner . This site is full of videos, articles, tips & tricks. Many of the videos are have young teens being actors & doing the voiceovers. For some examples, check out a...
20 Apr 2009
SQL Server 2008 Jumpstart Materials – very detailed training, now FREE to download.
This post is a pointer to a lot of in-depth training on SQL 2008. It includes Virtual PC’s with Demo Scripts, Lab Exercises & a lot of PowerPoint's with notes. To get access to it all click here SQL Server 2008 Training . It is free but you do need to register as helps us to cost justify developing...
16 Apr 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
Resource Recommendations - Data Mining
I'm often asked "what references should I have for ... <Insert Technology here>. " For Data Mining, the MUST HAVE "bible" text book is... Data Mining with SQL Server 2005 (See the link for ISBN & similar details) Why do I love this book? It walks thru each data mining algorithm...
5 Nov 2008
Page 1 of 1 (13 items)
© 2013 Microsoft Corporation.
Privacy & Cookies