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

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.

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.

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.