Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
The information in SQL Server Books Online about how to generate the Shared Access Signature key for...
Date: 06/27/2016
Here's a powershell script to install SQL Server Express Edition and restore a database from a...
Date: 04/23/2016
A new Connection String property has been added for SqlConnection in .NET 4.6.1. See...
Date: 04/04/2016
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
Use this: ODP.NET, Managed Driver - Official https://www.nuget.org/packages/Oracle.ManagedDataAccess/...
Date: 07/24/2014
The documented and recommended way to reference a custom assembly from an SSIS Script Task or Script...
Date: 06/25/2014
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
I just published a new sample in the MSDN sample gallery: ObjectDataReader. This is an update of an...
Date: 06/11/2014
There are at least three easy ways to get your SQL Server backups to Azure storage, which, being...
Date: 03/07/2014
This post is a walkthrough of creating a Linked Server to Oracle from 64bit SQL Server. There's...
Date: 10/02/2013
If your runtime schema differs from your design-time schema, you need to update your Entity...
Date: 08/30/2013
Database snapshots cannot be attached/detached, so how do you move a database that has database...
Date: 07/25/2013
I’d like to demonstrate a technique for storing compressed rowsets in SQL Server using CLR...
Date: 03/18/2013
I have gotten this question a couple of times, so I thought I’d post the answer. No, MERGE...
Date: 02/25/2013
SQL 2012 SP1 CU2 has introduced support for backup to Azure Cloud storage right in the...
Date: 01/28/2013
I work in a lab environment, often examining running SQL workloads for performance analysis. This...
Date: 01/18/2013
I recently published a couple of new samples. One for doing custom security with Analysis Services...
Date: 01/15/2013
A customer asked me the other day for a sample of synchronizing a Replication subscription from...
Date: 11/16/2012
There’s a Windows function to create sequential GUIDs, called UuidCreateSequential...
Date: 07/03/2012
It’s well-known that inserts using monotonically increasing key values at the end of an index...
Date: 06/25/2012
A Hostname Alias SQL Server instance is a simple Hostname that allows clients to connect to an...
Date: 05/21/2012
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
Here’s how to run SSIS packages on a remote server using PowerShell 2.0 and PowerShell...
Date: 10/11/2010
When you are connecting to a web service from an SSIS Script component or transform using a WCF...
Date: 07/08/2010
In SQL Server members of the local administrators group are often configured to log in as...
Date: 06/11/2010
Hopefully you are familiar with the greatness of the TransactionScope class in .NET. It provides...
Date: 06/03/2010
Most developers building an OLTP system know that you should declare and enforce relationships...
Date: 03/29/2010
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