Dave does Data
Tutorials, Performance Tuning, Tips & Techniques on SQL Server & its ecosystem.
TSQL Tips: Writing more efficient DDL (Data Definition Language) with system functions
The internet is swimming with examples of really inefficient TSQL code. Just because everyone...
Date: 11/28/2010
Handy Links for SQL 2008 R2 & .NET Development
This post is not about a unique body of work, it is just a list of links to materials I’ve found...
Date: 08/03/2010
Apple headline I’d like to see ;-)
Apple releases the iPatch for software Pirates ® (pronounced Arrrh … me hearty's!) ...
Date: 04/22/2010
SQL 2008 R2 RTM’s check out the free training
Yes SQL 2008 R2 has reached a major milestone, on the 21st Apr 2010 the news went to the world...
Date: 04/22/2010
Get the Data Mining Add-ins made for you
Action Please consider taking this 1 page survey. & give your feedback to this team....
Date: 03/31/2010
Geek Australian, N.Z, UK .NET Comedy
Every now & then the politically correct world of Microsoft overlooks the cultural diversity of...
Date: 01/03/2010
Ultimate Resource for File Extensions
Occasionally, especially in large corporate clients, I find myself looking at a file extension...
Date: 01/03/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....
Date: 10/03/2009
Tip: Avoiding REALLY hard to reproduce bugs in Production
If everything is bug free in Development, Testing, User Acceptance Testing (UAT) how can it possibly...
Date: 09/22/2009
Tip SSMS: How to quickly find the line with the Syntax error
When executing code in SQL Server Management Studio. Occasionally people make errors. If you find...
Date: 09/21/2009
How to get Database Edition Power Tools to work on Visual Studio Team System 2008 Database Edition GDR
If you want to compile sample code or write your own extensions for Visual Studio Team System 2008...
Date: 09/20/2009
TSQL Tips: The correct way to write your Scripts – ALTER PROC, don’t DROP & CREATE PROC
SQL Management Studio has a very nice Scripting feature that generates scripts to DROP & CREATE...
Date: 09/11/2009
More FREE training for Developers & DBA’s
I tend to forget about this little gem, so this post more of a reminder to me, that I hope you will...
Date: 05/18/2009
News: Look at the CTP3 of our upcoming Distributed Cache technology - Velocity
If you develop high scale, scale out/distributed apps, check out Microsoft Project Code Named...
Date: 04/20/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...
Date: 04/20/2009
SQL Server 2008: April 09 Updates – Handy links
Scanning the Microsoft sites it might not be obvious that April 09 was a huge month for new releases...
Date: 04/20/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...
Date: 04/20/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...
Date: 04/16/2009
SQL Server 2008 SP1 - Released
April 09: Service Pack 1 for SQL 2008 can now be downloaded Download SQL 2008 Service Pack 1 from...
Date: 04/09/2009
Tip: Make your Identity Keys go Further
It is extremely common to use computer generated Primary Keys in a table. eg: OrderID INT PRIMARY...
Date: 04/06/2009
Boost your Bottomline – BI Breakfast with New Horizons
Recently I’ve been flying around Australia delivering a 90 min seminar called Boost your BottomLine...
Date: 03/07/2009
SQL Reporting "How to" - Conditional Color 1/4: The Basics. Report Expressions & Custom Code
This "How to" guide provides ideas & code samples on using color to improve your users...
Date: 02/16/2009
SQL Reporting "How to" - Conditional Color 2/4: Functions for Tables & Charts
This "How to" guide provides ideas & code samples on using color to improve your users...
Date: 02/16/2009
SQL Reporting "How to" - Conditional Color 3/4: Tint & Shade Functions
This "How to" guide provides ideas & code samples on using color to improve your users...
Date: 02/16/2009
Resource Recommendations - Data Mining
I'm often asked "what references should I have for ... <Insert Technology here>. "...
Date: 11/05/2008
Steve Ballmer Event SOLD OUT - But you can sneak in, online.
UPDATE: Now this event is complete, you can watch it online as a Webcast here Power to Developers...
Date: 11/04/2008
SQL 2008 - Ways to architect Spatial apps
Adding spatial capability to your app might be simpler than you think. This is not a comprehensive...
Date: 11/02/2008
SQL 2008 Spatial Samples, Part 1 of 9 - How to Learn SQL Spatial
This post covers how to get started with SQL Spatial methods & the best way to test things for...
Date: 11/01/2008
SQL 2008 Spatial Samples, Part 2 of 9 - Background on Spatial Types & Well Known Text (WKT)
This post covers all the Methods to enter data in WKT, WKB & XML(GML) as well as functions to...
Date: 11/01/2008
SQL 2008 Spatial Samples, Part 3 of 9 - SQL Builder API
This post covers the SqlGeographyBuilder & SqlGeometryBuilder Classes & their methods....
Date: 10/30/2008