Articles

Technical Article

Data Warehousing 2.0 and SQL Server: Architecture and Vision

Architecture and data warehousing are not static. From the first notion of a data warehouse to a full-blown analytical processing architecture that includes data marts, ETL, near line storage, exploration warehouses, and other constructs, data warehousing and its associated architecture continue to evolve. In 2008, the book on the latest evolution of data warehousing appeared – DW 2.0: The Architecture for the Next Generation of Data Warehousing (Morgan Kaufman). In that book the general architecture for data warehousing in its highest evolved form appeared.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2010-01-12

4,485 reads

Technical Article

Top 10 steps to optimize data access in SQL Server. Part IV (Diagnose database performance problems)

It’s time for us to learn how to diagnose different performance and related problems in SQL Server database. Take a look at the following articles to learn the step by step process that we’ve already carried out so far.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2010-01-12

5,307 reads

Blogs

Experimenting with CHOOSE: #SQLNewBlogger

By

I was looking over the CHOOSE() function while editing an article at SQL Server...

Fighting Procrastination?

By

Here is another short video (~ 15 minutes). This is by the author of...

A Fun Prize at the PASS Data Community Summit

By

I had a briefing for the 2026 PASS Data Community Summit, which is just...

Read the latest Blogs

Forums

SQL Server 2025 Server-level Roles

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server 2025 Server-level Roles

Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions

By Bill Pearson

Comments posted to this topic are about the item Stairway to DAX and Power...

AI Is Improving Security

By Steve Jones - SSC Editor

Comments posted to this topic are about the item AI Is Improving Security

Visit the forum

Question of the Day

SQL Server 2025 Server-level Roles

In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?

See possible answers