SharePoint on Azure

The PointBeyond blog recently posted an interesting piece on running SharePoint on Azure. This piece covers setting up a virtual machine environment on Azure for running a Multi-Server SharePoint Farm. The post can be found here and is useful reading if you’re thinking about putting SharePoint onto the Azure platform.


PowerPivot: Sort by column

Sometimes there are measures which have an intrinsic order to them, such as days of the week or month of the year. However, this order is not always known by the technology being used to represent data by those values. For example, if I was to create a pivot table plotting some value against month…


DQS: Create a New Knowledge Base

[View:] This is the first video I’ve done on Data Quality Services. It shows how to get started with DQS by creating a new knowledge base and running knowledge discovery on a sample data set.


Data Quality in SQL Server 2012 Part 4: Data Quality Services Client

Data Quality Services, introduced in the previous blog post, includes two main components: DQS Server and DQS Client. There’s also a DQS Cleansing transformation included in SSIS in SQL Server 2012, but I won’t be going into that in this post. In this post, I’ll be talking about these two, core components. At its simplest,…


Data Quality in SQL Server 2012 Part 3: Introducing Data Quality Services

The previous two blog posts have been focusing on Master Data Services. Given the title of this series, it would be remiss of me to forget Data Quality Services, the second piece of the data quality story in SQL Server 2012. Data Quality Services is a new set of functionality in SQL Server 2012, based…


Data Quality in SQL Server 2012 Part 2: Introducing Master Data Services

In the previous blog post, I introduced the concept of Master Data Management as a methodology to improve data quality by creating a “master” version of important information. Master Data Services is Microsoft’s technology for implementing Master Data Management. It is included in SQL Server 2008 R2 Enterprise and SQL Server 2012 Enterprise and Business…


Data Quality in SQL Server 2012 Part 1: Introducing Master Data Management

Data quality is important and data quality mistakes can be expensive. Imagine a situation where a company has two systems, each with their own data set. One system is for CRM, the other is a financial system. Both systems have information about customers. Now an employee needs to send an invoice to a customer. What…


Displaying the month in an InfoPath form

Someone asked this question on a discussion list and I thought the answer was one that others might be interested in. What do you do if you want to set a field in an InfoPath form to show the month that the form is filled out? This can be done by using the today() function….


SQL Server 2012 Webcasts

Myself and colleagues (mostly Sam Solieman, but also will Thompson) have been running a series of webcasts on SQL Server 2012. The ones we’ve run so far have been recorded, so you can watch them on demand. The recordings are on the Partner Learning Center, so you’ll need a Microsoft partner login to access them. The…


SQL Server 2012 Customers

The SQL Server team blog has posted recently about customers using SQL Server 2012 today. This post has five case studies of big customers who are on the early adopters programs for SQL Server, putting to use the new features of SQL Server 2012.