Mike Diehl's WebLog
Much aBlog about nothing...
Browse by Tags
All Tags
»
SQL Server
(
RSS
)
.NET
Data Dude
Heap
Imaginet
Integration Services
Merge
SSIS
Team System
Visual Studio
SQL Table stored as a Heap - the dangers within
30 April 10 11:55 AM
|
MikeD
|
6 comment(s)
Nearly all of the time I create a table, I include a primary key, and often that PK is implemented as a clustered index. Those two don't always have to go together, but in my world they almost always do. On a recent project, I was working on a data warehouse...
SSIS Bulk Insert task that bit me in the butt...
02 October 09 12:22 PM
|
MikeD
I've been working on SSIS packages that extract data from production databases and put them into data warehouses, and recently I hit an issue using the Bulk Insert task that bit me real good. When you create a Bulk Insert task in the control flow of your...
SQL Database diagramming and VSTS Data Dude
28 July 09 07:14 PM
|
MikeD
At Imaginet, we use Visual Studio Team Edition for Database Professionals (Data Dude) on our projects to manage database schemas, keep them in source control, unit testing, and lots of other nice features. But it doesn't do database models well. Or at...
MS BI Conference: Monday Keynote
06 October 08 08:31 PM
|
MikeD
Here are my notes on the Monday morning keynote: About 3000 attendees at the conference, over 60 countries represented. There is BI in Halo3: whenever you look at competitor stats or weapon effectiveness, this is implemented using BI tech Madison - MS...
Swivel
14 December 06 12:58 PM
|
MikeD
|
1 comment(s)
Swivel has been called "YouTube for Data". Very cool. Who will be the first to post their Team System productivity data? How about some kind of SQL Server connector to Swivels?
More Posts
Search
Go
This Blog
Home
Contact
About
Tags
.NET
.NET Development
2011 predictions azure facebook xbox kinect
asp.net
Business Intelligence
Community News
Data Dude
Database stuff
DDD
General Software Development
Heap
Imaginet
Integration Services
Merge
MSBuild
ORM
Personal
PowerShell
Sandcastle
Sharepoint
Software Factories
SQL Server
SSIS
TDD
Team System
Visual Studio
WCF
Web Services
Navigation
Home
Blogs
Archives
December 2010 (1)
June 2010 (1)
April 2010 (1)
October 2009 (1)
July 2009 (1)
October 2008 (2)
May 2007 (14)
April 2007 (1)
February 2007 (2)
January 2007 (1)
December 2006 (1)
November 2006 (1)
October 2006 (12)
September 2006 (6)
August 2006 (5)
July 2006 (1)
June 2006 (1)
May 2006 (2)
April 2006 (1)
January 2006 (4)
December 2005 (6)
September 2005 (4)
August 2005 (3)
July 2005 (4)
January 2005 (1)
November 2004 (1)
September 2004 (4)
April 2004 (1)
March 2004 (8)
February 2004 (11)
January 2004 (17)
December 2003 (23)
November 2003 (5)
Other web sites
Personal Blogspace
Joel
Not from Toronto
Robert Hahn
Derek Hatchard
Syndication
RSS
Atom