you'll also want to set the multisubnetfailover=true option in your connection string. This requires .NET 4.5 or above

Slightly neater I suppose 😉

SELECT REPLACE(REPLACE(REPLACE(CAST(CONVERT(VARCHAR(19), GETDATE(), 120) AS VARCHAR(10)),'-',''),':',''),' ','');

hth

further to Jeff and Grant's posts, some additional reading on backups (including the importance and meaning of RTO and RPO), can be found in the following link. If you...

I do tend to agree. Logically, if an order has been placed, but we do not yet have a fulfillment date, then it is unknown, which is what null...

There is, apparently a workaround, but it does require a server restart, and I have to say it's not something I've tested because, frankly, the DTA is not something I'd...

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