tag:blogger.com,1999:blog-5083207193778237668Mon, 09 Sep 2024 03:14:28 +0000.netC#codesql serverextension methodshelper class<br>my memory extension in the cloud. Is that what they call "augmented reality"?http://yepthatspossible.blogspot.com/noreply@blogger.com (Guirec)Blogger3125tag:blogger.com,1999:blog-5083207193778237668.post-5645696009055532104Wed, 09 Dec 2009 16:25:00 +00002009-12-09T18:08:26.798+01:00.netC#sql serverOk, that one is a bit hardcore but helped me a few times... Here I'll demonstrate how with a very little impact on your code you can pass a variable from C# code to Sql Server to make it available as a session variable during your connection lifetime. Let's try and explain through a concrete example: You are architect at Colors, you know, the multi-all company (multi-national, multi-technology, http://yepthatspossible.blogspot.com/2009/12/how-i-saved-my-company-from-piracy-by.htmlnoreply@blogger.com (Guirec)0tag:blogger.com,1999:blog-5083207193778237668.post-2488966430689291997Wed, 09 Dec 2009 15:35:00 +00002009-12-09T18:06:10.840+01:00.netC#codeextension methodshelper class<!-- code formatted by http://manoli.net/csharpformat/ --> public static class HexadecimalConverter { static readonly string[] fLookupTable; static HexadecimalConverter() { // Populates cache fLookupTable = new string[256]; for (int i = 0; i &lt; fLookupTable.Length; i++) fLookupTable[i] = i.ToString("X2"); } http://yepthatspossible.blogspot.com/2009/12/convert-array-of-bytes-to-hexadecimal.htmlnoreply@blogger.com (Guirec)0tag:blogger.com,1999:blog-5083207193778237668.post-2735604602695245067Tue, 08 Dec 2009 13:29:00 +00002009-12-09T12:22:35.996+01:00codesql serverIt is very likely that one day or other you'd want to run a sql task at startup of your server. What for? You probably know better than I do but here are a few ideas: Create a denormalized table in tempdb Check sanity of the server Start a monitoring process Whatever... The following script configures your db server for launching (in each database) the stored procedure called _startup when http://yepthatspossible.blogspot.com/2009/12/sql-server-startup-procedures.htmlnoreply@blogger.com (Guirec)0