David Browne's Web Log

Simple EF6-style Logging for EF Core

It took me a while to figure out logging in EF Core, and I missed the simple way you could add...

Author: davidbaxterbrowne Date: 09/22/2017

Resource Manager Powershell Script to Enable SQL Server Managed Backup to Azure

The information in SQL Server Books Online about how to generate the Shared Access Signature key for...

Author: davidbaxterbrowne Date: 06/27/2016

Installing SQL Server Express and Restoring a Database With Powershell

Here's a powershell script to install SQL Server Express Edition and restore a database from a...

Author: davidbaxterbrowne Date: 04/23/2016

TransparentNetworkIPResolution in SQLClient for .NET 4.6.1

A new Connection String property has been added for SqlConnection in .NET 4.6.1.  See...

Author: davidbaxterbrowne Date: 04/04/2016

How to create a Linked Server to SQL 2000 from SQL 2012 or later

So SQL 2000 has been out of support for a while now. But I know some of you still run it. As you...

Author: davidbaxterbrowne Date: 05/15/2015

How to connect to Oracle from a .NET Application

Use this: ODP.NET, Managed Driver - Official http://www.nuget.org/packages/Oracle.ManagedDataAccess/...

Author: davidbaxterbrowne Date: 07/24/2014

How to load an Assembly in a SSIS script task that isn't in the GAC

The documented and recommended way to reference a custom assembly from an SSIS Script Task or Script...

Author: davidbaxterbrowne Date: 06/25/2014

Compatible Encryption/Decryption for Windows Store Apps and Full .NET Framework

I recently needed to encrypt some data in a Windows Store App and decrypt it on the server in a full...

Author: davidbaxterbrowne Date: 06/19/2014

New Sample Published: ObjectDataReader

I just published a new sample in the MSDN sample gallery: ObjectDataReader. This is an update of an...

Author: davidbaxterbrowne Date: 06/11/2014

Copying SQL Server Backups to Windows Azure Storage using AzCopy

There are at least three easy ways to get your SQL Server backups to Azure storage, which, being...

Author: davidbaxterbrowne Date: 03/07/2014

Creating a Linked Server for Oracle in 64bit SQL Server

This post is a walkthrough of creating a Linked Server to Oracle from 64bit SQL Server.  There's...

Author: davidbaxterbrowne Date: 10/02/2013

Entity Framework Schema Redirection

If your runtime schema differs from your design-time schema, you need to update your Entity...

Author: davidbaxterbrowne Date: 08/30/2013

How to Move a Database That Has Database Snapshots

Database snapshots cannot be attached/detached, so how do you move a database that has database...

Author: davidbaxterbrowne Date: 07/25/2013

Compressed Rowsets in SQL Server with CLR

I’d like to demonstrate a technique for storing compressed rowsets in SQL Server using CLR...

Author: davidbaxterbrowne Date: 03/18/2013

Why is TSQL MERGE failing with a Primary Key Violation? Isn’t it atomic?

I have gotten this question a couple of times, so I thought I’d post the answer. No, MERGE...

Author: davidbaxterbrowne Date: 02/25/2013

Backup All Your SQL Server Databases to the Cloud with SQL 2012

SQL 2012 SP1 CU2  has introduced support for backup to Azure Cloud storage right in the...

Author: davidbaxterbrowne Date: 01/28/2013

My Favorite Query For Investigating SQL Server Performance

I work in a lab environment, often examining running SQL workloads for performance analysis.  This...

Author: davidbaxterbrowne Date: 01/18/2013

New Samples Published for Analysis Service Security and Service Broker .NET coding

I recently published a couple of new samples. One for doing custom security with Analysis Services...

Author: davidbaxterbrowne Date: 01/15/2013

Synchronizing a Transactional Replication Subscription From PowerShell

A customer asked me the other day for a sample of synchronizing a Replication subscription from...

Author: davidbaxterbrowne Date: 11/16/2012

How to Generate Sequential GUIDs for SQL Server in .NET

There’s a Windows function to create sequential GUIDs, called UuidCreateSequential...

Author: davidbaxterbrowne Date: 07/03/2012

Good Page Splits and Sequential GUID Key Generation

It’s well-known that inserts using monotonically increasing key values at the end of an index...

Author: davidbaxterbrowne Date: 06/25/2012

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...

Author: davidbaxterbrowne Date: 05/21/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...

Author: davidbaxterbrowne Date: 05/23/2011

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

[This post uses the old staging functionality from MDS 2008 R2. With MDS 2012, you should be using...

Author: davidbaxterbrowne Date: 12/20/2010

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...

Author: davidbaxterbrowne Date: 12/17/2010

Remote SSIS Package Execution with PowerShell 2.0

Here’s how to run SSIS packages on a remote server using PowerShell 2.0 and PowerShell...

Author: davidbaxterbrowne Date: 10/11/2010

How to Configure an SSIS Package to Access a Web Service using WCF

When you are connecting to a web service from an SSIS Script component or transform using a WCF...

Author: davidbaxterbrowne Date: 07/08/2010

Batch File to Grant Local Administrators a Sysadmin Login in SQL Server

In SQL Server members of the local administrators group are often configured to log in as...

Author: davidbaxterbrowne Date: 06/11/2010

using new TransactionScope() Considered Harmful

Hopefully you are familiar with the greatness of the TransactionScope class in .NET. It provides...

Author: davidbaxterbrowne Date: 06/03/2010

Indexes Supporting Foreign Keys

Most developers building an OLTP system know that you should declare and enforce relationships...

Author: davidbaxterbrowne Date: 03/29/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,...

Author: davidbaxterbrowne Date: 03/22/2010