The SQL Connections conference will be held this November in Las Vegas and Steve Jones is attending. See what he's interested in viewing at the event.

What's Your Education Worth?

by Steve Jones

SQLServerCentral.com

Editorial

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?

Introduction to Dimension Security in SQL Server Analysis Services SSAS 2005

by Additional Articles

MSSQLTips.com

Analysis Services (SSAS)

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

SQLServerCentral

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.