Practical guides and insights for modern data practitioners
For this months T-SQL Tuesday contribution I want to share some of my thoughts about SQL Server upgrades. Including ones for SQL Server 2019 and SQL Server 2022 (which is due to be released in near future). This months T-SQL Tuesday is hosted by Steve Jones. Steve has invited us to discuss our thoughts about … Read more
In this post I want to do a crash course on how to connect a local SQL Server database to Azure Synapse Analytics. So that Azure Synapse Analytics can get data from it. I thought I would do this post since I got asked last week in a meeting if this was possible. In reality, … 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
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 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
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