cjsommer.com

#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. I think it can be cultural and can propagate from the senior level DBA’s right on down to the new hires. [Read More]

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. [Read More]

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. The ask here was pretty straight forward. [Read More]

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. [Read More]

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. [Read More]

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. [Read More]

<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. [Read More]

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. SQL Server on Linux will provide customers with even more flexibility in their data solution. [Read More]

Maybe you’re new to SQL Server or maybe you’re just expanding into performance tuning a little more. Query tuning can be a very daunting task and sometimes it’s hard to decide where to look first. In this post I am going to show you a couple of my go-to methods for troubleshooting slow performing queries in SQL Server. This is not a “ZOMG my SQL Server is slow” list. This post is more geared to when I have been tasked to dig into a very specific query. [Read More]