Welcome to MSDN Blogs
Sign in
|
Join
|
Help
Dave does Data
Tutorials, Performance Tuning, Tips & Techniques on SQL Server & its ecosystem.
This Blog
About
Email
Syndication
RSS 2.0
Atom 1.0
Search
News
SQL 08 SP1 has shipped,
Lijit Search
Tags
.NET
.NET Development
ADO.NET
Azure
BI
Cloud Computing
Connection Strings
Data Mining
Downloads
Events
Free
Geography
Geometry
Kids
Linked Servers
Load Testing
News
Polygon
Recommendations
Reporting Services
Small Biz
Software+Services
Spatial
SQL Analysis Services (SSAS)
SQL Integration Services (SSIS)
SQL Management Studio (SSMS)
SQL Reporting (SSRS)
SQL Server
SQL Server Analysis Services
SQL Server Intergration Services
SQL Server Spatial
SSAS
SSIS
SSRS
Tools
Training
TSQL
Visual Studio DBPro
Webcast
Windows 7
Recent Posts
Review: Programming MS SQL Server 2008 – Holistic coverage for an App Developer
Review: MS SQL Server 2008 Internals – Core knowledge for all DBA’s
Tip: Avoiding REALLY hard to reproduce bugs in Production
Tip SSMS: How to quickly find the line with the Syntax error
How to get Database Edition Power Tools to work on Visual Studio Team System 2008 Database Edition GD
Archives
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)
Browse by Tags
All Tags
»
Recommendations
(RSS)
.NET Development
Data Mining
Downloads
Free
Kids
News
SQL Analysis Services (SSAS)
SQL Integration Services (SSIS)
SQL Reporting (SSRS)
SQL Server
SQL Server Analysis Services
SQL Server Intergration Services
SQL Server Spatial
SSAS
SSIS
Training
TSQL
Saturday, October 03, 2009 7:57 PM
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. 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.
Posted by
davele
|
0 Comments
Filed under:
SQL Server
,
TSQL
,
SQL Server Spatial
,
Recommendations
,
SQL Reporting (SSRS)
,
SQL Analysis Services (SSAS)
,
Training
Saturday, September 26, 2009 11:14 PM
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: 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
Posted by
davele
|
0 Comments
Filed under:
SQL Server
,
TSQL
,
Recommendations
Wednesday, September 16, 2009 11:55 PM
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 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
Posted by
davele
|
0 Comments
Filed under:
SQL Server
,
TSQL
,
Recommendations
Saturday, August 22, 2009 3:23 PM
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 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
Posted by
davele
|
3 Comments
Filed under:
SQL Server
,
TSQL
,
Recommendations
Tuesday, April 21, 2009 3:59 AM
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 like MySQL just because they have an entry level offering for free. You may be one of many who expressed concern for its quality & design which suffered
Posted by
davele
|
2 Comments
Filed under:
SQL Server
,
Recommendations
,
SQL Reporting (SSRS)
,
Downloads
,
News
,
Free
Tuesday, April 21, 2009 3:56 AM
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 free” or they download pirate Microsoft from really dodgy, spyware prone sites to get it free. The irony is that many of these people qualify to get the
Posted by
davele
|
2 Comments
Filed under:
SQL Server
,
Recommendations
,
Downloads
,
News
,
Free
,
Training
Tuesday, April 21, 2009 12:15 AM
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 Technology. Point them at Kid's Corner . This site is full of videos, articles, tips & tricks. Many of the videos are have young teens being actors & doing
Posted by
davele
|
2 Comments
Filed under:
.NET Development
,
Recommendations
,
Free
,
Training
,
Kids
Thursday, April 16, 2009 4:17 PM
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 Scripts, Lab Exercises & a lot of PowerPoint's with notes. To get access to it all click here SQL Server 2008 Training . It is free but you do need
Posted by
davele
|
5 Comments
Filed under:
Data Mining
,
Recommendations
,
SQL Reporting (SSRS)
,
SQL Analysis Services (SSAS)
,
SQL Integration Services (SSIS)
,
Downloads
,
Free
,
Training
Saturday, November 08, 2008 7:23 PM
Resource Recommendations - Integration Services (SSIS & DTS)
I'm often asked "what references should I have for ... <Insert Technology here>. " For Integration Services (SSIS), the MUST HAVE "bible" text book is... Professional SQL Server 2005 Integration Services (See the link for ISBN
Posted by
davele
|
1 Comments
Filed under:
SSIS
,
SQL Server Intergration Services
,
Recommendations
Thursday, November 06, 2008 12:13 PM
Resource Recommendations - Data Mining
I'm often asked "what references should I have for ... <Insert Technology here>. " For Data Mining, the MUST HAVE "bible" text book is... Data Mining with SQL Server 2005 (See the link for ISBN & similar details) Why do I
Posted by
davele
|
1 Comments
Filed under:
SQL Server
,
Data Mining
,
Recommendations
,
SQL Server Analysis Services
,
SSAS