Share via


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

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

Next>