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 (Aug. 2016)

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

Cumulative Update #1 for SQL Server 2014 SP2

Cumulative Update #8 for SQL Server 2014 SP1

SQL Server Management Studio 16.3 is available here with its high resolution support.

SQL Server Latest Updates (Apr. 2016)

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

Cumulative Update #6 for SQL Server 2014 SP1

Cumulative Update #13 for SQL Server 2014 RTM

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

Stay Tuned! 🙂

SQL Server latest Updates (Dec. 2015)

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

Cumulative Update #11 for SQL Server 2014 RTM

Cumulative Update #4 for SQL Server 2014 SP1

Additionally, you can download the latest release (december) of SQL Server Management Studio here.

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

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! 🙂

A 2015 full of DLM

After SQL Saturday Pordenone, I’ll keep speaking about DLM (aka ALM on databases) during the following events:

PASS Italian Virtual Chapter, April 14. I’ll demonstrate the SQL source control usage on SQL Server database
PASS SQL Saturday Torino, May 23, I’ve proposed two sessions (source control and unit testing on database)
.Net Campus a Roma, May 30, I’ll speak about continuous integration with SQL Server (source control, unit testing, deploy).
There’s a lot of work to do. But I’m thinking now about two or three new sessions. I hope to finish them in the last months of the year, and I hope to meet you in one of  these events, at least online.
Stay tuned!