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…

How Fast Can You Learn?

How Fast Can You Learn?

Self-analysis and emotional intelligence are valuable assets. Internal, or even external, dialog aids in problem solving and understanding. Knowing yourself is more important than any skill that you may have. You must understand what you think you know, what you know for certain,…

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…

Rotating Tables with Indicators in SSRS 2016

Rotating Tables with Indicators in SSRS 2016

When creating SSRS (SQL Server Reporting Services) dashboards, I like to use indicators to give clear and colorful data visualizations. In this post I am going to cover the use of indicators and demonstrate how to rotate your tables so that…

DBCC OPTIMIZER_WHATIF: Spoofing production hardware

DBCC OPTIMIZER_WHATIF: Spoofing production hardware

Performance tuning in a development environment can be difficult. Processor core count and memory are important factors in execution plan generation. The undocumented command DBCC OPTIMIZER_WHATIF will alter the optimizer’s perception of its server resources. Syntax You can use the DBCC…

T-SQL Tuesday #84: Building an hour of content

T-SQL Tuesday #84: Building an hour of content

This month’s T-SQL Tuesday is being hosted by Andy Yun (t | b). T-SQL Tuesday (#TSQL2SDAY) is a blog party founded by Adam Machanic (t | b). Each month a member of the community hosts the party and selects the…

Unique Indexes and Computed Columns in SQL Server

Unique Indexes and Computed Columns in SQL Server

In the last post of this blog series, I discussed what a non-clustered index is and how to choose an ideal non-clustered index key. In this post, I will discuss indexes on computed columns and unique indexes. Computed columns Computed…

QS-Config is no longer supported

QS-Config is no longer supported

It saddens me to announce that I will no longer be supporting QS-Config. It seems like a long time since I wrote the first version of it, long before I ever decided to publish it. At the time I was…

Demo God Recovery Kit

Demo God Recovery Kit

I was scheduled to give a virtual presentation to the MagicPASS user group. The week before I received a beta update for Windows 10. My computer became very unstable. It would not boot half of the time and it corrupted…

Non-Clustered Indexes in SQL Server

Non-Clustered Indexes in SQL Server

In the last post of this blog series, I discussed what a clustered index is and how to choose an ideal clustered index key. In this post, I will describe the non-clustered index and offer design tips as they relate…