A series from MVP Jessica Moss designed to help you understand Reporting Services and begin building reports.

You Should Know

by Steve Jones

SQLServerCentral.com

Editorial

Are there things you should know? It seems that we quite often find that others in our profession don't understand the simple things we assume they do. Steve Jones talks about one item in particular: staging servers.

Five DMV Queries That Will Make You a Superhero in 2011!

by GlennBerry

SQLServerCentral.com

Blogs

Way back in January, 2008, I wrote a blog post called “Five DMV Queries That Will Make You A Superhero!”...

SEQUENCE in SQL Server 2011

by Additional Articles

SQL Server Performance

SQL Server 2011

SEQUENCE is a core new feature of SQL Server 2011 (Denali). It is a more performant, flexible alternative to the INDENTITY attribute. This article introduces sequence and demonstrates how to use it and its performance advantage.

Life Without Keyboards

by Steve Jones

SQLServerCentral.com

Editorial

The way we input data is changing with the advent of the iPad and tablets. Is that good or bad for the acquisition of data? Steve Jones has a few thoughts today.

SQL DISTINCT on Multiple Columns

by Sarvesh Singh

SQLServerCentral.com

DISTINCT

Learn the basic usage of DISTINCT in this article.

PASS Summit Location

by Grant Fritchey

SQLServerCentral.com

Blogs

Andy Warren has posted another one of his excellent summaries of what’s going on at the PASS Board. Andy, thanks...

Re-generating SQL Server Logins

by Additional Articles

Database Journal

Security

SQL Server stores all login information on security catalog system tables. By querying the system tables, SQL statements can be re-generated to recover logins, including password, default schema/database, server/database role assignments, and object level permissions. A comprehensive permission report can also be produced by combining information from the system metadata.