Facebook Twitter LinkedIn YouTube E-mail
Home Posts tagged "SQL Server"
formats

Automate Bus Matrix Documentation Using DMV Queries from a Microsoft BI Tabular Solution for Project Management Scope Verification – Part 1

Share

This is Part One of two blog posts about automating the creation of a Bus Matrix in Power Pivot for Excel using DMV queries from an SSAS Tabular Model.  UPDATE: Part 2 is now published and can be viewed at this link. Have you ever spent several hours making a Business (Bus) Matrix for an

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
formats

SharePoint, SQL and Office together – Part 1

Share

With the recent releases of software products from Microsoft, there have been many questions about compatibility and deployment for SQL Server, SharePoint Server and the Microsoft Office suite. The questions of particular interest are whether a particular version of SQL Server will work with a particular version of SharePoint Server, and then will Office work

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on SharePoint, SQL and Office together – Part 1  comments 
formats

Introduction to SQL Server 2012 “ColumnStore” Index (Part I)

Share

Overview Is “ColumnStore” a new idea? No, it has been around for years, and even dates back to the 1970s. Is this new for SQL Server Database? Yes, it was newly introduced into the SQL Server database engine in SQL Server 2012. This new idea combining with other enhancements in algorithm and execution plan can

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
2 Comments  comments 
formats

Using Data Quality Services to Cleanse Source Data in Integration Services

Share

So far we’ve seen various methods of cleansing source data using Data Quality Services. One of the main applications of DQS is in SQL Server Integration Services. This is where source data can be cleansed using the knowledge bases maintained in the DQS client by launching the DQS cleansing transform available in Integration Services. This blog gives

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Using Data Quality Services to Cleanse Source Data in Integration Services  comments