xsummary.com

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:

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.

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.

1. Download and install this.
2. Download this file and unzip it to
   C:\Program Files (x86)\Microsoft SDKs\Windows Phone\v7.0\Emulation\Images
3. 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}

1. Sign up at Assembla and create a space with Free GIT Hosting
2. Do this
3. Start >> Run >> puttygen
4. Generate Private and Public Keys. Save them.
5. Copy the public key and add it to the GIT space we created at Assembla.
   
6. Right click a folder on your local system and create a Git repository.
7. Right click the local Git repository folder, TortoiseGit >> Settings >> Git >> Remote
   Name: Name of project
   URL: Assembla PUSH URL under the project
   Putty: Load the private key you exported earlier
8. Finally, create the “master” branch for the first time, by right clicking on the Git repository folder and clicking “Git Commit –> master""
9. Entitle the message “initial” and check the “Select / Deselect All” box, click “Ok”
10. Finally, click the “Push” button and click “Ok”
11. Success!!

1. Download SkyDrive Simple Viewer – which, very simply, lists the URLs associated with your SkyDrive account (screenshot below)
   
2. Right click “My Computer”, click “Map network drive”, choose a drive letter, paste a URL returned from DumpUrls.exe into the “Folder” text box and click “Finish”
3. Provide your Windows Live ID username and password.
4. Done!

Unfortunately, SQL 2005 is unable to restore .BAK files created by SQL 2008. Subsequently, SQL 2005 is unable to attach MDF and LDF files created by SQL 2008.

Here are the steps to copy a SQL 2008 database to SQL 2005.

1. From SQL 2008, right click on the database, click Tasks >> Generate Scripts
   
2. The “Generate and Publish Scripts” wizard is displayed. Click Next
   
3. Take the default, which should be, “Script entire database and all database objects”. Unless of course, you don’t want the whole database. In this case you can select tables, views, etc.
   
4. For the export options, make sure “Save to file” is selected. Additionally, give a unique name for the generated sql file. In this example, we are exporting the SAMINC database, so we have titled the sql export file, saminc.sql.
   
5. Almost there! Click “Advanced”
   
6. From the “Advanced Scripting Options” make two changes. Change “SQL for Server Version” to “SQL Server 2005” and change “Types of data to script” to “Schema and data”.
   
7. Click “OK” to close the “Advanced Scripting Options” and click “Next”.
8. After the wizard finishes, copy the resulting sql file to the SQL 2005 server.
9. Open SQL Management Studio. From within SQL Management Studio, click File >> Open and select the resulting sql file.
10. IMPORTANT!!! Finally, change the directory to the correct data directory.
    

A quick way to add jQuery to your Visual Studio 2010 projects. The example utilizes Microsoft’s Content Delivery Network (CDN) to serve up the jQuery include file and the jQuery vsdoc file required for Intellisense. Simply copy, paste and rebuild your project.

<script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.4.2.min.js" type="text/javascript"></script>
<script src="http://ajax.microsoft.com/ajax/jQuery/jquery-1.4.1-vsdoc.js" type="text/javascript"></script>

Here is an example of the Intellisense.

A well put together deck on Windows Azure. Simple. Clean. Detailed.

How to QUICKLY delete a MSSQL transaction log (LDF file) without affecting production.

USE di_mas_agr – name of database

GO

DBCC shrinkfile(‘DI_MAS_AGR_log’, 1) – name of log file under Database properties

BACKUP LOG di_mas_agr WITH truncate_only – name of database

DBCC shrinkfile(‘DI_MAS_AGR_log’, 1) – name of log file under Database properties

GO 

UPDATE: The above doe NOT work for SQL 2008. Here is the work around for SQL 2008.