SQL Server provides several system meta data functions which allow users to obtain property values of different SQL Server objects and securables. Although you can also use the SQL Server catalog views or Dynamic Management Views to obtain much of this information, in some circumstances the system meta data functions simplify the process. In this tip I am going to demonstrate some of the available system meta data functions and their usage in different scenarios.

Calling exceptional DBAs: step up and be recognized

by Bob-Cramblitt

SQLServerCentral.com

Exceptional DBA

Nominations for The Exceptional DBA of 2010 open today, giving database administrators around the world the chance to be recognized for service to their employers, the SQL Server community, and the IT industry at large.

Improving Performance of Cross-Partition Queries

by Solomon Rutzky

SQLServerCentral.com

Partitioning

Table partitioning was added in SQL Server 2005 and increases performance in most cases but decreases it in others.

This Can't Happen

by Steve Jones

SQLServerCentral.com

Editorial

A bug reported on Connect has Steve Jones worried. This one could be a big deal in some situations that are concerned about comprehensive auditing.

The Com.PASS Feeds

by Press Release

SQLServerCentral.com

pass

A new set of RSS feeds, hosted by PASS, bring you a large quantity of SQL Server content from various sites, including SQLServerCentral.

How to create Policies using PowerShell scripts

by Jayakumar Krishnan

SQLServerCentral.com

MS SQL 2008 Policy-Based Management &

This article explains how to create policies with user defined conditions in MS SQL 2008 using PowerShell scripts

Leadership

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones talks about the need for leadership and what managers should be looking to achieve in their efforts.

The Cost of Data Loss

by Steve Jones

SQLServerCentral.com

Editorial

The cost of data loss is higher in the US than other countries. That's good and bad for DBAs.

TSQL Challenge 29 - Reorganize sales data by sales amount

by Press Release

SQLServerCentral

T-SQL Challenges

Your job is to reorganize the items in the table by sales amount (quantity * price). Reorganize the items from left to right, bottom to top. The item with the highest sales amount should come on top left of each invoice.

Using REPLACE in an UPDATE statement

by Additional Articles

SQLServerCentral

T-SQL

This article covers using the REPLACE function to selectively replace text inside a string in SQL Server. The REPLACE function is easy to use and very handy with an UPDATE statment.

SQL Server 2008 System Functions to Monitor the Instance, Database, Files, etc.

Calling exceptional DBAs: step up and be recognized

Improving Performance of Cross-Partition Queries

This Can't Happen

The Com.PASS Feeds

How to create Policies using PowerShell scripts

Leadership

The Cost of Data Loss

TSQL Challenge 29 - Reorganize sales data by sales amount

Using REPLACE in an UPDATE statement

Blogs

Measuring RAG Solutions: Are We Retrieving the Right Information?

Advice I Like: Lots of Ideas

Building a DBA Agent for Your SQL Server Estate with MCP

Forums

BCA KCU Menara Bidakara Telp:0821-8200-233

Server-Level Row Counts for Tables and Views

Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't

Question of the Day

Hyperscale Replicas I