Learn how you can manipulat XML documents solely in memory. No file required.   Read more...

For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.  Read more...

In this article I will run a SQL Server script to backup a database using C# in visual studio. For this purpose, I am going to use the sqlcmd.  Read more...

This article describes how to backup a database using a C# Windows Form.   Read more...

This article demonstrates how to build an SSIS package that generates an XML invoice document from data stored in SQL Server and saves it to an XML file.  Read more...

This SSIS package performs multiple XSL transformations on an XML document, then shreds the transformed document and inserts its data into a SQL Server table.  Read more...

Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing  Read more...

Second in the series of tools & techniques to help manage aspects Of Enterprise BI implementation.  Read more...

This article demonstrates basic C#.NET code that will enable SSIS package developers to write useful custom SSIS script tasks.  Read more...

A set of 20 functions for URI and URL parsing, using .NET's native System.Uri parser  Read more...

One CLR function and four CLR procedures for the import/export of JSON data to and from SQL Server are presented, with supporting performance metrics.  Read more...

A CLR procedure utilizing the NPOI library to export the results of a passed stored procedure to an Excel spreadsheet.  Read more...

For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.  Read more...

Read a sample chapter from this new book about C# and LINQ from Murach.  Read more...

For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.  Read more...

The Advanced Encryption Standard (AES) is a National Institute of Standards and Technology specification for the encryption of electronic data. It is expected to become the accepted means of encrypting digital information, including financial, telecommunications, and government data. This article presents an overview of AES and explains the algorithms it uses. Included is a complete C# implementation and examples of encrypting .NET data. After reading this article you will be able to encrypt data using AES, test AES-based software, and use AES encryption in your systems.  Read more...