Full DTC Support for AGs Now in SQL Server 2017

By: on June 7, 2017 in Always On, Availability Groups, Distributed Transaction Coordinator, DTC, SQL Server 2017 | No Comments

SQL Server 2016 introduced support for the Microsoft Distributed Transaction Coordinator (DTC, or MS DTC) and Always On availability groups (click here for more info). However, what is in SQL Server 2016 is only half of the story. For a cross database transaction, it can happen either in the same instance of SQL Server (and therefore, as databases participating in a single AG), or to another database in another instance of SQL Server or some other data source like Oracle. The functionality in SQL Server 2016 covers the latter. That means that if you have two databases in an SQL Serer 2016 AG, you still have the old way – meaning, distributed transactions won’t work properly.

This has now been fixed as of SQL Server 2017 CTP 2.0. Somehow I missed this line in the release notes for CTP 2.0:

DTC support for Always On Availability Groups for all cross database transactions among databases that are part of the availability group, including for databases that are part of same instance.

As far as I know, this will not be backported to SQL Server 2016, but if you need full DTC support with AGs, it’s now there in SQL Server 2017 – a good reason to consider looking at it now. Want help with planning a SQL Server 2017 deployment on Windows Server or Linux? Contact us.


PASS Summit 2017, SQL Saturday LA, and SQLHA’s Memorial Day Training Sale

By: on May 25, 2017 in PASS Summit 2017, SQLHAU, Training | No Comments

This year is going by fast. I can’t believe Memorial Day here in the US is this weekend and it’ll be June in a few days.

Some of you may have noticed, but PASS changed how they were doing submissions for PASS Summit this year. Usually the call for speakers went out around March and people were picked by June/July. I always felt March was a bit early since so much can change. One of the bigger changes was that PASS themselves were going to choose the precon speakers – you could not submit abstracts. As someone who has had a precon quite a bit over the past ten years, I never take it for granted when I am selected, and if I am not, I don’t complain. That’s the way the cookie crumbles. I am thrilled that PASS did select me as one of the lucky ones who will be doing a precon at PASS Summit 2017. No, I cannot say just yet what it will be – you’ll find out soon enough – but as has been the case for the past few years, there will be labs (I’m a masochist for work). Last year was sold out so if you want to get in on my precon, I suggest you sign up early.

This means I’ll also have a regular session during PASS Summit itself, and will hopefully be judging Speaker Idol again assuming it’s happening. I bring my best Simon Cowell impression to the table. SQLHA, the company Max and I run, will also once again be sharing a booth in the exhibitor’s hall with Denny Cherry & Associates, so come say hello.

I’ve got some other stuff in the pipeline that I can’t talk about just yet for later this year – it’s going to be a busy fall. I will be speaking at SQL Saturday in Los Angeles in a few weeks and am looking forward to that. Hope to see you there.

Memorial Day Training Sale

SQLHA has some of the best training around. This year we have three public classes in the US scheduled for the second half of this year:

To “celebrate” Memorial Day weekend, we’re offering a sale on all of our training classes which is bigger than the current discounts offered. Don’t miss out!

The best part? There’s nothing you have to do! When you go to register, the discounts are already there. Just select what you want and that’s it. No codes to remember, no secret handshake, nothing special you need to sign up to get it (but feel free to sign up for our newsletter …) – just use it. What are you waiting for?




Big TempDB Improvement In SQL Server 2017 CTP 2.0 Setup

By: on April 19, 2017 in Setup, SQL Server 2017, TempDB | 1 Comment

SQL Server 2016 is the first version of SQL Server which allows you to configure multiple files during Setup. That’s good, but it had a very severe limitation: the data files could only be created with a size up to 1GB (1024 MB). For anyone sizing TempDB properly, clearly you’re going to have sizes that are greater than 1GB, so you still had to configure TempDB manually even in SQL Server 2016. I brought this up to Microsoft in early March because I have been working with a customer who was trying to configure TempDB to their standards using SQL Server 2016, but couldn’t via Setup due to this limitation. It was a great discussion with quite a few folks (including fellow MVPs), and being honest, I didn’t think anything would be done about it in the immediate future. I was wrong.

As of SQL Server 2017 CTP 2.0, this limitation no longer exists. Setup now allows the data files you create to be up to 256GB.

Creating a 256GB data file for TempDB

Microsoft listens, folks. This combined with the AG improvements I blogged about earlier in CTP 2.0 make it a welcome release.

Thinking about SQL Server 2017 or just looking to get more up to date than you are now? Contact us today to help you get started down the path …

SQL Server 2017 Is Official & Enhancements to AGs in CTP 2.0

By: on in Availability Groups, SQL Server 2017 | No Comments

Well, it’s official – SQL Server v.Next which has been in preview is going to be SQL Server 2017. This was announced at the DataAmp event. While we do not have an  release date, it’ll be sooner rather than later. CTP 2.0 was just released today, so go and play with it.

There are two improvements for AGs in CTP 2.0 over 1.4 for listeners on Linux:

  • The listener will now be persisted post-failover (I have yet to test this … will do so soon)
  • Read only routing should be working in this releas

In other words, the listener should work properly now in CTP 2.0.

Also, there is a new CLUSTER_TYPE called External. I’ll blog more about this another time, but this is a follow on to the AGs that do not need an underlying WSFC or Pacemaker cluster that I blogged about here.

That’s it – not a long post, but all good stuff.

A Few Days Left – 25% or 30% off Upcoming Chicago Classes

By: on April 11, 2017 in Always On, Availability Groups, High Availability, SQLHAU | No Comments

Happy Tuesday. I just wanted to make sure everyone took advantage of the great discount SQLHA is offering on our two upcoming classes in Chicago this August:

The Boot Camp features our world famous labs which everyone raves about. There is no better way to learn than with hands on experience that is custom designed for this course in addition to the instructional content.

Through this Saturday, April 15, both classes are on sale for 25% off the list price. After that, there is still a discount, but this is an Early Bird special. This means that SQL Server Fundamentals would be $521.25 (list price: $695) and the Boot Camp $1646.25 (list price: $2195).

For an even bigger discount, sign up for both classes and you will get 30% off the total price, which means that for four days of SQL Server availability training, you’ll pay $2023 – less than the list price of just the Always On Availability Groups Boot Camp.

Click on the links above for more information and how to register.