SQLServerCentral.com Articles tagged C#

Using XML from data variable option in SSIS

Wed, 15 May 2013 06:00:00 UT

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

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Run SQL Server Scripts using C#

Fri, 27 Apr 2012 06:00:00 UT

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.

How to create a database backup using visual studio

Fri, 30 Mar 2012 06:00:00 UT

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

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Basics of XML and SQL Server, Part 4: Create an XML invoice with SSIS

Wed, 28 Mar 2012 06:00:00 UT

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.

Basics of XML and SQL Server, Part 3: Transform and Shred XML in SSIS

Wed, 21 Mar 2012 06:00:00 UT

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.

An Implementation of the FNV1a Hash Algorithm for SQL Server

Mon, 20 Feb 2012 07:00:00 UT

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

Managing Data Dictionaries in DW and DSS Database Applications

Tue, 20 Dec 2011 07:00:00 UT

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

A C#.NET toolkit for writing SSIS Script Tasks

Mon, 12 Dec 2011 07:00:00 UT

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

URI Parser: A set of 20 CLR functions for URI parsing

Thu, 21 Jul 2011 06:00:00 UT

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

JSON.SQL: A CLR-resident JSON serializer/deserializer for SQL Server

Mon, 18 Jul 2011 06:00:00 UT

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.

XLSExport: A CLR procedure to export proc results to Excel

Thu, 23 Jun 2011 06:00:00 UT

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

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Murach’s ADO.NET 3.5, LINQ, and the Entity Framework with C# 2008

Tue, 11 Aug 2009 06:00:00 UT

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

Keep Your Data Secure with the New Advanced Encryption Standard

Fri, 19 Oct 2007 06:00:00 UT

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.