Sign In
Dave does Data
Tutorials, Performance Tuning, Tips & Techniques on SQL Server & its ecosystem.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
.NET
.NET Development
Connection Strings
Data Mining
Downloads
Free
Geography
Geometry
News
Polygon
Recommendations
Reporting Services
Spatial
SQL Analysis Services (SSAS)
SQL Integration Services (SSIS)
SQL Management Studio (SSMS)
SQL Reporting (SSRS)
SQL Server
SQL Server Intergration Services
SQL Server Spatial
SSIS
SSRS
Tools
Training
TSQL
Archive
Archives
November 2010
(4)
October 2010
(2)
August 2010
(1)
April 2010
(4)
January 2010
(2)
October 2009
(1)
September 2009
(8)
August 2009
(1)
May 2009
(1)
April 2009
(11)
March 2009
(1)
February 2009
(3)
January 2009
(1)
November 2008
(9)
October 2008
(8)
MSDN Blogs
>
Dave does Data
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Dave does Data
TSQL Tips: Writing more efficient DDL (Data Definition Language) with system functions
Posted
over 2 years ago
by
davele
4
Comments
The internet is swimming with examples of really inefficient TSQL code. Just because everyone does it that way doesn’t make it optimal. I’ve already blogged about the issues you will find with NOLOCK hints , this post show that using system functions...
Dave does Data
PreScan: SQL Schema Data Types
Posted
over 2 years ago
by
davele
0
Comments
Continuing on from my previous post PreScan: SQL Database Schema Distribution this Scan looks at the datatypes used in the database you need to tune. Perhaps one of the less useful of the pre-scans it is still handy. It highlights the use of depreciated...
Dave does Data
How to: See SharePoint 2010 Data Connections from Excel 2010
Posted
over 2 years ago
by
davele
3
Comments
Recently I tore my hair out trying to create a great end-user experience for my Excel 2010 users when they access SharePoint. Eventually I found a way to get it to work. This is not a perfect post. I’m far from an expert in SharePoint & I’m...
Dave does Data
PreScan: SQL Database Schema Distribution
Posted
over 2 years ago
by
davele
0
Comments
At the very start of a performance tuning exercise I do a Quick Appraisal to assess what I'm dealing with. This is one of a number of “information collection” scripts I run. This post shows (a) Code & (b) some ideas on insight you can...
Dave does Data
"How To": Performance Tuning - High Frequency Queries - Test Harness
Posted
over 2 years ago
by
davele
4
Comments
If I had a month free I’d like to do a brain dump on how to Load Test, Bulk Up data, find problem queries, refactor them with confidence etc. Then deliver it in one comprehensive guide. But that is unlikely, so I’ve decided to deliver little bits...
Dave does Data
Solution: Can edit, but can’t process, an Analysis Server Cube using ORACLE data
Posted
over 2 years ago
by
davele
2
Comments
Recently I was developing a SQL Server Analysis Server cube using Oracle as a data source. Weirdly the the development environment (BI Dev Studio) could see the Oracle schema & let me explore the data. But when I tried to process the cube or...
Dave does Data
Handy Links for SQL 2008 R2 & .NET Development
Posted
over 2 years ago
by
davele
0
Comments
This post is not about a unique body of work, it is just a list of links to materials I’ve found useful. I hope it may make it easier for me to point people here rather than have them write down or remember URL’s If you are looking for SQL Add-in’s, Utilities...
Dave does Data
Apple headline I’d like to see ;-)
Posted
over 2 years ago
by
davele
1
Comments
Apple releases the iPatch for software Pirates ® (pronounced Arrrh … me hearty's!) Note: This might not be true, but I think of it every time I hear the word iPad. Now you can too. If I worked for Apple it would only be a matter of...
Dave does Data
SQL 2008 R2 RTM’s check out the free training
Posted
over 2 years ago
by
davele
0
Comments
Yes SQL 2008 R2 has reached a major milestone, on the 21st Apr 2010 the news went to the world SQL2008 R2 has gone “Release To Manufacturing (RTM)”. This means that the Development Team (& many others) have signed it off as complete. It then takes...
Dave does Data
Hey Network installers, need a Cool way to cut a square hole in a skirting board?
Posted
over 2 years ago
by
davele
1
Comments
While this has little to do with Data & I am far from a DIY dude. Just thought I’d mention the Bosch PMF180E All Rounder . Just cause it is such a handy tool. I had some rot in my wooden deck & needed to cut out some wooden panels precisely on...
Dave does Data
Get the Data Mining Add-ins made for you
Posted
over 2 years ago
by
davele
0
Comments
Action Please consider taking this 1 page survey. & give your feedback to this team. http://survey.constantcontact.com/survey/a07e2shn6xwg6n3fotc/start Why? Recently a number of the Microsoft Data Mining folks decided to start up their own company...
Dave does Data
Geek Australian, N.Z, UK .NET Comedy
Posted
over 2 years ago
by
davele
0
Comments
Every now & then the politically correct world of Microsoft overlooks the cultural diversity of another nations gutter humour. Today I stumbled across one such example, it brought a slight smile to my face, the System.IO.Path. IsPathRooted Method...
Dave does Data
Ultimate Resource for File Extensions
Posted
over 2 years ago
by
davele
1
Comments
Occasionally, especially in large corporate clients, I find myself looking at a file extension wondering “what sort of application created that?”. Most often the file is intended to be a source of data for an SSIS extract & no-one can recall the legacy...
Dave does Data
Review: Programming MS SQL Server 2008 – Holistic coverage for an App Developer
Posted
over 3 years ago
by
davele
0
Comments
Following on from my review of my library. This week, Programming Microsoft SQL Server 2008. Summary: It appears to me that the authors started this book with the premise “There is a lot in SQL2008 that can dramatically change the way you architect solutions...
Dave does Data
Review: MS SQL Server 2008 Internals – Core knowledge for all DBA’s
Posted
over 3 years ago
by
davele
0
Comments
Following on from my review of my library. This week, Microsoft SQL Server 2008 Internals. Summary: This is not as the title might suggest, “special” information for elite DBA’s. It contains the base knowledge that all DBA’s need in order to understand...
Dave does Data
Tip: Avoiding REALLY hard to reproduce bugs in Production
Posted
over 3 years ago
by
davele
0
Comments
If everything is bug free in Development, Testing, User Acceptance Testing (UAT) how can it possibly go wrong in Production? The following post looks at how that can occur… Intermittently. Recommendation: Ensure that the Server Names & SQL Instance...
Dave does Data
Tip SSMS: How to quickly find the line with the Syntax error
Posted
over 3 years ago
by
davele
1
Comments
When executing code in SQL Server Management Studio. Occasionally people make errors. If you find yourself counting thru your TSQL Batch up to “LINE 231” where your error is supposed to be, then this tip is for you. Tip: Double Click on the Error...
Dave does Data
How to get Database Edition Power Tools to work on Visual Studio Team System 2008 Database Edition GDR
Posted
over 3 years ago
by
davele
2
Comments
If you want to compile sample code or write your own extensions for Visual Studio Team System 2008 Database Edition GDR (also known as DBPro or Datadude) this post will save you hours. Summary In Nov 08 when Microsoft shipped the GDR (General Distribution...
Dave does Data
Tip SSMS: Script your Entire Table including the Data – a hidden gem.
Posted
over 3 years ago
by
davele
0
Comments
Have you ever written a TSQL SELECT statement that builds INSERT Statements so you can script the entire table? Usually we do it to make it simple to create & load a “Reference or Lookup” table? Sure, Most DBA’s have. This Waay Cool little feature...
Dave does Data
Tip SSMS: How to BLOCK Select
Posted
over 3 years ago
by
davele
1
Comments
SQL Server Management Studio has so much capability, yet most people I meet don’t seem to have read the manual to discover it. So I thought I might post a few of features I find invaluable. This works for SQL 2005, SQL2008, SQL2008 R2 & Visual Studio...
Dave does Data
Review: MS SQL Server 2008 T-SQL Fundamentals – a must have for most people.
Posted
over 3 years ago
by
davele
0
Comments
At Tech-Ed Aust last week I had an interesting evening with a few people chatting about finding information & how hard it is to judge the value of textbooks when you are looking online. As I am an avid reader & have a huge library a few of my...
Dave does Data
TSQL Tips: The correct way to write your Scripts – ALTER PROC, don’t DROP & CREATE PROC
Posted
over 3 years ago
by
davele
2
Comments
SQL Management Studio has a very nice Scripting feature that generates scripts to DROP & CREATE your stored procedures, tables & other objects. This is handy, but not good for production systems. Most people use it, … to their peril. This post...
Dave does Data
Using TSQL Variables: Subtle BUG when assigning values to Variables via a Query
Posted
over 3 years ago
by
davele
3
Comments
I’m unsure if this is a BUG or “By Design” but for me it is unexpected & likely to cause your application to hang if you aren’t aware of it. So one more article in my “TSQL Best Practise” or “Good TSQL Coding Standards” posts. Summary: If you assign...
Dave does Data
More FREE training for Developers & DBA’s
Posted
over 3 years ago
by
davele
1
Comments
I tend to forget about this little gem, so this post more of a reminder to me, that I hope you will find handy too. Ramp Up: eLearning Site Official News I’m happy to announce that we’ve just launched 3 brand new learning tracks on Ramp Up * ( www.MyRampUp...
Dave does Data
News: Look at the CTP3 of our upcoming Distributed Cache technology - Velocity
Posted
over 3 years ago
by
davele
2
Comments
If you develop high scale, scale out/distributed apps, check out Microsoft Project Code Named “Velocity” Community Technology Preview 3 (CTP3) Released to Web on 7 April 09. "Velocity" is a distributed in-memory application cache platform for...
Page 1 of 3 (57 items)
1
2
3