Azure

External Article

Azure SQL Database Resiliency - Point-in-Time Restore

  • Article

Azure SQL Database provides a number of benefits that leverage resiliency and redundancy built into the underlying cloud infrastructure. You can take advantage of these features in order to perform backup, restore, and failover tasks, which help you recover from human errors, service outages, or even regional disasters. In this article, Marcin Policht provides an overview of the primary capabilities incorporated into Azure SQL Database, in particular focusing on point-in-time restore

2015-12-28

4,050 reads

Technical Article

Azure Data Lakes

  • Article

The Data-lake is basically a large repository of data for 'big data' analytic workloads, held in its original format. The Azure Data Lake adds Data Lake Analytics, and Azure HDInsight. Although the tools are there for Big Data Analysis, it will require new skills to use, and a heightened attention to Data Governance if it is to appeal to the average enterprise. Rob Sheldon takes a look.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2015-12-21

3,485 reads

External Article

Azure SQL Database - Transparent Data Encryption

  • Article

Transparent Data Encryption offers the ability to encrypt content of the database, its transaction logs, as well as backups while at rest. Encryption and decryption are performed in real-time, at the individual page level, as the database is being written to and read from storage, without necessitating changes to applications accessing their data. Marcin Policht reviews the feature.

2015-11-24

4,471 reads

External Article

Choosing hash distributed table vs. round-robin distributed table in Azure SQL DW Service

  • Article

Designing databases to use distributed tables effectively will help you to achieve the storage and query processing benefits of the Azure SQL DW Service (SQL DW). In this article, Murshed Zaman explains the various Azure SQL Data Warehouse distributed table types, and offers guidance for choosing the type of distributed table to use and when to use it.

2015-08-31

2,130 reads

External Article

Azure Event Hubs

  • Article

If you need to receive and process a large volume of of packets of data, such as telemetry, or event-log items, it may be worth considering Azure Event hubs. They aren't like traditional messaging but represent more of a stripped down one-way event processing system for large volumes of data. It could represent a good solution to an ever-present problem, but is it ready for production use? Rob Sheldon investigates.

2015-07-22

3,382 reads

External Article

Microsoft Azure Stream Analytics

  • Article

Azure Stream Analytics aims to extract knowledge structures from continuous ordered streams of data by real-time analysis. It provides a ready-made solution to the business requirement to react very quickly to changes in data and handle large volumes of information. Robert Sheldon explains its significance.

2015-06-25

3,380 reads

External Article

Cloud Storage Replication Is Not Backup

  • Article

The options that you need to select when setting up an Azure Storage service account allow you to specify the durability and high-availability of your data, but they don't provide for data recovery to a point-in-time. In fact, it means that some of the bad things that can happen to data are more efficiently replicated to all copies. Backup is quite a separate issue.

2015-02-27

8,864 reads

Blogs

Database AI Agents: The Read-Only Rule

By

Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...

Creating a SQL Stored Procedure to Load a SCD2

By

This is a blog that I am writing for future me and hopefully it’ll...

Funny Money: #SQLNewBlogger

By

While wandering around the documentation looking for some Question of the Day topics, I...

Read the latest Blogs

Forums

Backup Availability Group

By jayoub

Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...

How Do the Experts Become Experts?

By Kathi Kellenberger

Comments posted to this topic are about the item How Do the Experts Become...

Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment

By Massimo Preitano

Comments posted to this topic are about the item Stairway to Reliable Database Deployments...

Visit the forum

Question of the Day

Secure Communications

As of June 2026, what is the best version of TLS to use with SQL Server?

See possible answers