762 reputation
1720
bio website
location
age
visits member for 3 years, 7 months
seen 3 hours ago

May
31
asked Should numeric identifiers like serial numbers be stored as integers?
May
15
awarded  Popular Question
Apr
19
awarded  Popular Question
Mar
23
awarded  Yearling
Feb
6
awarded  Notable Question
Jan
12
accepted With the advent of integrated source control, do stored procedure changes still need comments?
Jan
11
revised With the advent of integrated source control, do stored procedure changes still need comments?
edited tags
Jan
11
asked With the advent of integrated source control, do stored procedure changes still need comments?
Dec
28
answered SQL Server 2005 on Windows 7 along with SQL Server 2008 R2 Express edition
Dec
14
accepted ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?
Dec
14
comment ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?
BIML looks very interesting. I was also considering creating each data flow as a separate package and then having them called through a master package. Do you think that's any better? Also, curious if you have an opinion on the T-SQL approach. It's slower but I've tested it and it will work.
Dec
14
comment ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?
The databases reside on multiple servers which I think makes it more complicated. I have actually tried creating a view of different tables on my development box against 225 databases and reading of the data was painfully slow.
Dec
14
asked ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?
Nov
5
awarded  Popular Question
Oct
27
comment overhead for INSERTS using change tracking and/or change data capture (CDC)
You may find this link useful: databasejournal.com/features/mssql/article.php/3806001/…
Oct
25
comment Data archival strategy that handles schema changes?
Maybe substantial is the wrong word but the functionality is constantly evolving. It would not be unusual to see the addition of new tables and columns as well as modifications to existing ones.
Oct
25
asked Data archival strategy that handles schema changes?
Aug
31
revised Commonly Used Acronyms by Database Administrators
Added MDX - Multidimensional Expressions
Aug
29
accepted Does surrogate key assignment for a fact table require that the source data has natural keys?
Aug
29
comment Does surrogate key assignment for a fact table require that the source data has natural keys?
In this example, I think the rules are one order per one customer and one product (not realistic, I know).