Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.

Power BI Histogram Example using DAX

by Additional Articles

MSSQLTips.com

Power BI

Companies use a Bell Curve approach to measure performance. As part of this approach they create a histogram. A histogram is a statistical concept and according to Wikipedia it is defined as a graphical distribution of the numerical data. A histogram is made of several bins and bins can be considered a range of values or a benchmark

When SQL Server Performance Goes Bad: Rogue Indexes

by Additional Articles

Redgate

Vendors/3rd-party Products

Phil Factor explains how SQL Monitor helps focus performance tuning efforts on the tables and queries where 'rogue indexes' might be a significant problem, and then how to identify both 'missing' indexes that might be beneficial to the overall workload, and those that are unused or duplicated, and so are doing more harm than good.

The Challenges of Splitting a Table

by Steve Jones

SQLServerCentral

Database modelling

Today Steve talks database development.

SQL Server Wait Stats Monitoring with PowerShell

by Additional Articles

MSSQLTips.com

PowerShell

In this article we add another module to the PowerShell monitoring process to capture wait stats for all monitored SQL Server instances.

Choosing a VCS

by Steve Jones

SQLServerCentral

Today Steve talks about choosing a VCS and which one he recommends.

SQL Server 2017 Installation Error with KB2919355

by iLearnSQL

SQLServerCentral

Installation

Recently I was installing SQL Server 2017 and I could not believe a simple installation took up my whole day. I was installing an instance on one newly built Windows 2012 R2 server. After clicking next a few times, I got an error: a rule failure, for KB2919355. I downloaded the KB2919355 as mentioned in […]

Fully Left-Shifted Deployments with Version Control and Automatic Cloning

by Additional Articles

Redgate

Conferences, Classes, Events, and Webinars

Discover the future of DevOps! Join Microsoft MVP Kendra Little to see Redgate's recent innovations in action and give you a picture of where Database DevOps is going, and why.