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 […]
Migrating Databases using Backup and Restore
In this blog post we will describe how to migrate a SQLServer Database between different SQL Instances using the Backup and Restore procedure. The main advantage from migrating databases this way, is that it is less error prone than other procedures. I would recommend using this method on very static databases or databases where you […]
Creating and managing Audits in SQL Server
In this blog I will be talking about Creating and Managing Audits in SQL Server. We will first look at what SQL Server audit is and why you should use it. After this we will be looking at where to configure and how to activate SQL server audit, server audit specifications and database level specifications. […]