Practical guides and insights for modern data practitioners
Since I’ve officially stopped working for the year now I thought it would be a good time to do a personal 2019 review. Technology As far as technology is concerned it’s being an interesting year. As usual, there were a large number of announcements at this year’s Ignite. To save reinventing the wheel you can … Read more
At today’s Microsoft Ignite conference SQL Server 2019 was officially released. As some of you are aware SQL Server Release Candidate 1.1 has been around for some time now. In addition, last week I noticed that the SQL Server documentation site was changed. Now the ‘SQL Server 2019 Preview’ search option is just ‘SQL Server … Read more
In this post I cover finding SQL Server versions for Docker and Linux using a web browser. Mostly because the other day somebody asked where the latest version of the SQL Server 2019 release candidate was. Of course, they asked this because the links were not working yet. I’m sure this will be resolved shortly. … Read more
I have written this personal SQL Server 2019 Lab review. Because last week I saw the new lab based on CTP 3.1 and I decided to go through it. In addition, I thought I would give you some useful tips along the way. SQL Server 2019 Lab introduction Now this lab is a recent addition … Read more
In this post I discuss creating Clustered Columnstore Indexes everywhere. In other words, which clustered columnstore indexes you can create depending on your SQL Server version. Because in a previous post I mentioned I could create clustered columnstore indexes in SQL Server 2019 regardless of the database compatibility level. To clarify, it appears you can … Read more
In this post I want to cover some interesting SQL Server 2019 findings whilst testing sp_estimate_data_compression_savings. Because in SQL Server 2019 the stored procedure sp_estimate_data_compression_savings has been updated. In fact, you can now use it to estimate amount of savings used if you convert an index to be a columnstore or columnstore_archive index. You can … Read more
In this post I want to cover deploying SQL Server services in Azure with Visual Studio subscription. Because somebody made a comment on Twitter previously which got me thinking. It was about the fact that they could not afford to run one of the SQL Server related services in Azure. So, I thought it’d be … Read more
Recently I made an interesting discovery about SQL Server 2019 database scoped settings. Because I tested the one that sets index rebuilds to be online by default. Setting this at the database level allows index rebuilds to be online by default. Without having to specify it in the index rebuild command. When you select this … Read more
In this post I want to cover using local repositories with SQL Server on Linux. Because I discussed with my colleagues recently about offline installations of SQL Server on Linux. In reality, it is something that has been on my mind for a while now. To install SQL Server on Linux onto a server which … Read more
Introduction I’ve decided to post about building a test lab to use outside of work. Because it’s something most data platform professionals deal with at one stage or another. Some of you can also consider this a primer for future posts. Now if you’re lucky your workplace already has a test environment where you can … Read more