We just upgraded our last few SQL2000 dbs to 2008R2 earlier this year and that was a very large project that took over 2 years to complete as it was...

Do NOT count out the Cardinals... they are in it every single year. KC is very strong this year as well.

Great. Thanks, much appreciated.

I have never been able to figure this out either.

What level of SQL Server 2014 are you at? RTM, CU, SP1? select @@version will give you that if you don't know.

Best I can tell from doing more digging is that RDS is simply SQL Server as a service and that is it. The other is like creating a VM...

Better get your legal dept involved. The decision for us to put anything in the cloud is waiting on our Legal Dept to give us the OK to...

Several things....

YES, rebuild indexes at bare minimum after moving from 2008 to 2014... any verison upgrade you should do that.

Also, get the query and see what indexes it...

We have a formal change control process where ANYTHING that changes including windows patches or restarts HAVE to be approved by the application owner and a DBA if it...

We used some type of purchased tool that would migrate everything server wise to a new domain. It would see the domain users within SQL Server and then create...

We rotate each week who the DBA on Call is. That person does the requests and is the one called for after hours issues. If that person gets...

We use COMMVAULT to backup our SQL Servers as well. Yes, it uses a SQL Server Domain ID to run the SQL DB Backups and stores them within COMMVAULT....

IT here let go about 15 people last year and then created about 20 new positions mostly in the Mobile space. The direction and technology changes so IT must...

We have applied it to almost all NonProd and a couple Prod environments without issue so far.

Nice script. However, I found one flaw to it. If you have a database that has never been backed up or had an integrity check run on it...