Would You Move For a Job?

• by Andy Warren

• SQLServerCentral.com

• Editorial

Today we have a guest editorial from Andy Warren as Steve is on vacation. Would any job be enough for you to uproot your life?

Posting SQL Server Notifications to Slack

• by Additional Articles

• MSSQLTips.com

• Monitoring

In this article we look at how to send Slack notifications when certain events occur in a SQL Server database.

Conditional Formatting with SSRS

• by Thom Andrews

• SQLServerCentral

• Reporting Services (SSRS)

An introduction on how to implement condition formatting of cells, such as the font and background colour or font weight, within SSRS using SSRS Expressions.

Solving Real Problems

• by Grant Fritchey

• SQLServerCentral

• problem solving

Today we have a guest editorial where Grant talks about being effective and practical in your world.

Heaps in SQL Server: Part 3 Nonclustered Indexes

• by Additional Articles

• SimpleTalk

• Development

Uwe Ricken continues his series on heaps. This time he demonstrates a common scenario where the query against a heap is faster than a clustered index.

Aiming for Better Data Governance

• by Steve Jones

• SQLServerCentral

• Data Privacy and Protection

Today Steve gives a reason why your organization might consider improving its data governance.

Indexes: When Column Selectivity Is Not Always A Requirement

• by Mike Byrd

• SQLServerCentral

• Indexing

While preparing for my SQL Saturday Salt Lake City presentation, Climbing the B-Tree, I ran into one of the “word of mouth” facts that the first column of an index should be highly selective, i.e., it should only point to one or a few rows. This is not always the case and I’ll show you […]

Stairway to Biml Level 7 – Populating the Database for a Custom Biml Framework

• by Andy Leonard

• SQLServerCentral.com

In this next level of the Stairway to Biml, we look at a custom framework in Biml.

Free eBook: Defensive Database Programming

• by Press Release

• Redgate

• defensive 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

• 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