Good Enough

Steve talks a little about when code is good enough.

Stairway to SSAS Tabular Level 7: Time Intelligence

Time Intelligence is a common methodology in Dimensional Modeling that allows for calculations of measures based on relative dates. These include “To-Date” measures like Year to Date or Quarter to Date as well as Previous Period comparisons. Once these are created within a model, other DAX functions can be used for metrics like Year over […]

DevOps 101 Webinar: Key Concepts and Terminologies

As you embark on your own Database DevOps journey you are going to hear many new concepts and phrases, but what do they mean and why are they important to consider? Join Grant Fritchey live as he breaks down the key concepts and terminologies around Database DevOps.

Raising Exceptions and Error Handling with SQL Server THROW

Learn how and why to use THROW in your SQL Server code to be able to better handle errors that may occur during code execution.

The Home Password Cracker

Passwords cracked in under an hour using modern hardware have Steve shaking his head.

How to Use PowerShell to Track a Network Latency Issue in an Always On Availability Group

This article tracks down a problem with Availability Groups due to network bandwidth.

Remote Remote Work

Working remotely can be more than working at home, which Steve thinks helps the work-life balance.

Sign up to PASS Data Community Summit 2022

There's still time to register for Summit and unlock access to over 300 sessions. Join peers and industry leaders in the data community homecoming. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE

SQL Server Data Masking with DbDefence

Data Lineage Scripts for Microsoft SQL Server and Azure SQL

Learn how you can easily analyze the data lineage in your SQL Server database.