Great article, wasn't aware of the - Script command, that is very handy.

qh

It could be the way SQL Server runs on Windows 2012 Server, or Windows 2012 server itself, I don't really know.

Might be worth giving Ola a nudge to...

I did not find any result with extracting the files as the SP installer still uses the C:\ drive, however what I did find, (and in 15+ years of SQL...

Great post Rod.  Contractors/freelance get this from time to time; it's called being on the bench, the trick is to use this time wisely, something I've been guilty of not...

Thanks Sue_H, I will give that a try. Will post my result (if any) on here.

qh

One thing I have found of most successful DBA's is that they never stop learning, they never stop pushing the envelope of what they know. Knowledge is power. 😎

For the...

Thanks David, great article.

qh

Great article, thanks.

qh

Partly related to my editorial:

https://blogs.technet.microsoft.com/uktechnet/2016/03/21/dealing-with-security-risks-from-upper-management/%5B/url%5D

qh

Full marks Rob, at least you understood the implications and made changes to resolve that. My issue is the in house devs who are developing with full sysadmin access....

Thanks for the comments, and yes for DBA's it does sound all too familiar. At one client I used to actually wake up and think: I wonder if today's...

Top 5 regrets of the dying[/url]

Not wanting to bring anyone down and/or depressive but it does make you wonder, we're only here in this existence for ultimately a short time....

Great article, Andy; thanks for sharing.

ps - I'm teaching my kids chess, now that's where you find how damn smart they are becoming! 😀

qh

I think in some cases (or maybe a lot more) the problem is that some application have not been tested with higher versions of SQL Server. I've seen cases...

Nice article Steve on what can be a complex subject matter.

qh