Dave does Data
Tutorials, Performance Tuning, Tips & Techniques on SQL Server & its ecosystem.
The internet is swimming with examples of really inefficient TSQL code. Just because everyone...
Date: 11/28/2010
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 releases the iPatch for software Pirates ® (pronounced Arrrh … me hearty's!) ...
Date: 04/22/2010
Yes SQL 2008 R2 has reached a major milestone, on the 21st Apr 2010 the news went to the world...
Date: 04/22/2010
Action Please consider taking this 1 page survey. & give your feedback to this team....
Date: 03/31/2010
Every now & then the politically correct world of Microsoft overlooks the cultural diversity of...
Date: 01/03/2010
Occasionally, especially in large corporate clients, I find myself looking at a file extension...
Date: 01/03/2010
Following on from my review of my library. This week, Programming Microsoft SQL Server 2008....
Date: 10/03/2009
If everything is bug free in Development, Testing, User Acceptance Testing (UAT) how can it possibly...
Date: 09/22/2009
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
SQL Management Studio has a very nice Scripting feature that generates scripts to DROP & CREATE...
Date: 09/11/2009
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
If you develop high scale, scale out/distributed apps, check out Microsoft Project Code Named...
Date: 04/20/2009
If you are a Student, Teacher or anyone on a budget, don’t feel pushed to use Open Source databases...
Date: 04/20/2009
Scanning the Microsoft sites it might not be obvious that April 09 was a huge month for new releases...
Date: 04/20/2009
If you know Primary, High School aged kids OR know a teacher who struggles to keep up with...
Date: 04/20/2009
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
April 09: Service Pack 1 for SQL 2008 can now be downloaded Download SQL 2008 Service Pack 1 from...
Date: 04/09/2009
It is extremely common to use computer generated Primary Keys in a table. eg: OrderID INT PRIMARY...
Date: 04/06/2009
Recently I’ve been flying around Australia delivering a 90 min seminar called Boost your BottomLine...
Date: 03/07/2009
This "How to" guide provides ideas & code samples on using color to improve your users...
Date: 02/16/2009
This "How to" guide provides ideas & code samples on using color to improve your users...
Date: 02/16/2009
This "How to" guide provides ideas & code samples on using color to improve your users...
Date: 02/16/2009
I'm often asked "what references should I have for ... <Insert Technology here>. "...
Date: 11/05/2008
UPDATE: Now this event is complete, you can watch it online as a Webcast here Power to Developers...
Date: 11/04/2008
Adding spatial capability to your app might be simpler than you think. This is not a comprehensive...
Date: 11/02/2008
This post covers how to get started with SQL Spatial methods & the best way to test things for...
Date: 11/01/2008
This post covers all the Methods to enter data in WKT, WKB & XML(GML) as well as functions to...
Date: 11/01/2008
This post covers the SqlGeographyBuilder & SqlGeometryBuilder Classes & their methods....
Date: 10/30/2008