Category: Microsoft

PASS SQL Saturday in Parma (#sqlsat462) – Second Edition

The 28 of November, PASS SQL Saturday will be held in Parma, in the north of Italy. This year event will be important, due to the new releases of SQL Server 2016.

SQLSAT462_print

Location

Parma University Campus, Computer Science department

Marchio_uni

Continue reading “PASS SQL Saturday in Parma (#sqlsat462) – Second Edition” →

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