kohera-logo-regular.svg

SQL Spot – Part 6

Summer holidays are coming up: perfect timing to take that moment of peace and quiet you had been waiting for and catch up on some of the most recent SQL updates with our monthly SQL Spot. And once again, our thanks to the neverending support and input of  SQL blogging community!

Business, releases, news and trivia

Business

Releases and news

Power and Excel BI

Power BI

Excel BI

M and DAX

DWH

General

On-premise

Azure SQL DWH

SSIS

SSAS

General

Azure AS

SSRS

Data science

General

Machine learning, AI, Deep learning

R, Python, JSON,…

Maintenance

Internals

Monitoring and auditing

Backup and recovery

Storage

Index

Health Practices

Infrastructure

SQL

Security and quality

Tuning

Internals

Indexing

In-memory optimization

Health practices

Language

Career and learning

Thoughts

Courses

Parameter sniffing solved with new Parameter Sensitive Plan Optimization feature

If you’re someone that works a lot with Microsoft SQL Server, there’s no doubt that you’ve had issues with an issue called “Parameter sniffing” before. Up until now, you had...

Creating maps with R and Power BI

The possibilities are infinite when it comes to creating custom visuals in Power BI. As long as you have creativity and knowledge about the right programming language, you can let...

Sending monitoring alerts through Telegram

What if you could get the ease of phone notifications for whatever monitoring alerts you need? Then we have a solution for you with the app Telegram. Some of you...

Send mails with Azure Elastic Database Jobs

The DatabaseMail feature in SQL Server and Managed Instance is widely used by many professionals. But what if you want a similar functionality in Azure SQL Database? There are options,...

Sorting matrices in Power BI

Recently I worked on a Power BI project for a client. They had a SharePoint site where they regularly published articles and wanted to pour view data into a report...

The world of data is evolving

The data landscape has changed dramatically over recent years. In the past, we mainly heard that we needed to do as much as possible “cloud-only”—but this trend has become more...