Azure SQL Server Database

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

SQL Server in Azure
You can create and leverage cloud based SQL Server instances using Microsoft Azure.  However, if you have...

2014-12-04 (first published: 2014-12-01)

6,758 reads

SQL Server Management Studio Reports

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

SQL Server Management Studio Reports
Whether you are an Application, SQL, BI Developer or a DBA.  Knowing what is occurring within...

2014-11-21 (first published: 2014-11-17)

7,565 reads

SQL Server Table Partition Example

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

Why Use a SQL Server Table Partition
Data warehouses and data repositories often have tables that store millions of records and...

2014-11-03

2,074 reads

SQL Pass Summit 2014

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

Next week I will be in Seattle for the 2014 SQL Pass Summit event.  If you are involved in projects...

2014-10-30

1,149 reads

SQL Server TABLESAMPLE

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

Using TABLESAMPLE in SQL Server
SQL Server has several ways for you to limit the number of records returned from a...

2014-10-28 (first published: 2014-10-20)

7,114 reads

SQL Server Checksum

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

Use SQL Server Checksum in Data Warehousing
When building data warehouses you often need a fast way to know if the...

2014-10-14

1,808 reads

Common Table Expressions (CTE)

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

Common Table Expresseion (CTE)
A common table expression (CTE) is a derived table that is defined and only stored for the...

2014-10-08 (first published: 2014-10-03)

9,001 reads

SQL Server 2014 Cardinality Estimator

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

SQL Server 2014 Cardinality Estimator
The SQL Server 2014 cardinality estimator has been improved to increase the quality of SQL Server query...

2014-09-25

977 reads

Schema on Read vs Schema on Write

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

Schema on Read vs Schema on Write in Business Intelligence
When starting build out a new BI strategy.  There are more...

2014-09-12

997 reads

Basics of Dimensional Modeling

• by Derek Wilson

• SQLServerCentral.com

• star schema

Introduction of how to design a star schema dimensional model for new BI developers

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.19 (36)

Log in or register to rate

2014-09-09

7,453 reads

• Discuss