xsummary.com

SQL – A count of all rows in all tables

Ryan Lowdermilk — Fri, 03 Sep 2010 20:24:23 +0000

Need to count the number of rows in each table of a database. Here you go.

SELECT
    [TableName] = so.name,
    [RowCount] = MAX(si.rows)
FROM
    sysobjects so,
    sysindexes si
WHERE
    so.xtype = ‘U’
    AND
    si.id = OBJECT_ID(so.name)
GROUP BY
    so.name
ORDER BY
    2 DESC

Here is what the results look like:

Increase the speed your Remote Desktop sessions!

Ryan Lowdermilk — Thu, 02 Sep 2010 21:53:15 +0000

If you use Remote Desktop as often as I do, this command is like holy water!

Start >> Run >> cmd

netsh interface tcp set global autotuninglevel=highlyrestricted

Done! Prepare for grease lighting!

TeraCopy – Transfer files at the speed of light!

Ryan Lowdermilk — Thu, 02 Sep 2010 21:36:25 +0000

I needed to copy 60GB worth of file/folders from one server to another. I needed to transfer the files as quickly as possible. Teracopy to the rescue!

Teracopy couldn’t be easier to use. Simply highlight and drag the files you want to copy and drop them on Teracopy. Next, click on the the link, labeled “Target Folder” and specify the target/destination. Finally, click “Copy”. Full throttle baby!!!

Per Code Sector’s website, author of Teracopy:

TeraCopy is a compact program designed to copy and move files at the maximum possible speed, providing the user with a lot of features:

Copy files faster. TeraCopy uses dynamically adjusted buffers to reduce seek times. Asynchronous copy speeds up file transfer between two physical hard drives.

Pause and resume file transfers. Pause copy process at any time to free up system resources and continue with a single click.

Error recovery. In case of copy error, TeraCopy will try several times and in the worse case just skip the file, not terminating the entire transfer.

Interactive file list. TeraCopy shows failed file transfers and lets you fix the problem and recopy only problem files.

Shell integration. TeraCopy can completely replace Explorer copy and move functions, allowing you work with files as usual.

Full Unicode support.

Windows 7 x64 support.

Trillian – Advanced Automation!

Ryan Lowdermilk — Tue, 31 Aug 2010 19:17:38 +0000

Trillian has a feature which allows automation of routine tasks. I encourage you to explore some of the options – the combinations are endless. Here is one I use all the time to toggle the visibility of my contact list. Give it a whirl – steps are below.

Go to Trillian Preferences

Then to Sound and Notifications and click Automation

Click Add

Use the following settings

Save and close Preferences. Now toggle hold down Windows Key and press A

Woooooo awwwwww. Well .. I like it!

Understanding MVVM (Model, View, ViewModel) for Silverlight and Windows Phone in 3 easy steps!

Ryan Lowdermilk — Sat, 28 Aug 2010 16:16:25 +0000

I have scoured the inter-webs, in search for lucid, succinct, distilled, information pertaining to MVVM. With little exposure to MVVM, I wanted to gain a high level understanding of MVVM. I also wanted to get my hands dirty and apply my new found knowledge to personal/business related projects. I compiled the below list after reading lots of articles and listening to several podcasts, screencasts and videos.I felt the resources below helped “get the ball rolling” in my attempt to better understand MVVM. So without further a due, “3 easy steps to understanding MVVM”

Step 1 – Foundation

First, the video by Craig Shoemaker and Tim Huer.The video serves as a foundation piece – In some way, helps to wrap a fence around MMVM.

Step 2 – Architecture

Next, Josh Smith, considered by most at Microsoft to be the thought leader of MVVM, has written an MSDN article entitled “WPF Apps with the Model-View-ViewModel Design Patern” I read it. It’s good and very complete! Josh recently released a MVVM book entitled “Advanced MVVM” (e-book here). The book has received praise and some critiques. Regardless of the critiques, Josh continues to pave the way and evangelize proper thinking when utilizing and harnessing the power of MVVM.

Step 3 - Structure

Next, David Gadd’s tutorial entitled, “Building a Windows Phone 7 app with MVVM pattern, using TDD and mock objects” This tutorial is feature complete (UI, data binding and unit testing). Excellent work David!

UPDATED: Laurent Bugnion, author of MVVM Light Toolkit, discussed MVVM at TechDays 2010. At the time of research Channel 9 hadn’t utilized a “MVVM” tag . Thankfully Laurent brought it to my attention.

Javascript – A shorter “IF…THEN” statement

Ryan Lowdermilk — Mon, 16 Aug 2010 21:26:44 +0000

variable = (condition) ? true-value : false-value;

Windows Phone 7 Jump Start – Download

Ryan Lowdermilk — Sat, 14 Aug 2010 21:31:54 +0000

The infamous Rob Miles and notorious Andy Wigley walkthrough, architecture, building, selling and debugging XNA and Silverlight applications for Windows Phone 7. The exhaustive, 12 hours of coverage is a great way to get jump started into development for Windows Phone 7. All 12 sessions can be found below. Enjoy!!

(Session 1 of 12): Introduction
Download | More Info

(Session 2 of 12): Building a Silverlight Application, Part 1
Download | More Info
UPDATED: 8/14/2010 – Two things, #1The video retrieved from the ‘Download’ link above, when viewed, stops after 19 minutes AND #2 The only video available is Zune (small), found here. I have sent a tweet to Rob Miles. Hopefully Microsoft will upload the full video for the ‘Download’ link above.

(Session 3 of 12): Building a Silverlight Application, Part 2
Download | More Info

(Session 4 of 12): Building Games for the Windows Phone 7 Platform
Download | More Info

(Session 5 of 12): Building XNA Games for the Windows Phone 7 Platform, Part 1
Download | More Info

(Session 6 of 12): Building XNA Games for the Windows Phone 7 Platform, Part 2
Download | More Info

(Session 7 of 12): Advanced Application Development, Part 1
Download | More Info

(Session 8 of 12): Advanced Application Development, Part 2
Download | More Info

(Session 9 of 12): Advanced Application Development, Part 3
Download | More Info

(Session 10 of 12): Marketing Your Windows Phone 7 Application
Download | More Info

(Session 11 of 12): Working with Media
Download | More Info

(Session 12 of 12): Final Silverlight Topics and Wrap-Up
Download | More Info

Creating new records in SageCRM and returning the resulting primary keys

Ryan Lowdermilk — Thu, 12 Aug 2010 22:16:52 +0000

For example, let’s say you have created a table entitled “Shipments”, through the SageCRM Create Table interface. Then, let’s say, from an ASP page, you create a new record in this “Shipment” table. For example:

ShipmentRecord = CRM.CreateRecord(“Shipment”);
Shipment.ship_trackingnumber = “1Z12312312123”;
Shipment.SaveChanges();
NewId = Shipment.RecordId;

The last command, will return the newly created primary id.

Very cool!

Mount ISOs in Windows 7 x64 for FREE!

Ryan Lowdermilk — Thu, 12 Aug 2010 17:19:00 +0000

Magic ISO, Inc. maker of “Magic ISO Maker” also provides a FREE application to mount ISO files. What’s more? They offer a 64-bit version for Windows 7 x64! Of course, they also offer a 32-bit version for Windows XP/Vista/7.

Download here.

Running Windows Phone 7 unlocked (July build)

Ryan Lowdermilk — Fri, 06 Aug 2010 16:35:40 +0000

Download and install this.
Download this file and unzip it to
C:\Program Files (x86)\Microsoft SDKs\Windows Phone\v7.0\Emulation\Images
Run the emulator
"C:\Program Files (x86)\Microsoft XDE\1.0\XDE.exe" "C:\Program Files (x86)\Microsoft SDKs\Windows Phone\v7.0\Emulation\Images\WM70C1-6414-unlocked.bin" /VMID {E575DA31-FC47-4766-853F-018D823B9EE6}