SQL Server Performance Dashboard Reports unleashed for Enterprise Monitoring !!!

SQL Server 2012 Performance Dashboard Reports is one of most popular SQL Server monitoring solution for customers and SQL community leveraging dynamic management views (DMVs) for monitoring and reporting and available at no cost to consumers. SQL Server Performance Dashboard Reports are available as a set of custom reports in SQL Server Management Studio (SSMS)…


Migrating SAP workloads to SQL Server just got 2.5x faster

SAP provides R3load process to perform export/import of SAP data to SQL Server for homogenous (SQL Server to SQL Server) or heterogeneous migration from different OS or database platform (UNIX/Oracle). By default, R3Load process performs parallel bulk load operations while importing the data in SQL Server. With SQL Server 2014 SP1 CU8, SQL Server 2014…


Improving Concurrency & Scalability of SQL Server workload by optimizing database containment check in SQL 2014\SQL 2016

Starting SQL 2012, database containment property is introduced in SQL Server database to support contained databases. As described in MSDN article here, database collation not only applies to data stored in user tables but also applies to variables, stored procedure parameters, GOTO labels. In case of contained databases, the collation of the metadata, variables, parameters,…


Boosting Update Statistics performance with SQL 2014 & SQL 2016

With SQL 2005 end of life, many customers are planning their upgrades to SQL 2014. One of the recommended post upgrade tasks is updating the statistics of all the tables and databases in latest compatibility level. The updated statistics ensures the query optimizer in the latest release has most up to date data to produce…


SQL Server 2014 is FIPS 140-2 compliant

We have recently published a KB article on using SQL Server 2014 in FIPS 140-2-compliant mode. Please see https://support.microsoft.com/en-us/kb/3141890 for more information.  

0

Transactional Replication to Azure SQL DB is now in public preview.

  As announced yesterday during my presentation at Pass Summit 2015, you can now configure Azure SQL DB as a subscriber of SQL Server Transactional Replication. This new capacity of Transactional Replication is available starting with the following versions\updates of SQL Server: Community Technology Preview (CTP) 3.0 of SQL Server 2016 SQL Server 2014 Service…

1

Multi-fold increase in throughput for big gateway query compiles in SQL Server

There are some exciting new changes in the database engine that dramatically improves query compilation scalability in SQL Server 2014 and SQL Server 2016. These changes are yet another reason to upgrade your SQL Server versions. When a query first starts and has to be compiled in SQL Server, it needs to acquire memory for…

5

SQL Server 2014 Service Pack 1 is now available

Approximately one year ago, we launched SQL Server 2014. Today, May 15, we are pleased to announce the release of SQL Server 2014 Service Pack 1 (SP1). The Service Pack is initially available for download on the Microsoft Download Center. SQL Server 2014 with SP1 will be rolling out to additional venues including MSDN/TechNet, the Volume…

0