Blog of The Green Dragon Empire - Prime™


December 7, 2011

iPhone delete Other


Problem Solved!!

Resolution (If Jailbroken IPhone).


> Delete all files from the /private/var/mobile/Media/iTunes_Control/Music folder using WinSCP.


Resolution (If Not Jailbroken)


> Restore your iPhone..


October 24, 2011

SQL SERVER – 2005 – Create Script to Copy Database Schema and All The Objects


October 3, 2011

Diablo III Beta enUS Setup MAC OSX


Here is the Diablo 3 beta for Mac

sql server,windows

September 30, 2011

An Introduction to Clustered and Non-Clustered Index Data Structures


When I first started using SQL Server as a novice, I was initially confused as to the differences between clustered and non-clustered indexes. As a developer, and new DBA, I took it upon myself to learn everything I could about these index types, and when they should be used. This article is a result of my learning and experience, and explains the differences between clustered and non-clustered index data structures for the DBA or developer new to SQL Server. If you are new to SQL Server, I hope you find this article useful.

sql server,windows

September 29, 2011

Top 10 Hidden Gems in SQL Server 2005



  • Table Difference tool allows you to discover and reconcile differences between a source and destination table or a view. Tablediff Utility can report differences on schema and data. The most popular feature of tablediff is the fact that it can generate a script that you can run on the destination that will reconcile differences between the tables. TableDiff.exe takes 2 sets of input;
    • Connectivity – Provide source and destination objects and connectivity information.
    • Compare Options – Select one of the compare options
      • Compare schemas: Regular or Strict
      • Compare using Rowcounts, Hashes or Column comparisons
      • Generate difference scripts with I/U/D statements to synchronize destination to the source.

TableDiff was intended for replication but can easily apply to any scenario where you need to compare data and schema.

You can find more information about command line utilities and the Tablediff Utility in Books Online for SQL Server 2005.



stream from iphone to mac


iOS 4.2.1 supports watching videos from your iPhone, iPad and iPod Touch to a television, a coolest offering from AirPlay, but only limited to Apple TV. In brief, this means that you need to have a Apple TV 2G along with iPhone, iPod Touch or iPad to enjoy the service.


Typically apple. Intentionally crippling another service to make a quick buck. I’ll never pay!

Hopefully you have arrived at this page BEFORE fruitlessly searching google and coming up with nada.

From arstechnica

An independent developer has cracked the private key used in Apple’s AirPort Express to stream music to approved speakers, potentially allowing third-party software and hardware to receive AirPlay streams without paying Apple’s licensing fee. Developer James Laird has released his work as an open source project called ShairPort. While still in its early stages, the project could upset Apple if anyone besides home tinkerers decide to make use of it.

Be sure to read on how to make/compile for your system!