SQL Server | Information Technology News

SQL Server

Permission Changes in Master Data Services 2016

Problem With the release of SQL Server 2016, there have been some changes in the security model for groups and/or users for Master Data Services (MDS). New roles have been added and the granularity of permissions has been modified. This tip will explain those changes. Solution Master Data Services has received quite an upgrade in SQL Server 2016. Lots of ...

Read More »

Managing SQL Server Backup and Restore History Information

Every time you backup or restore a database SQL Server keeps history information about the backup or restore operation.  The backup and restore information is captured and stored in the msdb database.  This backup and restore information if left unchecked can take up more and more space over time.  To minimize msdb storage space you need to consider removing the ...

Read More »