Reading Time: 3 minutes Recently I’ve seen recommendations about putting PowerShell modules on every SQL Server. I must admit it has got me thinking if this is indeed worthwhile.…
A blog about SQL Server and related Data Platform offerings
Reading Time: 3 minutes Recently I’ve seen recommendations about putting PowerShell modules on every SQL Server. I must admit it has got me thinking if this is indeed worthwhile.…
Reading Time: 2 minutes On Tuesday, July 9, 2019, extended support for SQL Server 2008 and SQL Server 2008 R2 ended. In this post I am looking back at…
Reading Time: 3 minutes My T-SQL contribution for this month discusses what you should consider when adopting SQL Server on Linux. This month’s T-SQL Tuesday is hosted by Tracy…
Reading Time: 2 minutes Well last month was one very busy June for yours truly. Because I had somehow managed to squeeze gaining a new Azure certification, going on…
Reading Time: 3 minutes This months T-SQL Tuesday is hosted by Mohammad Darab. He invites us all to write our 20 year old selves a letter and wants us…
Reading Time: 5 minutes As you are probably aware SQL Server 2019 is due for release later this year. Because of this I’ve already started discussing upgrades and business…
Reading Time: 3 minutes In a previous post I mentioned I could create lustered columnstore indexes in SQL Server 2019 regardless of the database compatibility level. So, in this…
Reading Time: 2 minutes In a previous post I discussed some interesting findings whilst testing the updates for sp_estimate_data_compression_savings in SQL Server 2019. Which you can read about in…
Reading Time: 3 minutes Recently I’ve been going through different options to create Azure DevOps test environments. In order for people to perform changes without interfering with the existing…
Reading Time: 2 minutes In case you did not know in SQL Server 2019 the stored procedure sp_estimate_data_compression_savings has been updated. In fact, you can now use it to…