SQL Server 2016 CTP2.4 – Installation steps In order to start investigating the new features of SQL Server 2016 CTP2.4, I first needed to install it. The official link for download is this one: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 While doing the installation, I noticed a few new things in the setup. While the first screens of the setup Read More
SQL Server 2016 introduces support for an interesting new feature, called Temporal Tables. As you may see on other sites as well, this comes with the following warning: Don’t confuse them with Temporary Tables! I will try to explain in this post (and maybe in some others, following this one) the main functionality of the Read More
Hello, In this post, I want to mention a few things about the data storage metadata in SQL Server, or metadata storage, as the title mentiones. What’s that, you say? 🙂 Well, to be more exact, my goal is to cover the following DMVs, with some meaningful examples and explanations. And maybe at the end, Read More
This post (even though it doesn’t look like it) is about the SQL Server Architecture. When I first started to learn about SQL Server and got to the architecture of the product, I had a lot of gaps in my knowledge of this subject, which made me feel a little overwhelmed. But I took things slowly Read More