Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Business Intelligence and Enterprise Architecture

Derek Wilson delivers tactical and strategic Business Intelligence and Enterprise Architecture solutions. His primary focus in on Microsoft SQL Server technologies and aligning business problems to technology solutions. He architects BI solutions leveraging SQL Server, SharePoint and any other technologies that help his clients achieve better data driven decisions. By leveraging the information learned while collecting requirements for BI projects, he helps align business processes to technology helping further organizations Enterprise Architecture. He is an author, trainer, blogger and has been using SQL Server since version 6.5.

Practical Data Migration Strategies

Practical Data Migration Strategies

As organizations mature their IT infrastructure must change to keep up with new applications and technologies. Many times this includes moving data housed in one technology (legacy) to the upgraded or new platform that is being implemented. Depending upon what you are trying to accomplish there… Read more

0 comments, 37 reads

Posted in Business Intelligence and Enterprise Architecture on 23 April 2014

Hortonworks Data Platform 2.1 New Features

What is Hortonworks Data Platform

Hortonworks recently announced their release of the HDP 2.1 their Hadoop Big Data platform.  If you have not tried it yet and are interested in how to get started with Big Data.  Now is the time learn Hadoop.

In this release there are 5 new… Read more

1 comments, 110 reads

Posted in Business Intelligence and Enterprise Architecture on 13 April 2014

SQL Server Filtered Index

What is a SQL Server Filtered Index

A SQL Server Filtered index is a nonclustered indexes that can be used to increase query performance when selecting records from a table.  This type of index can be especially useful when there are a small count of  distinct values in a column… Read more

0 comments, 137 reads

Posted in Business Intelligence and Enterprise Architecture on 5 April 2014

Houston SQL Saturday #308 – Presenting

Saturday May 10th – Houston SQL Saturday #308

I will be presenting at the upcoming SQL Saturday in Houston on May10th.  For those of you not familiar with SQL Saturdays.  It is an all day training event hosted by the local SQL Server User Groups.  If you are interested in… Read more

0 comments, 118 reads

Posted in Business Intelligence and Enterprise Architecture on 29 March 2014

CISSP and Enterprise Architecture

CISSP and Enterprise Architecture

One topic that professionals pursing Enterprise Architecture roles should focus on is security.  Enterprise Architects are responsible for designing the structure and interaction of IT systems around fulfilling business needs for an organization.  However, not everyone moving to an EA role has had a broad exposure,… Read more

0 comments, 147 reads

Posted in Business Intelligence and Enterprise Architecture on 22 March 2014

When Good BI Goes Bad – Data Quality

Regardless of the Technology BI is about Data

Many BI projects are sold as a technology solution.  Vendors come in a wow executives with new features, visualizations, and dashboards.  Along with the software they offer simple and fast implementation that can “connect to all of your data and produce fantastic… Read more

1 comments, 278 reads

Posted in Business Intelligence and Enterprise Architecture on 15 March 2014

SQL Server Data Encryption Options

SQL Server Data Encryption Types

Businesses today have a greater need than ever to protect their data from security breaches.  Data stored in databases are a prime target for hackers since it contains data that is normalized and contained in a central location.  Once a hacker accesses a database all… Read more

0 comments, 304 reads

Posted in Business Intelligence and Enterprise Architecture on 5 March 2014

(SSAS) SQL Server Analysis Services Tabular Basics

What is (SSAS) SQL Server Analysis Services Tabular Mode?

SQL Server 2012 ships Analysis Services that can be installed in the traditional OLAP engine or in the Tabular engine mode.  Tabular mode is an in-memory database that compresses and queries the data with great performance.  In most cases, you may… Read more

0 comments, 248 reads

Posted in Business Intelligence and Enterprise Architecture on 22 February 2014

SQL Server PDW the Microwave of BI

The Path to the PDW

For decades we had the traditional electric oven to cook with and people thought it was great.  This technology allowed for consistent and dependable cooking for its users.  Then something magical happened, the microwave was invented and used for food preparation.  By leveraging the a… Read more

0 comments, 435 reads

Posted in Business Intelligence and Enterprise Architecture on 8 February 2014

SQL Server Analysis Services – SSAS Fundamentals

SQL Server Analysis Services (SSAS) Fundamentals

SSAS comes with your purchase of Microsoft’s SQL Server.  It is a separate component and can be installed in two different modes, Multidimensional or Tabular.  Multidimensional is the traditional method of building and OLAP cube.  Tabular mode using in memory techniques to aggregate relational… Read more

0 comments, 94 reads

Posted in Business Intelligence and Enterprise Architecture on 2 February 2014

SQL Server Data Compression

SQL Server Data Compression Overview

I have been reviewing the options for data compression in SQL Server and believe it can be a great value to Reporting and Business Intelligence databases.  By their nature BI databases typically store more data than any other database in your environment.  Even with the… Read more

0 comments, 95 reads

Posted in Business Intelligence and Enterprise Architecture on 29 January 2014

Technology Alignment

Technology Alignment with Enterprise Architecture

A critical component in your Enterprise Architecture program is assuring your organization is leveraging the best technology to achieve alignment of business objectives.  This includes reviewing the current technologies in place as well as understanding how new technology, if used would impact the organization. The… Read more

0 comments, 50 reads

Posted in Business Intelligence and Enterprise Architecture on 24 January 2014

Gathering Business Intelligence Requirements

Questions to Ask when Gathering Business Intelligence Requirements

When starting any project requirements are the key to being successful.  Business intelligence projects are no different and even harder to document.  It is critical to gather the appropriate requirements to deliver the project being requested to provide the business value being… Read more

0 comments, 80 reads

Posted in Business Intelligence and Enterprise Architecture on 18 January 2014

SQL Server Filtered Index Performance

Filtered Index – Database Performance

SQL Server 2012 includes filtered indexes and is a great feature for Business Intelligence and Reporting databases.  Filtered indexes allow you to reduce the overhead of having a index on a tables and increase the performance of the query optimizer by already reducing the number… Read more

0 comments, 54 reads

Posted in Business Intelligence and Enterprise Architecture on 15 January 2014