Category Archives: Technology

sp_who2 Alternative (T-SQL, SQL Server)

The trusty "sp_who2" is a quick way to look at what’s happening on your SQL instance, but completely lacks the ability to filter using a WHERE clause. You may have to manually sift through hundreds of results to find what you need. Never fear. This quick script gives you the same basic output that sp_who2… Read More »

PowerShell With Uptime – Getting Days Only

There is a handy and free tool to check your system's uptime called "Uptime".  (Clever, no?)  It can be downloaded at http://uptimeexe.codeplex.com. While it is very easy to use (just navigate to it in a command window and type "uptime"), it doesn't give much of an option for formatting the output to include only the days.  So, a… Read More »

Android – Wi-Fi Battery Usage When Wi-Fi is Disabled

How could it be?  Wi-Fi is showing up as consuming 10% of your Android battery when wifi is turned off!  What gives? Android is sneaky, that’s what.  The Wi-Fi setting is more like a “use Wi-Fi for internet” setting.  In other words, your selection of that setting has nothing to do with the phone actually stopping the use… Read More »