Tag: sql server 2016

SQL Server Latest Updates (Nov./Dec. 2016)

Directly from the SQL Server Release Service blog, here the latest updates for SQL Server 2012, 2014 and 2016:

Cumulative Update #6 for SQL Server 2012 SP3

Cumulative Update #15 for SQL Server 2012 SP2

Cumulative Update #3 for SQL Server 2014 SP2

Cumulative Update #10 for SQL Server 2014 SP1

Cumulative Update #3 for SQL Server 2016 RTM

and then, SQL Server 2016 Service Pack 1!

Stay Tuned! 🙂

SQL Server Latest Updates (Jul. 2016)

Directly from the SQL Server Release Service blog, here the latest updates for SQL Server 2012, 2014 and 2016:

Cumulative Update #13 for SQL Server 2012 SP2

Cumulative Update #4 for SQL Server 2012 SP3

Cumulative Update #1 for SQL Server 2016 RTM

SQL Server 2014 Service Pack 2 is available here!

The SQL Server Management Studio July release here.

Starting from the 13 of July, you can use the Basic Installer for SQL Server 2016 Express, Developer and Evaluation Editions. As Microsoft says “With three clicks, you can get a default installation of these editions and have SQL Server installed in a manner of minutes.”

The following pictures show what you are going to see while installing those SQL Server editions through the Basic Installer:

Stay Tuned! 🙂

SQL Server Latest Updates (Mar. 2016)

Directly from the SQL Server Release Service blog, here the latest updates for SQL Server 2012 SP2 and SP3:

Cumulative Update #2 for SQL Server 2012 SP3

Cumulative Update #11 for SQL Server 2012 SP2

You can download the latest preview of SQL Server Management Studio here.

Additionally, downloads of new useful tools are available:

Stay Tuned! 🙂

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” →

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” →