SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: 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

2 comments, 3,173 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, 351 reads

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

Distributed Databases - One Way Synchronization

Applies to: xSQL Data Compare v7.0.0 – v9.0.0

Business Need

A very common organization of the data infrastructure for big companies who operate in many countries and use some type of centralized system to manage their operations, is to have separate databases for each branch and one database that is…

Read more

0 comments, 207 reads

Posted in xSQL blog 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, 517 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, 488 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, 414 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, 396 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, 472 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, 323 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, 336 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

1 comments, 556 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, 354 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, 408 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

1 comments, 810 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, 521 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, 357 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, 393 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, 412 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, 419 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, 497 reads

Posted in The SQL Professor on 26 October 2016

Newer posts

Older posts