SQL Server 2016 CTP3 – new features and the JSON support improvements

SQL Server Community Technology Preview 3 has been released some days ago.

The SQL Server team added a lot of features related to:

  • SQL Server Engine (Query Store, Temporal Tables and In-Memory improvements)
  • Cloud-ready stuff (Transactional replication from and to Azure SQL Databases, Stretched database enhancements)
  • New releases of Management Studio
  • Analysis Services
  • Reporting Services (great, let’s say, “new entry”)
  • Integration Services

Continue reading “SQL Server 2016 CTP3 – new features and the JSON support improvements”

SQL Server latest Updates (Sep. 2015)

Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2012 SP2:

Cumulative Updates #8 for SQL Server 2012 SP1

Additionally, you can download:

SQL Server Data Tools preview (setp. 2015)

SQL Server Management Studio (sept. 2015)

and the new SQL Server 2016 CTP 2.4! This release adds new features, like the Smart Maintenance Plans, GUI improvements for indexes and TempDB, and so on..

 

Stay Tuned! 🙂

How to manage SQL Server security with SQL Source Control

One of the most common issue you can find when source controlling the database is about the security. How to manage the users and the related permissions?

If you use to apply permission to users and to assign users to the database, this can be a problem, especially when you are in the deployment phase (or else when getting latest versions from the source control). Let’s see these two scenarios:

Continue reading “How to manage SQL Server security with SQL Source Control”

SQL Server latest Updates (Jun. 2015)

Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2014 RTM and SP1:

Cumulative Updates #8 for SQL Server 2014 RTM

Cumulative Updates #1 for SQL Server 2014 SP1

Additionally, you can download the new SQL Server Management Studio.  As in the Microsoft Release Service blog, the SQL Server Engineering Team says: “we are delighted to announce our first “preview” release of SQL Server Management Studio!  This is our first effort to release SQL Server Management Studio (SSMS) in a mechanism outside of the SQL Engine releases.  Our goal is to update this frequently with new features, fixes and support for the newest SQL Server features in SQL Server Engine and Azure SQL Database

Stay Tuned! 🙂