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
25 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
52 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,754 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
158 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
15 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,346 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
978 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
2 reads
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
When ASCII(Column) is null, what does it represent? Is this some kind of special/control...
Hello, I created the below script to output 999 rows from SQL Server table...
I have a database on SQL 2019 in an Availability Group (AG) and I...
Ask SSC