{#advanced_dlg.about_title}

8 Free eBooks from Microsoft

Monday, 23 May 2011 10:02

Free ebook: Moving to Microsoft Visual Studio 2010 (10 chapters by by Patrice Pelland, Pascal Paré, and Ken Haines) Free ebook: Programming Windows Phone 7, by Charles Petzold (a 24-chapter gift from the Windows Phone 7 team and Microsoft Press) ... [More]

{#advanced_dlg.about_title}

Free Online Training on SQL Server 2008 R2

Monday, 02 May 2011 04:35

Free online training on SQL Server 2008 R2 on Virtual Tech Days. Date, Time and Topics 2nd May, 2011 (2:30 pm - 3:45 pm) - Managing and Optimizing Resources for SQL Server 3rd May, 2011 (2:30 pm - 3:45 pm) - Optimizing and Tuning Full Text Se... [More]

{#advanced_dlg.about_title}

Remove Duplicate rows from table - SQL Server

Tuesday, 19 April 2011 03:45

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]

{#advanced_dlg.about_title}

Fix - Cannot connect to WMI provider – Invalid class - SQL Server 2008

Sunday, 10 April 2011 23:38

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]

{#advanced_dlg.about_title}

Free SQL Script Generator - generate scripts to recreate the data, tables, stored procedures, views, triggers, keys, indexes and more.

Monday, 03 January 2011 01:10

  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]

{#advanced_dlg.about_title}

SQL Server 2008 - Reducing log file size

Tuesday, 28 December 2010 02:23

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]