Creating and Managing User-Defined Roles in SQL Server 2012 Introduction SQL Server 2012 introduces user-defined server roles. These user-defined server roles are similar to fixed server roles with only difference is that they are created by SQL Server Administrator. SQL Administrators can create, delete or manage these user-defined server roles using T-SQL or SQL Server Management Studio. User-defined roles can...
Author: Basit Aalishan Masood-Al-Farooq
Retrieving Deadlock Graphs with Event Notification
Retrieving Deadlock Graphs with Event Notification Basit A Farooq Introduction Recently, one of our clients requested us that they wanted instant deadlock notification every time a deadlock occurs on their SQL Server. This notification should be in the form of email alert containing a deadlock graph as an attachment. As we know, SQL Server provides variety of different ways to...
Partitioning relational and multidimensional data for OLAP solution – (Part-2)
Partitioning relational and multidimensional data for OLAP solution – (Part-2) Multidimensional solutions usually hold extremely large amounts of data. Partitioning this data can improve manageability because aged data can be removed more easily. When aged data is removed from the relational data source, the matching partition can be removed, so it is not necessary to reprocess the entire cube. Well-designed […]