South Asia MVP Open Day 2008 - Goa - Group Photo

submitted by pinaldave 6 hours, 23 minutes ago

blog.sqlauthority.com — Microsoft Most Valuable Professionals (MVPs) are exceptional technical community leaders from around the world who are awarded for voluntarily sharing their high quality, real world expertise in offline and online technical communities. Microsoft MVPs are a highly select group of experts that represents the technical community’s best and brightest, and they share a deep commitment to community and a willingness to help others. Kick the story to support Microsoft Event. read more...

1 comment | category: Community | Views: 1

SQL Server 2008 - Cheat Sheet - One Page PDF Download

published 1 month, 15 days ago, submitted by pinaldave 1 month, 16 days ago

blog.sqlauthority.com — Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and for novice developers it is good to keep all the important SQL Script and SQL Statements handy. I have attempted to create cheat sheet for SQL Server 2008 most important commands. User can print this in one A4 size page and keep along with them. This can be used in interviews where T-SQL scripts are being asked. Let me know your opinion and if you find this useful. Bookmark it for future use. read more...

2 comments | category: Database | Views: 595

SQL SERVER - 2008 - Interview Questions and Answers - Download PDF

published 2 months ago, submitted by pinaldave 2 months, 1 day ago

blog.sqlauthority.com — Interview is very important event for any person. A good interview leads to good career if candidate is willing to learn. I always enjoy interview questions and answers series. This is my very humble attempt to write SQL Server 2008 interview questions and answers. SQL Server is very large subject and not everything is usually asked in interview. In interview what matters the most is conceptual knowledge and learning attitude. I have listed all the series in this post so that it can be easily downloaded and used. All the questions are collected and listed in one PDF which is here to download. If you have any question or if you want to add to any of the question please send me mail or write a comment. Bookmark this first ever set of interview questions and answers. read more...

2 comments | category: Database | Views: 280

Introduction to Table-Valued Parameters with Example

submitted by pinaldave 2 months, 19 days ago

blog.sqlauthority.com — Table-Valued Parameters is a new feature introduced in SQL SERVER 2008. In earlier versions of SQL SERVER it is not possible to pass a table variable in stored procedure as a parameter, but now in SQL SERVER 2008 we can use Table-Valued Parameter to send multiple rows of data to a stored procedure or a function without creating a temporary table or passing so many parameters. This is one feature all the SQL Server developer were waiting for long time. This article explains how it can be used with very simple words. read more...

1 comment | category: Database | Views: 12

SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Data

published 2 months, 29 days ago, submitted by pinaldave 2 months, 30 days ago

blog.sqlauthority.com — First and Complete article of SQL Server 2008 Database Mail configuration. From start to end - Complete article. Bookmark it! read more...

2 comments | category: Database | Views: 181

SQL SERVER - 2005 - Difference Between INTERSECT and INNER JOIN

published 3 months, 17 days ago, submitted by pinaldave 3 months, 19 days ago

blog.sqlauthority.com — INTERSECT operator in SQL Server 2005 is used to retrieve the common records from both the left and the right query of the Intersect Operator. INTERSECT operator returns almost same results as INNER JOIN clause many times. When using INTERSECT operator the number and the order of the columns must be the same in all queries as well data type must be compatible. Let us see understand how INTERSECT and INNER JOIN are related.We will be using AdventureWorks database to demonstrate our example. read more...

3 comments | category: Database | Views: 250

SQL Server in One Page - Download it Now

published 6 months, 25 days ago, submitted by pinaldave 6 months, 25 days ago

blog.sqlauthority.com — One of the most popular request I have received on this blog is to create one page which list all the SQL Server FAQs. SQL Server technology is very broad as well very deep. This is my humble attempt to list few of the daily used details in one page. Let me know your opinion and suggestion. Download SQL Server FAQ Sheet in PDF format read more...

4 comments | category: Database | Views: 145

SQL SERVER - Better Performance - LEFT JOIN or NOT IN?

published 6 months, 30 days ago, submitted by pinaldave 7 months ago

blog.sqlauthority.com — What do you think? I am sure result will surprise you. read more...

2 comments | category: Database | Views: 20