Free eBook: Defensive Database Programming

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

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

Blogs

VMworld 2020 – Top 10 Database Sessions (Part 2)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 25 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

VMworld 2020 – Top 10 Database Sessions (Part 1)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Read the latest Blogs

Forums

Stored Procedure Performance Woes... How to get around CURSORS for html gen.

By scarr030

Hi everyone, Working with a stored procedure that is used in an application of...

Any guides for sizing Azure managed instances.

By Sliverlight

Hi All, Has anyone got any tips for sizing a move from VM running...

How to check if NextDay is Holiday (exclude Saturday and Sunday)?

By SQL Server

Hi: We maintain a calendar table with these columns. We have a process which...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers