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

Latest Blog Posts

SSMS 2016 Bug

I have been using SSMS (SQL Server Management Studio) 2016 build number 13.0.15900.1 and noticed that if you wanted to manage compression you couldn’t as it is greyed out. Microsoft SQL Server Management Studio 13.0.15900.1 The actual message that you … Continue reading

Read more

0 comments, 73 reads

Posted in All About SQL on 27 October 2016

Starting a ReadyRoll Project

This is part 5 in the series named SQL Server and Continuous Integration. This post will cover the steps I follow to setup a ReadyRoll project. Topics covered so far in this series are:

I’m using ReadyRoll in my Continuous Integration setup to generate… Read more

0 comments, 82 reads

Posted in The Database Avenger on 26 October 2016

PASS Summit Live Keynote – Release 5

Julie Koesmarno, Senior Project Manager at Microsoft, takes the stage to talk about business analytics utilizing War and Peace.

Tracing emotions of each key characters via a heat map…..pretty cool to see application of SQL Light language.

Cognitive capabilities managed with big data……

Deep learning is everywhere; this means that… Read more

0 comments, 84 reads

Posted in The SQL Professor on 26 October 2016

Three Reasons Why I Am Attending PASS Member Summit 2016

Three reasons why I am attending PASS Member Summit in 2016

Over the past few weeks, I saw on social media that many of my #sqlfamily members were not attending the PASS Member Summit conference this year.  It made me want to blog about why I am attending this year. Read more

0 comments, 54 reads

Posted in John Sterrett on 26 October 2016

PASS Summit Live Keynote – Release 4

Document DB: Blazing fast planet-scale NoSQL:

  • Guaranteed Low Latency
  • Elastically Scaling Storage
  • Elastically Scaling Throughput
  • No Impedance Mismatch
  • Choice of Consistency
  • Enterprise Level SLA

Azure + DocumentDB with leading game technology. A game and TV show integration of Walking Dead that brings exclusive clip content into the game using Azure… Read more

0 comments, 54 reads

Posted in The SQL Professor on 26 October 2016

PASS Summit Live Keynote – Release 3


Justin Silver, Scientist Pros, takes the stage……

Taking data science out of the lab settings and placing it into real world scenarios.

Azure has tremendously been able to allow enhanced functionality into the realm of data science bridging the gap 100x faster with SQL Server 2016.

Microsoft is the… Read more

0 comments, 57 reads

Posted in The SQL Professor on 26 October 2016

PASS Summit Live Keynote -Release 2

Rohan Kumar, General Manager of Microsoft, takes the stage hyping up SQL Server 2016. We keep hearing the word “Sharing” among databases.

Intelligent Database:

  1. In-Memory Analytics
  2. In-Memory OLTP

Wow, 100X faster analytics + 30x faster transactions

Azure SQL database is the first in the world to support HTAP technology

Two… Read more

0 comments, 54 reads

Posted in The SQL Professor on 26 October 2016

PASS Summit Live Keynote – Release 1

Joseph Sirosh taking the stage by first telling us a story with over 400 million children in India. Only 50% of them attend school regularly. Consider the loss of potential that could have been a doctor.

Millions more like these children; a world of lost human potential. Millions who drop… Read more

0 comments, 59 reads

Posted in The SQL Professor on 26 October 2016

Summit 2016–Setup

Tuesday was the first real day of the Summit for me, and a long, all day event. First, a lovely breakfast with Micky Steuwe, during which she presented me with a lovely glass art piece she made herself.

I’ll treasure this, as personal, thoughtful gifts are touching. Thanks, Mickey.

Then… Read more

0 comments, 93 reads

Posted in The Voice of the DBA on 26 October 2016

PASS Summit 2016: Day 1 Keynote

This week I’m attending the SQL PASS Summit in Seattle. I’ll be live blogging each of the keynote presentations on Wednesday and Thursday morning. This post will be updated throughout the duration of the Day 1 keynote. Introduction We’re off and running! PASS president Adam Jorgensen starts us off with… Read more

0 comments, 54 reads

Posted in Tim Mitchell on 26 October 2016

PASS Summit 2016 – Live Keynote

Good morning from PASS Summit 2016!

Today will be the first keynote session at 8:15 a.m. with Joseph Sirosh. I’ve found myself back at the bloggers table this year during the keynotes so check back here for updates and highlights.

In addition to these updates (plan on sending 4-5 mass… Read more

0 comments, 101 reads

Posted in The SQL Professor on 26 October 2016

Win a Year of Death Wish Coffee at the #sqlsummit

One of the promotions this week at the PASS Summit from Redgate Software is a chance to run a year’s supply of coffee. This isn’t just any coffee, but the Death Wish Coffee, full of extra caffeine. Grant Fritchey loves this stuff, and that’s what one lucky attendee will… Read more

0 comments, 100 reads

Posted in The Voice of the DBA on 26 October 2016

More bytes for Row versioning

I like row versioning– see this link for more details: If your database is enabled for one of the isolation levels that uses row versioning and a row is updated it will have 14 bytes added to it. Before … Continue reading

Read more

1 comments, 103 reads

Posted in All About SQL on 26 October 2016

It’s a small world

As I write this we are packing to leave for Disney World, where my family and I will spend close to a week hanging out with hundreds of thousands of the happiest people, not just from the US, but from all over the world. Then while I’m traveling home thousands… Read more

2 comments, 63 reads

Posted in SQLStudies on 26 October 2016

Sending Trevor love…

As some of you may be aware – fellow SQL family member, PASS Director, SQL Server MVP, founder of SQL Cruise and a good friend to many of us – Tim Ford – has a young son Trevor Ford who was recently diagnosed with a rare allergic drug reaction called… Read more

0 comments, 104 reads

Posted in Mala's Data Blog on 26 October 2016

PASS Summit 2016–Tuesday

For the first day at the Summit this year, I spent half my time in a Pre-Conference session with Idera as an outgoing Idera Ace. The session include a 45 minute presentation for me on a Customer Use-Case. The second half of the day was spent in #SQLPASS Community… Read more

0 comments, 62 reads

Posted in The Smiling DBA on 25 October 2016

Columnstore Indexes – part 89 (“Memory-Optimised Columnstore Limitations 2016”)

Continuation from the previous 88 parts, the whole series can be found at I would like to dedicate this blog post to the Memory-Optimised (also known and LOVED as Hekaton) Columnstore Indexes and their limitations in SQL Server 2016.…

Read more

0 comments, 135 reads

Posted in Niko's blog on 25 October 2016

Convert User Friendly Retention to DateTime value with PowerShell

I think the title is fairly descriptive so let me put a little context around it for you. In my SQL Server environment we backup our databases to local disk. Unfortunately we don’t have unlimited storage for backups, which means we have to delete the old backups on a regular… Read more

0 comments, 104 reads

Posted in on 25 October 2016

Getting dbatools in Powershell

I had the chance to watch dbatools in action recently at SQL Saturday Cambridge. I watched a presentation from Chrissy LeMaire (@cl) that was impressive in how easy she made a number of DDL type changes between instances.

I decided to give some of these new cmdlets a… Read more

1 comments, 232 reads

Posted in The Voice of the DBA on 25 October 2016

Azure App Service Companion for iOS

This has absolutely nothing to do with SQL Server, it actually has nothing to do with data but I felt like blogging about it. I saw an announcement recently and I was intrigued by it. All my excitement was over … Continue reading

Read more

3 comments, 177 reads

Posted in All About SQL on 25 October 2016

Older posts