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

PreScan: SQL Schema Data Types

Continuing on from my previous post PreScan: SQL Database Schema Distribution this Scan looks at the...

Author: davele Date: 11/18/2010

How to: See SharePoint 2010 Data Connections from Excel 2010

  Recently I tore my hair out trying to create a great end-user experience for my Excel 2010...

Author: davele Date: 11/14/2010

PreScan: SQL Database Schema Distribution

  At the very start of a performance tuning exercise I do a Quick Appraisal to assess what I'm...

Author: davele Date: 11/14/2010

"How To": Performance Tuning - High Frequency Queries - Test Harness

  If I had a month free I’d like to do a brain dump on how to Load Test, Bulk Up data, find...

Author: davele Date: 10/24/2010

Solution: Can edit, but can’t process, an Analysis Server Cube using ORACLE data

  Recently I was developing a SQL Server Analysis Server cube using Oracle as a data source....

Author: davele Date: 10/16/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

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

Author: davele Date: 04/07/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

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

Author: davele Date: 09/26/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

Tip SSMS: Script your Entire Table including the Data – a hidden gem.

Have you ever written a TSQL SELECT statement that builds INSERT Statements so you can script the...

Author: davele Date: 09/19/2009

Tip SSMS: How to BLOCK Select

SQL Server Management Studio has so much capability, yet most people I meet don’t seem to have read...

Author: davele Date: 09/18/2009

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

Author: davele Date: 09/16/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

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

Author: davele Date: 08/22/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

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

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

Even though its been available for more than 6 months, many people have overlooked this little gem....

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

Database Design – Many to Many Join Tables

I was asked why my previous post suggested to “not use an Identity Column as a Key for Many to Many...

Author: davele Date: 04/06/2009

SQL Server NOLOCK Hint & other poor ideas.

Frequently I see production code, created by professional development teams, peppered with NOLOCK...

Author: davele Date: 04/05/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

SQL Reporting "How to" – Conditional Color 4/4: Charts & Multi-Dimensional analysis

Part 4 of 4: Continuous Color functions for Multi-Dimensional analysis (in charts) This "How to"...

Author: davele Date: 01/30/2009

SQL Spatial - How to get Spatial data. (FREE Maps 'n Demographics)

This post lists ways to get spatial maps, some of them are Free. If you are in a hurry jump to the...

Author: davele Date: 11/13/2008

Resource Recommendations - Integration Services (SSIS & DTS)

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

Author: davele Date: 11/08/2008

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

Small Business Server 2008 - WOW

Summary. I don't think every product that Microsoft ships is great, one or two embarrass me. Most...

Author: davele Date: 11/04/2008

SQL Spatial - Tips on Storage

This post talks about ways to Store Spatial Reference data in SQL in order to improve performance of...

Author: davele Date: 11/03/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>