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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
SQL Server tool improvements
While there’s plenty of new and exciting features coming with SQL Server 2016, Microsoft has also worked hard on improving the delivery of their SQL Server tools. Previously figuring out the correct tools or what version to install could be more than little confusing, but no more!
-
Few thoughts from the Data Driven SQL event
Just finished watching the Data Driven event that was broadcasted live from New York earlier today. As expected there was a lot of information about SQL Server 2016 and quite a few visitors telling how their companies used Microsoft SQL Server in their daily business. And these were some big…
-
PASS Summit 2015: Conference Day 3
This post comes a bit late as our last day in Seattle went on bit longer than expected, but for very positive reasons. We had an ad hoc gathering of Finnish PASS Summit attendees and despite the fact that it was very last minute setup, we got pretty much everyone…