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:
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!
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 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! 
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.
variable = (condition) ? true-value : false-value;
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
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!
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.
