2016-10

2016-08

log shipping. One of the key points I mentioned was how slow restoring can be for a read only log shipped database. If going and reading the whole thing is too much effort for you now, I’ll save you the effort (you child of the internet you) and tell you it’s because the database needs to be kept transactionally consistent in between restores when making it available for read-only. It creates a .tuf file (transaction undo file) to keep the progress of all the pages that have uncommitted transactions saved to them. The checking, creation, applying and re-applying of this can take some time where there is a significant amount of uncommitted transactions within a log backup.

posts. I realised I had made a mistake on that post and had updated. But I also realised that the script itself is actually part of a PowerShell module. So wanting to make things as easy as possible, and being the helpful guy that I am, I have altered that example into a script which I am posting here.

It’s worth stressing that the errors that output to the console are fairly generic, and that there is a log file that will contain all the information if there are any errors.

2016-07

Incremental Service Modelling, Microsoft have released SQL Server 2016 Cumulative Update #1 for SQL Server 2016 RTM.

2016-06

Incremental Service Modelling, Microsoft have released SQL Server 2014 Cumulative Update #7 for SQL Server 2014 SP1.

2016-02

Incremental Service Modelling, Microsoft have released SQL Server 2014 Cumulative Update #5 for SQL Server 2014 SP1.

2015-12

Incremental Service Modelling, Microsoft have released SQL Server 2014 Cumulative Update #4 for SQL Server 2014 SP1.

2015-10

Incremental Service Modelling, Microsoft have released SQL Server 2014 Cumulative Update #3 for SQL Server 2014 SP1.

2015-08

Incremental Service Modelling, Microsoft have released SQL Server 2014 Cumulative Update #2 for SQL Server 2014 SP1.

2015-04

Incremental Service Modelling, Microsoft have released SQL Server 2014 Cumulative Update #7.

2015-02

Incremental Service Modelling, Microsoft have released SQL Server 2014 Cumulative Update #6.

2014-10

Incremental Service Modelling, Microsoft have released SQL Server 2014 Cumulative Update #4.

2014-09

Incremental Service Modelling, Microsoft have released SQL Server 2014 Cumulative Update #3.

2014-07

2014-02

yesterday. So I’m 13 of the way towards achieving the Microsoft Certified Solutions Associate (MCSA) SQL Server Solutions Associate certification.

The second exam I passed is the “Delivering Continuous Value with Visual Studio 2012 Application Lifecycle Management”, which (along with the testing and TFS exams) is necessary for achieving the Microsoft Certified Solutions Developer Certification.

2013-10

to download here. It is also available as a VM on Azure. According to a tweet from Glenn Berry, the version number in the demo is 12.0.1524.

Before what you download and install, here’s what you ought to know;

2013-08

2013-07

The Story of Synchronized Settings - The Visual Studio Blog - Site Home - MSDN Blogs.

This blog from the Visual Studio team provides an insight into how and why synchronized settings came about.

2013-06

Visual Studio 2013 Preview and now the SQL Server 2014 CTP1. And that’s just the ones I’m focusing on! There’s the Windows 8.1 Preview as well as Windows Server 2012 R2. What with all the keynotes from Build and both TechEd’s this month, it is clear that Microsoft have certainly accelerated the release cycle and embraced a cloud-first development model. For me this is most noticeable in Team Foundation Services, the Azure based Source Control solution. Features were turned on regularly before they were released in the three updates we’ve had since the release of TFS 2012 back in August. This is a big change from the Microsoft’s previous strategy of developing for its products hosted on the premises first and then being pushed to them to the cloud afterwards.

At a later date I’ll dig more into features of SQL 2014, as this week my focus has been on Visual Studio 2013, which is out sometime this year, as well as doing my job in real life. The duties of blogging…

2013-04

2013-01

2012-12