Programming Archives ⋆ Page 7 of 9 ⋆ Programming and Tech Blog

Exporting SQL Query Results to a CSV file using SQLCMD and C#

Programming

by Dirk Strauss - March 8, 2013November 19, 2018 1311454

Today a colleague asked me how to export SQL Query Results to a CSV file. This got me thinking that it would be a nice exercise to do this from a C# application. So to start off, I downloaded the correct AdventureWorks database for my version of SQL from the following

C# Programming – Caller Information Attributes

Programming

by Dirk Strauss - March 4, 2013November 2, 2016 04986

Okay, so I don't have a specific series for this and seeing as this is more of a programming tip, I'll leave it out of the Visual Studio 2012 Tips series. Caller Information Attributes are a very useful and probably underutilized feature implemented in the C#5.0 Compiler. Caller Information Attributes

Why I Fall In Love With Code Each And Every Day

Programming

by Dirk Strauss - March 1, 2013 15962

You know that feeling when you are in the groove, and the code just flows? You might be listening to music (Pink Floyd or Ahmad Jamal is my code music) or sitting in complete silence. You might code to Slayer blasting in your ears or flourish in the hum drum

Typical Developer’s Life… in GIF’s (How you feel when…)

Programming

by Dirk Strauss - February 18, 2013November 16, 2018 310037

Typical Developer's Life - I really enjoy these GIF's that illustrate a different meaning than the original scene they were taken from. I decided to create a few myself, just for the fun of it. If you know of some really funny ones, let us know in the comments. Also

Debugging Windows Services using an #if Directive

Programming

by Dirk Strauss - November 26, 2012November 2, 2016 27009

Debugging Windows Services - I love writing them. In fact, to encompass a unit of functionality in a self contained bit of code is incredibly powerful. That is, if it is written correctly. I think it is something we as programmers take a bit for granted. One thing I know, is that

Backwards Compatibility of SQL Server Management Objects (SMO)

Programming

by Dirk Strauss - November 22, 2012November 2, 2016 06611

Recently I had an issue where a Web Application stopped working when a SQL Server Migration took place. The SQL Server was moved to a new physical server, but in addition to that they upgraded SQL Server from 2005 to 2008 R2. The problem turned out to be the SMO

Calling a .NET DLL From VBScript

Programming

by Dirk Strauss - November 20, 2012November 2, 2016 1036420

Recently I have had to call a .NET Dll from a VBScript. Why would I need to do this I hear you ask? Well sometimes it is easier to do certain things in .NET or you might have previously written functionality in a .NET DLL that you now need to

South African ID Number Validation in C#

Programming

by Dirk Strauss - November 16, 2012November 15, 2018 438727

South African ID Number Validation - There are many reasons a developer in South Africa would need to validate a South African ID number. They might need to validate the input on an Online order form. They might need it as a form of identification for a loan etc. How exactly

Import Application Option missing in IIS Manager

Programming

by Dirk Strauss - November 23, 2011November 18, 2016 817577

With the release of Visual Studio 2010 came support to package up your ASP.NET Web Application. This also packages dependencies like the web.config, databases etc. An administrator can then import the created package via the Import Application option in IIS Manager. When I first read about this option, I thought

Add External Tools (All-In-One Code Framework v4) to Visual Studio 2010

Programming

by Dirk Strauss - October 4, 2011April 26, 2021 23482

Today saw the All-In-One Code Framework Sample Browser updated to Version 4. I have to say, that I really love the look and feel of this latest version. Now while I know that there is a Sample Browser Visual Studio Extension for 2010, I feel that version 4 looks nicer and I