1,851 reputation
1026
bio website
location Denver, CO
age 39
visits member for 3 years, 11 months
seen Mar 17 at 19:36

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.


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
May
27
comment Using integrated security over VPN
I hesitate to mark your answer as correct for the simple fact that I want to hold on a little longer to the time when my "street cred" on this forum was higher than yours... but alas, it'll happen soon enough I guess.
May
25
comment What would I need to do to make sure my DB policies have to pass a security audit?
No problem, good luck with audit.
May
23
answered In MS SQL how do I find out what tables have not been queried or updated in a long time?
May
18
comment In Microsoft SQL Server's linked server configuration, what does the “RPC” setting do?
I'm just guessing here but from what you posted... if A is linked to B from A, and B is linked to A from B then the links are going both ways through two different pipes. The settings above likely only apply when A is linked to B on A ONLY.
May
18
revised What would I need to do to make sure my DB policies have to pass a security audit?
added 373 characters in body; added 90 characters in body
May
18
answered What would I need to do to make sure my DB policies have to pass a security audit?
May
18
comment What would I need to do to make sure my DB policies have to pass a security audit?
Agreed - they can't very well expect you to meet expectations without publishing what those expectations are. Is it related to HIPPA, Sarbanes Oxley, specific legal requirements related to the storage of criminal histories etc...
May
16
answered In Microsoft SQL Server's linked server configuration, what does the “RPC” setting do?
May
16
comment How can I get a list of column names and types from a resultset?
I like any solution that makes two jobs into one.
May
16
revised How to reduce the log file size without shrinking it in SQL server
added 2 characters in body
May
13
comment Should SQL full text search match the value test2 when searching for test?
I wrote an application once where I wanted to support all the features of FTS. I ended up having to outline in the user manual that users would need to pass quotes, wildcards, and specific syntax themselves in order to do fuzzy searches. Some power users of the application were able to figure it out but most users never took advantage and then also complained that the index wasn't very good. Google has made search expectations pretty lofty for most lay-users.