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

Latest Blog Posts

PASS Summit 2016-Thursday Part II

The second half of the day was spent talking with various speakers and attendees. I got into a great conversation about trying to mentor developers at work places about how to write good T-SQL. It was interesting to here how some developers (or DBAs) are not open to new ways… Read more

0 comments, 48 reads

Posted in The Smiling DBA on 28 October 2016

Data Compare on Temporal Tables

I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went through the exercise to compare current to historical to see how Red Gate & Devart handled this. I'm a part of the Friends of Red Gate program, so love checking… Read more

0 comments, 8 reads

Posted in SQL Barbarian on 28 October 2016

This Week In Data – Episode 10 (Getting Started with Azure)

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 how you can get started with Azure.

Many of us already know this, but Azure is here and is not going anywhere. Whether… Read more

0 comments, 88 reads

Posted in Devin Knight on 28 October 2016

SQLDinner/Meetup Tonight at PASS Summit

If you’re at the PASS Summit and would like to meet some new people, come see us from 5:30 to 6:30! Take the convention center escalator to the first floor and turn left, you’ll see us and some volunteers. Here’s the plan:

  1. We’ll give you a large card and a…

Read more

0 comments, 85 reads

Posted in SQLAndy on 27 October 2016

First thoughts on Power BI on premises

The wait is over, the Reporting Services team finally released a preview for Power BI Desktop reports hosted on premises using Reporting Services! The preview itself is a VM hosted in Azure. You can read all about setting it up in the SSRS team blog post.

I toyed around… Read more

0 comments, 118 reads

Posted in Koen Verbeeck on 27 October 2016

PASS Summit Friday Night Activity

Anyone staying until Saturday from the PASS Summit in Seattle? Be at the Seattle Underground at 530p for a 6p tour Friday night! Let’s have some fun!

614 1st Avenue, in Pioneer Place Park, Pioneer Square, between Cherry and James Street.

Read more

0 comments, 55 reads

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

PASS Summit Keynote 2 – Release 2

Dr. David DeWitt is getting ready to take the stage to a huge ovation and is thrilled to be back at PASS Summit.

Haha, bring back #BringBackRimma is a twitter tag that he has put in place….looking forward to hearing Dr. David DeWitt speak today…..

  1. Why data warehousing in the…

Read more

0 comments, 76 reads

Posted in The SQL Professor on 27 October 2016

PASS Summit Keynote 2 – Release 1

Grant Fritchey taking the stage to talk about the financial health of PASS.

250k members , 170 countries, and 87% global representation – outstanding.

73% return into the community; focused on being a one global community

119 SQL Saturday Events held in 2016; have had pretty solid growth over the… Read more

0 comments, 57 reads

Posted in The SQL Professor on 27 October 2016

PASS Summit 2016: Day 2 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 2 keynote. It’s the second full day of the PASS Summit and we’re back for… Read more

0 comments, 84 reads

Posted in Tim Mitchell on 27 October 2016

#RedgateRocks Tonight at #sqlsummit

Tonight is the #RedgateRocks party at 1927 Events in Seattle. You’ll need to get a wristband from the Redgate Software booth in the exhibition hall to gain admission, so stop by.

Today’s your last chance.

And if you’re looking for someone to go to dinner with, come to our #sqldinner… Read more

0 comments, 109 reads

Posted in The Voice of the DBA on 27 October 2016

PASS Keynote Part 2 – Live Coverage


Good morning from PASS Summit in Seattle, Washington. Like yesterday I will be live blogging the event. The same format of the blog will apply with up to 5 releases every 15 minutes.

Yesterday was a great first keynote, and from what it appears attendees are pretty excited to… Read more

0 comments, 91 reads

Posted in The SQL Professor on 27 October 2016

Days 1,2 and 3 of PASS Summit 2016

Today is Thursday, October 27th already. For some of us the summit begins monday – with precons and PASS Volunteering related meetings on Tuesday. For most other attendees the first day was Wednesday.

I arrived in the afternoon on Sunday with six other friends from Louisville,including my good friend Chris… Read more

0 comments, 65 reads

Posted in Mala's Data Blog on 27 October 2016

PASS Summit 2016-Thursday Part 1

Today’s keynote was by David Dewitt. He did an excellent job explaining the architecture behind various Cloud Data Warehouse offerings. It was nice to get an explanation of the behind the scenes node and disk usage.


One announcement that caught me off guard was next year’s Summit is Oct… Read more

0 comments, 44 reads

Posted in The Smiling DBA on 27 October 2016

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, 164 reads

Posted in All About SQL on 27 October 2016

Technical Presentations - What happen's behind the scene

A while ago I wrote a piece on public speaking assignements over here and promised to write what it takes to do the same. While I started writing it, realized it can be made into a article for SQL Server Central. Link to the article provided below.

Do let…

Read more

0 comments, 91 reads

Posted in SQL and SQL Only on 27 October 2016

PASS Summit 2016-Wednesday

As all Summits, the first Regular Session day in Seattle started with the Keynote. Well, really it starts with a great breakfast at the Seattle Convention Center, but I digressed. Microsoft released information about new features for its Microsoft Data Platforms. The Keynote provided Customer specific examples of some… Read more

0 comments, 78 reads

Posted in The Smiling DBA 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, 100 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, 100 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, 73 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, 70 reads

Posted in The SQL Professor on 26 October 2016

Older posts