meta user
network profile
| bio | website | |
|---|---|---|
| location | Denver, CO | |
| age | 37 | |
| visits | member for | 2 years, 1 month |
| seen | 2 days ago | |
| stats | profile views | 180 |
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 @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 |
|
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. |
