Administration

Inside the XEvent Profiler

Inside the XEvent Profiler

XEvent Profiler is a new feature of SQL Server Management Studio v17.3. I applaud the SQL Server Tools Team for this feature. I feel like it will go a long way towards putting the legacy SQL Profiler to bed. Sometimes…

Redgate SQL Prompt Grid Features

Redgate SQL Prompt Grid Features

I love Redgate tools. Most of all, I love SQL Prompt because its features increase my productivity on a daily basis. Recently I discovered a couple of new features for the SQL Server Management Studio results grid. The usefulness of…

DBCC CLONEDATABASE

DBCC CLONEDATABASE

Often I hear developers claim that they need production data in order to properly tune their queries. There are a couple of reasons that they believe this. The most important one is likely because the execution plans generated in a…

Azure SQL Database Elastic Pools

Azure SQL Database Elastic Pools

Azure SQL Database Elastic Pools are a mechanism for grouping your Azure SQL Databases together into a shared resource pool. Imagine for a moment that you had a physical server on premise. On that server, you have a single SQL…

Connecting your Azure regions

Connecting your Azure regions

In this post, I am going to demonstrate how to configure virtual network gateways in Azure using Resource Manager. This is important for connecting two Azure regions together, enabling you to setup high-availability and/or disaster recovery systems. 1. Resource Groups…

T-SQL Tuesday #85: STOP! Restore Time!

T-SQL Tuesday #85: STOP! Restore Time!

I know, I know. That was a bit much. This month’s T-SQL Tuesday is being hosted by Kenneth Fisher (b | t). T-SQL Tuesday (#TSQL2sDAY) is a blog party founded by Adam Machanic (b | t). Each month a member…

SQL Agent 2016 Jobs Running PowerShell Scripts

SQL Agent 2016 Jobs Running PowerShell Scripts

I recently performed a side-by-side upgrade of a SQL Server 2008 R2 instance to SQL Server 2016 RTM. This particular instance had over 200 SQL Agent jobs running various PowerShell scripts. After the upgrade I had to modify nearly all…

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…