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.


Mar
31
awarded  Nice Question
Feb
7
comment Is there a way to use a SQL Server 2000 database in SSIS 2012?
@Zane Ehh, we've finally gotten rid of it. Now to update all the things.
Nov
1
asked Can SQL Server prevent the pagefile from being moved?
Sep
24
awarded  Popular Question
Sep
16
accepted Replication randomly started failing
Jul
16
asked Replication randomly started failing
Jul
16
answered Replication randomly started failing
Jun
11
comment Severity 016 Backup virtual device fail
@Cougar9000 i didn't include it, but there were messages in the app log that explicitly stated "backup of database x failed".
Jun
11
comment Severity 016 Backup virtual device fail
@Cougar9000 scheduled sql server maintenance plan.
Jun
11
comment Severity 016 Backup virtual device fail
@Cougar9000 yes, all databases. yes, it works at toher times, but seems to always fail on sundays.
Jun
11
awarded  Informed
Jun
11
asked Severity 016 Backup virtual device fail
May
14
awarded  Popular Question
May
13
awarded  Caucus
May
11
awarded  Yearling
Apr
29
awarded  Benefactor
Apr
29
comment What could cause the wrong ID to be inserted?
Interesting. I am going to look into this.
Apr
26
comment What could cause the wrong ID to be inserted?
yes, the first one sets the id to 0, so when the next record is inserted sql server takes the current id, adds 1, and gets 1. the next one the first id i would get is 2.
Apr
24
comment What could cause the wrong ID to be inserted?
@jnk we are not inserting data into identity columns anywhere in the application.
Apr
22
accepted Prevent users from using power pivot excel connections to a database