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

DSC_1388
Aggregaties
Power BI Desktop is een prachtige tool om snel data-analyses te kunnen uitvoeren. Je connecteert op een databron, importeert en...
dba image
DBA is not that scary
Often when talking to people who are looking for a career path in the data world I feel like there...
blog-2303
How do you link an SCD Type 2 table in Power Query?
This article uses a simple example to demonstrate how to link an SCD Type 2 table in Power Query to...
featured-2302
How to easily parse JSON in Power BI Desktop
Sometimes you want to use JSON data in Power BI. And sometimes Power BI doesn’t exactly do what you want...
header-2301
Power BI reports as monitoring tool
Who has not created monitoring reports or beautiful dashboards in Power BI? Would it not be great to show off...
your-modernization-journey-starts-now-header
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...