Administration

SQL Server 2016 Basic Installer

SQL Server 2016 Basic Installer

On many occasions I have found myself installing SQL Server and/or its development tools for a non-DBA power user. It always frustrated me to do this because I feel that SQL Server is for advanced users and I would expect…

Query Store for Everyone

Query Store for Everyone

SQL Server 2016’s Query Store feature is, without a doubt, one of the most exciting new features for this version. The Query Store will keep track of current and past query execution plans which grants you deeper insights into the performance…

Everything has a cost

Everything has a cost

Too often we end up in a conflict while trying to explain how a minimally impacting function has no true business impact. If you are too detailed, no one wants to listen to you and you are wasting their time. If…

Performance tuning backup and restore operations

Performance tuning backup and restore operations

The standard backup strategy seems to always include backups running at midnight, hoping that they complete before anyone starts using the applications. There is value in performing maintenance on off-hours. However, many applications do not have off-hours or our databases grow…

Guest Post: Identifying and handling blocked processes in SQL Server

Guest Post: Identifying and handling blocked processes in SQL Server

Author Bio: Priyanka Chouhan is a technical writer in Stellar Data Recovery with 5 years of experience and has written several articles on SQL server & SharePoint. In her spare time she loves reading and gardening. Identifying and handling blocked processes in SQL…

Statistics Parser

Statistics Parser

Today I’d like to recommend a free community tool, StatisticsParser.com. Statistics Parser is web-based tool for interpreting the text output of the T-SQL SET STATISTICS IO and TIME settings. The tool was created and is maintained by Richie Rump (b…

Connect to SQL Server on Azure VM via Local SSMS

Connect to SQL Server on Azure VM via Local SSMS

After you provision a Microsoft Azure VM with SQL Server there are a few more steps that you need to take to make remote connections. The procedure below starts with a fresh Azure VM provisioned and walks through the process…

Help! I am Locked Out of my SQL Server Instance

Help! I am Locked Out of my SQL Server Instance

Beginning with SQL Server 2008, local administrators are no longer SQL Server sysadmins by default. Microsoft removed this feature in an attempt to increase security. I agree with the change. The principle of least privilege would imply that even system administrators…

Policy Based Management Templates – TSQL2sDay #70

Policy Based Management Templates – TSQL2sDay #70

T-SQL Tuesday (aka #TSQL2sday) is a monthly SQL Server blogger event started back in late 2009 by Adam Machanic (blog | twitter). The first topic was about Date/Time Tricks. Read the original TSQL2sday call-out. Each month a different SQL Server blogger…

Do we care about development environment performance?

Do we care about development environment performance?

Recently, but not for the first time, I was confronted with a server administrator that didn’t want to allocate more than one vCPU to a SQL Server machine in a development environment. His exact words ring over and over in my…