Reputation
884
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
1 10 22
Newest
 Yearling
Impact
~81k people reached

Aug
10
awarded  Taxonomist
Jun
27
accepted Reason for using hexadecimal in NCHAR()?
Jun
26
revised Reason for using hexadecimal in NCHAR()?
added 2 characters in body
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.