Reputation
971
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 11 25
Newest
 Caucus
Impact
~98k people reached

Jun
26
asked Reason for using hexadecimal in NCHAR()?
Jun
22
comment How to gracefully handle a source database restore from backup in a data warehouse
@MarkStorey-Smith: I think a rebuild is a possibility; is that how this is typically handled in the field?
Jun
21
accepted Should numeric identifiers like serial numbers be stored as integers?
Jun
21
asked How to gracefully handle a source database restore from backup in a data warehouse
Jun
2
accepted How to break out of error loop in transactional replication?
Jun
2
accepted Data archival strategy that handles schema changes?
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