I find the role of "DBA" is more like "Jack of all trades concerning Database Servers, the Databases contained and how those components interact with the universe around them".

At its...

Hi all, Is there any update or more recent improvements to the code? Does this take changes in SQL 2016 into account?

Thanks to the OP (Sean) for the...

Thanks Perry.

I'm going to build a 'Test Bed' and try it out.

I've been looking into this too lately. Could Resource Governor be used to point logins / groups to the read-only Servers? or can it be used to specify the "application...

Perry Whittle (11/27/2014)

---

jumpin (11/26/2014)

---

From what I've read adding the WSFC components to the server after SQL has already been installed is problematic and one of the ways around it is...

Hi there,

Thanks for the response so far. Below are the answers to your questions:

TheSQLGuru (11/26/2014)

---

1) What is your experience with windows clustering and SQL Server's Always On technologies? ...

Perry Whittle (11/26/2014)

---

you should be able to form the WSFC without uninstalling the existing instance.

First things to check are the OS and hardware between the existing server and its...

I'm currently working at a company that actively pursues upgrading to the latest version. I've also worked in environments where the oldest 'active' DB platform was SQL 2000 (and is...

I want SQL in the City to come to South Africa.

This is some useful code, but I have a bit of a challenge with it. Or should I say "I need it changed a bit".

What if I need another 'level'....

Msg 515, Level 16, State 2, Line 113

Cannot insert the value NULL into column 'NonClusteredIndexCount', table 'tempdb.dbo.#ClusteredIndexes___________________________________________________________________________________________________000000009C07'; column does not allow nulls. INSERT fails.

:angry: I've tried this script on 2...

Awesome. This is really helpfull. 😀

I've been thinking of doing something similar for a while now, but just haven't gotten round to it. Thanks for saving me the time. 😎

This is a very important topic that not many people (esp. men) take seriously. I've been there. Done that. Took a long time and 2 job moves to come out...

Good question. I'd also like to know that...