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

Latest Blog Posts

Not a Great Search

Tldr: A bit of a rant. I’m not spending a bunch of time crafting this.

I have mixed feelings about searching for information on Microsoft sites. It kind of works, kind of doesn’t. I know that there are resource constraints to upgrading their sites, but I’m more and more annoyed. Read more

2 comments, 159 reads

Posted in The Voice of the DBA on 22 June 2016

Starting ReadyRoll with an Existing DB

I’ve been working with ReadyRoll quite a bit the last few months, and wanted to start putting out some information. I’m looking to do a longer series, but here’s a quick post on getting started.

When you install ReadyRoll, you get a new project type under SQL Server.

This is… Read more

0 comments, 128 reads

Posted in The Voice of the DBA on 22 June 2016

Microsoft finally got SQL setup right!

This past week, Microsoft revealed that SQL Server 2016 will be available in June. Exciting news indeed! With that said, I thought I’d take a few moments to point out some neat new features housed in SQL Server 2016 Setup.

As you can see from the following image, SQL… Read more

0 comments, 102 reads

Posted in Confessions of a Microsoft Addict on 22 June 2016

SQL Server Security Series, part 1

In the first entry in this SQL Server security series, we will demonstrate a brute force attack against SQL Server and discuss various techniques to protect against one. Brute force attacks are nothing new. They have been around for a long time and are very simplistic by design. The recent… Read more

0 comments, 95 reads

Posted in Confessions of a Microsoft Addict on 22 June 2016

Database snapshots

This feature is Enterprise only which can limit who it is useful to, but I find the whole concept fascinating. In particular the way it works.

First of all what is a Database Snapshot? A Database Snapshot is a read only copy of a live database. It remains fixed… Read more

0 comments, 112 reads

Posted in SQLStudies on 22 June 2016

Join Me at PASS Summit 2016

It seems like it was just yesterday that we all said goodbye in Seattle at last year’s PASS Summit, but the calendar on the wall says that the next event is a mere four months away. This means that it’s that time of year again: the schedule of sessions has… Read more

0 comments, 73 reads

Posted in Tim Mitchell on 22 June 2016

Columnstore Indexes – part 85 (“Important Batch Mode Changes in SQL Server 2016”)

Continuation from the previous 84 parts, the whole series can be found at I wanted to write a blog post on some of the changes that were implemented in SQL Server 2016, that might affect workloads migrated from SQL…

Read more

4 comments, 167 reads

Posted in Niko's blog on 21 June 2016

SQL Server Service Broker – Networking

This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database Engine.

Previous posts:

Read more

0 comments, 134 reads

Posted in Cleveland DBA on 21 June 2016

Power BI Custom Visuals Class (Module 04 – Radar Chart)

In this module you will learn how to use the Radar Chart, a Power BI Custom Visual. The Radar Chart is sometimes is also know to some as a web chart, spider chart, or star chart.  Using the Radar Chart allows you to display multiple categories of data on each… Read more

0 comments, 133 reads

Posted in Devin Knight on 21 June 2016

LAST_VALUE–The Basics of Framing

I did some work a 3-4 years ago, learning about the Windowing functions and enjoying them so much I built a few presentations on them. In learning about them, and trying to understand them, I found some challenges, and it took some experimentation to actually understand how the functions work… Read more

0 comments, 180 reads

Posted in The Voice of the DBA on 20 June 2016

Columnstore Indexes – part 84 (“Practical Dictionary Cases”)

Continuation from the previous 83 parts, the whole series can be found at In this blog post I wanted to focus on 2 practical aspects of Columnstore Dictionaries compression – the ones I have seen in the past months…

Read more

0 comments, 176 reads

Posted in Niko's blog on 20 June 2016

Monday Morning SQL Break – June 20, 2016

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more

0 comments, 93 reads

Posted in StrateSQL on 20 June 2016

Minimizing Cloud cost

The cloud can be expensive. I had this hammered home the other day by a simple mistake. I’m currently working with Microsoft’s Azure platform and using one of the free credit options. I get a free $25 a month for a year and fortunately for me this put a… Read more

6 comments, 147 reads

Posted in SQLStudies on 20 June 2016

The PASS Speaker Agreement

I hope when you’ve read all of this post that you’ll think that I’ve added to the discussion and not fueled the fire.

The various posts and discussions and the time writing this (multiple drafts) have definitely caused me to re-examine my own views. I’ve found that some were simplistic… Read more

0 comments, 705 reads

Posted in SQLAndy on 20 June 2016

Using Power BI with Enterprise, On-premises Data

I just finished posting a 4-part series demonstrating how to use Power BI with on-premises data.  The running time for all four parts is about 44 minutes.  I cover using the Power BI Enterprise Gateway to connect published Power BI reports to on-premises data sources:  SQL Server database connected with…

Read more

2 comments, 179 reads

Posted in SQL Server BI Blog on 19 June 2016

Power BI Architecture Diagram v2 is Now Available

I finally finished putting together version 2 of my Power BI architecture diagram. I previously put together an architecture diagram but as fast as Power BI is changing, v1 of the diagram was quickly obsolete. I always wanted to come back and add more to the diagram to make it… Read more

6 comments, 245 reads

Posted in SQL with Dustin Ryan on 18 June 2016


I first heard this little acronym from Grant Fritchey (b | t). He used it when talking about backups and restores, and I like it. However I realize that I’ve never actually noted what it is, so a short blog to do so today.

An RGE is a… Read more

5 comments, 1,069 reads

Posted in The Voice of the DBA on 17 June 2016

Return Max or Min Value of a Group of Columns as a Single Column

Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never used again (turns out, there’s quite a lot of them in this database). They are characterized by having _bak or _ appended to the end of them. I wanted to…

Read more

Upcoming Course – LFCE: Advanced Linux Networking

I’m pleased to announce that I’m working on a new course for Pluralsight.

The course is titled LFCE: Advanced Linux Networking.

This course targets IT professionals that design and maintain Linux based enterprises. It aligns with the Linux Foundation Certified Engineer (LFCE) objectives and can be used by… Read more

0 comments, 128 reads

Posted in Anthony Nocentino's Blog on 17 June 2016

Why is creating excel sheets from SSIS so hard ?

If there is one process that should be simpler than it is out of the box, it is creating Excel spreadsheets from SSIS.   Over the years i’ve tried doing it a number of ways, using the built in component,  Interop , OLE DB etc all suck to one degree or… Read more

0 comments, 883 reads

Posted in Dave Ballantynes blog on 17 June 2016

Newer posts

Older posts