DForck42

953 reputation

624

bio	website	about.me/DavidForck
	location	Missouri
	age	26
visits	member for	2 years
	seen	2 days ago
stats	profile views	40

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.

	953 reputation	bio	website	about.me/DavidForck	visits	member for	2 years
624 badges		location	Missouri		seen	2 days ago

summary answers questions tags badges favorites bounties reputation activity

228 Actions

suggestions reviews revisions comments badges posts accepts all

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"
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.