Tag: SQL Server

Automatically link databases to Red Gate SQL Source Control

For the ones that have many databases to keep under source control, it can be really useful to speed up the link-to-source-control process. The only way we have now is to use the GUI provided by Red Gate SQL Source Control. Actually, there’s a github project called SOCAutoLinkDatabases by Matthew Flat, a Red Gate engineer, but, unfortunately it works only on a shared database model (centralised) in TFS. Let’s see how to manage the link using Working Folder (which is also good for many SCM) and dedicated database model (distributed).

Continue reading “Automatically link databases to Red Gate SQL Source Control” →

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