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

7,506 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,503 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: )

8,722 reads

Blogs

Opening the SQL Prompt Command Palette

By

A few years ago SQL Prompt added a command palette to let you search...

Common Mistakes in SQL Server – Part 2

By

The  Identity property creates an incremental value for the specified column automatically, which is...

Enable PowerShell Remoting

By

Enable PowerShell Remoting I use PowerShell quite a lot...

Read the latest Blogs

Forums

SQL Migration - Identifying Connections - Best approach

By ramana3327

I have one SQL Database server which is old version and planning to migrate...

Restore With Standby; A Review and A Lesson Learned

By Andy Warren

Comments posted to this topic are about the item Restore With Standby; A Review...

Are You Worried About AI?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Are You Worried About AI?

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers