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
116 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
31 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
3 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
57 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,868 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
244 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
42 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,351 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
982 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
7 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers