SQL Server Migration Assistant (SSMA) v7.3 is now available

  Overview SQL Server Migration Assistant (SSMA)  for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2 and Access lets users convert database schema to Microsoft SQL Server schema, upload the schema, and migrate data to the target SQL Server (see below for supported versions). What is new? Improved quality and conversion metric with targeted…

0

MSSQLTIGER and February PASS Virtual Conferences

Tiger is delivering another session on today’s Performance Virtual Chapter (VC) meeting. A revamp of the “Gems to help you troubleshoot query performance”. You can join us here at 11AM PST / 2PM EST 2/23/2017. In this session we will learn about SQL Server enhancements in the most recent versions that can help you troubleshoot…

0

Getting more statistics information programmatically

As the building blocks which the Query Optimizer uses to know data distribution on tables, statistics are one of the key aspects in calculating a good enough plan to read data. So, when engaging in query performance troubleshooting, information about statistics is something you need to look at. Let’s say we need to look at statistics…

4

Tigers Down Under at Difinity, Ignite and SQL Saturday

Tigers (@ajaymsft, @s_u_n_e_e_l) are leaving the wet and cold Pacific Northwest to the warm regions down under in Australia and New Zealand. We’ll be there to present and connect with the Data Platform community in New Zealand and Australia through various events. If you are in any of these cities during this time, feel free…

0

Upgrading a Replication Topology to SQL Server 2016

SQL Server Replication provides multi-faceted data movement capabilities across SQL Server releases which has been used by customers across the globe for a large number of years. When moving from one major release of SQL Server to another, replication topology upgrade has been a constant topic of lengthy discussions. In this post, we shall outline…

13

Data Migration Assistant (DMA) v3.0 is now available

Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It also allows you to not only move your schema, data, but also uncontained objects from…

0

SQL Server Mysteries: The Case of TDE and Permanent Tempdb Encryption

I’m a huge Sherlock Holmes fan (I’ve read all the books, watch Elementary on CBS every week, and loved the most recent season Four of Sherlock) so when I recently got a question about some unexplained behavior for SQL Server, I thought of the idea of posting some of these as I get and solve…


Introducing VDC_Complete for Backup and Restore applications using SQLVDI

In addition to its built-in functionality for backup and restore, SQL Server is supported by a large number of third-party backup solutions. SQL Server provides application programming interfaces (APIs) that enable independent software vendors to integrate SQL Server backup and restore operations into their products. These APIs are engineered to provide maximum reliability and performance,…

0

Unicode strings and implicit conversions

Recently we had an interesting customer question about a seemingly strange behavior (and perhaps not widely known) on implicit conversions to Unicode. Imagine you declare a non-unicode string variable, and when concatenating strings that seem to fit the variable declaration, you get a result that is trimmed, although the sum of all string sizes is…


Columnstore Index: SQL Server 2016 – Improved DMV performance

SQL product team has made significant improvements in columnstore index functionality, supportability and performance in SQL Server 2016 based on the customer feedback. This blog post focuses on the performance improvements on a DMV done as part of our latest servicing release of SQL Server 2016, SQL Server 2016 SP1 CU1 and SQL Server 2016 RTM CU4. For…