can you provide details of the scripts you used to define the read only routing configuration (obfuscate any computer names and domain, etc)

I highly recommend you use Windows 2012 R2...

i don't think UK postcodes are an exact measurable science i could be wrong. They are assigned on a street level and one long street will usually have many postcodes

GraveD (11/14/2014)

---

Hi,

We have 2-node SQL Server 2008 R2 Cluster. I'm going to add a new node with SQL Server 2014 and then, after some time, upgrade the cluster to SQL...

enabling FTP also requires the application server features. It's bad practice to host web services on your SQL Server, segregate them always

Grant Fritchey (11/13/2014)

---

First, they run the Database Tuning Advisor and then do everything it says to do without looking at what it said. This leads to lots of indexes that...

TheSQLGuru (11/14/2014)

---

Yes, primary is the GOLD MASTER VERSION of the database. You can only have one of those, although it can move locations on failover. That is where...

SQL server doesn't tell porky pies, when you get this message it's because an I\O request has taken longer than 15ms. Common with SAN attached disks is storage saturation, but...

Database mirroring basic concept is exactly similar to AlwaysOn groups, they dont require shared storage.

Russell.Morgan-813114 (11/14/2014)

---

I need a location...

MyDoggieJessie (11/14/2014)

---

Russell; I'm looking to implement something similar to this and I'd be very curious to see how you implement this (seems like a great step-by-step article that you could...

what do you want shared storage for?

All instances...

it's the same principal as mirroring from 2012 to 2014 or Log shipping from 2012 to 2014, it's a one time switch due to the version number increase and database...

yes, you can use sql server clustered instances in an AlwaysOn group

it'll try so many times then comply with the default policy which leaves the resources offline rather than just constantly attempting restarts. After the default of one hour restarts will...

don't forget to check out my stairway series here on SSC too