kohera-logo-regular.svg

SQL Spot – Part 4

Vector_BG.png

SQL Spot – Part 4

Vector_BG.png

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

Photo of successful woman coder hacker web creator sitting armchair comfortable workspace workstation indoors.
The hurdles and pitfalls of moving or migrating a System-versioned temporal table cross database
Maybe you already have your own way of doing this and are wondering about alternative methods, or maybe you are...
Group of computer programmers working in the office. Focus is on blond woman showing something to her colleague on PC.
Updating your Azure SQL server OAuth2 credentials in Power BI via PowerShell for automation purposes
The better way to update OAuth2 credentials in Power BI is by automating the process of updating Azure SQL Server...
2401-under-memory-pressure-featured-image
Under (memory) pressure
A few weeks ago, a client asked me if they were experiencing memory pressure and how they could monitor it...
2402-fabric-lakehouse-featured-image
Managing files from other devices in a Fabric Lakehouse using the Python Azure SDK
In this blogpost, you’ll see how to manage files in OneLake programmatically using the Python Azure SDK. Very little coding...
2319-blog-database-specific-security-featured-image
Database specific security in SQL Server
There are many different ways to secure your database. In this blog post we will give most of them a...
kohera-2312-blog-sql-server-level-security-featured-image
SQL Server security made easy on the server level
In this blog, we’re going to look at the options we have for server level security. In SQL Server we...