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...
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...
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...
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...
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...
Date: 05/15/2015
How to connect to Oracle from a .NET Application
Use this: ODP.NET, Managed Driver - Official https://www.nuget.org/packages/Oracle.ManagedDataAccess/...
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...
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...
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...
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...
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...
Date: 10/02/2013
Entity Framework Schema Redirection
If your runtime schema differs from your design-time schema, you need to update your Entity...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 06/11/2010
using new TransactionScope() Considered Harmful
Hopefully you are familiar with the greatness of the TransactionScope class in .NET. It provides...
Date: 06/03/2010
Indexes Supporting Foreign Keys
Most developers building an OLTP system know that you should declare and enforce relationships...
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,...
Date: 03/22/2010