Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager Database
MAY 1, 2015
In my last post, I discussed some of the concepts around Sharding and how we...
2015-04-30
112 reads
Azure SQL Database Elastic Scale Part 1 - What is Sharding?
MARCH 19, 2015
This week, Microsoft introduced an update to Azure SQL Database Elastic Scale Preview. This update is good...
2015-03-19
30 reads
Dynamic Data Masking
FEBRUARY 26, 2015
Have you ever wanted to only show parts of a field to certain sets of users such as credit card numbers, telephone numbers or last...
2015-02-26
2 reads
Index Fragmentation in Azure SQL Database
FEBRUARY 4, 2015
Recently, I read the articles Stop Worrying About SQL Server Fragmentation and When Does Index Fragmentation Matter?, and that got me starting to...
2015-02-03
54 reads
Monitoring Geo-Replication in SQL Azure using DMV'sDECEMBER 26, 2014Azure SQL Database comes with a host of disaster recovery options. The...
2014-12-25
5,818 reads
Monitoring Geo-Replication in SQL Azure using DMV's
DECEMBER 26, 2014
Azure SQL Database comes with a host of disaster recovery options. The most robust of these options involves replicating the database...
2014-12-25
201 reads
Runbooks in SQL Azure
DECEMBER 2, 2014
SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud”. They enable you to use PowerShell Scripts inside of SQL Azure...
2014-12-10
40 reads
Runbooks in SQL AzureDECEMBER 2, 2014SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud”. They enable...
2014-12-10
1,348 reads
SQL Azure Point-in-Time RestoreOCTOBER 26, 2014As a strategic direction, many companies have decided to start moving their SQL Server databases...
2014-12-06
980 reads
SQL Azure Point-in-Time Restore
OCTOBER 26, 2014
As a strategic direction, many companies have decided to start moving their SQL Server databases into the cloud using SQL Azure. This change in...
2014-12-06
3 reads
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers