The Curious Engineer

All blogs / Databases

David Browne's Web Log

learn.microsoft.com/en-us/archive/blogs/dbrowne

DatabasesC# / .NETMicrosoft blogsMSDN archive

’10’15’20’25
Posts
31 from 22 Mar 2010 to 22 Sep 2017
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/dbrowne/feed.xml

2017 1

  1. Simple EF6-style Logging for EF Core

2016 3

  1. Resource Manager Powershell Script to Enable SQL Server Managed Backup to Azure
  2. Installing SQL Server Express and Restoring a Database With Powershell
  3. TransparentNetworkIPResolution in SQLClient for .NET 4.6.1

2015 1

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

2014 5

  1. How to connect to Oracle from a .NET Application
  2. How to load an Assembly in a SSIS script task that isn't in the GAC
  3. Compatible Encryption/Decryption for Windows Store Apps and Full .NET Framework
  4. New Sample Published: ObjectDataReader
  5. Copying SQL Server Backups to Windows Azure Storage using AzCopy

2013 8

  1. Creating a Linked Server for Oracle in 64bit SQL Server
  2. Entity Framework Schema Redirection
  3. How to Move a Database That Has Database Snapshots
  4. Compressed Rowsets in SQL Server with CLR
  5. Why is TSQL MERGE failing with a Primary Key Violation? Isn’t it atomic?
  6. Backup All Your SQL Server Databases to the Cloud with SQL 2012
  7. My Favorite Query For Investigating SQL Server Performance
  8. New Samples Published for Analysis Service Security and Service Broker .NET coding

2012 4

  1. Synchronizing a Transactional Replication Subscription From PowerShell
  2. How to Generate Sequential GUIDs for SQL Server in .NET
  3. Good Page Splits and Sequential GUID Key Generation
  4. How to Add a Hostname Alias for a SQL Server Instance

2011 1

  1. Transparent Data Encryption in a SQL Server Fast Track Data Warehouse

2010 8

  1. Implementing an Master Data Management Solution With SQL Server Master Data Services and the MDS Utilities (Part 2 Loading the Model)
  2. Implementing an Master Data Management Solution With SQL Server Master Data Services and the MDS Utilities (Part 1 Creating the Model)
  3. Remote SSIS Package Execution with PowerShell 2.0
  4. How to Configure an SSIS Package to Access a Web Service using WCF
  5. Batch File to Grant Local Administrators a Sysadmin Login in SQL Server
  6. using new TransactionScope() Considered Harmful
  7. Indexes Supporting Foreign Keys
  8. Oracle Database Connectivity for the Microsoft BI stack (Part 1 Oracle Client)