Press "Enter" to skip to content

Day: November 17, 2015

Building An Azure VM Of SQL Server 2016 CTP3

Published 2015-11-17 by Kevin Feasel

Dan English shows us an easy way to build a SQL Server 2016 CTP 3 instance:

If you have an Azure account (possibly through your MSDN subscription) here is the easiest way to get up and running with SQL Server 2016.

First go to the Azure Portal – http://portal.azure.com

Search and find the SQL Server 2016 CTP3 in the Data and Analytics Marketplace in Azure.

My preference is to grab the ISO and build a local VM, or install it on a server in my environment.  But if your server infrastructure lives on Azure or you’ve got those MSDN credits to burn, this is a good alternative.

Comments closed

Checking Statistics Validity

Published 2015-11-17 by Kevin Feasel

Bob Dorr has scripts to tell if your statistics are accurate:

The dilemma we all run into is what level of SAMPLED statistics is appropriate?   The answer is you have to test but that is not always feasible and in the case of Microsoft CSS we generally don’t have histogram, historical states to revisit.

Microsoft CSS is engaged to help track down the source of a poorly performing query.   It is common step to locate possible cardinality mismatches and study them closer.   Studying the statistics dates, row modification counter(s), atypical parameters usage and the like are among the fundamental troubleshooting steps.

Good post and great scripts, even if he Microsoftly nouns the verb “ask.”

Comments closed

One SSMS Setup

Published 2015-11-17 by Kevin Feasel

Kenneth Fisher describes his SSMS setup:

Every time I install a new version of SSMS I make a handful of changes to the default setup. For my own notes, and in case anyone is interested in some of the things you can do with SSMS I thought I’d post a list of those changes.

I also use a darker theme, very similar to Fisher’s; mine is designed to look like vim blue.  Of course, personal SSMS settings are personal.

Comments closed