Query SQL Server using PowerShell

I don’t understand why it was so difficult for me to find an example on this, so I compiled one from three posts so I could put it here: [crayon-5ba20f91aea74076164033/] Enjoy...

Extension Methods: Straight to the Point!

I kept looking at many articles on extension methods and for some reason I couldn’t get mine to work. It then dawned on me that the class where you declare you extension methods MUST BE STATIC. ...

C# String PadLeft() and PadRight()

This has been an irritating method to use especially when you don’t use it too often. Here are some tips about using PadLeft() and PadRight(). First off it is not a static method, you need an in...

Remoting Servers 101

Before I jump into this, I just want to explain that Remoting is an old .Net v1.1 technology and it is no longer supported. However it still gets the job done if that is what you are using already or ...

Remoting Server Troubleshooting

If you are having trouble with getting remoting to function properly and you know you have everything configured properly then it is more than likely caused by a bad or incomplete dll. Here is a list ...

SQL Server: Tips on Declaring a Decimal Data Type

One of my pet peeves about SQL Server is the decimal data type. Declaring it once in a table where you don’t have to do any math on it is normally okay, but I get very confused when I have to ta...

Blog Title

I changed the title of my blog because I am going to encompass all topics that have baffled me or confused me. I haven’t gotten around to it yet, but I am going to post about an irrigation syste...