One of the challenges associated with running your workloads in Azure SQL Database is the limited level of management oversight. Fortunately, there is an alternative approach that leverages the functionality incorporated into the recently introduced Azure SQL Database Advisor - Marcin Policht provides a brief overview.
2016-07-06
3,869 reads
An evaluation of the SQL Azure Database Performance Levels recommended by the DTU Calculator service, and a comparison with on premise SQL Server performance.
2016-02-04
3,674 reads
One of the benefits of using Azure-based Platform-as-a-Service and Software-as-a-Service offerings, is considerably quicker access to newly developed capabilities. In this article Marcin Policht focuses on row-level security, included in both Azure SQL Database V12 and SQL Server 2016 Community Technology Preview 2 (CTP2).
2015-10-14
3,552 reads
This document describes the process to provision a SQL Azure server manually. While it is expected that most servers will be provisioned using automation, DBA's must have the skills and know the process to perform the same provisioning manually.
2015-08-24
1,993 reads
The Microsoft Azure platform is evolving fast. Azure SQL Database is riding high on the cloud wave with new features enabled at a fast pace. In this article, Kun Cheng shares a few Azure SQL Database security features that could help developers and DBAs develop and manage a secure SQL Database solution.
2015-07-17
5,994 reads
If you need to do a time test for restoring an Azure SQL database from a point in time, and wonder about automating this through PowerShell, here are the guidelines that Tim Smith would you recommend?
2015-04-27
4,842 reads
SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud” enabling automation of time consuming, repetitive tasks.
2014-12-02
6,473 reads
Marcin Policht presents different methods that allow you to monitor the performance and characteristics of your PaaS databases, ensuring that they behave in a manner that matches your expectations.
2014-11-20
8,841 reads
Recently, we have been exploring the ability to administer Azure SQL Database by leveraging REST APIs invoked from PowerShell-based scripts. Such an approach offers more flexibility, facilitating functionality that is not directly exposed in the PowerShell cmdlets. In this article Marcin Policht shows the benefits when dealing directly with Azure SQL Databases.
2014-10-15
7,612 reads
Point-in-Time Restore is a new feature of the SQL Azure Service Tiers
2014-10-14
1,672 reads
It is Friday, the queries are running, and nobody is watching the bill. That...
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Wa:0817781222 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Wa:0817781222 Jl. Ir. H. Juanda No.118, Lebakgede, Kecamatan Coblong, Kota Bandung, Jawa Barat 40132
Wa:0817781222 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...
When running bcp on Linux, what is the field terminator?
See possible answers