In this article, we look at stretch enabled tables that one should be aware of including key constraints Stretch Database is a SQL Server feature which allows users to migrate cold data securely and transparently to Azure cloud. Users can even...
Read more »This article addresses the installation error ‘A Constraint Violation Occurred’ and how users can solve it. This is among the most common problems witnessed by most people while installing SQL Server in Windows. Usually, this error occurs...
Read more »In this article, we look at roles being used to grant permissions on the report server. We also look at who sets these permissions how these permissions are stored. Reporting Services in SQL Server use a role-based authorization and...
Read more »