Slides & Links from SQL Saturday Cleveland

Thank you to everyone who came out to see my presentation Keys to a Healthy Relationship with SQL Server at SQL Saturday Cleveland. I had a great time and...

High Availability options for SQL Server 2008 in an Azure VM – a #sqlhelp story

I asked a question on Twitter yesterday: And check out the magic of the sqlhelp hash tag, I got loads of answers! So many that I’m actually selecting a...

Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)

I am very passionate about having a disaster recovery architecture, plan and strategy. This is very important for business continuity. I will be walking you through a journey on...

ASF 028: Uwe Ricken interview

Introduction Uwe Ricken is working with IT systems since the 90’s. He found the way to the technology of Microsoft SQL Server with the assignment for the development of...

ASF 028: Uwe Ricken interview

Introduction Uwe Ricken is working with IT systems since the 90’s. He found the way to the technology of Microsoft SQL Server with the assignment for the development of...

Bring Your Own Key to Azure SQL Database Managed Instance TDE

Last year Azure SQL Database Managed Instance saw the introduction of bring your own key (BYOK) functionality for transparent data encryption (TDE). This functionality has been in the singleton...

Changing the owner of a schema removes all direct permissions of objects owned by the schema.

This is one of those things that probably doesn’t happen all that often, but bit me in the … elbow ... Continue reading

New Youtube Channel

Last year I noticed I was blogging way less than I should, in part because of new projects: work, personal stuff, local community activities, university projects... you name it.As...

New Youtube Channel

Last year I noticed I was blogging way less than I should, in part because of new projects: work, personal stuff, local community activities, university projects... you name it.As...

Part 3 : Does data archival strategy matters ?

This article is the part of Does it matter ? series.

We'll discuss various aspects to save cost and optimize the database performance by archiving the data.