Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

SQL Browser, what is it good for? Absolutely something!

Another great teaching opportunity landed in my lap this week. I got an email from a coworker looking for some help troubleshooting a SQL connection issue. He had an application server that could not connect to one of our SQL Servers.

We have a fairly complex and secure network environment.… Read more

0 comments, 18 reads

Posted in cjsommer.com on 1 March 2017

How Do You Use SQL Clone?

On Monday, Redgate released v1.0 of SQL Clone, and I’m excited that the product is finally available. I’m excited because this has been a long time coming, but it’s worth the wait.

You can certainly download SQL Clone and try it out, but I’d also say you should check… Read more

0 comments, 64 reads

Posted in The Voice of the DBA on 1 March 2017

Event storming! It’s raining emails!

One of the most common ways to get an event notification is by email. So what happens when you get 500 emails in a day and only one or two are actionable? Do you read every single email? Spending quite literally hours to find those one or two gems? Or… Read more

3 comments, 47 reads

Posted in SQLStudies on 1 March 2017

Webinar – Executing, Configuring and Scheduling SSIS 2016 Packages

I’ll be giving a webinar for MSSQLTips.com at March 31st. It’s a sponsored webinar, meaning there will also be a vendor to talk about JAMS,  a scheduler that “runs, monitors and audits critical processes across a diverse array of servers and business applications”. Anyway, the title is Executing, Configuring and… Read more

0 comments, 34 reads

Posted in Koen Verbeeck on 1 March 2017

Everything on Always on Availability Groups series

Step By Step configuring Windows 2012 R2 fail over cluster How to setup windows cluster for Always on Availability Groups

AlwaysOn Availability Groups: Step by Step Setup Step by Step procedure to setup Always on Availability Groups

Read more

0 comments, 62 reads

Posted in Ganapathi's MSSQLLover on 1 March 2017

Step By Step configring Windows 2012 R2 fail over cluster

One of my client requirement is to install Always on availability groups for SQL databases. You don't require shared storage to setup Always on availability. it can be configured in local disks.
AlwaysOn Availability Groups rely on the Windows Server Failover Cluster for failure detection and management of the Availability…

Read more

0 comments, 56 reads

Posted in Ganapathi's MSSQLLover on 1 March 2017

A GUI for Docker Container Administration

I’ve been working with containers for a while now and one of the questions that always gets asked when I demo the technology to people is, is there a graphical user interface out there that can be used to manage containers?

Now, I’m happy with working on the command line… Read more

1 comments, 56 reads

Posted in The DBA Who Came In From The Cold on 1 March 2017

SQL Server Target vs Total Memory

For this blog post I want to discuss the meaning behind SQL Server: Memory Manager\Target Server Memory (KB) and SQL Server: Memory Manager \Total memory (KB) Perfmon counters.  I will mention how under different situations and configuration settings their behaviour … Continue reading

Read more

1 comments, 82 reads

Posted in All About SQL on 1 March 2017

How Do I Add an R Package to SQL Server from In-Database R?

Hello Dear Reader!  I'm working on some really fun stuff with in-database R using SQL Server 2016.
I needed to add a couple packages to my R engine so I could use them and call them from an R script. I realized I had not added any external packages to…

Read more

0 comments, 77 reads

Posted in SQLBalls on 28 February 2017


I’ve hosted a page on this blog that has all the T-SQL Tuesday blog invitations and roundups linked. I did this mainly because I was trying to ensure I have hosted a few, I wanted to know what others had chosen. Since I didn’t see a good list, I created… Read more

2 comments, 89 reads

Posted in The Voice of the DBA on 28 February 2017

Determining the Cost Threshold for Parallelism

In the previous post, I showed how you can get full listings of your execution plan costs. Knowing what the values you’re dealing with for the estimated costs on your execution plans can help you determine what the Cost Threshold on your system should be. However, we don’t want… Read more

5 comments, 69 reads

Posted in The Scary DBA on 28 February 2017

Power BI Custom Visuals Class (Module 40 – Long Text Viewer)

In this module you will learn how to use the Long Text Viewer Power BI Custom Visual.  The Long Text Viewer visual helps in displaying longer text fields that you have in your dataset.

Module 40 – Long Text Viewer


Read more

0 comments, 68 reads

Posted in Devin Knight on 28 February 2017

Not An Administrator For Analysis Services Tabular

A couple of weeks back I installed SQL Server 2016 on my personal machine, including SSAS Tabular. Yesterday I created a new Tabular model project in SQL Server Data Tools. When I had to choose where to locate the model – integrated or a server workspace – I got the… Read more

0 comments, 89 reads

Posted in Koen Verbeeck on 28 February 2017

Configuring and analyzing the Query Store through dbatools

In case you didn’t know this already, dbatools is an awesome collection of Powershell functions that will help you immensely in your work as a DBA. Just one example: migrating SQL Server Instances takes a massive amount of work. You need to backup and restore every database, write down instance… Read more

0 comments, 124 reads

Posted in DotNine SQL Server and more on 27 February 2017

Upcoming Speaking Engagements

In the next few months I will be speaking at some awesome events around Europe.


SQLBits – April 5-8 

SQLBits is THE SQL Server event in Europe, with a very long tradition and a fantastic audience. I totally love SQLBits!
This time I will speak about “Benchmarking like… Read more

0 comments, 79 reads

Posted in SpaghettiDBA on 27 February 2017

Speaking at VS Live–Austin

I’ll be speaking at Visual Studio Live – Austin in May 2017. I was fortunate to be selected to speak again, after my first two VS Lives last year in DC and Orlando. I’m excited to go back, as the conference is a lot of fun, and Austin is a… Read more

0 comments, 106 reads

Posted in The Voice of the DBA on 27 February 2017

Queries with optional parameters

These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or a city. Simple enough, until you notice that or. We might only get a first name, or a state and the query still needs to work. These queries are… Read more

4 comments, 105 reads

Posted in SQLStudies on 27 February 2017

SQL VNext sp_configure on Windows and Linux with dbatools

This weekend I set up some SQL vNext virtual machines, two on Windows and one on Linux so that I could test some scenarios and build an availability group.

IMPORTANT NOTE :- The names of dbatools commands with a Sql prefix WILL CHANGE in a later release of dbatools. dbatools… Read more

1 comments, 111 reads

Posted in SQL DBA With A Beard on 27 February 2017

The Empirical Rule

I am resuming technical blogging after a gap of nearly a month. I will continue to blog my re learning of statistics and basic concepts, and illustrate them to the best of my ability using R and T-SQL where appropriate.

For this week I have chosen a statistical concept called… Read more

0 comments, 111 reads

Posted in Mala's Data Blog on 27 February 2017

SQL Clone

Today is the launch of SQL Clone, a great new tool that helps you quickly and easily provision SQL Server databases for development and testing.

Oh god, that sounds like marketing speak. To heck with that. Let me tell you why I’m so excited about SQL Clone and why… Read more

2 comments, 92 reads

Posted in The Scary DBA on 27 February 2017

Older posts