Dave does Data

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

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • 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: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • 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: 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...
Page 1 of 1 (13 items)