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.

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… Read more

0 comments, 109 reads

Posted in Business Intelligence and Enterprise Architecture on 1 September 2014

SQL Server Keyboard Shortcuts

SQL Server Keyboard Shortcuts for Management Studio

SQL Server Management Studio is filled with lots of optional settings that lets you maximize your development experience.  There are a few helpful settings and shortcut keys that will help you get the most out of the tool while working on database activities.… Read more

0 comments, 6,370 reads

Posted in Business Intelligence and Enterprise Architecture on 18 August 2014

Effective Business Intelligence

How Business Intelligence Can Help

Effective business intelligence starts with questions that will help your organization make better decisions.  For example, an Electrical Utility provider may be asking how to better understand its customer usage patterns for the next 1-6 months.  An insurance provider may be asking how to look… Read more

0 comments, 170 reads

Posted in Business Intelligence and Enterprise Architecture on 4 August 2014

5 Tips for Finding SQL Server System Data

Regardless of the type of development (application or reporting) that you are performing on SQL Server.  There are 5 items within SQL Server that I consistently use to help me design and troubleshoot solutions.

SP_Who

SP_Who is a system stored procedure that returns information on what is currently running on… Read more

0 comments, 8,745 reads

Posted in Business Intelligence and Enterprise Architecture on 17 July 2014

Azure HDInsight – Hadoop in the Cloud

Azure HDInsight Overview

HDInsight is a cloud based implementation hosted in the Microsoft Azure cloud. It enables you to quickly create, expand and delete a Hadoop cluster installation as your project dictates. For organizations just beginning to see how Big Data could be leveraged to solve business problems. A HDInsight… Read more

0 comments, 149 reads

Posted in Business Intelligence and Enterprise Architecture on 10 July 2014

SQL Server 2014 New Features

SQL Server 2014

Below is a listing of the SQL Server 2014 new features and where you can find more information on them.

Analysis Services

Power View is now able to access Multidimensional models in SQL 2014.

Complete information is available at MSDN

Database Engine

Included in the new release… Read more

Microsoft Azure Data Services

Azure Data Services

Microsoft’s Azure data services provides you with a method to enhance your enterprise architecture and business intelligence options.  No longer are you limited to building more servers or adding SAN storage in your on-premise datacenter.   By leveraging the data services in Azure you can become elastic in… Read more

0 comments, 153 reads

Posted in Business Intelligence and Enterprise Architecture on 21 June 2014

ETL vs ELT Data Migration

ETL Process

Reporting databases need to consolidate data from across many applications within an organization.  In order to successfully pull data from source applications and make it into usable data for reporting and analytics.  There are two paths that most Business Intelligence strategies can leverage, ETL or ELT.

Extract Transform…

Read more

0 comments, 207 reads

Posted in Business Intelligence and Enterprise Architecture on 11 June 2014

Languages of Big Data Apache Hadoop

Languages of Big Data

Big Data is here and rapidly growing.  If you are just starting to learn about Big Data then it is important for you to understand all of the various pieces that can be used in Big Data architectures.  The Apache foundation is a major player in… Read more

SharePoint 2013 External Data Connections

SharePoint 2013 External Data Connections

SharePoint 2013 External Data Connections  are part of the Business Connectivity Services (BCS)  that can be leveraged to perform CRUD operations on data stored outside of SharePoint such as SQL Server or other databases.  This means that if you have users that need to insert,… Read more

SQL Saturday #308 – Houston TX Presentation

Tabular Data Visualized by Power View

I am presenting this Saturday 5/10/2014 at 4PM at the Houston TX SQL Saturday Event.  My session is titled Tabular Data Visualized by Power View.  It focuses on showing how to build SSAS Tabular Services and how to connecting Power View reports against… Read more

What is MongoDB?

How does MongoDB Store Data?

What is MongoDB?  MongoDB is a document oriented database.  This means it stores its data in fields within a document.  Each document can contain a different number of fields making the database highly flexible.  You do not have to predefine each column for data that… Read more

0 comments, 2,715 reads

Posted in Business Intelligence and Enterprise Architecture on 4 May 2014

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, 222 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, 190 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, 241 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, 224 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, 198 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, 529 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, 482 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, 408 reads

Posted in Business Intelligence and Enterprise Architecture on 22 February 2014

Older posts