Author: SQL by the book
Learning Corner #4 – SQL Server 2016 – Installation steps
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
Learning Corner #3 – SQL Server 2016 – Temporal tables
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
Learning Corner #2 – Metadata storage
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
Learning Corner #1 – SQL Server is actually Santa Claus
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