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…

15