I have a requirement to implement a custom security scheme where roles and the user's place in the organization hierarchy are used to determine which customers a user can access. In particular the requirements are that a sales person can only access their customers and any other role can access any customer in their level of the organization hierarchy and below. We have a simple hierarchy that is made up of regions and offices. Can you provide us with an example of how to do this?

Timing is Everything

by Steve Jones

SQLServerCentral.com

Editorial

For this Friday poll, Steve Jones asks about storing time values. Should they always be in UTC? Does that solve more problems than it creates?

Exceptional PowerShell DBA Pt 3 - Collation and Fragmentation

by Additional Articles

SimpleTalk

PowerShell

In this final look into his everyday essentials, Laerte Junior provides some useful scripts for the DBA that use an alternative way of error-logging. He shows how to use a PowerShell script to check and, if necessary, to defragment your indexes, write data to a SQL Server table, and change the collation for a table. Being an exceptional DBA just got a little easier.

Experiments with Data Compression in SQL Server 2008

by GlennBerry

SQLServerCentral.com

Blogs

Data compression is an Enterprise Edition only feature that was added in SQL Server 2008. It allows you to use...

SQLSaturday Acquired by PASS – Reactions

by Jack Corbett

SQLServerCentral.com

Blogs

The Announcement
On February 2nd, PASS (@sqlpass), here, and Andy Warren (@sqlandy), here, announced ownership of the SQLSaturday franchise brand was transferred...

Upgrading Replication from SQL Server 2000 32-Bit to SQL Server 2008 64-Bit without re-initialization

by Additional Articles

SQLCAT

Replication

In this article we summarized the experiences we gathered during the planning and upgrade of a customer's project. The customer is one of the largest retail shops in its area. Their architecture is made up of a main server, which is located at headquarters and hosts several hundred publications containing over a thousand articles. Regional stores are located all over the country acting as subscribers for the publications hosted on the main server. Based on the business needs and infrastructure limitations the customer set the following goals for the project:

Dude, Your Fly is Open

by Tim Mitchell

SQLServerCentral.com

Editorial

A guest editorial from Tim Mitchell today talks about the way you handle problems. Other people's problems. A professional way of pointing out mistakes is the best policy.

Managing Analysis Services Deployment - Part 4

by Shahfaisal Muhammed

SQLServerCentral.com

Analysis Services (SSAS)

Part 4 of this series, Shahfaisal Muhammed brings another method of deploying your SSAS projects to a new server: the synchronize database method. The rest of the series covers other methods.

Data Type Precedence and Implicit Conversions

by Seth Phelabaum

SQLServerCentral.com

Blogs

In my last post, I noted that one of the biggest differences between ISNULL and COALESCE was the fact that...

SQL Server Impersonation

by Additional Articles

Database Journal

Security

SQL Server impersonation, or context switching, is a means to allow the executing user to assume the permissions of a given user or login until the context is set back, set to yet another user, or the session is ended. Deanna Dicken shows you two mechanisms for accomplishing this task and walks through some examples.

Using a Parent Child Hierarchy in SQL Server to Implement a Custom Security Scheme

Timing is Everything

Exceptional PowerShell DBA Pt 3 - Collation and Fragmentation

Experiments with Data Compression in SQL Server 2008

SQLSaturday Acquired by PASS – Reactions

Upgrading Replication from SQL Server 2000 32-Bit to SQL Server 2008 64-Bit without re-initialization

Dude, Your Fly is Open

Managing Analysis Services Deployment - Part 4

Data Type Precedence and Implicit Conversions

SQL Server Impersonation

Blogs

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them

A Cloud Dependency Failure from Amazon

Deploying AI in logistics (the unfiltered version)

Forums

BCA KCP Andalas TLP: WA 08218573837

BCA KCU SURYOPRANOTO Telpon/wa:0813.7887.595

BCA KCP Sungguminasa TLP/WA 0821°857°3837

Question of the Day

Creating a JSON Document III