URI Parser: A set of 20 CLR functions for URI parsing
A set of 20 functions for URI and URL parsing, using .NET's native System.Uri parser
2011-07-21
1,395 reads
C#
JSON.SQL: A CLR-resident JSON serializer/deserializer for SQL Server
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.
2011-07-18
15,596 reads
XLSExport: A CLR procedure to export proc results to Excel
A CLR procedure utilizing the NPOI library to export the results of a passed stored procedure to an Excel spreadsheet.
2011-06-23
9,993 reads
Murach’s ADO.NET 3.5, LINQ, and the Entity Framework with C# 2008
Read a sample chapter from this new book about C# and LINQ from Murach.
2009-08-11
2,168 reads
Generate C# class code for table
For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.
2013-12-24 (first published: 2007-11-06)
12,029 reads
Keep Your Data Secure with the New Advanced Encryption Standard
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.
2007-10-19
2,427 reads
RE: "Column encryption" software recommendations?
Be wary of column level encryption. It sounds like a great idea but is miserable on performance. I also know that it is very difficult and potentially impossible to create an index on an encrypted column.
2005-05-03
RE: Transaction log backups causing application to hang?
I agree - I have a hard time imagining that 15 minute backups of a tlog are unusual. However there does seem to be a direct correlation between the increase in frequency and the increase in application 'hangs'. Even more to the point, the times of the application hangs often correspond with the kickoff of […]
2005-04-29
2005-04-28
RE: Where to find out detail of when the Index is created and modified?
Colin is attempting to provide help. Questions are not always clear as to their intent, giving more information rather than less helps other to help you. Colin is just trying to get that information to be of greater assistance. Berating him for that is pointless and ridiculous.
2005-04-28
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers