One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being able to failover a group of databases which are logically connected. i.e. SharePoint databases. Well, it is also possible to do that in SQL 2008 (R2). It’s called a Grouped Failover.
2013-01-24 (first published: 2013-01-16)
560 reads
Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...
By Steve Jones
A customer asked about how they could organize their migration scripts in different ways...
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
I have a production server with SQL server 2016 version (13.0.5026.0) and a database...
I am trying to use unpivot to extract some data, however, the results are...
hi, I have one nested transaction and want to deescalate to outer transaction's isolation/...
Ask SSC