1,796 reputation
826
bio website
location Denver, CO
age 39
visits member for 3 years, 9 months
seen Jan 23 at 20:27

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.


Sep
7
revised SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
added 212 characters in body
Sep
7
comment SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
+1 just for the query... I'm looking it over now, but appreciate the suggestion. One of these days I'm going to get approved for a full week of DMV training. And "wildly different profiles" is a very good way to put it.
Sep
7
comment SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
I see Ozar has an upcoming webinar on SANs for DBAs... sanbasics.eventbrite.com hmmm, good timing maybe. His presentations are usually pretty good.
Sep
7
revised SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
added 7 characters in body
Sep
7
asked SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
Jul
15
comment Change Tracking Retention from a backup?
Test results inconclusive... sorry. See my updated post below.
Jul
15
revised Change Tracking Retention from a backup?
deleted 695 characters in body
Jul
15
revised Change Tracking Retention from a backup?
deleted 695 characters in body
Jul
15
revised Change Tracking Retention from a backup?
added 418 characters in body
Jul
14
comment Retrieving row count without using Count function
@a_horse ... good catch - the query ran as was but you're right the column alias should have brackets as well.
Jul
14
revised Retrieving row count without using Count function
added 147 characters in body
Jul
14
comment Retrieving row count without using Count function
+1 for educational additions
Jul
14
answered Retrieving row count without using Count function
Jul
12
comment Change Tracking Retention from a backup?
Part two of that article: databasejournal.com/features/mssql/article.php/3829861/…
Jul
12
comment Change Tracking Retention from a backup?
Great article on change tracking and features: databasejournal.com/features/mssql/article.php/3824196/…
Jul
12
revised Change Tracking Retention from a backup?
added 84 characters in body
Jul
12
answered Change Tracking Retention from a backup?
Jun
10
awarded  Critic
May
27
awarded  Scholar
May
27
accepted Using integrated security over VPN