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

Latest Blog Posts

How DATEDIFF_BIG a new feature of SQL SERVER 2016 Can Keep You Out of Trouble

In the series of SQL SERVER 2016, this is a new post. in this post, we will discuss DATEDIFF_BIG and how it is helpful.
So, before jumping into directly in technical details, we all know that time is very important and every second valuable and countable but sometimes every microsecond…

Read more

0 comments, 119 reads

Posted in Rajat Jaiswal-337252 on 22 October 2016

Columnstore Indexes – part 88 (“Minimal Logging in SQL Server 2016”)

Continuation from the previous 87 parts, the whole series can be found at Getting Data into the Database is one essential process, no matter if you are working with an OLTP application or if you are a professional Data…

Read more

0 comments, 114 reads

Posted in Niko's blog on 22 October 2016

Fixing Untrusted Foreign Key or Check Constraint

Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax.

If you are deploying data through several tables, you might want to disable foreign keys on those tables during the deployment to ensure that all the required relationships have a… Read more

0 comments, 62 reads

Posted in SQL Barbarian on 22 October 2016

If You Read One Article About Split String in SQL SERVER 2016s Read this One #3

In the Series of SQL SERVER 2016, this is another post. Before Jumping in detail just think if you have a comma or other separator string and if you have to split it by separator field then for such task  in previous SQL SERVER versions either you will write a…

Read more

0 comments, 68 reads

Posted in Rajat Jaiswal-337252 on 22 October 2016

VMworld Europe 2016 Wrap Up

This past week I had the pleasure of attending our first VMworld Europe conference, held this week at the Fira Gran Via in Barcelona, Spain. What a great experience!

The key takeaways from the conference are quite interesting. The announcements from last and this week indicate some challenges in… Read more

0 comments, 114 reads

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

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, 129 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, 98 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, 108 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, 128 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, 145 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, 106 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, 95 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, 84 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

6 comments, 132 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, 174 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, 185 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, 124 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

4 comments, 150 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, 164 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, 157 reads

Posted in Databases – Infrastructure – Security on 19 October 2016

Older posts