About Me

My photo
Northglenn, Colorado, United States
I'm primarily a BI Developer on the Microsoft stack. I do sometimes touch upon other Microsoft stacks ( web development, application development, and sql server development).

Wednesday, December 17, 2008

Good programming / mathematical fun with Project Euler

I just started doing some the problems at http://projecteuler.net and found it actually quite fun to do. The problems just get more interesting  and complex. What is really nice about the site, is that you need to recall or learn some of the math from discrete, finite, etc… that will make coding faster to solve. Most of the problems I have done so far take less then 1 second if done correctly.

All done in C#:

Euler 1: Add all the natural numbers below one thousand that are multiples of 3 or 5.   Runs in ~0.001 seconds

Euler 2: Find the sum of all the even-valued terms in the Fibonacci sequence which do not exceed four million. ~1.12 seconds

Euler 3: Find the largest prime factor of a composite number. 600851475143  ~.09 seconds

Euler 4: Find the largest palindrome made from the product of two 3-digit numbers. ~.01 seconds   (Example: A palindromic number reads the same both ways. The largest palindrome made from the product of two 2-digit numbers is 9009 = 91 × 99.)

Euler 5: What is the smallest number divisible by each of the numbers 1 to 20? ~5.25 seconds (need to optimize this one) (Example: 2520 is the smallest number that can be divided by each of the numbers from 1 to 10 without any remainder.)

Euler 6: What is the difference between the sum of the squares and the square of the sums?  ~.001 seconds
Example:
The sum of the squares of the first ten natural numbers is,
    1^(2) + 2^(2) + ... + 10^(2) = 385

    The square of the sum of the first ten natural numbers is,
    (1 + 2 + ... + 10)^(2) = 55^(2) = 3025

    Hence the difference between the sum of the squares of the first ten natural numbers and the square of the sum is 3025 − 385 = 2640.

    Find the difference between the sum of the squares of the first one hundred natural numbers and the square of the sum.

Euler 7:  What is the 10001^(st) prime number? ~4.5 seconds

Euler 8:  Find the greatest product of five consecutive digits in the 1000-digit number.  ~.003 seconds

            73167176531330624919225119674426574742355349194934
            96983520312774506326239578318016984801869478851843
            85861560789112949495459501737958331952853208805511
            12540698747158523863050715693290963295227443043557
            66896648950445244523161731856403098711121722383113
            62229893423380308135336276614282806444486645238749
            30358907296290491560440772390713810515859307960866
            70172427121883998797908792274921901699720888093776
            65727333001053367881220235421809751254540594752243
            52584907711670556013604839586446706324415722155397
            53697817977846174064955149290862569321978468622482
            83972241375657056057490261407972968652414535100474
            82166370484403199890008895243450658541227588666881
            16427171479924442928230863465674813919123162824586
            17866458359124566529476545682848912883142607690042
            24219022671055626321111109370544217506941658960408
            07198403850962455444362981230987879927244284909188
            84580156166097919133875499200524063689912560717606
            05886116467109405077541002256983155200055935729725
            71636269561882670428252483600823257530420752963450

Euler 9:  A Pythagorean triplet is a set of three natural numbers, a < b < c, for which,
          a^(2) + b^(2) = c^(2)

          For example, 3^(2) + 4^(2) = 9 + 16 = 25 = 5^(2).

          There exists exactly one Pythagorean triplet for which a + b + c = 1000.
          Find the product abc.
        ~ .007 seconds

Euler 10:  The sum of the primes below 10 is 2 + 3 + 5 + 7 = 17.  Find the sum of all the primes below two million. ~.17 seconds
My personal solution was slow, then I found this interesting concept of using bits to hold the place of primes and loved it because it is so fast.

            BitArray Sieve = new BitArray(2000000);

            long sum = 0;

 

            Sieve.SetAll(true);

            Sieve.Set(0, false);

            Sieve.Set(1, false);

 

            for (int i = 2; i < Sieve.Length; i++)

            {

                if (!Sieve[i])

                    continue;

                else

                {

                    for (int j = i << 1; j < Sieve.Length; j += i)

                    {

                        Sieve.Set(j, false);

                    }

                }

            }

 

            for (int i = 2; i < Sieve.Length; i++)

            {

                if (Sieve[i])

                {

                    sum += i;

                }

            }

            Console.WriteLine(sum);

Euler 11: In the 20×20 grid below, four numbers along a diagonal line have been marked in red.

08 02 22 97 38 15 00 40 00 75 04 05 07 78 52 12 50 77 91 08
49 49 99 40 17 81 18 57 60 87 17 40 98 43 69 48 04 56 62 00
81 49 31 73 55 79 14 29 93 71 40 67 53 88 30 03 49 13 36 65
52 70 95 23 04 60 11 42 69 24 68 56 01 32 56 71 37 02 36 91
22 31 16 71 51 67 63 89 41 92 36 54 22 40 40 28 66 33 13 80
24 47 32 60 99 03 45 02 44 75 33 53 78 36 84 20 35 17 12 50
32 98 81 28 64 23 67 10 26 38 40 67 59 54 70 66 18 38 64 70
67 26 20 68 02 62 12 20 95 63 94 39 63 08 40 91 66 49 94 21
24 55 58 05 66 73 99 26 97 17 78 78 96 83 14 88 34 89 63 72
21 36 23 09 75 00 76 44 20 45 35 14 00 61 33 97 34 31 33 95
78 17 53 28 22 75 31 67 15 94 03 80 04 62 16 14 09 53 56 92
16 39 05 42 96 35 31 47 55 58 88 24 00 17 54 24 36 29 85 57
86 56 00 48 35 71 89 07 05 44 44 37 44 60 21 58 51 54 17 58
19 80 81 68 05 94 47 69 28 73 92 13 86 52 17 77 04 89 55 40
04 52 08 83 97 35 99 16 07 97 57 32 16 26 26 79 33 27 98 66
88 36 68 87 57 62 20 72 03 46 33 67 46 55 12 32 63 93 53 69
04 42 16 73 38 25 39 11 24 94 72 18 08 46 29 32 40 62 76 36
20 69 36 41 72 30 23 88 34 62 99 69 82 67 59 85 74 04 36 16
20 73 35 29 78 31 90 01 74 31 49 71 48 86 81 16 23 57 05 54
01 70 54 71 83 51 54 69 16 92 33 48 61 43 52 01 89 19 67 48

The product of these numbers is 26 × 63 × 78 × 14 = 1788696.

What is the greatest product of four adjacent numbers in any direction (up, down, left, right, or diagonally) in the 20×20 grid?
~.00009 seconds

Euler 12: The sequence of triangle numbers is generated by adding the natural numbers. So the 7^(th) triangle number would be 1 + 2 + 3 + 4 + 5 + 6 + 7 = 28. The first ten terms would be:

     1, 3, 6, 10, 15, 21, 28, 36, 45, 55, ...

     Let us list the factors of the first seven triangle numbers:

          1: 1
          3: 1,3
          6: 1,2,3,6
         10: 1,2,5,10
         15: 1,3,5,15
         21: 1,3,7,21
         28: 1,2,4,7,14,28

     We can see that 28 is the first triangle number to have over five divisors.

     What is the value of the first triangle number to have over five hundred divisors?
~2.50 seconds

Euler 13: Work out the first ten digits of the sum of the following one-hundred 50-digit numbers. ~.002 seconds     37107287533902102798797998220837590246510135740250
    46376937677490009712648124896970078050417018260538
    74324986199524741059474233309513058123726617309629
    91942213363574161572522430563301811072406154908250
    23067588207539346171171980310421047513778063246676
    89261670696623633820136378418383684178734361726757
    28112879812849979408065481931592621691275889832738
    44274228917432520321923589422876796487670272189318
    47451445736001306439091167216856844588711603153276
    70386486105843025439939619828917593665686757934951
    62176457141856560629502157223196586755079324193331
    64906352462741904929101432445813822663347944758178
    92575867718337217661963751590579239728245598838407
    58203565325359399008402633568948830189458628227828
    80181199384826282014278194139940567587151170094390
    35398664372827112653829987240784473053190104293586
    86515506006295864861532075273371959191420517255829
    71693888707715466499115593487603532921714970056938
    54370070576826684624621495650076471787294438377604
    53282654108756828443191190634694037855217779295145
    36123272525000296071075082563815656710885258350721
    45876576172410976447339110607218265236877223636045
    17423706905851860660448207621209813287860733969412
    81142660418086830619328460811191061556940512689692
    51934325451728388641918047049293215058642563049483
    62467221648435076201727918039944693004732956340691
    15732444386908125794514089057706229429197107928209
    55037687525678773091862540744969844508330393682126
    18336384825330154686196124348767681297534375946515
    80386287592878490201521685554828717201219257766954
    78182833757993103614740356856449095527097864797581
    16726320100436897842553539920931837441497806860984
    48403098129077791799088218795327364475675590848030
    87086987551392711854517078544161852424320693150332
    59959406895756536782107074926966537676326235447210
    69793950679652694742597709739166693763042633987085
    41052684708299085211399427365734116182760315001271
    65378607361501080857009149939512557028198746004375
    35829035317434717326932123578154982629742552737307
    94953759765105305946966067683156574377167401875275
    88902802571733229619176668713819931811048770190271
    25267680276078003013678680992525463401061632866526
    36270218540497705585629946580636237993140746255962
    24074486908231174977792365466257246923322810917141
    91430288197103288597806669760892938638285025333403
    34413065578016127815921815005561868836468420090470
    23053081172816430487623791969842487255036638784583
    11487696932154902810424020138335124462181441773470
    63783299490636259666498587618221225225512486764533
    67720186971698544312419572409913959008952310058822
    95548255300263520781532296796249481641953868218774
    76085327132285723110424803456124867697064507995236
    37774242535411291684276865538926205024910326572967
    23701913275725675285653248258265463092207058596522
    29798860272258331913126375147341994889534765745501
    18495701454879288984856827726077713721403798879715
    38298203783031473527721580348144513491373226651381
    34829543829199918180278916522431027392251122869539
    40957953066405232632538044100059654939159879593635
    29746152185502371307642255121183693803580388584903
    41698116222072977186158236678424689157993532961922
    62467957194401269043877107275048102390895523597457
    23189706772547915061505504953922979530901129967519
    86188088225875314529584099251203829009407770775672
    11306739708304724483816533873502340845647058077308
    82959174767140363198008187129011875491310547126581
    97623331044818386269515456334926366572897563400500
    42846280183517070527831839425882145521227251250327
    55121603546981200581762165212827652751691296897789
    32238195734329339946437501907836945765883352399886
    75506164965184775180738168837861091527357929701337
    62177842752192623401942399639168044983993173312731
    32924185707147349566916674687634660915035914677504
    99518671430235219628894890102423325116913619626622
    73267460800591547471830798392868535206946944540724
    76841822524674417161514036427982273348055556214818
    97142617910342598647204516893989422179826088076852
    87783646182799346313767754307809363333018982642090
    10848802521674670883215120185883543223812876952786
    71329612474782464538636993009049310363619763878039
    62184073572399794223406235393808339651327408011116
    66627891981488087797941876876144230030984490851411
    60661826293682836764744779239180335110989069790714
    85786944089552990653640447425576083659976645795096
    66024396409905389607120198219976047599490197230297
    64913982680032973156037120041377903785566085089252
    16730939319872750275468906903707539413042652315011
    94809377245048795150954100921645863754710598436791
    78639167021187492431995700641917969777599028300699
    15368713711936614952811305876380278410754449733078
    40789923115535562561142322423255033685442488917353
    44889911501440648020369068063960672322193204149535
    41503128880339536053299340368006977710650566631954
    81234880673210146739058568557934581403627822703280
    82616570773948327592232845941706525094512325230608
    22918802058777319719839450180888072429661980811197
    77158542502016545090413245809786882778948721859617
    72107838435069186155435662884062257473692284509516
    20849603980134001723930671666823555245252804609722
    53503534226472524250874054075591789781264330331690

Euler 14:   The following iterative sequence is defined for the set of positive integers:

     n → n/2 (n is even)
     n → 3n + 1 (n is odd)

     Using the rule above and starting with 13, we generate the following sequence:
     13 → 40 → 20 → 10 → 5 → 16 → 8 → 4 → 2 → 1

     It can be seen that this sequence (starting at 13 and finishing at 1) contains 10 terms. Although it has not been proved yet (Collatz Problem), it is thought that all starting numbers finish at 1.

     Which starting number, under one million, produces the longest chain?

     NOTE: Once the chain starts the terms are allowed to go above one million.
~9.05 seconds (slow)

Euler 15: Starting in the top left corner of a 2×2 grid, there are 6 routes (without backtracking) to the bottom right corner. How many routes are there through a 20×20 grid?  ~0.001 seconds  (I cheated and used math to solve this.)

Euler 16: What is the sum of the digits of the number 2^1000? ~.01 seconds

Euler 17: If the numbers 1 to 5 are written out in words: one, two, three, four, five, then there are 3 + 3 + 5 + 4 + 4 = 19 letters used in total. If all the numbers from 1 to 1000 (one thousand) inclusive were written out in words, how many letters would be used?

NOTE: Do not count spaces or hyphens. For example, 342 (three hundred and forty-two) contains 23 letters and 115 (one hundred and fifteen) contains 20 letters. The use of "and" when writing out numbers is in compliance with British usage.
~.01 seconds

       public enum WrittenNumbers

        {

            one = 1,

            two,

            three,

            four,

            five,

            six,

            seven,

            eight,

            nine,

            ten,

            eleven,

            twelve,

            thirteen,

            fourteen,

            fifteen,

            sixteen,

            seventeen,

            eighteen,

            nineteen,

            twenty = 20,

            thirty = 30,

            forty = 40,

            fifty = 50,

            sixty = 60,

            seventy = 70,

            eighty = 80,

            ninety = 90,

            hundred = 100,

            hundredand,

            thousand = 1000

        };

 

        static void Main(string[] args)

        {

            int totalLetterCount = 0;

            for (int i = 1; i <= 1000; i++)

            {

                totalLetterCount += getWrittenLength(i);

            }

            Console.WriteLine(totalLetterCount);

            Console.ReadLine();

        }

 

        private static int getWrittenLength(int i)

        {

            if (i >= 1 && i < 20)

            {

                return ((WrittenNumbers)i).ToString().Length;

            }

            else if (i >= 20 && i < 100)

            {

                if (i % 10 == 0)

                {

                    return ((WrittenNumbers)i).ToString().Length;

                }

                else

                {

                    int remainder;

                    int temp = 10 * Math.DivRem(i,10,out remainder);

                    return ((WrittenNumbers)temp).ToString().Length + ((WrittenNumbers)remainder).ToString().Length;

                }

            }

            else if (i >= 100 && i < 1000)

            {

 

                if (i % 100 == 0)

                {

                    int temp = i / 100;

                    return ((WrittenNumbers)temp).ToString().Length + ((WrittenNumbers)100).ToString().Length;

                }

                else

                {

                    int remainder;

                    int temp;

                    temp = Math.DivRem(i,100,out remainder);

                    return ((WrittenNumbers)temp).ToString().Length + ((WrittenNumbers)101).ToString().Length + getWrittenLength(remainder);

                }

            }

            else if (i >= 1000 && i < 10000)

            {

                if (i % 1000 == 0)

                {

                    int temp = i / 1000;

                    return ((WrittenNumbers)temp).ToString().Length + ((WrittenNumbers)1000).ToString().Length;

                }

                else

                {

                    int remainder;

                    int temp = Math.DivRem(i, 1000, out remainder);

                    return ((WrittenNumbers)temp).ToString().Length + ((WrittenNumbers)1000).ToString().Length + getWrittenLength(remainder);

                }

            }

            else

            {

                return 0;

            }

        }

Euler 19: You are given the following information, but you may prefer to do some research for yourself.

    * 1 Jan 1900 was a Monday.
    * Thirty days has September,
      April, June and November.
      All the rest have thirty-one,
      Saving February alone,
      Which has twenty-eight, rain or shine.
      And on leap years, twenty-nine.
    * A leap year occurs on any year evenly divisible by 4, but not on a century unless it is divisible by 400.

How many Sundays fell on the first of the month during the twentieth century (1 Jan 1901 to 31 Dec 2000)?
~.01 seconds - C# cheat way

        static void Main(string[] args)

        {

            int sum = 0;

            for (int year = 1901; year <= 2000; year++)

            {

                //cheat version thanks to C#

                sum += HowManySundays(year);

            }

            Console.WriteLine(sum);

            Console.ReadLine();

        }

 

        private static int HowManySundays(int year)

        {

            System.DateTime temp;

            int totalSundays = 0;

 

            for(int month = 1; month <= 12; month++)

            {

                for (int days = 1; days <= System.DateTime.DaysInMonth(year, month); days++)

                {

                    temp = new DateTime(year, month, days);

                    if (temp.DayOfWeek == DayOfWeek.Sunday && temp.Day == 1)

                    {

                        totalSundays++;

                    }

                }

            }

            return totalSundays;

        }

Euler 20:  n! means n × (n − 1) × ... × 3 × 2 × 1

Find the sum of the digits in the number 100!
~.004 seconds

        static void Main(string[] args)

        {

            int sum;

            Console.WriteLine(GetPermutationOf(100, out sum));

            Console.WriteLine(sum);

            Console.ReadLine();

        }

 

        private static string GetPermutationOf(int p, out int sum)

        {

 

            int[] perm = new int[159];

            int place = 0;

            int carry = 0;

 

            for (int i = 0; i < perm.Length; i++)

            {

                perm[i] = 0;

            }

            perm[0] = 1;

            for (int i = 1; i <= p; i++)

            {

                for (int j = 0; j <= place; j++)

                {

                    perm[j] *= i;

                    perm[j] += carry;

                    carry = 0;

                    while (perm[j] >= 10)

                    {

                        carry++;

                        perm[j] -= 10;

                    }

                }

                if (carry != 0)

                {

                    while (carry > 10)

                    {

                        perm[place + 2] += 1;

                        carry -= 10;

 

                    }

                    perm[place + 1] = carry;

                    carry = 0;

                }

                for (int k = perm.Length - 1; k >= 0; k--)

                {

                    if (perm[k] != 0)

                    {

                        place = k;

                        break;

                    }

                }

            }

            string result = "";

            sum = 0;

            for (int i = place; i >= 0; i--)

            {

                result = result + perm[i].ToString();

            }

            for (int i = 0; i < result.Length - 1; i++)

            {

                sum += Int32.Parse(result[i].ToString());

            }

            return result;

        }

 

I still have to do Euler 18 which will probably use a shortest-path algorithm. There are so far 221 problems.

Monday, December 08, 2008

Displaying a list of user selected parameters in Reporting Services

I’m generating a notice that the user will need to select reasons for an application was rejected. The user could select multiple reasons, but must include at least one. So I needed to display the reasons of rejection in the report like:

* Reason1

* Reason2

*Reason4

The problem I was running into was checking how many reasons were selected and displaying only the selected amount. I was at first trying something like this for all counts of Parameters!Reasons:

=IIF(Parameters!Reasons.Count < 2, “”, “* “+Parameters!Reasons.Value(1))

The problem with this is, even though the count was less than 2 the false part of the IIF still gets evaluated, giving me an “#Error” in my document with an index out of bounds.

I then got cleaver and tried using the join and came up with this:

="* " + Join(Parameters!Reasons.Value,VbCrLf+VbCrLf + "* ")

While, normally a join would use something like a whitespace or comma to delimit.

Friday, October 31, 2008

Updated Fractal Viewer

I just updated my Fractal Viewer and is now downloadable from my SkyDrive.

What I did:

  • Convert from .Net 1.1 to .Net 3.5
  • Add little performance enhancements (parallel processing, bit shifting, less use of division, less converting, etc…)
  • Changed the structure of the program. Where before it was more like a C style program with one large Main() function. Now it incorporates a more OOP style.
  • Remove unnecessary imports.
  • Add “precision” functionality to the Fractals.
  • Move the Complex Systems on the screen to take up more room.
  • Made color changes take effect immediately, instead of having to refresh.

I don’t see much of a speed improvement, since there is not much I can do the functions to improve them. I was hoping to incorporate other techniques like asynchronous,  threading, background workers, or better use of parallel processing,  but this couldn’t be done because only one use of the control’s graphics can be used at a time.

box julia mandel newton sierp

Check list of what I still want to do:

  • Look into more improvements by trying to separate  the drawing and point generating.
  • Add more Complex Systems and Fractals.
  • Try getting a zoom and move feature.
  • Improve color picking technique.
  • Improve image saving and add location to save to.
  • If possible, improve image detail of complex systems.

Friday, October 03, 2008

Some Cool Powershell Commands

A list of useful and fun commands to remember.

1) Using wmiobject

get-wmiobject -list | where {$_.name -like "win32*"} | more
to get a list of classes that provide great information about your computer. Some uses are…


get-wmiobject -class win32_quickfixengineering

(return a history of all patches installed on your computer)


get-wmiobject -class win32_service | where {$_.name -like 'IISADMIN'}

(return if you are running IIS)

2) Using get-childitem

get-childitem c:\ Measure-Object -Character -Word -Line

Lines
-----

89

get-childitem c:\ -force Measure-Object -Character -Word -Line

Lines
-----
141

force hidden files to be visible.

(get-childItem c:\Eftmcon).Count
counting how many items are in a folder.

3) Using select-string and out-string

select-string -path 001460_20081002_1.dat -pattern "2007[0-9]*"
find all lines from a file matching 2007 followed by zero or more numbers and display what that line would look like.

gc crm3.txt | out-string -stream | foreach {$_ -replace "2007","2008"} > text.txt

This will at least replace all 2007 for 2008 and write it out to a file of your choice. Here I use get-content to read in a file in which I then pipe it to out-string to send it out as one string and do my replace.

4) Playing with Merlin

$agent = new-object -com Agent.Control.2
$agent.Connected = 1
$agent.Characters.Load("Merlin")
$merlin = $agent.Characters.Character("Merlin")
$merlin.Show()
$merlin gm

Display Merlin

$merlin.Play("DoMagic1")
Make him animate a move from the $merlin.AnimationNames list

Sources:

Edited: Removed an extra PS in the Merlin.

Edited (10/14/2008): Added the missing "pipes" and "greater than" sign back in, since they were missing.

Tuesday, September 30, 2008

Finding smallest whole number on Google

The Math Factor Podcast was wondering what was the lowest number that Google did not archive.

I figured, a Powershell script would be fun to make to solve this problem. Here is what I wrote so far:

 

clear-variable -name doc
clear-variable -name link
clear-variable -name anchors
clear-variable -name ie
clear-variable -name Notfound

$ie = new-object -com "InternetExplorer.Application"
$Notfound = $true
$i = 1000
$ie.navigate("http://www.google.com/search?hl=en&q=" + $i + "&btnG=Search")
Start-Sleep –s 3

while($Notfound)
{
   $doc = $ie.document

       $anchors = $doc.getElementsByTagName("a")
       "Searching number: " + $i
       $j = $i
       foreach ($link in $anchors)
       {
               if($link.href)
               {
              $link.href
                     if($link.href.StartsWith("http://www.google.com/swr?q="))
                  {
                     $i = $i + 1
                                $ie.navigate("http://www.google.com/search?hl=en&q=" + $i + "&btnG=Search")
                Start-Sleep –s 3
                clear-variable -name doc
                 clear-variable -name link
                clear-variable -name anchors
                  }
               }
       }

        if($j -eq $i)
       {
              $Notfound = $false
              "Number not found: " + $i
       }
}

 

I ran into the problem of my program running to fast, which is why I had to add “Start-Sleep –s 3”. This makes the program wait 3 seconds for google to reply.

The problem with a time delay is, lets assume the number is 1 Million. It would basically take me 34 days to reach the number.

I guess if I has a independent server, I could solve this and let it run for a year.

Thursday, August 28, 2008

Timeout Errors Prevention

After a while, you may end up getting complaints or request dealing with timeout issues. I’m going to use this post to help collect some ways to increase the timeout seconds and prevent errors from happening.

*Note: Even though you increase the timeout seconds, timeouts might still occur but with a longer delay then before. This might make your customers even more upset because of the longer wait for the error to display.

  • In code, increase the sqlCommand timeout. Ex:
     
  • Dim myCommand As New SqlCommand("[dbo].[spSetUserPreferences]", myConnection)

    myCommand.CommandType = CommandType.StoredProcedure
    'change default time out setting
    myCommand.CommandTimeout = 120

  • In code, increase the connection’s string timeout by appending “Connection Timeout=” to it. Ex:

    Data Source=mydatabase;Initial Catalog=Match;Persist Security Info=True;User ID=User;Password=password;Connection Timeout=120
  • On SQL-Server 2005, In management studio’s Tools > Option > Designers Increase the “Transaction time-out after:” even if  “Override connection string time-out value for table designer updates” checked/unchecked. 
  • Make (non-dynamic) stored procedures instead of using inline sql statements within the code. This will also allow for easy fixes instead of having to recompile and deploy for future changes.

 

If you have any other suggestions, please contact me so I can add them to the list.

Tuesday, July 01, 2008

Bulk Export from SQL Server into a CSV file

Well, here is a simple query/stored procedure that you can run to bulk export the tables in a database into a csv file.

Just change the “databaseName” in the file to the one you want to point to and also change the location if you wish. Currently it is the C:\ drive.

 

DECLARE @var nvarchar(MAX)

DECLARE curRunning
CURSOR LOCAL FAST_FORWARD FOR
select name from sysobjects where type = 'U'

Open curRunning

Fetch NEXT From curRunning into @var

WHILE @@FETCH_STATUS = 0
BEGIN
    --select 'exec master.dbo.xp_cmdshell ''bcp databaseName.dbo.' + @var + ' out C:\' + @var + '.csv -c -T -t ,'''
    DECLARE @Exec nvarchar(MAX)
    set @Exec = 'exec master.dbo.xp_cmdshell ''bcp databaseName.dbo.' + @var + ' out C:\' + @var + '.csv -c -T -t ,'''
    execute sp_executesql @Exec
FETCH NEXT FROM curRunning into @var
END

close curRunning
DEALLOCATE curRunning

Wednesday, March 12, 2008

WCF Binding Info

BasicHttpBinding

Element Collection

System.ServiceModel.Channels.TextMessageEncodingBindingElement
System.ServiceModel.Channels.HttpTransportBindingElement

Support Features

  • Transport-Level Security
  • Message-Level Security
  • WS-*Interoperability

Use if

  • Need basic level of interoperability

Performance : Good

Communication

  • Request/Reply
  • One-Way


WSHttpBinding

Element Collection

System.ServiceModel.Channels.TransactionFlowBindingElement
System.ServiceModel.Channels.SymmetricSecurityBindingElement
System.ServiceModel.Channels.TextMessageEncodingBindingElement
System.ServiceModel.Channels.HttpTransportBindingElement

Support Features

  • Transport-Level Security
  • Message-Level Security
  • WS-*Interoperability
  • WS-*Transactions
  • Reliable Sessions / Reliable Messaging

Use if

  • Need WS-* level of interoperability

  • Don't need duplexing

  • Don't need federated security

Performance : Good

Communication

  • Request/Reply
  • One-Way


WSDualHttpBinding

Element Collection

System.ServiceModel.Channels.TransactionFlowBindingElement
System.ServiceModel.Channels.ReliableSessionBindingElement
System.ServiceModel.Channels.SymmetricSecurityBindingElement
System.ServiceModel.Channels.CompositeDuplexBindingElement
System.ServiceModel.Channels.OneWayBindingElement
System.ServiceModel.Channels.TextMessageEncodingBindingElement
System.ServiceModel.Channels.HttpTransportBindingElement

Support Features

  • Transport-Level Security
  • Message-Level Security
  • WS-*Interoperability
  • WS-*Transactions
  • Reliable Sessions / Reliable Messaging

Use if

  • Need WS-* level of interoperability

  • Need Duplexing

Performance : Good

Communication

  • Request/Reply
  • One-Way
  • Duplex


NetTcpBinding

Element Collection

System.ServiceModel.Channels.TransactionFlowBindingElement
System.ServiceModel.Channels.BinaryMessageEncodingBindingElement
System.ServiceModel.Channels.WindowsStreamSecurityBindingElement
System.ServiceModel.Channels.TcpTransportBindingElement

Support Features

  • Transport-Level Security
  • Message-Level Security
  • WS-*Transactions
  • Reliable Sessions / Reliable Messaging

Use if

  • Don't need interoperability

  • Is not local

  • Don't need queuing

  • Don't need peer networking

Performance : Better

Communication

  • Request/Reply
  • One-Way
  • Duplex


NetNamedPipeBinding

Element Collection

System.ServiceModel.Channels.TransactionFlowBindingElement
System.ServiceModel.Channels.BinaryMessageEncodingBindingElement
System.ServiceModel.Channels.WindowsStreamSecurityBindingElement
System.ServiceModel.Channels.NamedPipeTransportBindingElement

Support Features

  • Transport-Level Security
  • WS-*Transactions

Use if

  • Don't need interoperability

  • Is local

Performance : Best

Communication

  • Request/Reply
  • One-Way
  • Duplex


NetMsmqBinding

Element Collection

System.ServiceModel.Channels.BinaryMessageEncodingBindingElement
System.ServiceModel.Channels.MsmqTransportBindingElement

Support Features

  • Transport-Level Security
  • Message-Level Security
  • Durable Reliable Messaging

Use if

  • Don't need interoperability

  • Is not local

  • Need Queuing

  • Don't need legacy MSMQ

Performance : Better

Communication

  • One-Way


NetPeerTcpBinding

Element Collection

System.ServiceModel.Channels.PnrpPeerResolverBindingElement
System.ServiceModel.Channels.BinaryMessageEncodingBindingElement
System.ServiceModel.Channels.PeerTransportBindingElement

Support Features

  • Transport-Level Security

Use if

  • Don't need interoperability

  • Is not local

  • Need queuing

  • Need peer networking

Performance : Good

Communication

  • One-Way
  • Duplex


MsmqIntegrationBinding

Element Collection

System.ServiceModel.MsmqIntegration.MsmqIntegrationBindingElement

Support Features

  • Transport-Level Security
  • Durable Reliable Messaging

Use if

  • Don't need interoperability

  • Is not local

  • Need queuing

  • Need legacy MSMQ

Performance : Better

Communication

  • One-Way


WSFederationHttpBinding

Element Collection

System.ServiceModel.Channels.TransactionFlowBindingElement
System.ServiceModel.Channels.SymmetricSecurityBindingElement
System.ServiceModel.Channels.TextMessageEncodingBindingElement
System.ServiceModel.Channels.HttpTransportBindingElement

Support Features

  • Transport-Level Security
  • Message-Level Security
  • WS-*Interoperability
  • Reliable Sessions / Reliable Messaging

Use if

  • Need WS-* level of Interoperability

  • Don't need duplexing

  • Need federated security

Performance : Good

Communication

  • Request/Reply
  • One-Way

WS2007HttpBinding

Element Collection

System.ServiceModel.Channels.TransactionFlowBindingElement
System.ServiceModel.Channels.SymmetricSecurityBindingElement
System.ServiceModel.Channels.TextMessageEncodingBindingElement
System.ServiceModel.Channels.HttpTransportBindingElement

Support Features

  • Transport-Level Security
  • Message-Level Security
  • WS-*Interoperability
  • WS-*Transactions
  • Reliable Sessions / Reliable Messaging

Use if

  • Need WS-* level of Interoperability

  • Don't need duplexing

    Don't need federated security

Performance : Good

Communication

  • Request/Reply
  • One-Way


WS2007FederationHttpBinding

Element Collection

System.ServiceModel.Channels.TransactionFlowBindingElement
System.ServiceModel.Channels.SymmetricSecurityBindingElement
System.ServiceModel.Channels.TextMessageEncodingBindingElement
System.ServiceModel.Channels.HttpTransportBindingElement

Support Features

  • Transport-Level Security
  • Message-Level Security
  • WS-*Interoperability
  • Reliable Sessions / Reliable Messaging

Use if

  • Need WS-* level of Interoperability

  • Don't need duplexing

  • Need federated security

Performance : Good

Communication

  • Request/Reply
  • One-Way

Tuesday, March 04, 2008

WCF Error: HTTP could not register URL http://+:80/Temporary_Listen_Addresses// because TCP port 80 is being used by another application

So I was doing a dual http binding (WSDualHttpBinding) [page 53-54 in Essential Windows Communication Foundation For .Net Framework 3.5] when I got the error above. I doubled checked by running the svcutil and the wizard, but with no luck.

 

Found the solution at(http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2782499&SiteID=1)

 

Just need to include the clientBaseAddress attribute with a URI in the binding tag, since the default is using port 80.

 

<?xml version="1.0" encoding="utf-8"?>

<configuration>

   <system.serviceModel>

      <bindings>

         <wsDualHttpBinding>

               <binding   name="WSDualHttpBinding_IServerStock"

                        closeTimeout="00:01:00"

                        openTimeout="00:01:00"

                        receiveTimeout="00:10:00"

                        sendTimeout="00:01:00"

                        bypassProxyOnLocal="false"

                        transactionFlow="false"

                        hostNameComparisonMode="StrongWildcard"

                        maxBufferPoolSize="524288"

                        maxReceivedMessageSize="65536"

                        messageEncoding="Text"

                        textEncoding="utf-8"

                        useDefaultWebProxy="true"

                        clientBaseAddress="http://localhost:8001/WCFDuplexService">

               <readerQuotas   maxDepth="32"

                           maxStringContentLength="8192"

                           maxArrayLength="16384"

                           maxBytesPerRead="4096"

                           maxNameTableCharCount="16384" />

               <reliableSession   ordered="true"

                              inactivityTimeout="00:10:00" />

               <security   mode="Message">

                  <message   clientCredentialType="Windows"

                           negotiateServiceCredential="true"

                           algorithmSuite="Default" />

               </security>

            </binding>

         </wsDualHttpBinding>

      </bindings>

      <client>

         <endpoint   address="http://localhost:8000/WCFDuplexService"

                  binding="wsDualHttpBinding"

                  bindingConfiguration="WSDualHttpBinding_IServerStock"

                  contract="IServerStock"

                  name="WSDualHttpBinding_IServerStock">

            <identity>

               <userPrincipalName value="wandrus@mbsnav.com" />

            </identity>

         </endpoint>

      </client>

   </system.serviceModel>

</configuration>