We are excited to open our mouth wide to shout "Yes, We are ready. Are you?"
SQL Data Camp @ Chennai is all set for making a claim to be First ever largest SQL Server Event to be held in India.
Category Archives: General - Page 3
Installing SQL Server 2008 R2
Posted by Vidhya Sagar
on May 24, 2010
3 comments
In this article we are going to discuss about installing SQL Server 2008 R2, I know I’m little late as R2 is released last month. Before we stepping into installation make sure you have necessary hardware and software requirements, check http://technet.microsoft.com/en-us/library/ms143506(SQL.105).aspx this KB article for the same.
SQL Server 2008 R2 RTM Launched
Posted by Vidhya Sagar
on April 22, 2010
2 comments
Today the next version of SQL Server is released. Most of us know that MS is working on SQL Server 2008 R2 and the last package released for this version is on November and we got the Nov CTP package. If you remember, on Jan 2010 DPI has posted a blog that SQL 2008 R2 will be May 2010 however MS has launched SQL Server 2008 R2 RTM today. SQL Server 2008 R2 packed with many features for BI, DBA’s and Developers. If you are express edition user then you have a good news, SQL Server 2008 R2 express edition supports max of 10 GB data file size which is increased from 4 GB however all other features remains same as SQL Server 2008 Express. We have couple of new editions also available for SQL Server 2008
Backup SQL Database to Remote location
Posted by Vidhya Sagar
on April 10, 2010
No comments
Does the title sounds crazy? You might think that this topic is very simple? Yes you are right however some folks still raise this question in forums. I’m seeing this question for for a long time in forums and thought of sharing the solution here, so that the folks can give a search to get this (coz Google is our first techie teacher or instant solution provider 
).
SQL Server Joins
Posted by Vidhya Sagar
on January 18, 2010
1 comment
SQL Server joins are required to retrieve data from one or more tables to get a single result set. Joins are needed when Normalization enforced in design. When you normalize the data you be reducing redundancy in data by placing data in different tables and also you will be creating relationship between the tables. With the help of these relationship you will be retrieving the data using joins efficiently.