Category: Uncategorized

What Could Be In Future SQL Server Releases

In November, i attended the annual SQL Server Pass Summit. Pass Summit is an event held in Seattle, Washington.
SQL Pass Logo

A Q&A session with the Microsoft SQLCat Team led to some interesting insight into what might be coming to future SQL Server releases:

  1. Re-build indexes can be paused and resumed. Useful if you need to spread the re-indexing over several nights;
  2. SQL Injection Detection. Wait and see on this one;
  3. SQL Graph. Coming to a future release. Adds graph processing capabilities to SQL Server, to help gather powerful insights and increase operational agility. Best suited for applications, where relationships are important, like fraud detectection
  4. In addition to R, there is talk that Python will be coming to SQL Server as well.

For anyone that wants to grow their career, this is a must attend event.

You can register at the link below:
http://www.sqlpass.org/summit/2017/registernow.aspx

Went last year and I know I will be back for many years. Definitely worth the 13 hour flight from Australia.

Microsoft SQL Server Named DBMS of the Year

Its no surprise that Microsoft Server has been named DBMS of the Year for 2016 according to DB-Engines.com. Its been a big year for Microsoft with the announcement of SQL Server on Linux which will bring a whole new customer base to providers and Microsoft. Developer Edition for free, as well as certain enterprise features available in Standard Edition in SQL Server 2016 SP1.

Congratulations Microsoft.

I mentioned to someone the other day, how far Microsoft have come in the last 10 years. Investing in their products and deliver new capabilities that the people and customers want. Not just in the SQL Server space. Windows 10 in my mind has been one of the best operating systems since Windows XP.

In second place was MySQL. Oracle who own MySQL have shown that they are willing to keep investing in MySQL development and continue to increase market share.

Third place was PostgreSQL. It has been a big year for PostgreSQL with 2 new versions of the product as well many big improvements to high performance workloads.

               Rankings

  1. Microsoft SQL Server
  2. Oracle MySQL
  3. PostgreSQL

 

 

Source:

http://db-engines.com/en/blog_post/67