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)
September, 2009
MSDN Blogs
>
Dave does Data
>
September, 2009
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
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...
Page 1 of 1 (8 items)