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...

Finding Foreign Key Child Records In SQL Server

Foreign keys help to ensure referential integrity between tables.  In other words, parent records cannot be deleted if there are child records present.   This is a great thing and...

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.

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...

Your SQL Server's Screaming But Is Anyone Listening? – High Severity Alert Notifications

As usual, the scripts in this post can be found HERE on our Git Hub repo If your SQL Server comes across something that it’s not happy about, it...

Parameterizing a REST API Linked Service in Data Factory

We can now pass dynamic values to linked services at run time in Data Factory. This enables us to do things like connecting to different databases on the same...

AWS RDS SQL Server Announcements - 2019

AWS RDS SQL Server Announcements - 2019

1.    Amazon RDS SQL Server Supports differential and log and restores: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-differential-restores-and-log-restores/ 

2.    Amazon RDS SQL Server now supports logs to cloudwatch: https://aws.amazon.com/about-aws/whats-new/2019/11/now-publish-log-files-amazon-rds-sql-server-amazon-cloudwatch/ 

3.    Amazon RDS SQL...

AWS RDS SQL Server Announcements - 2019

1.    Amazon RDS SQL Server Supports differential and log and restores: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-differential-restores-and-log-restores/ 

2.    Amazon RDS SQL Server now supports logs to cloudwatch: https://aws.amazon.com/about-aws/whats-new/2019/11/now-publish-log-files-amazon-rds-sql-server-amazon-cloudwatch/ 

3.    Amazon RDS SQL Server now supports high availability in...

Chaos Engineering and SQL Server

Recently I’ve been delving into Chaos Engineering, reading books, watching videos, listening to podcasts etc. and I find it really intriguing….I mean, it just sounds exciting, right? CHAOS Engineering!...