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… Read more
Common Table Expresseion (CTE)
A common table expression (CTE) is a derived table that is defined and only stored for the duration of the query. CTE’s can be used for recursive queries, creating a view on demand and referencing the same table multiple times in the same query. CTE’s make… Read more
SQL Server 2014 Cardinality Estimator
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… Read more
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.
When you… Read more
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
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
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 is a system stored procedure that returns information on what is currently running on… Read more
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
SQL Server 2014
Below is a listing of the SQL Server 2014 new features and where you can find more information on them.
Power View is now able to access Multidimensional models in SQL 2014.
Complete information is available at MSDN
Included in the new release… Read more
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
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.
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 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
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
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
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
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
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