SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Pie in the Sky

I have been working with SQL Server for 15 years and have done everything from reporting to database design to ETL to architecture to administration. The way I see it, the cloud is the future, and SQL Azure is a great platform. Here are my musing on the subject.

Archives: February 2015

Dynamic Data Masking

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 names? This functionality is now possible in Azure SQL Database with Dynamic Data Masking. This month, Microsoft has continued…

Read more

0 comments, 8,610 reads

Posted in Pie in the Sky on 26 February 2015

Index Fragmentation in Azure SQL Database

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 think about how index fragmentation in Azure SQL Database compares to index fragmentation in on-premise versions of…

Read more

0 comments, 9,532 reads

Posted in Pie in the Sky on 3 February 2015