The hurdles and pitfalls of moving or migrating a System-versioned temporal table cross database
Maybe you already have your own way of doing this and are wondering about alternative methods, or maybe you are planning to implement them and are asking yourself this question. Or maybe your colleague introduced this to the developers team and suddenly they are popping up all around your databases like mushrooms and you need a quick guide about how to move or migrate system versioned tables from one to another database. This was a rather specific use case for me, and I thought it would be a nice idea to share.
Database specific security in SQL Server
There are many different ways to secure your database. In this blog post we will give most of them a quick description.
SQL Server security made easy on the server level
In this blog, we’re going to look at the options we have for server level security. In SQL Server we can add security on many different levels.
Microsoft SQL Server history
Since its inception in 1989, Microsoft SQL Server is a critical component of many organizations’ data infrastructure. As data has become increasingly valuable, the security of this infrastructure is more important than ever.
DBA is not that scary
Often when talking to people who are looking for a career path in the data world I feel like there are a lot of misconceptions about being a DBA and they don’t know what we do.
Your Modernization Journey starts now
Recently Microsoft introduced SQL server 2022. We wrote this post to make sure you won’t be missing out on all the fun and exciting new changes. Are you as thrilled as we are? Start your modernization journey now!
Parameter sniffing solved with new Parameter Sensitive Plan Optimization feature
If you’re someone that works a lot with Microsoft SQL Server, there’s no doubt that you’ve had issues with an issue called “Parameter sniffing” before. Up until now, you had to figure out a way around it. SQL Server 2022 solves this issue – almost completely – through a new feature called Parameter Sensitive Plan Optimization. Let’s have a look at it.
SQL Server Reporting Services 2019: what has changed compared to earlier versions?
When trying to do a standard install of SQL Server, you may have noticed that the 2017 or newer versions of SQL Server Reporting Services (SSRS) aren’t installed as well. That’s because SSRS now has its own separate installer. In this blog, we’ll show some of the changes compared to older versions of the software and detail how to install and update the 2019 version.
The magic of Scalar-valued function inlining in SQL 2019
When one of my clients asked me for a reason to upgrade to SQL 2019, the first thing that came to mind is Scalar-valued function inlining. Reason? Well, for some reason developers like stuffing their SQL with SVFs, and that… makes… it… so… slow. Are SVFs really that bad? And is scalar-valued function inlining useful at all? Let’s walk through it together and find out!
XML fun on Azure SQL
For a client project I was recently asked how to efficiently handle translations in SQL Server. As, in this particular case, the client application was very proficient in processing XML data I chose in cooperation with the development team to use XML as the datatype to handle this specific case.