About Me

Featured

I am passionate about using Microsoft Technology. Specialising in the Data Platform leveraging the power of Microsoft Azure – SQL server, Azure SQL DB, Azure SQL DW, Elastic Pools, Managed Instances, Azure Databricks, basically anything about data!

So any questions/ feedback – please Get In Touch

Copyright ©  in accordance with the Copyright, Designs and Patents Act 1988. All rights reserved. You are free to use any of the content here for personal use but need permission to use it anywhere or by any means (electronic, mechanical, photocopying, recording or otherwise).

 

Azure SQL Database F and M series

Taking a screen shot from my Azure Portal, you will see the available hardware configurations available for Azure SQL Database.

Continue reading

Azure SQL Database and Long-Term Backups

There is a new (ish) interface to looking and configuring backups for your Azure SQL Database. This can be found within the settings section of the SQL Server.

As you can see, by default we have 7 days retention to allow for PITR – Point In Time Recovery, anything longer you will need to setup long term retention.

Continue reading

SQL Server Linux

If you have come from a windows background you may be curious about the world of SQL Server Linux. Yes, the operating system and the implementation of it differs to the traditional Windows environment but once installed, it’s just good old SQL server and those lovely DBCC commands and backup statements work, all your DMVs are ready for you too.

Continue reading

Azure SQL Database – Greatest and Least TSQL

Being in the cloud does have many benefits, from lower administration to fast scaling but another “side effect” of operating in Azure SQL Database is the cloud first nature of changes. By this I basically mean new features always get pushed to Azure first before the classic on-premises version so some gems come to light.

Continue reading