Tuning Azure SQL Elastic Pools
The below image is a beautiful picture, now it could be worse. The red line and the green line could peak at the same time and for a very...
The...
2019-04-11
The below image is a beautiful picture, now it could be worse. The red line and the green line could peak at the same time and for a very...
The...
2019-04-11
More and more organizations are moving to the cloud to leverage the key benefits of agility and reduced overall cost. Its likely that at some point in time, your SQL Server will manifest as either of the three implementations in Azure.
2019-03-30
Transitioning to the Platform-as-a-Service model typically implies relinquishing certain degree of control over your computing environment. One of the primary concerns related to this transition is diminished level of transparency providing insights into performance of cloud-resident workloads. Fortunately, with Azure SQL Database, you have a wide range of options that address this concern, allowing you to identify and remediate overwhelming majority of performance-related issues.
2019-01-29
2,366 reads
2019-01-25
630 reads
With Azure SQL Database Hyperscale, databases can quickly auto-scale up to 100TB, eliminating the need to pre-provision storage resources, and significantly expand the potential for app growth without being limited by storage size.
2019-01-10
2,316 reads
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 the 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 functionality.
2018-12-04
1,981 reads
2018-10-18
748 reads
Determining the number of DTUs which will help in deciding the service tier for Azure SQL.
2018-09-20
835 reads
Site-wide or region-wide disasters, while undoubtedly more impactful, happen considerably less frequently than downtime resulting from scheduled maintenance events or isolated hardware and software faults. This article provides an overview of the high availability features of Azure SQL Database that mitigate risks affecting services within an individual Azure datacenter, rather than an entire Azure region.
2018-09-18
2,171 reads
Marcin Policht provides an overview of a number of new features that facilitate Azure SQL Database business continuity.
2018-08-28
2,456 reads
By Steve Jones
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...
By Rayis Imayev
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...
You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...
Hi All, I have couple questions related to Ola Hallengren's maintenance script. If anyone...
I've been exploring various methods to monitor and alert for long-running queries in SQL...
Hi everyone I need to find the last business of the week. In most...
How can I run SQL Agent with SQL Server Express 2022?
See possible answers