David Browne's Web Log
Translate This Page
Translate this page
Master Data Services
Transparent Data Encryption
Windows Store App
Browse by Tags
David Browne's Web Log
Tagged Content List
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...
11 Jun 2014
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...
21 May 2012
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...
23 May 2011
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:/...
17 Dec 2010
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...
29 Mar 2010
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) and 64bit...
22 Mar 2010
Page 1 of 1 (6 items)
© 2014 Microsoft Corporation.
Privacy & Cookies