SQL Server Latest Updates (Sep. 2016)

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

Cumulative Update #2 for SQL Server 2016 RTM

Cumulative Update #5 for SQL Server 2012 SP3

Cumulative Update #14 for SQL Server 2012 SP2

 

SQL Server Management Studio 16.4.1 is available here.

SQL Server Latest Updates (May. 2016)

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

Refreshed Cumulative Update #6 for SQL Server 2014 SP1 (previously deprecated CU here)

Cumulative Update #3 for SQL Server 2012 SP3

Cumulative Update #12 for SQL Server 2012 SP2

SQL Server 2005 is end of life. The SQL Server 2005 upgrade options are here.

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 Latest Updates (Jan. 2016)

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

Cumulative Update #1 for SQL Server 2012 SP3

Cumulative Update #10 for SQL Server 2012 SP2

Additionally, Microsoft announced the release of TLS (Transport Layer Security) 1.2 support for SQL Server 2008, 2008 R2, 2012 and 2014. Read more here.

Stay Tuned! 🙂

How to manage SQL Server security with SQL Source Control

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

SQL Server latest Updates (May 2015) + SQL Server 2016 CTP2

SQL Server latest Updates (May 2015) + SQL Server 2016 CTP2

Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2012 SP1/SP2 and SQL Server 2014 + SQL Server 2016 CTP2:

Cumulative Updates #16 for SQL Server 2012 SP1

Cumulative Updates #6 for SQL Server 2012 SP2

SQL Server 2014 SP1

and then….

SQL Server 2016 CTP2!

Stay Tuned! 🙂

Unit testing with SQL Server article on SQLServerCentral.com

Unit testing with SQL Server article on SQLServerCentral.com

My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).

art

You can read it here.

Stay tuned! 🙂