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.


Apr
19
revised Compress backup file using T-SQL
cleaned up grammer
Apr
19
suggested suggested edit on Compress backup file using T-SQL
Apr
16
comment Prevent users from using power pivot excel connections to a database
Also, @kin, power pivot shows up with the application name "Microsoft Office 2010". I set it up to block anythign with "Office" and it seems to work. Testing it out with my boss now.
Apr
16
comment Prevent users from using power pivot excel connections to a database
well it was my boss that was inquiring about this, he fould the permission hole. I don't want users connecting to my oltp databases unless it's through an application.
Apr
16
accepted dbo.DTA_* tables in MSDB
Apr
16
asked Prevent users from using power pivot excel connections to a database
Apr
12
revised What is the best permissions to set for only creating and managing own databases?
removed "Thanks"
Apr
12
suggested suggested edit on What is the best permissions to set for only creating and managing own databases?
Apr
12
comment What could cause the wrong ID to be inserted?
@AaronBertrand very rarely, mainly when we need to clear out the data in a database after testing has been done. Once a database hits production we don't clear the data.
Apr
12
comment What could cause the wrong ID to be inserted?
I edited my question to include that my table already had data in it when i deleted the data.
Apr
12
revised What could cause the wrong ID to be inserted?
added 32 characters in body
Apr
12
comment What could cause the wrong ID to be inserted?
@MartinSmith deleting the record and reseeding is the pattern that i've been following. Truncate doesn't work on most of our tables since they have FK relationships.
Apr
12
asked What could cause the wrong ID to be inserted?
Mar
13
comment Why is this user “Admin” created in all databases?
I was going to say that it was probably in the Model database. Good job figuring it out.
Mar
13
comment What alternatives exist when a table requires too many foreign keys?
I have to agree with Aaron Bertrand, if your design requires you to max out the foreign keys sql server supports, it may be time to consider a redesign.
Mar
7
awarded  Notable Question
Feb
21
awarded  Popular Question
Feb
19
accepted Find orphaned users
Feb
18
asked Find orphaned users
Feb
18
asked dbo.DTA_* tables in MSDB