@@VERSION and SERVERPROPERTY – What changed?

With the recent release of SQL Server 2014 SP1 CU3 and SQL Server 2014 RTM CU10, you will notice another change in the output @@VERSION. The motivation to introduce this change in the @@VERSION output string is completeness of the string information itself. This has been true over the years, as we have been introducing…


How we moved from on-premise to Azure Virtual Machine

We had previously blogged about moving some of our on-premise SQL Server environments which manages critical functions necessary for releasing the SQL Server builds to all our customers. We announced SQL Server 2016 CTP 2.4 which was made available on September 30th, 2015. You can download the preview from the Microsoft TechNet Evaluation Center site….

0

Released: System Center Management Pack for SQL Server and Replication (6.6.2.0)

We are happy to announce that a new version of SQL Server and Replication Management Packs has been released! Only the English version is available at this time. Localized management packs for this version will be made available at a later time. Downloads available: Microsoft System Center Management Pack for SQL Server enables the discovery…


MSSQLTIGER at SQL PASS Summit 2015

The SQL PASS Summit is round the corner and we are quite excited about it. The Microsoft SQL Server Tiger team will be at the SQL PASS Summit and is looking forward to meet the SQL Family. We will also be speaking at a few sessions during this summit. The PASS Summit is the world’s…

0

Comparison Tool released with latest SSMS

The ability to compare plans is something that a lot of people have to do for troubleshooting reasons. Maybe it’s to find why a query or batch suddenly slowed down; to understand the impact of a rewrite; or observe how a specific performance-enhancing change introduced to the design (like an index) has effectively changed the…


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

Cardinality Estimation for Correlated Columns in SQL Server 2016

When we introduced the new CE back in SQL Server 2014, several changes were done regarding the assumptions of the model. These changes were introduced because the vast potential for variations in data distribution, volume and query patterns, made some of the model assumptions not applicable. The 4 assumptions for the pre-2014 model were: Independence:…


New extended events for database recovery progress

In yesterday’s blog post, I talked about a new extended event for backup and restore. Continuing with the theme of insights into progress of long running tasks, another area we have invested in is database recovery. As most of you can attest, there is limited information available during database recovery activities such as Analysis, Redo…

0

New extended event to track backup and restore progress

Backup and restore are long running tasks in SQL Server with limited insights into progress. Often a question asked is “How much longer will it take for this operation to complete?”. Though there are trace flags and DMVs that provide some information, they are either unstructured (ex: trace flags send output to error logs and…

0

Record breaking performance numbers for SQL Server 2014

Record breaking performance numbers were recently published for SQL Server 2014 for various hardware systems. TPC-E (which measures the online transaction processing workload) and TPC-H (which is a decision support benchmark) numbers at the link below show SQL Server in the top ten price/performance for different hardware and OS platforms. TPC-E: http://www.tpc.org/tpce/results/tpce_price_perf_results.asp TPC-H: http://www.tpc.org/tpch/results/tpch_price_perf_results.asp  

1