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-5f92c3ed84eed136725851/] Enjoy...

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...

How to connect to a remote SQL Server

I posted about this on Stackoverflow.com http://stackoverflow.com/questions/2486610/how-to-connect-to-sql-server-from-another-computer/6765184#6765184 I think I will revisit this later to find the cor...

UPDATE SELECT FROM JOIN

This is something that I don’t do often, but it pops up every now and again. I always forget how to do it, so I have to look it up each time. Here is an example: [crayon-5f92c3ed892fb984425459/]...