Author: Basit Aalishan Masood-Al-Farooq

Pro Members SQL Server Standard Members

Creating and Managing User-Defined Roles in SQL Server 2012

by

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Retrieving Deadlock Graphs with Event Notification

by

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
SQL Server

Partitioning relational and multidimensional data for OLAP solution – (Part-2)

by

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 […]

Continue Reading →
1 … 13 14 15