Johan Åhlén


SQLServerCentral Article

Monitoring Azure SQL Databases

There are many reasons you should monitor your databases, including avoiding performance problems or running out of disk space. Ideally, you want a scalable monitoring solution where you can monitor all your SQL databases in one single place. This article will describe two options that are available: Azure SQL Analytics and Azure SQL Insights. Both […]

5 (2)

You rated this post out of 5. Change rating

2022-03-18

9,010 reads

SQLServerCentral Article

Getting Started with Azure Purview

Introduction Azure Purview is Microsoft’s unified data governance service that helps you discover and get insight into your available data. It replaces Azure Data Catalog and is now based on Apache Atlas, one of the leading open-source data governance and metadata frameworks. Apache Atlas was created by Hortonworks and big names within finance, pharma, etc. […]

5 (2)

You rated this post out of 5. Change rating

2021-02-18

4,847 reads

SQLServerCentral Article

Time Traveling with Temporal Tables on SQL Server 2016

One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates.

4.91 (35)

You rated this post out of 5. Change rating

2017-09-04 (first published: )

9,447 reads

Blogs

Updating dbatools–Fixing the Certificate Failure

By

I was trying to update my dbatools install to test something and go this...

Classifications and sensitivity labels in Microsoft Purview

By

I see a lot of confusion on how classifications and sensitivity labels work in...

PASS Data Community Summit: A Personal Journey

By

As someone attending the event since 2011, I would like to share my personal...

Read the latest Blogs

Forums

AWS RDS MSSQL

By shambhumahto

Since AWS RDS MSSQL does not support logon trigger, is there any alternative way...

How to get a distinct value from my data set

By skaggs.andrew

Hi, I need help with writing a script that will allow me to pull...

How To Approach Adding A primary Key To An Existing Table

By YSLGuru

In our vendor created/managed DB we have a table that is like an audit...

Visit the forum

Question of the Day

SQL Server on Linux Restrictions

Which of these features are not available on SQL Server on Linux? (choose 2)

See possible answers