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

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”