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

Latest Blog Posts

Meet and Greet Data Pros at #sqlsummit

Next Monday night is the networking dinner that Andy Warren and I have put together for the last 6 years. Once again, we’ve arranged for everyone in Seattle to come join in.

If you don’t have plans for Monday night, pick a time, and join us at the Yardhouse. We’ve… Read more

0 comments, 69 reads

Posted in The Voice of the DBA on 21 October 2016

#RedgateRocks at the PASS Summit

If you are attending the PASS Summit next week in Seattle, and want to attend a fun party on Thursday night, come by the Redgate Software booth in the expo hall for your #RedgateRocks bracelet. This is your ticket to admission Thursday night.

Walk down to 1927 3rd Ave between… Read more

0 comments, 65 reads

Posted in The Voice of the DBA on 21 October 2016

How O’reilly Picks Sessions

Read this and wanted to share as we head to the PASS Summit next week: This is how we do it: Behind the curtain of the O’Reilly Security Conference CFP


Read more

0 comments, 72 reads

Posted in SQLAndy on 21 October 2016

Notes on Designing an After Hours Event for the PASS Summit

This year we’re trying out two ideas on Thursday night, a networking dinner (of a sort) and game night. I wanted to share some ideas on how and why we put these together.

  • We’ve long tried to encourage more after hours events with limited success. Of course not all events…

Read more

0 comments, 117 reads

Posted in SQLAndy on 20 October 2016

Creating a Logon Trigger–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

Suppose you want to audit logins for your SQL Server instance. There are multiple ways to do this, but Logon Triggers have a few advantages. First, they… Read more

2 comments, 129 reads

Posted in The Voice of the DBA on 20 October 2016

PASS Summit 2016: Dinner, Dinner, Game

Part of making a week long trip to a big event like the PASS Summit successful is finding something to do in the evening that recharges you. PASS has a number of events listed for After Hours this year. Steve Jones and I are organizing three of them:

Read more

0 comments, 94 reads

Posted in SQLAndy on 20 October 2016

SQL Saturday Washington DC Preconference Training Session

I am pleased to announce that we are launching our next round of all-day precon training session at the upcoming SQL Saturday in Washington DC on Friday, December 2 called ‘The Complete Primer to SQL Server Infrastructure‘.

The focus of the course is to help those new to… Read more

0 comments, 83 reads

Posted in Technobabble by Klee from @kleegeek on 20 October 2016

Making the Most of PASS Summit and Similar Events

Events like the PASS Summit aren’t just about education. They are a chance to meet new people, get some distance from the day to day problems of work (and life perhaps), and even have some fun. Done well attendees end the week tired and recharged.

How to do… Read more

0 comments, 74 reads

Posted in SQLAndy on 20 October 2016

Who owns your availability groups?

Question: Who owns your availability groups?

The person who creates the AG becomes the owner by default. Did you know that you can (and probably should) change that the same as many of the other SQL Server objects like databases, jobs, endpoints, etc. Up until this week I did not… Read more

2 comments, 118 reads

Posted in on 20 October 2016

Why I don’t love SELECT INTO

Long ago there were locking / blocking problems with the SELECT INTO statement. That’s not the case anymore and for AdHoc operations and investigation of data SELECT INTO is very helpful.

If you’re not aware of what SELECT INTO is or its benefits here’s an example:


Read more

4 comments, 159 reads

Posted in Confessions of a Microsoft Addict on 20 October 2016

Another way to move SQL DB to Azure

About 8 months ago I wrote an article ( ) where I showed you how to migrate your “earth” SQL Database to Azure using a BACPAC import. If you look at the following diagram I will now show you the … Continue reading

Read more

1 comments, 173 reads

Posted in All About SQL on 20 October 2016

This Week In Data – Episode 9 (What Does Pizza Have to Do with the Cloud?)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we discuss the cloud as a service and how it relates to pizza.

The world of the cloud includes a lot of parts and can… Read more

0 comments, 109 reads

Posted in Devin Knight on 19 October 2016

Data Warehouse Fast Track for SQL Server 2016

Microsoft Data Warehouse Fast Track for SQL Server 2016 is a joint effort between Microsoft and its hardware partners to deliver validated, pre-configured solutions that reduce the complexity of implementing a data warehouse on SQL Server Enterprise Edition.  The Data Warehouse Fast Track program provides flexibility of solutions and customer… Read more

3 comments, 138 reads

Posted in James Serra's Blog on 19 October 2016

Fun and Contests at Summit 2016

I’ll be attending the 2016 Pass Summit as a part of the Redgate Software crew. I’m not speaking this year, so most of my time will be at the Redgate booth, showing you a few tricks and tips with products and maybe convincing you that we can help your company… Read more

3 comments, 149 reads

Posted in The Voice of the DBA on 19 October 2016

Webinar Available On Demand – Building an Auditing Framework for SQL Server

Recently I gave an introductory webinar on how to build an auditing framework for SQL Server. The focus was for those tasked with auditing SQL Server on a regular basis and needing some ideas of how to get started. I talk through some of the challenges as well as what… Read more

0 comments, 144 reads

Posted in Databases – Infrastructure – Security on 19 October 2016

Installing SQLCMD

For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says anything I want to point out that yes, I realize that you can use Powershell instead. Of course not all of us know Powershell all that well and most of… Read more

0 comments, 93 reads

Posted in SQLStudies on 19 October 2016

Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Portland)

Prakash will walk you through a centralized process using PowerShell where the key information collected, organized and sent via HTML formatted email, provides consolidated view of SQL server along with key observations which DBA should verify and share with IT stakeholders for increasing transparency and improved efficiency

Read more

0 comments, 187 reads

Posted in SQLFeatures on 18 October 2016

DB CI: Getting Test Results in VSTS

One of the things I struggled with a bit was getting test results to appear in VSTS from my builds.

Here’s my original Build flow:

However, when I’d run a build, I got this in the Build summary:

That’s not great, and I knew this could work better, so I… Read more

0 comments, 144 reads

Posted in The Voice of the DBA on 18 October 2016

SQL Cruise as a Speaker and Sponsor

SQL Cruise offers a number of unique opportunities for everyone involved, including speakers and sponsors. I’ve written before, several times, about the benefits of SQL Cruise. As an attendee of the cruise, you will get to sit in classes by amazing people (and me) talking about all aspects… Read more

0 comments, 107 reads

Posted in The Scary DBA on 18 October 2016

Mastering Index – Index with included columns

This article is the part of series Mastering Index, in this particular article we will be exploring Index with included columns. Take a look at the content of this series – Mastering Index – Index with included columns One of the most interesting and talked about topic in database field…

Read more

0 comments, 120 reads

Posted in Help on MSBI on 18 October 2016

Older posts