SQL Server 2005 implemented the concept of a database object schema. A schema is a distinct namespace to facilitate the separation, management, and ownership of database objects. It removed the tight coupling of database objects and owners to improve the security administration of database objects. Database object schemas offer functionality to control and help secure application objects within a database environment not available in previous versions of SQL Server.

VDBA RAW

by Steve Jones

SQLServerCentral.com

Blogs

I've had a few requests in the past, so I decided to just give it a go. Here's the raw footage from the episode of the Voice of the DBA podcast that I shot this week. It's uncut, the raw footage of what I took off the camcorder,

Advice for the Unemployed

by Phil Factor

SQLServerCentral.com

Editorial

Everyone has an opinion on the best advice to give an IT person who is unemployed and wants to get back into paid work. Phil Factor outlines what he would advise.

Auditing with SQL Profiler

by Thom Bolin

SQLServerCentral.com

Auditing

Complete package to allow tracking of any data that Profiler can capture and storage for auditing purposes, use to satisfy SOX compliance.

Setting Single User Mode - SQL School Video

by Andy Warren

SQLServerCentral.com

Video

This edition of SQL School brings us a look at how to set single user mode for your SQL Server instance.

Being The Best vs. Being Affordable

by Tim Mitchell

SQLServerCentral.com

Blogs

I read a post on Brent Ozar’s blog last week that discussed employers’ expectations when hiring new team members. Though the story was specific to database professionals, the same principles apply to almost any hiring situation. The moral of Brent’s story...

Building Your Brand at Work?

by Steve Jones

SQLServerCentral.com

Editorial - MP3

This Friday's poll asks how much you can help yourself while working at your job? Can you build your own brand at work?

Building Your Brand at Work?

by Steve Jones

SQLServerCentral.com

Editorial - WMV

This Friday's poll asks how much you can help yourself while working at your job? Can you build your own brand at work?

Creating a Member Selection Dashboard Filter in Performance Point Server 2007 (PPS)

by Additional Articles

MSSQLTips.com

PerformancePoint

We have heard that you can create filters in a Performance Point dashboard then apply them to one or more reports and scorecards. Can you provide some step-by-step instruction on how to do this?