Recover Deleted TDE Key for Azure SQL Database
In this article we look at the steps to recover a deleted TDE key that is being used by Azure SQL Database for database encryption.
2021-04-20
384 reads
Additional Articles
A data transformation problem in SQL and Scala: Dovetailing declarative solutions Part II
In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.
2021-04-20
SQL Window Functions in SQL Server, Oracle and PostgreSQL
In this article we look at using Window Functions in SQL Server, Oracle and PostgreSQL to see the differences and similarities of the syntax.
2021-04-19
Tell us about how you monitor your databases
The 2021 State of Database Monitoring survey is now open, and we want to know how you’re currently tackling your server, instance, and database monitoring. By taking part, you’ll contribute to the sole industry-wide report on database monitoring, and provide insights into how SQL Server professionals manage their estates and what challenges they face. Plus, you’ll receive an advanced copy of the report and entry to a prize draw to win a $500 Amazon voucher.
2021-04-19
Code Review & DevOps
A frequent question among those learning about DevOps is "How do we do code reviews in this automated process?". Grant Fritchey shares three options - and a word of caution - to ensure you can appropriately understand the changes happening in your system.
2021-04-16
What to monitor for SQL Server security
Keeping databases secure is critical. In this article, Robert Sheldon explains what to monitor for SQL Server security.
2021-04-16
Power Apps Canvas Apps Examples
In this article we will focus on Power Apps canvas apps which are natively optimized for mobile devices and we will look at potential use cases for canvas apps.
2021-04-15
SQL Monitor v11.1 now supports Azure SQL Managed Instances
Migration to the cloud and PaaS solutions has accelerated in the past years, and many organizations now manage hybrid estates. To reflect this, the latest release of SQL Monitor adds Azure SQL Managed Instances to its list of supported cloud platforms. This article explains how to monitor performance and activity for Azure SQL Managed Instances using SQL Monitor, with advice on monitoring hybrid estates and migrating from on-prem to Azure SQL Managed Instance.
2021-04-15
Digital Event: Innovate Today with Azure SQL
Join Microsoft's Rohan Kumar, and a full team of Azure SQL experts, for Innovate Today with Azure SQL. This free digital event from Microsoft lets you choose the sessions and technical demos that are most interesting to you and focus on the capabilities and possibilities that you want to learn more about.
2021-04-14
Oracle sequences: The basics
Oracle sequences can be used to create artificial IDs for a table. In this article, Jonathan Lewis explains how they work under-the-hood.
2021-04-14
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers