cjsommer.com

Availability groups have owners, just like every other object in SQL Server. The owner sid is found in sys.availability_replicas. The script below will map those sids to an actual principal name, and display the owners for all AG’s on the replica where you run it. You can run this on both the PRIMARY and SECONDARY replicas, which we have discovered may or may not be consistent. Regardless, you should see an owner for every AG on your SQL Server.

#TSQL2SDAY is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam Machanic (blog|twitter). You can take part by posting your own participating post that fits the topic of the month and follows the requirements below. Additionally, if you are interested in hosting a future T-SQL Tuesday, contact Adam Machanic on his blog.

If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded individuals, SQL Saturday is for you. It’s a day chock full of SQL Server related presentations given by other members of the community.

Here is a glimpse of my presentation on SQL Server Automation using PowerShell taken from the SQL Saturday event page.

Another Twitter-born blog post! I love getting new ideas from the community. Real world ideas for solving real world problems!

The original question was “Does SQL Compare or others prods allow me to compare 1 “gold” db to the 57 “identical” databases in prod at once? asking for a friend ;)”. The original question and link to the twitter feed is off to the right.

This blog post is just a quick follow from my presentation last week for the SQL PASS PowerShell Virtual Chapter.

Here is a link to the YouTube Video of the presentation.

There are obviously quite a few things that could cause internet issues that are totally out of our control, but there are some things that we may be able to try to help ourselves. Face it, dealing with cable service calls is right up there with doing your taxes. If you are a cable internet subscriber and are having stability problems this post may help you solve your issues without having to call the cable company.

If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded individuals, SQL Saturday is for you. It’s a day chock full of SQL Server related presentations given by other members of the community.

Here is a glimpse of my presentation on SQL Server Automation using PowerShell taken from the SQL Saturday event page.

If PowerShell isn’t your thing that’s OK. There are plenty of other topics to choose from. With sessions geared toward Database Development, Database Administration, Business Intellignece, Database Security and even Professional Development, SQL Saturday offers a wide variety of content for everyone.

Scripts that write scripts! One of my favorites!

So last night I was up working on an issue with an Availability Group. For whatever reason the cluster resource for the AG would not come online. Looking in SSMS the AG’s on both replicas were stuck in “Resolving”. I beat on the keyboard for almost 2 hours before deciding that rebuilding the AG was my best option. The databases were down and the birds were starting to chirp and I needed to get them back online.

<img alt=’’ class=‘alignright size-full wp-image-1238 ‘src=’/img/2016/04/img_570152b22dc45.png’ />

If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded individuals, SQL Saturday is for you. It’s a day chock full of SQL Server related presentations given by other members of the community.

Here is a glimpse of my presentation on SQL Server Automation using PowerShell taken from the SQL Saturday event page.

http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/

Today I’m excited to announce our plans to bring SQL Server to Linux as well. This will enable SQL Server to deliver a consistent data platform across Windows Server and Linux, as well as on-premises and cloud. We are bringing the core relational database capabilities to preview today, and are targeting availability in mid-2017.