... and, I'm wrong.

The link does in fact have the statement I was looking for, "When a SQL Server 2005 database is upgraded to SQL Server 2016, the database...

Perry Whittle (2/1/2016)

---

curious_sqldba (2/1/2016)

---

If you are moving to 2016, it will be two phase migration, from 2008R2 - > 2014 and then from 2014 -> 2016. At most you upgrade...

Hi, Rudy -

No need to apologize - you've done well.

"In my spare time" I'll see what it may take, and then I'll share it back.

Hi, Rudy -

Nice script! Thank you for sharing.

I have just over 300 SQL Servers, and about 100 are Express, for 3rd party apps.

Express instances give the following error when...

Thanks, all - for the encouraging comments.

Also, thanks to Albert for the informative links regarding CasPol.

What I haven't seen mentioned is the solution my organization uses:

Have a dedicated (to the DBAs) terminal server where SSMS, Profiler, et al, are installed. Then run...

paul 25096 (11/4/2015)

---

I think the reason "Options 1, 2 and 3" has more votes than "Option 2" is because of course you should also avoid statements that cause a syntax...

GilaMonster (9/2/2015)

---

So 6 then.

In that case, you can try 6, 9 or 12 as maxdop, see which works best for you (calced as 1x, 1.5x and 2x the number of...

Very nice little script. Thanks for sharing with the community.

For more security-minded DBAs (which I hope are most of us!) I recommend keeping "show advanced options" turned off, as well...

I don't work for Idera. That said, three or four times a year I run the Idera Password Checker (part of SQL Admin Toolset) against all my SQL servers (individual...

Right now I am the only DBA, for over 300 SQL servers. I don't know the SA password for any of them. I disable SA immediately upon creating a new...

A guy I've worked with for about 12 years was asked on an interview, "What is your biggest fear?"

He answered, "Kryptonite."

He got the job.

Idera's Patch Analyzer has a link "Check for New List", which...

Rod at work (9/5/2013)

---

We're finally moving to SQL 2012 from SQL 2005. Is there a way of automating the moving or copying of securables from the old database for some...

joshua.post (6/6/2013)

---

Is backing up the databases and restoring the best way, including Master and Model, or once the old server is shut down, can I just copy the files over?...