databasejournal.com databasejournal.com

Planning for SAP HANA Deployments in Public Cloud Environments

The public cloud increasingly has become the target for workloads which traditionally were considered to be confined to on-premises environments. This trend is particularly evident in the context of deployments of SAP products. In this article, you are provided with an overview of factors that should be taken into account if you are considering hosting SAP HANA in a public cloud. When it comes to SAP HANA deployments, it is fairly easy...

databasejournal.com databasejournal.com

Implementing SQL Server Integration Services with Azure Data Factory

SQL Server Integration Services (SSIS) was first made available well over a decade ago as part of the release of SQL Server 2005, replacing Data Transformation Services, which had been integrated into the product since SQL Server 7.0. This enduring pedigree has been interrupted by the introduction of Azure SQL Database, which, unlike its on-premises counterparts, restricted its capabilities to those implemented directly by the database...

databasejournal.com databasejournal.com

Backup Techniques Available Exclusively When Using Azure VMs

Running SQL Server in Azure VMs offers a number of benefits directly associated with the very nature of the Infrastructure-as-a-Service (IaaS) platform, such as simplified scalability, enhanced agility, and the operational cost model. In addition, the use of Azure as the cloud platform presents some additional opportunities that simplify traditional maintenance tasks such as patching or backups. In this article, you will learn backup...

databasejournal.com databasejournal.com

Deployment of SQL Server 2019 Always On Availability Groups on Azure AKS

In the article Introduction to Running SQL Server 2019 on Kubernetes recently published on this forum, the core concepts and basic architecture of implementation of SQL Server 2019 Always On Availability Groups on a Kubernetes cluster are described. In this article, an implementation will be stepped through by leveraging Microsoft Azure-hosted managed Kubernetes service referred to as AKS. AKS considerably simplifies provisioning of...

databasejournal.com databasejournal.com

Graphical Tools for Accessing Azure Cosmos DB

While the most common methods of interacting with Azure Cosmos DB involve programmatic access, there are times when you might want to perform a quick change or take a peek at some of documents in a collection. In such instances, it is typically more convenient to rely on the graphical interface. Fortunately, there are several options you can use to accomplish. Data Explorer: The Azure portal includes Data Explorer, which provides a...

databasejournal.com databasejournal.com

Introduction to Running SQL Server 2019 on Kubernetes

In recent years, Microsoft has fully embraced the open source paradigm. One of the more prominent examples of this trend was providing the ability to host SQL Server 2017 instances on Linux, including running Docker-based SQL Server images (available directly from Microsoft Container Registry) on Kubernetes clusters. The release of SQL Server 2019 further extends the multi-platform capabilities by allowing for Kubernetes-based...

databasejournal.com databasejournal.com

Overview of Azure SQL Database Information Protection

Information protection becomes one of the dominant factors that drive modern database design and implementation. This becomes particularly evident when operating in a cloud computing environment, with Azure SQL Database serving as one of prime examples of this trend. Microsoft delivers relevant features by leveraging several different security-related Azure services. In this article, we will provide an overview of this...

databasejournal.com databasejournal.com

Overview of In-Memory Technologies of Azure SQL Database

Azure SQL Database offers a straightforward approach to controlling its performance through vertical scaling. Despite its simplicity, scaling up has obvious pricing implications and, while it is an online operation, it might result in rollback of in-flight transactions. If you are looking for a supplemental approach to enhancing performance, then you might want to consider implementing in-memory technologies, which are part of the...

databasejournal.com databasejournal.com

Azure SQL Database and GDPR Compliance

In recent years, technology landscape has undergone dramatic changes, driven primarily by cloud computing and a continuously increasing level of attention dedicated to security, privacy, and compliance. As recent revelations related to improper use of consumer data by social network providers and research firms have shown, this attention is well warranted. Similarly, surging numbers of increasingly sophisticated cyber attacks further...