Category: Microsoft
-
Well-Architected Framework (for Databases)
If you work mainly with on-premises and focus on databases, there’s a good chance that you are not familiar with the concept of a Well-Architected Framework (WAF). However, while you might not be familiar with the term, you probably are already doing things related to it. How do I know that, you ask? Because, ultimately,…
-
Azure SQL Database SLA is awesome
Microsoft recently released their new SLA, RPO and RTO guarantees for Azure SQL Database and oh boy, those are really something else. In fact, they are so much something else, that at the moment of me writing this, no other cloud provider has managed to promise the same level of business continuity for their Platform-as-a-Service…
-
Treating database as a code
Over the last two years I have been working lot on improving the tooling and processes related to database development at where I work. One concept born out of this work is what we have started calling a “Database-as-a-Code” model. Originally the idea was to introduce some of the good practices, such as version control,…
-
Reflections on PASS Summit 2017
PASS Summit 2017 is now well behind us and there has been good time to reflect on this years conference. First of all, I have to say that Seattle as a venue is a good choice, even though for some of us that is a long way to travel. To me, it is about 20…
-
Undeprecated SQL Server features
As we all know there are many features in SQL Server that have been deprecated over the time by Microsoft for one reason or another. In fact, there is a long list of features that are deprecated in the latest SQL Server 2017 release. It is far less often that any of these features make…
-
Summing up the PASS Summit 2016
This year I didn’t write my usual daily blog posts during the PASS Summit 2016 as I felt it to be bit too much work with the long days and bit of a jet lag with the 10 hour time difference. Instead I decided to write a post summarizing my experience of the event. Every…
-
Time travelling with SQL Server
One of the new interesting features in SQL Server 2016 is the system-versioning with a catchy name, Temporal Tables. The name of the feature offers a hint to its purpose, to collect and to keep historical information about the data changes inside the database over a period of time. Instead of having just the latest…