Checking blocked transactions in SQL Server

This is probably very well known, but I think it’s an important part of a developers arsenal. Imagine this scenario: Your application fails to perform its actions. You may even see an error similar to “Timeout expired. The timeout period elapsed prior to completion of…

Changing screen orientation in Windows 7

Today I managed to accidentally hit the keyboard shortcut to rotate the screen orientation 90 degrees. It was quite a surprise. After wrestling with the mouse, I managed to search up what keys I had managed to press and was able to resolve the issue….

DateTime Conversion Formats in SQL Server

I found an answer on StackOverflow.com to a question on different DateTime conversions. The following script will provide an example of every possible DateTime conversion in SQL Server. Having a visual like this is extremely helpful when deciding what conversion code is right for you….

Scripting AWS commands with Windows Powershell

Lately I’ve been doing a lot of work writing Powershell scripts to automate some deployment tasks for our application environment in the cloud. The environment is hosted with Amazon Web Services (AWS), which provides a toolkit to accept commands via Powershell. As part of our…

Lazy Instantiation

Today I learnt a lesson on Lazy Instantiation with C#. The lesson came from a bad (and rookie) oversight that I had made with setting up properties on a class. I had a class similar to the following [CSHARP] public class MyClass { public int…

LINQ – Deterred Execution

I won’t go into specific detail in this post on Deterred Execution with LINQ, as I am mainly posting this for anyone (and certainly myself) to keep this post by Charlie Calvert in mind whenever working with LINQ. Deterred Execution is definitely something that could catch a developer…

Executing programs in Windows Powershell

I’m used to executing programs via Windows Command Prompt (cmd) by doing either Setting the current directory to the executable location path, and then calling the executable e.g. >> cd C:ParentFolderChildFolder >> MyExec.exe /Commands OR Entering the executable path and the executable in quotes e.g. “C:ParentFolderChildFolderMyExec.exe” /Commands…