If you can, use Windows Auth for your apps. No major flaws reported, and it can be secured well.

OAuth is another: http://oauth.net/

If you need to build something else into an...

Sean Redmond (2/2/2016)

---

Hi Steve,

On the other hand, for my day-to-day work, I don't do this. I'm not often at my home computer and others use it too. I prefer the...

mike.gallamore (2/2/2016)

---

Rocket science always makes me laugh. It's turtles all the way down of course so you can always get more and more detailed. But the basic physics of rocket...

I don't think you can do this in a single statement. I might be wrong, but I suspect you could drop the results into a temp table, then query that...

I'm in agreement with most people that changes should go through development. I agree nothing should happen on production. I think that the true version of your code is what's...

roger.plowman (2/1/2016)

---

"Certainly hot fixes need to occur, and there are times that you can't wait for a set of changes to be made in development, tested, approved, and then deployed...

Orlando Colamatteo (2/1/2016)

---

VCS needs to be taught in College and on Day 1 of onboarding in a new job. I find that with application developers (by apps I am targeting...

Orlando Colamatteo (2/1/2016)

---

VCS needs to be taught in College and on Day 1 of onboarding in a new job. I find that with application developers (by apps I am targeting...

Phil Parkin (2/1/2016)

---

I'm with the DBA: the true version of code is what's in Production.

And if your development and release processes are strict enough, the version in SC will match...

Jeff Moden (1/30/2016)

---

If anyone is actually doing it that way, they need to prepare to...

If you'd like to share, it would be great as an article, describe how/why you built the script.

You shouldn't need a restart. This is, IMHO, a flaw in SQL Server.

http://thomaslarock.com/2015/02/changing-default-database-file-locations-in-sql-server/

I changed this is setup, and it worked for me. (see pix)

I just changed this again, and it didn't appear to work. However what happens is that changing the location...

SQL 2005 direct upgrade is not supported. You can attach SQL 2005 data files to 2016 according to the docs.

There is also a note that 32->64 is not supported, so...