I have to say, that tool is a potential disaster area, and you really shouldn't, if you run it, implement its recommendations without some serious further investigation, as if you...

Firstly, if you do your backup with the checksum option, this will identify various forms of potential corruption. Restore with verifyonly will also identify a range of issues with...

alan.archer (10/7/2016)

The challenge is to find others that are motivated to learn and excel, identify them early in their career (it takes years to learn this SQL stuff well! Agreed?)...

FTFY

pdanes (10/8/2016)

---

I don't know about for the net in general, but for this forum, maybe Steve could institute some sort of marking for people that know what they are talking...

My guess would be the SQL Server service account not having access to that location. Can't see the location / file => file doesn't exist

16 cores on a VM looks like a lot to me. If you over provision cores on VM's running SQL Server this can lead to shocking performance problems. ...

MDW also has some decent functionality for managing and reporting on this, as well as a range of other performance and management related stuff

http://www.johnsansom.com/sql-server-management-data-warehouse-and-why-it-rocks/

To me, they're not really the same thing. MySQL is more of a replacement for xBase than a proper enterprise product, it's certainly nowhere like Oracle or SQL Server...

Grant Fritchey (9/26/2016)

---

Thanks everyone for the feedback. I was hoping someone would come in and argue in favor of hiding information since it sometimes seems to be considered a valid...

Another thing to consider when you're benchmarking for CPU would be the comparative performance of the CPU. If you're on something like E5-2640 v3 CPU's you may be getting...

netmikem (9/28/2016)

---

I am quite sure I came across a blog or some article in the last six months mentioning that SQL Server 2014 Developer Edition is now free.

I can't seem...

For the benefit of any future unwary victims.

The Audit_DDL_Events table is one that is used by DDL triggers for tracking changes, and presumably is only set up when you create...

It's an option for the version 11 and 13 ODBC driver

Via the wizard 10 seconds, but it would more likely be...