Extracting a Unique List of Rows from a Table using a Window Function

While working with data, many times I’ve had to extract unique rows out of a table, based on a subset of column values.  Here I will show you a quick way to do that using the ROW_NUMBER() window function. This time, the table I was working on stored files using the…

READ MORE

Downloads for “Introduction to Full-Text Searching in SQL Server 2012”

Below are the presentation and script files I used for my July 8 talk to the Virtual Access Groups on full-text searching in SQL Server: PowerPoint Presentation Scripts

Copying data between two Azure Databases

We use Windows Azure around here a lot, it works great with Access but it has one limitation: you can’t copy data from one database to another since they don’t support the USE statement. Use Generate Script Instead To get around this limitation use the following technique: Launch SQL Server…

READ MORE

Replicating made simple: SQL Azure Data Sync

On May 13th, at 6:30 PM CST, I will be speaking about how you can easily create a solution that enable you to have your Access program working across broad geographic regions by leveraging SQL Azure Data Sync which is still in preview. In the talk, we will demonstrate how…

READ MORE

Why Don’t I See all my Domains in the DQS Component of SSIS?

This one took me a while but I finally figured it out.  I had set up my DQS knowledge base and was mapping my columns to domains in the DQS component.  But I couldn’t find the domain that corresponded to a column called “Category of Disability” and that had the same…

READ MORE