Comparing Data Warehouse Design Methodologies for Microsoft SQL Server

In this article, Arshad Ali goes intp detail about how a data warehouse is different from operational data store and the different design methodologies for a data warehouse.

A New Look

We've changed the newsletter and would love to know what you think.

Change the Maintenance Plan Owner

This article shows how you can change the maintenance plan owner in SQL SERVER

The Intrusion of Life

Life intrudes on work at times, and we must learn to balance the limited time we have. However we also need to remember that we work to live, not live to work.

Performance Tuning in the Age of Big Data

Database Administrators must now deal with large volumes of data and new forms of high-speed data analysis. If your responsibility includes performance tuning, here are the areas to focus on that will become more and more important in the age of Big Data.

SQL Saturday #214 Louisville KY

Join us for a free day of SQL Server training and networking in Louisville Kentucky on July 13.

This SQL Saturday event also has 2 paid pre-con all day sessions on July 12 presented by Dave Fackler and Bill Pearson.

Achieve Better Performance

This week Steve Jones talks performance and a few things you might want to do that can help your career and employer.

Give

The world is bigger than you, and when you help others, you realize that. Making that change might also make you happier, and more successful, in your career.

Log Shipping Lite with PowerShell

A PowerShell driver that performs incremental restores on a standby server, a lite weight log shipping solution.

SQL Server CREATE TABLE syntax diagrams

Many of us have seen, on MSDN, the heading 'Syntax', followed by a rash of nested brackets and keywords, enough to put off the most resolute of code-cutters. However, there is a goldmine of information there, and Phil had an ambition to get at it, and share the gold. The result is this article, full of railroad diagrams.