Communication is important, and it's a real problem when people can't reach you. Read about an interesting phone accident the some hints for better communication.

TSQL Lab I - Playing around with ROW_NUMBER

by Jacob Sebastian

SQLServerCentral.com

T-SQL

Real world solutions are key and having different techniques can sometimes help you code quicker. Longtime author Jacob Sebastian shows us how to solve a few problems with different techniques.

Populating Dimension Tables with the SCD Task

by Additional Articles

SQL Server Universe

Integration Services (SSIS)

ETLing dimensions through SQL Server 2000 DTS, has more or less been quite a hassle, what with the lengthy ActiveX scripts and lookups that have to be performed. Enter SQL Server 2005 Integration Services: The Slowly Changing Dimension task has made it much simpler.

Snapshot Reports I: Report Manager Perspective

by Additional Articles

Database Journal

Reporting Services (SSRS)

BI Architect Bill Pearson continues his subseries surrounding Caching Options, examining the use of Report Manager to configure Snapshot Caching.

Data Breaches

by Steve Jones

SQLServerCentral.com

Editorial

Security is hard, but are we doing a good job? Steve Jones shares a few thoughts on our security development practices

Trigger Trivia

by Andy Warren

SQLServerCentral.com

T-SQL

From SQL Server trainer and guru Andy Warren, he are a few short nuggets that you might not realize about triggers.

SQL Server Management Objects: Lessons from the Wild

by Additional Articles

DevX

Harness the power of SQL Server Management Objects to create, document, and manage your SQL Server databases.

SqlCredit – Part 10: MAC Performance and Updating SqlCredit

by Additional Articles

Database Journal

Case Studies

This month's installment of "Developing a Complete SQL Server OLTP Database Project" covers MAC performance results, a summary of encryption findings, and comments on updating the SqlCredit code based on those findings.