Microsoft Data Platform is changing – so am I

This month’s T-SQL Tuesday entry hosted by Koen Verbeeck (http://sqlkover.com/t-sql-tuesday-89-invitation-the-times-they-are-a-changing/), a blog post about how we feel about the ever changing times within our technology space. Personally I love this new era of cloud computing and do not feel threatened in anyway.

TSQLTues

Continue reading

SQL Server DBCC CHECKDB

A quick video clip where I show two things.

Firstly I show how since SQL Server 2014 SP1+ the snapshot is no longer hidden then finally how I check that DBCC CHECKDB has ran successfully.

Continue reading

Azure – SQL Database Premium RS

A very quick post for today, I was navigating my way through the Azure portal within my SQL databases section and came across an edition that I had never seen before and I became very intrigued. It is called Premium RS (currently in preview mode) meaning we now have four tiers to select from – basic, standard, premium and premium RS.

Continue reading

My path from a junior to a senior DBA

A non-technical post but something I have been asked about few times so I thought that I would put pen to paper and tell you about my journey on becoming a senior DBA. You might find it fun to read.

Continue reading

TDE: Looking inside your backups

TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file too. I fancied looking inside a backup of my database before enabling TDE and comparing it to when enabled.

Continue reading