I have seen the tip Dynamically Control Data Filtering in SQL Server Reporting Services Reports which showed how to leverage a SQL Server database table to filter sales data based on the user running the report. I have a similar requirement to implement dynamic filtering except my data is in a SQL Server Analysis Services (SSAS) cube and the users query the data with a variety of different tools. How can I implement dynamic security in my case?

Issue with SQL Server 2K5 SP3 CU5

by Jeffrey Yao

SQLServerCentral.com

Blogs

In case you are considering to apply SQL Server SP3 CU5 (http://support.microsoft.com/kb/972511) to your system, I'd like to point out one issue / bug we found with CU5.

PowerShell 101 for the DBA – Installing PowerShell

by Joshua-Jones

SQLServerCentral.com

Blogs

Many DBAs have heard about the new scripting technology from Microsoft, but have yet to really dive right in. You...

T-SQL Challenge #13

by Press Release

Other

T-SQL Challenges

Take T-SQL Challenge #13, Break a batch of invoices into multiple parts based on rules.

Tuning the Performance of Change Data Capture in SQL Server 2008

by Additional Articles

Microsoft MSDN

Change Data Capture (CDC)

Change data capture is a new feature in SQL Server 2008 that provides an easy way to capture changes to data in a set of database tables so these changes can be transferred to a second system like a data warehouse. This document provides guidance on how to configure change data capture parameters to maximize data capture performance while minimizing the performance impact on the production workload. The scope of this document is limited to the capture of change data and the cleanup process. Querying the changed data is out of scope for this white paper.

What's Your Education Worth?

by Steve Jones

SQLServerCentral.com

Editorial - iPod

Most of us learn on the job, but is that the best way? If you could learn faster at a cost, would you pay it? Steve Jones talks a little bit about what he has done and what he would do today in today's editorial. What is a SQL Server education worth to you?

What's Your Education Worth?

by Steve Jones

SQLServerCentral.com

Editorial - MP3

What's Your Education Worth?

by Steve Jones

SQLServerCentral.com

Editorial - WMV

35K

by Steve Jones

SQLServerCentral.com

Editorial

Microsoft's new server lab building will house 35,000 servers. That's a lot of computing power, and it's being done in a greener fashion.

Changing Usernames

by Steve Jones

SQLServerCentral.com

SQLServerCentral is changing usernames for some of our members in an effort to clean things up. Read more about what will be happening on Tuesday, Sept. 15, 2009.

Introduction to Dimension Security in SQL Server Analysis Services SSAS 2005

Issue with SQL Server 2K5 SP3 CU5

PowerShell 101 for the DBA – Installing PowerShell

T-SQL Challenge #13

Tuning the Performance of Change Data Capture in SQL Server 2008

What's Your Education Worth?

What's Your Education Worth?

What's Your Education Worth?

35K

Changing Usernames

Blogs

Monitoring Fabric Mirroring for SQL 2025

Monday Monitor Tips: Intelligent Alert Thresholds

A New Word: los vidados

Forums

Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform

Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform

Doing the Little Things

Question of the Day

Historical Data Tracking