SQL Performance Counters are Missing

There was one time when I was delivering a Service using a tool that gathers performance data through the SQL Server Counters on Performance Monitor, I got surprised when I tried to review the data and there was no information. Then I checked the SQL Server counters directly on Performance Monitor and the counters were…


Using ‘R’ Services within SQL Server 2016

 Using ‘R’ Services Within SQL Server 2016 ‘R’ Services in SQL Server 2016 is a new technology within the SQL Server suite. This is an Enterprise feature allowing data scientists to explore and model data directly against the database, thereby minimising data movement and potentially stale data.   Enabling ‘R’ services requires the selection of…


Set your PowerShell session to automatically log into Azure

[Edit 18 July 2017] – A recent update in the PowerShell command line tools for Azure has broken my previous scripts.  I’ve now updated the post with the updated commands.  Note you should update your version of the Azure Command Line Tools before configuring this on your own machine.   I’ve been working in Azure…

5

Incremental statistics … How to Update Statistics on 100TB Database

I really like the idea of Incremental Statistics and what it can offer customers, specifically around reduced maintenance times and I’ve been trying to find a real life example of how a customer has used this feature to help them manage super huge databases. I was fortunate enough that one of our Brazilian colleagues has…

5

How to Consolidate Data Migration Assistant JSON Assessment Reports

Starting from Data Migration Assistant (DMA) v 2.1, DMA provides command-line support for running assessments in unattended mode.  This feature helps to run the assessments at scale.  The command-line version of DMA generates the assessment results in the form of a JSON or CSV file. You can assess multiple databases in a single instantiation of…

4

SQL Server 2016 DTC Support In Availability Groups

In this post I’ll discuss the new support for Distributed Transactions in SQL Server 2016, how this is made possible and show a brief example of a distributed transaction from TSQL and a simple COM Application against a database in an Availability Group and a stand alone database. What is MSDTC? The Microsoft Distributed Transaction…

4

Query Store: How it works? How to use the new Query Store Catalog Views?

Part 2 /*Fix 2017.03.28: Not Query Store DMVs but Catalog Views. Thanks Kalen Delaney for point it*/ “The SQL Server Query Store feature provides you with insight on query plan choice and performance. It simplifies performance troubleshooting by helping you quickly find performance differences caused by query plan changes. “msdn. If you want to know,…


SSMS March 2016 Fails to Install

It’s super frustrating when software fails to install, it’s especially frustrating when the log file doesn’t give you any useful help in figuring out why!   I’ve just set up a new VM with SQL Server 2016 RC1 and now need to install SSMS on the same machine.  My Hyper V VM is an offline…

3

SQL 2016 Load Balanced Readable Secondary Replicas

Continuing the theme of new features in SQL 2016, today I’ll introduce read workload load balancing with AlwaysOn Availability Groups. What is a readable secondary? A secondary replica can allow read-only access to all its secondary databases in the form of user connections or application connections.  Even though we class this as “read only” the…

3

SQL Server 2016 new features to deal with the new CE

It is no news that SQL Server 2014 changed the Cardinality Estimator (CE). Ok. Even if it is not something new: What means CE? What is the impact of the new CE? And most important what SQL server 2016 propose to deal with it? The idea of this post is to answer those kind questions and give…