Azure

Technical 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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

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

Technical 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2015-11-24

4,471 reads

Technical 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

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

Excellent article on securing msdb

By

Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...

T-SQL Tuesday #201: Temp Tables

By

This month we have a new host, which I am grateful for. So many...

When Do You Reach For A #temp Table?

By

I needed to do some research because there is more to #temp tables than...

Read the latest Blogs

Forums

jdbc auth failing to sql from sap's cloud middleware CPI

By stan

hi , our business partner is asking s4 sap api's for receivable info and...

Searching for my own posts

By pietlinden

I have a really stupid question... Is there an easy way to search for...

How to Work with On-Premises AI Models to Generate T-SQL Code

By Daniel Calbimonte

Comments posted to this topic are about the item How to Work with On-Premises...

Visit the forum

Question of the Day

Escaping Strings

The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?

See possible answers