1,053 reputation
627
bio website about.me/DavidForck
location Missouri
age 27
visits member for 2 years, 11 months
seen Feb 7 at 22:07

I'm a database developer for a CRO that does pharmaceutical and chemical studies. My duties include: designing and building databases, troubleshooting database performance issues, building SSRS reports, installing and configuring SQL Server (2005 and 2008), configuring SQL Server security, configuring SSRS security, and some other stuff.

I also build on-line surveys in PHP using a MSSQL Server 2005 backend for an Economic Development Consulting company.


May
7
comment Setting up users and admins with schema privileges
definatley can't do this. the application calls the stored procedures by schema.procname. by moving the procs to different schemas we completley break the app, and we're getting ready to do a final push to production. hence why i'm trying to clear up security.
May
7
accepted Can you rename or name Reporting Services jobs?
May
7
accepted What is the signifigance of a fillfactor of 20?
May
7
accepted Job Schedule view
May
7
accepted Can you rename replication jobs?
May
7
accepted Tracking stored procedure usage
May
7
asked Setting up users and admins with schema privileges
May
1
asked Can you rename or name Reporting Services jobs?
May
1
asked Can you rename replication jobs?
Apr
25
comment Help with this query
no explination of your code?
Apr
17
answered Why do people recommend not using the name “Id” for an identity column?
Apr
13
asked Tracking stored procedure usage
Apr
13
answered Manage select results in sql
Apr
12
comment Prevent Data Sources from being deployed outside designated folder
Yup, use Reporting Service's built in security management.
Apr
12
comment Manage select results in sql
What do you mean by manipulate? What are you doing after the initial select?
Apr
5
awarded  Organizer
Apr
5
revised What is the easiest way to use a SQL Server backup to retrieve just a few rows?
spelling, grammer, tags
Apr
5
suggested suggested edit on What is the easiest way to use a SQL Server backup to retrieve just a few rows?
Apr
5
comment Beginner design of biological sampling database
i'm still for not having a visits table....
Apr
5
answered CTE Running in Infinite Loop