This is the set of videos from the SQL Server Engineering Team on SQL Server 2016. This post is covering Tooling.

For the other groups of videos have a look at.

Videos on You tube.

Tooling Improvements in SQL Server 2016
Ken Van Hyning (LinkedIn) and Kevin Cunnane ( LinkedIn|Twitter)

On this Data Driven session, we'll go over a brief overview of new investments in SQL Server Management Studio and SQL Server Data Tools coming in SQL Server 2016. We also highlight topics such as new monthly updates, query analysis improvements, Wizard and Dashboard support for Standard Edition Availability Groups, the connection experience in SSDT and developer productivity improvements

R Tools for Visual Studio
John Lam (LinkedIn|Twitter)

Watch this Data Driven session to get a tour of key features in Microsoft's new IDE for R users and data scientists.

Did you watch the launch event on the 10th and walk away a little short changed. Well that’s because there is so much awesome new stuff in SQL 2016 that you couldn’t really give them all enough air time to really show them in the detail you want.

The great news is that the SQL Team have done a whole set of videos that go into the detail of the new features in SQL 2016

The whole list can be found here SQL Server Data Driven- Technical Deep Dive

or you can look at the lists in the following groupings I’ve put together

Posted by simonsabin | with no comments

The Database Systems team that build SQL Server , SQL Azure, SQL Data Warehouse and recently have ported SQL to run on linux, are running an open house next week.

Its still not too late to register, whether you are looking for a new challenge or just want to meet and discuss whats going on. Why not register, maybe you could be helping to deliver SQL Server on Linux.

Posted by simonsabin | with no comments


Sunil AgarwalSunil Agarwal

Principal Program Manager on the SQL Server team

I’ve just been made aware of an awesome series of blog posts from Sunil,


Real Time Operational Analytics

· real-time-operational-analytics-using-in-memory-technology/

· real-time-operational-analytics-using-nonclustered-columnstore-index/

· real-time-operational-analytics-simple-example-using-nonclustered-clustered-columnstore-index-ncci/

· real-time-operational-analytics-dml-operations-and-nonclustered-columnstore-index-ncci-in-sql-server-2016/

· real-time-operational-analytics-filtered-nonclustered-columnstore-index-ncci/

· real-time-operational-analytics-compression-delay-option-for-nonclustered-columnstore-index-ncci/

· real-time-operational-analytics-compression-delay-option-with-ncci-and-the-performance/

· real-time-operational-analytics-memory-optimized-table-and-columnstore-index/

Defragmenting Columnstore Index

· columnstore-index-defragmentation-using-reorganize-command/

· columnstore-index-merge-policy-for-reorganize/


Bulk importing data

· clustered-column-store-index-bulk-loading-the-data/

· clustered-columnstore-index-parallel-bulk-import/

· clustered-columnstore-index-data-load-optimizations-minimal-logging/

Posted by simonsabin | with no comments

So yesterday we got told that SQL Server will run on linux don’t forget to sign up


My interest is that if thats what we get told with two days to go before the big event on the 10th March, what else do you think is coming?


Are you prepared to be blown away

[Updated:8 March 2016 with number 2 days to go]

Posted by simonsabin | with no comments

As a consultant I have multiple clients with different PowerBI setups. I would love an easy way to switch between all the organisations. As it is I have to signout and sign back in every time I want to switch, or setup different browsers.

Its a real pain.


It would be lovely to have either an easy way to switch or an easy way to have multiple PowerBI sessions open, with different logins.

This is my suggestion for easy switching of logins.

Posted by simonsabin | with no comments
Filed under:

It just does to show that Steve Jones doesn’t have a time machine. 11 years ago Steve wrote about SQL Server being ported to run on Linux

Well today its been announced as true.


What does that mean for you normal SQL folks? Probably not much, except it makes your skills much more attractive now than they ever were.


What it does mean is that not only will folks be able to spin up visual studio core and write C# running on a linux OS they can also have a SQL database on there. Who cares?


Well with the increase of the surface are of the SQL stack to provide analytics seamlessly and in a performant way means that any small system can use SQL


If there is on piece that is missing in the puzzle its the programming surface area. Like me a fellow MVP Greg Low has been asking for a common programming interface for many years. This would enable a coder to start with SQL and when his startup starts flying they can easily turn up the knows and have the system scale easily. With the subscription model coming to more and more azure services, I wish they could solve my biggest wish (ok maybe not my biggest wish, I’d like a DB CD tool that supports replication)


This is a monumental we are 2 days away

Are you prepared to be blown away

Posted by simonsabin | with no comments

I’m constantly amazed at the rate at which blockers for adoption for Azure SQL Database are being removed. With the advent of V12 servers we got the same core services as on premise. Since then we’ve got full text, encryption, row level security, transparent data encryption and more.

Last week Torsten Grabs blogged about the next big thing which not only enables cross database queries but some other great elastic scale features.

You can read about the details here ttps://

We’re working on some posts on how to easily move your on premise DBs to SQL Azure and utilise these new features.

Posted by simonsabin | with no comments

Many people are fortunate enough to have laptops or desktops that enable high resolution displays. If you try and run SQL Server management studio on those displays you will see everything is minute and unreadable.



The solution is to use scaling to increase the size of fonts and other components so you can the fonts and push the buttons.

I use 150% on my surface Pro 3 and it works well for most apps.

Unfortunately for this to work properly your app needs to handle the scaling correctly. many apps the font sizes are increased but not the dialog sizes, of the icons, resulting in an unusable dialog.

This is definitely the case for SQL Server Management Studio.

Luckily for you i was pointed towards a post by an italian SQL guy Gianluca Sartori that shows you how you can enable SQL Server Management Studio (SSMS) to work with high resolution monitors and DPI scaling


Happy viewing

Posted by simonsabin | with no comments

If you are eager to get office 2016, I would there are some really nice features, you might be wondering how.

There is no automated update (that’s coming next year) and if you go to Office 365 and download software you will just get 2013 (the latest ??? go figure)


What latest actually means is latest on the branch of office you are configured for.

If you want the bleeding edge then you need to say so in the service settings of office 365image

To do this

  1. Go to the admin section of office 365.
  2. Select Service Settings
  3. Select Updates

and you will get a screen like that on the left. You can choose whether you want all users or individual users on the Standard Release or the First Release (aka early adopters).

To get Office 2016 at the moment you need to be on the First Release.

Once you do that you will get another section in the download software page that gives you the option to “try the next version of Office”

From here you can install the latest 32 or 64 bit version of office 365.

If you are a company and need to do a bit more planning then have a look at

Posted by simonsabin | 1 comment(s)
More Posts « Previous page - Next page »