Many time, colleagues come to me ask, they have setup SQL 2008 or SQL 2008 R2 for development or QA environment, but they don't know the login by which they can connect to server. In SQL server 2005, SQL use to add group BUILTIN\Administrators to the sysadmin fixed server role, meaning that any loc......

Just learned from focus.com's Editors article.In that they have identified Top 10 Largest Databases in the World, Here we have the list.
I)The Library of Congress (LC) boasts more than 130 million items ranging from cook books to colonial newspapers ......

Often, we will take the backup of a database and then we will maintain another copy of that file in a different location. Previously i used to do this in 2 steps. In first step, take the backup and then, copy that file to another location. I just learne......

This tutorial will take you through a detailed step-by-step installation of SQL Server Analysis Services. The tutorial focusses only on the Multidimensional version of SSAS and not on the tabular version....

Recently a colleague of mine asked me to give him a code for replacing spaces,dots(.),hyphens(-),braces '(' and ')'.
Here is my solution
[Code]string str= "This is a string having - and - - - - It also has dot (.) Many dots(.....)"; [/Code]
A......