Category Archives: Microsoft

A Look at How to Migrate an Access Database to SQL Server Part 1 of 2

By kmorillo | January 16, 2012

Recently I was tasked with migrating a Microsoft Access 2010 database to SQL Server 2008 R2 while preserving the form functionality built into Access.  While the migration using Microsoft Access’ ‘Upsizing Wizard’ was easy enough for a majority of the objects, I found that a few of the more complex Access queries and tables needed [...]

Also posted in SQL Server, Uncategorized | Tagged , , , , , , | Leave a comment

Book Announcement! Introducing “Programming Microsoft SQL Server 2012″

By Lenni Lobel | November 21, 2011

I’m very happy to announce that I am authoring Tallan’s new book on SQL Server 2012! The full title, “Programming Microsoft SQL Server 2012” will technically be published by O’Reilly, yet it will be branded as a Microsoft Press book, and will feature Tallan’s logo on the front cover. O’Reilly recently acquired MS Press, but [...]

Also posted in SQL Server | Tagged | Leave a comment

The Oracle Business Intelligence Stack

By achandler | April 24, 2009

Yesterday, I attended a seminar covering the Oracle BI landscape. My aim was to come out of this session with a clearer idea of how Oracle products correspond to the Microsoft BI stack. My impression going into this seminar was that Oracle had many, many applications bundled under the BI umbrella. Nevertheless, I was surprised [...]

Also posted in Oracle | 1 Comment

Introduction to Analysis Services

By achandler | April 10, 2009

This post is intended to introduce Analysis Services 2005/2008 foundational concepts.
SQL Server Analysis Services is a component included in the Microsoft SQL Server product, and its use is fully covered under the same license (which applies to Integration Services and Reporting Services as well). Like the database engine, SSAS has a range of features stratified [...]

Also posted in Analysis Services, SQL Server, Warehousing | Leave a comment

MS BI News Roundup

By achandler | January 27, 2009

Two big pieces of news on the Microsoft BI front:

Performance Point Server is being dismantled. After the next service pack, MS will cease develop of the product as its own entity. The Monitoring & Analytics capabilities will be bundled into the enterprise version of SharePoint. The Planning application looks to be dead in the water, [...]

Also posted in Analysis Services, SQL Server | Leave a comment