Remove Duplicate rows from table - SQL Server I just came to a situation where I have duplicate entries in a table (all fields are identical) and I want to remove the duplicates. After a search I found a simple solution for my problem. In my case, there were 2 duplicate entries for each record.... [More]
Fix - Cannot connect to WMI provider – Invalid class - SQL Server 2008 When I tried to open the SQL Server Configuration Manager, it was showing the error message above. I just had a search and found an article on Martin Poon - Microsoft MVP blog [SQL Server], which have a solution for this issue, It tells to Run the f... [More]
Collection of Visual Studio color schemes and Visual Studio Wallpapers Studiostyl.es is a web site where you can Share/Create /Download Visual studio color schemes. You can see few samples below Some of the themes will make your eyes feel better when you code. If you need to create your own color scheme you can cre... [More]
Expresso - Free DOTNET regular expression development tool Features Build complex regular expressions by selecting components from a palette Test expressions against real or sample input data Display all matches in a tree structure, showing captured groups, and all captures within a group Build... [More]
Search Engine Optimization - Redirecting Old URLs to New URLs permanently with Http Status Code 301 - BlogEngine.Net If you are using BlogEngine.Net When you change the Slug of a Page or Post your URL will change and all the previous Backlinks or Old Bookmarks will stop working and will show a 404 Error. To Solve this issue, you can use a BlogEngine.Net exte... [More]
Random Post Control for BlogEngine.Net First of all, this control is not developed by me. I have just downloaded and made some changes to the control written by Paul Tumelty, you can read more and download about the Random Post Link Generator Control for BlogEngine.Net he developed.... [More]
Free SQL Script Generator - generate scripts to recreate the data, tables, stored procedures, views, triggers, keys, indexes and more. Using SQLScriptGenerator you can connect to your local or remote SQL Server and generate T-SQL script of the whole database or just database structure or just data or specific database objects. In the result it generates one or several *.s... [More]
SQL Server 2008 - Reducing log file size Today we had a server space issue, and I found that Log file of a Database is nearly 16GB and which caused the issue. As usual I tried to Truncate the log file using DBCC SHRINKFILE(Log-Name, Size) Which did not do the trick. So I had a searc... [More]
Image optimizer extension for Visual Studio 2010 Mads Kristensen wrote an Extension for Visual Studio 2010 to optimize images inside folders with just one click. This extension will be really helpful for Web developers where the image size is an issue always. You can select one more more folders (... [More]
Free eBook - Programming Windows Phone 7 Earlier we have posted about the second draft of Programming Windows Phone 7. Now you can download the complete eBook for free. This book include 24 chapters. Part I The Basics 1 Hello, Windows Phone 7 Targeting Windows ... [More]