1,670 reputation
623
bio website
location Denver, CO
age 38
visits member for 2 years, 11 months
seen Mar 26 at 22:30

Developing, modeling, administering, tuning, troubleshooting, extracting, transforming, and loading databases full time since 1996.

First professional assignment with databases began building CAClipper xBase applications back when a database with 2 million plus records was considered huge. Moved to FoxPro and Borland Visual Delphi in the mid 90's and then SQL Server in '98.

Have also worked with Sybase, MySQL, Oracle, Access, Multivalue Informix, Filemaker, 4D and the Microsoft BI stack.


Nov
18
comment I Want to Become a Database Administrator - How Can I Start?
Probably right about it getting closed, but plus one until it does for giving such a thorough answer.
Nov
3
comment Change data capture - how to know who made the change?
Ahhhh, didn't catch that. I get what your saying now.
Nov
1
comment Change data capture - how to know who made the change?
That only gets you the svc account/owner of cdc, you might note that I tried those things and documented the results in my original question way back in Feb.
Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
We've been running CDC on an async mirror for several months. It's been working great for tbe data warehouse to query the snapshot. It wasn't until we moved the mirror partner to a new datacenter that all this became an issue. Setting up mirror and then CDC, no problem. CDC and then mirroring... not so easy.
Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
You know what... I just had an epiphany... do a full restore with keep_cdc on the new box. That will build cdc out, then start you multi file restore over the top of it without keep_cdc to do your point in time recovery. Ok, I'm squared away now.
Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
So restoring to a different database, a new database, or a database that will be a mirroring partner is still a no? I read this same article but it left me wondering about the scenarios above in a multi file scenario.
Sep
11
comment Do you know an easy way to generate one record for each hour of the past 12 hours?
Yeah for number tables - they're all the rage.
Mar
21
comment Upgrade SQL Server 2012 Express to Evaluation Edition
Yeah, sharepoint install makes it a little more fragile for sure.
Mar
21
comment Upgrade SQL Server 2012 Express to Evaluation Edition
How many databases on your express install? How much work to backup, install fresh, and restore?
Mar
8
comment Delete a variable number of records by a chronological order
Also, I was trying to get around deprecation with the sub select but it's a nil issue now. Thanks again.
Mar
8
comment Delete a variable number of records by a chronological order
Apparantly I didn't get the memo about using parenthesis. Thank you SQL2005. Awesome.
Mar
7
comment Change Data Capture and the __$update_mask binary
Check out my NEW answer before you do. As cool as the CLR is... we found an even better way. Good luck.
Mar
6
comment TSQL DateTime DataType - fractional seconds vs milliseconds
Its turning out to be a "taking their word for it" problem on my end with the vendor proc. They are using the LSN time mapping functions related to change data capture which DO allow < instead of =< calls. So, we'll be fixing code. msdn.microsoft.com/en-us/library/bb500137.aspx
Mar
6
comment TSQL DateTime DataType - fractional seconds vs milliseconds
If the range was in our own code that would be what we would do but we are passing to other procs that only take datetime for range and are inclusive on both ends
Feb
11
comment Quick way to validate two tables against each other
Nice, thanks... good way to find differences after aggregate indicates differences exist. Thanks.
Feb
8
comment Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
In summary... yes, I was misunderstanding the relationship between "parameter sniffing" and the plan cache. Knowing this better now brings it all together. Thanks guys.
Feb
8
comment Quick way to validate two tables against each other
Gave you a plus 1, but the aggregate provided by bacon bits was the icing on top. Thanks.
Feb
8
comment Quick way to validate two tables against each other
We can do a quick check against information_schema to make sure the schemas match. This does exactly what I was imagining... thanks.
Feb
8
comment Quick way to validate two tables against each other
It is an option, it's what is being used for the ETL process, but the mustaches upstairs want a second opinion on if it worked or not so using SSIS to prove that SSIS got it right is not as convincing as dropping fancy words like CheckSum or MD5 Hash.
Feb
8
comment Quick way to validate two tables against each other
This has potential. I'll do some testing and get back.