meta user
network profile
| bio | website | |
|---|---|---|
| location | Denver, CO | |
| age | 37 | |
| visits | member for | 2 years |
| seen | 23 hours ago | |
| stats | profile views | 179 |
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.
|
May 15 |
awarded | Caucus |
|
May 1 |
awarded | Enlightened |
|
May 1 |
awarded | Nice Answer |
|
Apr 27 |
awarded | Yearling |
|
Apr 13 |
awarded | Nice Question |
|
Mar 26 |
comment |
Booking system structure Does it meet the needs of the business logic? Simple is good if it covers the purpose of it's creation. In the booking record I assume that client and room are FK to clientid and roomid? My only suggestion... I usually recommend naming the same for clarity sake. |
|
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 14 |
comment |
Can't choose which date sql server 2005 backup to read in sql server 2008. Is one a full backup and the others log backups? Don't rely on the file extensions because SQL doesn't actually care about that. |
|
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 |
accepted | Delete a variable number of records by a chronological order |
|
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 8 |
revised |
Delete a variable number of records by a chronological order deleted 9 characters in body |
|
Mar 8 |
asked | Delete a variable number of records by a chronological order |
|
Mar 7 |
revised |
Change Data Capture and the __$update_mask binary deleted 29 characters in body |
|
Mar 7 |
revised |
Change Data Capture and the __$update_mask binary added 34 characters in body |
|
Mar 7 |
revised |
Change Data Capture and the __$update_mask binary added 66 characters in body |
|
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 7 |
accepted | Change Data Capture and the __$update_mask binary |
|
Mar 7 |
answered | Change Data Capture and the __$update_mask binary |
