Azure SQL Server Database

SQL Server in Azure You can create and leverage cloud based SQL Server instances using Microsoft Azure.  However, if you have never used the Azure portal it can be a bit challenging to get started.  This post will show you how the steps required to create an Azure SQL Server database. If you have an … [Read more…]

SQL Server Table Partition Example

Why Use a SQL Server Table Partition Data warehouses and data repositories often have tables that store millions of records and each day adding thousands more.  As the data ages, the older records generally require fewer updates.  If all of these records are kept in a single physical table.  Queries and maintenance on the table … [Read more…]

SQL Pass Summit 2014

Next week I will be in Seattle for the 2014 SQL Pass Summit event.  If you are involved in projects that leverage the Microsoft SQL Server stack this is a great conference to attend. If this is your first time going and would like some tips on making the most of the conference, send me … [Read more…]

SQL Server TABLESAMPLE

Using TABLESAMPLE in SQL Server SQL Server has several ways for you to limit the number of records returned from a query.  For example, the AdventureWorks [sales].[salesorderdetail] table has 121,317 rows loaded in sequential order starting with SalesOrderDetailID 1.  By Using a top 1000 clause I can limit the results to the first 1000 rows … [Read more…]

SQL Server 2014 Cardinality Estimator

SQL Server 2014 Cardinality Estimator The SQL Server 2014 cardinality estimator has been improved to increase the quality of SQL Server query plans in both OLTP and data warehousing solutions.  The cardinality of a field refers to the number of unique values that are populated in the table.  Gender would be a low cardinality field.  Storing … [Read more…]

Schema on Read vs Schema on Write

Schema on Read vs Schema on Write in Business Intelligence When starting build out a new BI strategy.  There are more options now than ever before.  Gone are the days of just creating a massive star or snowflake schema to store THE data warehouse.  In today’s business, you need to store data in structured and … [Read more…]

Business Intelligence Strategy – Beginning Steps

Business Intelligence Strategy A business intelligence strategy is used to determine where an organization is and where they are going with their BI implementation.  To start building an effective business intelligence strategy requires taking an objective look at your organizations BI capabilities including data, technology and people. DATA When you begin your discovery into the … [Read more…]