New Sample Published: ObjectDataReader

I just published a new sample in the MSDN sample gallery:  ObjectDataReader.  This is an update of an older sample (EntityDataReader) that is an IDataReader adapter for object collections.  This is useful primarily for bulk loading SQL Server from a collection of .NET objects. ObjectDataReader is intended to be simple and fast.  It uses dynamically-compiled expressions to…

0

How to Add a Hostname Alias for a SQL Server Instance

A Hostname Alias SQL Server instance is a simple Hostname that allows clients to connect to an instance of SQL Server without specifying an instance name or a port number. They are very useful for upgrades, server migration, consolidation, and disaster recovery.  A network alias can redirect clients from one server to another. This is most…

22

Transparent Data Encryption in a SQL Server Fast Track Data Warehouse

  SQL Server Fast Track Reference Architecture is a set of prescriptive hardware configurations and operational practices for building large data warehouses on SQL Server.  There are reference configurations ranging from a few terabytes to 40TB and more.  The really useful thing about the Fast Track configurations is that they have predictable performance.  Typically when…

0

Implementing an Master Data Management Solution With SQL Server Master Data Services and the MDS Utilities (Part 1 Creating the Model)

  I’ve been working with a number of customers to implement SQL Server Master Data Services, and found some common requests from customers that require some custom code to implement.  Over the course of those engagements I wrote a set of utilities for MDS that are now published on CodePlex http://mdsutilities.codeplex.com.  The questions I kept…

4

Indexes Supporting Foreign Keys

Most developers building an OLTP system know that you should declare and enforce relationships between tables using Foreign Keys.  But what physical database structures should you implement to support those relationships?  Every Foreign Key is a relationship from one or more columns on the table on which the Foreign Key is declared to a Key…

1

Oracle Database Connectivity for the Microsoft BI stack (Part 1 Oracle Client)

There’s lots of blog posts out there on how to get your SQL Server BI environment to talk to Oracle, but lot’s of it is a bit incomplete, so I’m going to take a crack an publishing a complete guide.  I’ll start with installing the Oracle client and getting it running with BIDS (Visual Studio)…

3