meta user
network profile
| bio | website | about.me/DavidForck |
|---|---|---|
| location | Missouri | |
| age | 26 | |
| visits | member for | 2 years, 1 month |
| seen | 23 hours ago | |
| stats | profile views | 43 |
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.
|
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 |
|
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" |
