kohera-logo-regular.svg

SQL Spot – Part 4

It is all about the data these days, and that is exciting. Let’s just be clear about the reality of things. The increasing growth of data technologies is on an all-time high. Yet with our SQL Spot we try to gather some intel for all SQL Server enthusiasts, to feed you professionally or just your common hungry personal interest. The community information gathered addresses a healthy BI data science perspective, ranging from business to technical insights on various topics: SQL Server News, Power BI, SQL Server BI stack, features, Data Science topics and Accidental DBA stuff focused on basic maintenance and tuning advise. We’ll finish with some interesting learning or study materials.

All rights go out the great blogging community.

Business, releases, news and trivia

Business

Releases and news

Power and Excel BI

General

Power BI

Excel BI

M

DWH

General

SSIS

SSAS

General

Tabular

DAX

SSRS

Data science

General

Machine learning, AI, Deep learning

Azure Data Lake Analytics

R, Python, JSON,…

Cognitive Services

Maintenance

Internals

Backup and recovery

Storage

Health Practices

Infrastructure

SQL

Security

Tuning

Internals

Health practices

Index Tuning

SQL skills

Career and learning

Courses

Vids

General

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...