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...

Author: davele 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...

Author: davele Date: 08/03/2010

Apple headline I’d like to see ;-)

Apple releases the iPatch for software Pirates ®  (pronounced Arrrh … me hearty's!)  ...

Author: davele 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...

Author: davele 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....

Author: davele 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...

Author: davele Date: 01/03/2010

Ultimate Resource for File Extensions

Occasionally, especially in large corporate clients, I find myself looking at a file extension...

Author: davele 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....

Author: davele 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...

Author: davele 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...

Author: davele 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...

Author: davele 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...

Author: davele 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...

Author: davele 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...

Author: davele 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...

Author: davele Date: 04/20/2009

Scanning the Microsoft sites it might not be obvious that April 09 was a huge month for new releases...

Author: davele 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...

Author: davele 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...

Author: davele 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...

Author: davele 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...

Author: davele 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...

Author: davele 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...

Author: davele 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...

Author: davele 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...

Author: davele Date: 02/16/2009

Resource Recommendations - Data Mining

I'm often asked "what references should I have for ... <Insert Technology here>. "...

Author: davele 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...

Author: davele 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...

Author: davele 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...

Author: davele 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...

Author: davele Date: 11/01/2008

SQL 2008 Spatial Samples, Part 3 of 9 - SQL Builder API

This post covers the SqlGeographyBuilder & SqlGeometryBuilder Classes & their methods....

Author: davele Date: 10/30/2008

Next>