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

Journey
Your Modernization Journey starts now
Recently Microsoft introduced SQL server 2022. We wrote this post to make sure you won’t be missing out on all the fun and exciting new...
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....
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 are creative and have knowledge about the...
Reading monitoring alerts in Telegram
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...
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 similar functionality in Azure SQL...
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...