SQL SERVER – What is a Technology Evangelist?

When you hear that someone is an “evangelist” the first thing that might pop into your mind is the Christian church.  In fact, the term did come from Christianity, and basically means someone who spreads the news about their faith.  In the technology world, the same definition is true.

evengelist SQL SERVER   What is a Technology Evangelist?

Technology evangelists are individuals who, professionally or in their spare time, spread the news about the latest new products.  Sounds like a salesperson, right?  No they are absolutely different. Salespeople also keep up to date with a large number of people, and like to convince others to buy their product – and some will go to any lengths to sell!  An evangelist, on the other hand, is brutally honest about the product, even if sometimes it means not making a sale.  An evangelist is out there to tell the TRUTH.  A salesperson needs to make sales.

An Evangelist offers a Solution independent of Technology used – a Salesperson offers Particular Technology.

With this definition in mind, you can probably think of a few technology evangelists you already know.  Maybe it’s a relative or a neighbor, someone who loves keeping up with the latest trends and is always willing to tell you about them if you ask even the simplest question.  And, in fact, they probably are evangelists and don’t even know it.  For a long time, the work of technology evangelism was in the hands of community and community technology leaders. Luckily now various organizations have understood the importance of the community and helping community to reach their goals. This has lead them to create role of “Technology Evangelists”.

Let me talk about one of the most famous Evangelist of the SQL Server technology. Technology Evangelist only belongs to technology and above any country, race, location or any other thing. They are dedicated to the technology.

Vinod Kumar is such a man, who have given a lot to community. For years he was a Technology Evangelist for Microsoft, and maintained a blog that was dedicated to spreading his enthusiasm for his favorite products.  He is one of the most respected Evangelists in the field, and has done a lot of work to define the job for other professionals. Vinod’s career has since progressed to the Microsoft Technology Center (read his post), but he is continuing to be a strong presence in the evangelism community.  I have a lot of respect for Vinod.  He has done a lot for the community and technology evangelism.  Everybody has dream to serve community the way he does, and he is a great role model for evangelists everywhere.

On his blog, Vinod created one of the best descriptions of a Technology Evangelist.  It defined the position and also made the distinction between evangelist and salesperson extremely clear.  I will include the highlights of that list here, because no one can say it better than Vinod:

  • Bundle of energy – Passion is their middle name
  • Wonderful Story tellers
  • Empathy, Trust, Loyalty, Openness, Accessibility and Warmth
  • Technology Enthusiast – Doers
  • Love people, people and more people – Community oriented
  • Unique Style and Leadership qualities !!!
  • Self-Confident, Self-Motivated but a student

(To read the full list, see: Evangelism Beyond Borders with Evangelists)

His blog is a must-read for anyone interested in technology evangelism as a career or simply a hobby.  His advice about how to gain an audience and become a trusted advisor is the best in the business.

I think there is an evangelist in everyone. I, too, consider myself a technology evangelist.  Regular readers of this blog will recognize that I am dedicated to bringing information to the masses, and that I pride myself on being both brutally and honest and giving every product fair consideration.

I think there is no better way of saying following subject.

“Once an Evangelist – Always an Evangelist!”

Reference: Pinal Dave (http://blog.SQLAuthority.com)



SQLAuthority News – A Successful Community TechDays at Ahmedabad – December 11, 2010

We recently had one of the best community events in Ahmedabad. We were fortunate that we had SQL Experts from around the world to have presented at this event. This gathering was very special because besides Jacob Sebastian and myself, we had two other speakers traveling all the way from Florida (Rushabh Mehta) and Bangalore (Vinod Kumar).There were a total of nearly 170 attendees and the event was blast. Here are the details of the event.

Pinal Dave Presenting at Community Tech Days

Pinal Dave Presenting at Community Tech Days

On the day of the event, it seemed to be the coldest day in Ahmedabad but I was glad to see hundreds of people waiting for the doors to be opened some hours before. We started the day with hot coffee and cookies. Yes, food first; and it was right after my keynote. I could clearly see that the coffee did some magic right away; the hall was almost full after the coffee break.

Jacob Sebastian Presenting at Community Tech Days

Jacob Sebastian Presenting at Community Tech Days

Jacob Sebastian, an SQL Server MVP and a close friend of mine, had an unusual job of surprising everybody with an innovative topic accompanied with lots of question-and-answer portions. That’s definitely one thing to love Jacob, that is, the novelty of the subject. His presentation was entitled “Best Database Practices for the .Net”; it really created magic on the crowd.

Pinal Dave Presenting at Community Tech Days

Pinal Dave Presenting at Community Tech Days

Next to Jacob Sebastian, I presented “Best Database Practices for the SharePoint”. It was really fun to present Database with the perspective of the database itself. The main highlight of my presentation was when I talked about how one can speed up the database performance by 40% for SharePoint in just 40 seconds. It was fun because the most important thing was to convince people to use the recommendation as soon as they walk out of the session. It was really amusing and the response of the participants was remarkable.

Pinal Dave Presenting at Community Tech Days

Pinal Dave Presenting at Community Tech Days

My session was followed by the most-awaited session of the day: that of Rushabh Mehta. He is an international BI expert who traveled all the way from Florida to present “Self Service BI” session. This session was funny and truly interesting. In fact, no one knew BI could be this much entertaining and fascinating. Rushabh has an appealing style of presenting the session; he instantly got very much interaction from the audience.

Rushabh Mehta Presenting at Community Tech Days

Rushabh Mehta Presenting at Community Tech Days

We had a networking lunch break in-between, when we talked about many various topics. It is always interesting to get in touch with the Community and feel a part of it. I had a wonderful time during the break.

Vinod Kumar Presenting at Community Tech Days

Vinod Kumar Presenting at Community Tech Days

After lunch was apparently the most difficult session for the presenter as during this time, many people started to fall sleep and get dizzy. This spot was requested by Microsoft SQL Server Evangelist Vinod Kumar himself. During our discussion he suggested that if he gets this slot he would make sure people are up and more interactive than during the morning session. Just like always, this session was one of the best sessions ever. Vinod is true to his word as he presented the subject of “Time Management for Developer”. This session was the biggest hit in the event because the subject was instilled in the mind of every participant.

Vinod Kumar Presenting at Community Tech Days

Vinod Kumar Presenting at Community Tech Days

Vinod’s session was followed by his own small session. Due to “insistent public demand”, he presented an interesting subject, “Tricks and Tips of SQL Server“. In 20 minutes he has done another awesome job and all attendees wanted more of the tricks. Just as usual he promised to do that next time for us. Vinod’s session was succeeded by Prabhjot Singh Bakshi’s session. He presented an appealing Silverlight concept. Just the same, he did a great job and people cheered him.

Prabhjot Presenting at Community Tech Days

Prabhjot Presenting at Community Tech Days

We had a special invited speaker, Dhananjay Kumar, traveling all the way from Pune. He always supports our cause to help the Community in empowering participants. He presented the topic about Win7 Mobile and SharePoint integration. This was something many did not even expect to be possible. Kudos to Dhananjay for doing a great job.

Dhananjay Kumar Presenting at Community Tech Days

Dhananjay Kumar Presenting at Community Tech Days

All in all, this event was one of the best in the Community Tech Days series in Ahmedabad. We were fortunate that legends from the all over the world were present here to present to the Community. I’d say never underestimate the power of the Community and its influence over the direction of the technology.

Vinod Kumar Presenting trophy to Pinal Dave

Vinod Kumar Presenting trophy to Pinal Dave

Vinod Kumar Presenting trophy to Pinal Dave

Vinod Kumar Presenting trophy to Pinal Dave

This event was a very special gathering to me personally because of your support to the vibrant Community. The following awards were won for last year’s performance:

Ahmedabad SQL Server User Group (President: Jacob Sebastian; Leader: Pinal Dave) – Best Tier 2 User Group

Best Development Community Individual Contributor – Pinal Dave



I was very glad to receive the award for our entire Community.

Attendees at Community Tech Days

Attendees at Community Tech Days

I want to say thanks to Rushabh Mehta, Vinod Kumar and Dhananjay Kumar for visiting the city and presenting various technology topics in Community Tech Days.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Community Tech Days – December 11, 2010

Community Tech Days are very close on December 11.

ctd1 SQLAuthority News   Community Tech Days   December 11, 2010

The venue details are as following:

H K Hall, H K College Campus, Near Handloom House, Opp. Natraj Cinema, Ashram Road, Ahmedabad – 380009

Click here to Registration for the event.

Please read the announcement details here.

I will be speaking on following session.

Best Database Practice for SharePoint Server

This session will be very unique. I will be starting with a bit pessimistic talk about how one cannot many things in SQL Server when SharePoint Server is installed. I will go over in the details for the reasons for the same. Right after this 5 minutes I am going to show few things to attendees which they can apply right away to their database and instantly get the performance. I am going to share the easy scripts with them online right away and if they run the same on their SharePoint Database, they will get the performance right out of the box right away – I Promise!

This is the same session I presented at SharePoint Conference and I have received excellent feedback on the same subject.

Join us!

Reference: Pinal Dave (http://blog.SQLAuthority.com)


SQLAuthority News – Community Tech Days – A SQL Legends in Ahmedabad – December 11, 2010

Ahmedabad is going to be fortunate city again on December 11.

We are going to have SQL Server Legends present at the prestigious event of Community Tech Days in Ahmedabad.

ctd1 SQLAuthority News   Community Tech Days   A SQL Legends in Ahmedabad   December 11, 2010

The venue details are as following:

H K Hall, H K College Campus, Near Handloom House, Opp. Natraj Cinema, Ashram Road, Ahmedabad – 380009

Click here to Registration for the event.

Agenda of the event is as following.
10:15am – 10:30am     Welcome – Pinal Dave
10:30am – 11:15am     SQL Tips and Tricks for .NET Developers by Jacob Sebastian
11:15am – 11:30am     Tea Break
11:30am – 12:15pm     Best Database Practice for SharePoint Server by Pinal Dave
12:15pm – 01:00pm     Self Service Business Intelligence by Rushabh Mehta
01:00pm – 02:00pm     Lunch
02:00pm – 02:45pm     Managing your future, Managing your time by Vinod Kumar
02:45pm – 03:30pm     Windows Azure News and Introducing Storage Services by Mahesh Devjibhai Dhola
03:30pm – 03:45pm     Tea Break
03:45pm – 04:30pm     Improve Silverlight application with Threads and MEF by Prabhjot Singh Bakshi
04:30pm – 04:45pm     Thank you – Mahesh Devjibhai Dhola

Ahmedabad considers itself extremely fortunate when there are SQL Legends presenting on various subjects in front of community.

Here is brief introduction about them in my own words. (Their names are in order of the agenda).

1) Jacob Sebastian (SQL Server MVP) – This person needs no introduction. Every developer and programmer in Ahmedabad and India knows him. He is the one man who is founder of various community-related ideas like SQL Challenges, SQL Quiz and BeyondRelational. He works with me on all the community-related activities; we are extremely good friends.

2) Rushabh Mehta (SQL Server MVP) – If you use SQL Server – you know this man. He is the President of SQL Server of Professional Association (PASS) and one of the leading Business Intelligence (BI) Experts renowned in the world. He has blessed Ahmedabad once before and now doing once again this year.

3) Vinod Kumar (Microsoft Evangelist – SQL Server & BI) – Ahmedabad remembers him very well. During his last visit to Ahmedabad, a fight had almost broke outside the hall amidst the rush to listen him. There were more people standing and listening to him than those who were seated. This is one man Ahmedabad will never forget.

4) and Myself. I will not rate myself in the league of abovementioned experts, but I must say that I am fortunate to have friends like those above.

We also have two strong .NET presenters – Mahesh and Prabhjot.

During this event, there will be plenty of giveaways, lots of fun, demos and pure technical talk, specifically no marketing and promotion – just pure technical talk.

The most interesting part is that all the SQL Legends – Jacob, Rushabh and Vinod are for sure presenting on SQL Server but with a twist.

Jacob – He is going to talk about .NET and SQL – Optimization Techniques

Rushabh – He is going to talk about SQL and BI – Self Service BI

Vinod – He is going to talk about professional development of developers – Managing Time

Pinal – Best Practices for SharePoint Database Administrators – SharePoint DBA – I have presented this session earlier.

I promise this event is going to be one of the best events held ever. You can read about the earlier event over here.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Statistics and Best Practices – Virtual Tech Days – Nov 22, 2010

I am honored that I have been invited to speak at Virtual TechDays on Nov 22, 2010 by Microsoft. I will be speaking on my favorite subject of Statistics and Best Practices.

This exclusive online event will have 80 deep technical sessions across 3 days – and, attendance is completely FREE. There are dedicated tracks for Architects, Software Developers/Project Managers, Infrastructure Managers/Professionals and Enterprise Developers. So, REGISTER for this exclusive online event TODAY.

statistics SQLAuthority News   Statistics and Best Practices   Virtual Tech Days   Nov 22, 2010

Statistics and Best Practices
Timing: 11:45am-12:45pm
Statistics are a key part of getting solid performance. In this session we will go over the basics of the statistics and various best practices related to Statistics. We will go over various frequently asked questions like a) when to update statistics, b) different between sync and async update of statistics c) best method to update statistics d) optimal interval of updating statistics. We will also discuss the pros and cons of the statistics update. This session is for all of you – whether you’re a DBA or developer!

You can register for this event over here.

If you have never attended my session on this subject I strongly suggest that you attend the event as this is going to be very interesting conversation between us. If you have attended this session earlier, this will contain few new information which will for sure interesting to share with all.

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – SQL Server Performance Optimizations Seminar – Grand Success – Colombo, Sri Lanka – Oct 4 – 5, 2010

I have been on world tour on SQL Server Performance Optimizations Seminar. The latest seminar was conducted in Colombo, Sri Lanka on Oct 4 – Oct 5. I had previously written about this event over SQLAuthority News – SQL Server Seminar at Colombo Full. This event was oversubscribed and we could not accommodate the last few nominations due to the restrictions of the place. We had total of 35 attendees and the event offered lots of fun. The attendees were a perfect combination – all had few years of experience and many of them were responsible for performance for their server. There were few attendees who were just there to know if SQL Server can deliver performance and what are its tricks.

Colombo Beach

Colombo Beach

Warm Welcome

The event was very much welcomed and I received a lot of good feedback. In this event, only few slides were presented – the rule of thumb I had was that I will show only one slide per hour and remaining time I will spend with attendees with real world scenarios and examples. During the two day sessions, we went through many examples, nearly 30 different performance tuning tricks, and tools and understood how performance is often misunderstood with scalability.

SQL Server Seminar Group Photo

SQL Server Seminar Group Photo

What really caught my attention is that many of the attendees thought creating Indexes is the way to improve performance. I had fun time to bust the myth of indexes, and later on, we learned the real trick of how we can improve the performance using indexes.

SQL Horoscope

As attendees were really interested in their current scenario, we did something very interesting during the training. I provided them a couple of queries on the very first day. On the second day, they brought the query results back to me. Based on these query results, we tried to play game where I told them what their server’s bottleneck is and what is it used as. The game went for nearly 10 minutes and we had fun time talking to attendees regarding their server.

Pinal presenting SQL Server Seminar

Pinal presenting SQL Server Seminar

Real World Scenario

The real world is often quite different from the theoretical world. The issues which we learn in classroom are not the same when we deal with the live production server. I focused on real world scenario and asked attendees to bring their valuable queries and configurations. Together, we discussed about their server and tried to help them out with the next logical steps to improve their server. This was a learning experience for me as well. Every server is new and every server has its own tale to share.

Pinal presenting SQL Server Seminar

Pinal presenting SQL Server Seminar

Excellent Participants

No matter how good sessions are, without proper interactive conversations and questions, any session can become boring. As I said earlier, the attendees were very much interested in the subject itself and they really wanted to learn the tricks. Well, I wanted to share my tricks too. It was perfect match – which lead to overall great feedback of the event. I received many emails after the session, I would like to share one here.

Pinal presenting SQL Server Seminar

Pinal presenting SQL Server Seminar


Here are some of the feedbacks received on my training in Sri Lanka.

“Many thanks for the email – your seminar was one of the best sessions I attended in my life. You made it so attractive and kept us at the edge of the seat every minute.”

Pinal presenting SQL Server Seminar

Pinal presenting SQL Server Seminar

“A BIG THANKS to your training, we all are at office and just experienced the first great benefit of your training right now. There was a major issue for almost a month which we discussed with you yesterday where the Java program and the SP tried to access the same table and Java program get stuck. Based on your training we have done some changes to Index & where clause and the problem is sorted out now. Juts now, we have completed. No more table lock and the Java program works fine. Once again thank you very much.”

Well, what else I can say, I am overwhelmed with this interest.

Pinal presenting SQL Server Seminar

Pinal presenting SQL Server Seminar

Next Seminar

My next seminar will be conducted in Hyderabad on Nov 27 to Nov 28 (Saturday, Sunday). The location of the seminar is at Best Western Amrutha Castle, 5-9-16, Opp. Secretriat, Saifabad, Khairatabad, Hyderabad. The fee for attending the seminar is Rs. 5,000. If you specify the code ‘SQLAuthority.com,‘ you will quality for 20% discount. Send email to indiainfo@solidq.com and pinal ‘at’ sqlauthority.com to register for the seminar.

You can click here to read more details about seminar.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – What is an MVP? – How to become an MVP?

There are a lot of basic questions I get that inquires about being an MVP. Some of them include:

  • What is an MVP?
  • How can I become an MVP?
  • Are there any exams needed before becoming an MVP?
  • Does an MVP get paid?
  • Is it compulsory for MVPs to promote Microsoft Technology?

and many more…

To anyone who wants to know more about the above questions I suggest you read the official Frequently Asked Questions.

Today, I want to address the same issue in a different manner. I want to leave the official definition aside, and try to answer the crucial question: “What is really an MVP?”

For me, an MVP is a passionate guy who loves the Microsoft technology and understands it well enough. Well enough is a very broad phrase, but it is the reality for virtually all MVPs. Many MVPs have a great understanding of the technology so they help the Microsoft Product team with feedbacks of a certain product and help that product to be enhanced. Many MVPs are extremely good at the technology and work as individual contributors to help develop products. Many MVPs are heavily involved in the Community through helping spread the word. Many MVPs are book authors and blog owners as well, aiming to spread the technology. Lastly, there are a lot of MVPs who are pretty much aware of the technology’s pros and cons. As they understand the limitations of it, they help others to come up with solutions to compensate the boundaries of the technology.

There are many things I can write about, but if you notice there is one common word in all of the above statements. The common word is “Help“. Every MVP is helping someone else to learn, to grow and to create a better ecosystem for technology. The obvious question is that “What is in it for them?” The answer is also very simple:  they get what we call time satisfaction. But once in a while, people think that becoming an MVP is also a matter of ego. In the programming world, however, there should be no ego involved. You are here today but you may not be here tomorrow anymore. An MVP has a right to be proud of their knowledge and passion centered on technology, but arrogance is a different thing and must not be a trait of an MVP.

Reading this may make you think that you can be an MVP too, having the burning passion about technology and helping others in your organization at the same time. Great point! Honestly, being an MVP does not stop at only helping others or being passionate with technology. Being an MVP is a commitment to one’s self, promising to keep the standard up and continue the passion onwards. I can keep on writing about what makes a person an MVP, but I do not want to be redundant with what my MVP fellows has already said in their own blogs.

Here is an excellent post by Joanthan Kehayias (SQL Server MVP and Book Author). I suggest that you read his blog post entitled: “What is an MVP Anyway?” He has busted common myths about this program and explained well what I wish to write here in details. Our thoughts are very similar. I would like to point out one sentence in that post which appeals to me the most: “I was recognized as an MVP because I do these things; I don’t do these things because I am an MVP.

Another great in-depth article is written by Vijay Raj (Application Setup/Deployment MVP and Great Human Being). He shares his idea on this blog post he called: “How to become an MVP?“, writing in his unique humorous style. I really like how he started the post: “First of all, Most Valuable Professional (MVP) is not a certification; it’s an AWARD! It’s a mode of recognition which Microsoft gives to individuals who are technology experts and most importantly, who play a role and are keen in sharing their expertise with the Community. So if your question is, “I have completed my MCTS or MCAD. What are the next steps towards being a MVP?” You must re-think on your question!”

I hope this blog post gives you a clear idea about what is an MVP.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – SQL Server Performance Optimization – Seminar Series

I am very glad that I will be presenting my very first seminar training series worldwide. This event is called the Solid Quality DIRECTIONS Seminar Series. I am very fortunate that I am given this opportunity to work under prestigious organizations. I have been with Solid Quality Mentors for more than a year now. I have learned a lot and I have grown a lot through this group. While working for Solid Quality, I have conducted many training events and various consultations projects. I can say that I have collected and kept with me all the wisdom and knowledge related to my passion, SQL. In one of my recent conversations with Rushabh Mehta (Solid Quality India CEO), I realized that I have a chance to share with everybody this wisdom I have learned. For the very same reason, I will present all the things I learned throughout these many years and  compress them into this one major seminar.

The quick schedule for registering here is listed below:

The very first seminar will occur in Chennai. The detailed agenda of this event you can find over here.

The venue for the first training is as follows:

146, Dr. Radhakrishnan Road,
Chennai – 600004, India
Phone: +91-44-2811-4700

Agenda of the event

This 2-day seminar will cover the best of the best concepts and practices from popular courses offered by Solid Quality Mentors. Instead of learning theory only, the seminar focuses on providing real world experience by using demos and scenarios derived from customer engagements. The seminar is uniquely structured and well-thought-out. Sessions are discussion- based and are designed to be an interactive gateway between the instructor and the participants for an optimal learning experience. The seminar is intended to be immersion-based where participants will have plenty of opportunities to get deeply involved in the concepts presented by the instructor. The best participants will receive special educational materials from the instructor, as well as further follow ups.

3 Free Registrations

Solid Quality India has announced three free give-away registrations for the first event. To win the free registrations, you have to write a blog post or comment on social media (facebook, twitter etc) as to why you should win the free registrations. If your entry is chosen to be the best one, you will win the free registrations. Once you write your blog post or spread the word in social networking, please leave a comment with the name of the city where you want to win free registrations.

To join the seminars, please drop me an email. My email address is pinal “at” SQLAuthority.com and IndiaInfo “at” SolidQ.com. If you specify SQLAuthority.com in the Title of your email, you will avail a special discount in overall rates on specified price. Yes, a more than 20%, I promise.

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – Why SQL Server is better than any other RDBMS Applications?

Earlier I had announced contest on blog where I gave away two MSDN Subscriptions to person who has provided best comment on the subject of “Why SQL Server is better than any other RDBMS Applications?” I have received tremendous response to the contest. I got many responses, it was extremely difficult to announce the winner and I requested help of two SQL Server MVPs to help me out with the results. Here is the winner of the contest. They really spend good time and wrote about their feeling for SQL Server product. Here is their answers.

I strongly suggest that you bookmark this post as this post can be used in future when you might want to write why SQL Server is better than any other RDBMS application.

Winner #1 HARSHU

SQL Server is like most RDMS systems, a database engine but what make it better than other RDMS systems (especially SQL 2008 onwards) are new features and other bells and whistles it comes with.
Here are the few:

1. Easy integration with Microsoft Operating systems.

2. East integration with world’s most common database: Spreadsheet, Microsoft excel in particular and power pivot has significantly enhanced its value.

3. User friendly interface

4. Easy to create maintenance plans.

5. Integrated Security (windows authentication): This definitely help streamline server access based on Active directory policies and groups.

6. Mixed Authentication: Not only it gives the option to use windows authentication, it allows other applications to authenticate based on username and password

7. Disaster recovery: SQL Server is very easy to restore after a disaster (proper backup and recovery strategy needs to be implemented) as compared to other RDMS. All you need is File system restore followed by system state and then restore databases from backup. I have been involved in DR for a lot systems and doing DR on a SQL Server is much easier than any other RDMS system. Other benefits include Failover Clustering and Transaction Replication

8. Licensing: The licensing structure of SQL Server is much better as compared to other RDMS systems. Other RDMS systems have a very complex licensing structure which comes out to be much costly than SQL Server.

9. SQL Server Management Studio (SSMS): As compare to other RDMS systems tools, SSMS is the best tool for a developer or a DBA.

10. SQL Server Business Intelligence: Business Intelligence in SQL Server has come a long way and has evolved so much. It is one of the best if not the best in the market at the moment.

Since SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services comes with the SQL Server license, customer doesn’t need to spend extra money on these additional tools, instead that money can be spend on something else e.g. upgrade SAN, user training.

11. Visualization

12. Administering and Monitoring: SQL Server 2008 R2 has really scored high in its new administration and monitoring tools. It has made the life of a DBA (even accidental DBA) a lot easier.

13. Backup Compression: Even though it is a new feature in SQL Server 2008, it has really helped companies to upgrade to the new version and speeding a lot (if not all) of the backup operations.

14. Data Encryption: SQL Server 2008 provides a lot of encryption options to encrypt data and code. Transparent Data Encryption has really safe guarded some of the crucial data movement operations our company.

Winner #2 SAJID

First upon, thanks for bringing this questions. I had heard lots of arguments comparing one RDBMS with another and believe me the debate never ends.

What we can think is how one RDBMS better than other – one thing must be remember; what you think is good, could be bad per other opinion.

I like SQL Server because of its SIMPLICITY. I learned SQL commands over Oracle (ah! it was too long that I used oracle and never touched it again after being FRIENDLY with SQL :) ).

I like following attributes of SQL Server hence I loved this one… and as I am trying to deep dive into technology I am being passionate lover… :)

1. First thing I liked is as said its SIMPLICITY.

2. Easy Availability– one don’t have to pay huge bucks to make SQL Available.. he can use Express edition available free.

3. Uncomplicated installation process – follows the same standard as of other MS Product like MS-Office etc… that no one need special knowledge of installation process to get ready to use SQL.

4. Can be install on Average system – like few other RDMS, SQL do not have special hardware requirement. so one can be benefited without having his/her system upgraded.

5. User friendly UI. again abide to MS standard for all other application so anyone feel friendly on first visit.

6. Easy navigation through common shortcuts and tool box. I don’t have to remember multiple keys to navigate.. what works in MS-Office / VS etc.. almost works in SQL as well.

7. BOL – help documentation is easily available and more friendly to browse to get the correct help.

8. Perfect match for all level of organizations… small firms to big enterprise to data store.

9. Perfect suite of application – good clubbing and packaging of Database engine, Agent Service, Notification Service, Reporting Service, Analysis Service, Integration Service.

10. Support for Multi- Instance and side by side installation of multiple versions.

11. Enhanced Security

12. Enhanced Optimizer

13. availability for various technologies to support high availability like Log Shipping, Replication, Clustering, Mirroring etc..

14. Easy to tune up, one can easily tune up the performance with help of wizards and additional tool like Profiler etc litle knowledge.

15. Advancement in the technology.. like SQL Azure, CLR integration, DAC, Intellisense (though I didnt like current intellisense but it helps often).

16. Broader community – I like the SQL community, in Fact I have sharpened my skill through this community.. where you can easily catch up with SQL MVP or MS SQL Team. I love dedication you guys shown up in communities. I believe that if someone is in crisis, this community will never let him get down with SQL.

17. non ANSI functions in SQL are similar to other programming languages hence feels comfortable and don’t have to dig more to find the right function that is equivalent in something like in .net.

ah… I never thought I can praise SQL Server in these many ways, still there are lots of things that are poping up in my mind.. like Query Plan and its help and documentation to understand one… like files and file groups are utilized. I remember having problem when one dont know where does the RDBMS technology keeps the data file, but that never happen with SQL… how friendly are the extended procedures and DMO’s…Centralized Server management, Data collection, Resource Governor.. Oh No!!again I found myself in a state of praising each feature delivered by SQL.

Wrapping up as time to be with someone special – SQL Server.

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – MSDN Subscription Giveaway Announced

Last Month received following “NOT FOR SALE” subscription of Microsoft Visual Studio 2010 Ultimate with MSDN. As a MVP, MCT I already have free subscription to MSDN and TechNet. I plan to give away this free subscription to someone who is need of the same or can use it the best. I have already given away two of the subscription to someone who can really use them. In fact, they have reported me where and how they are using the subscription. This gives me great satisfaction. I have announced one subscription for all of you my reader to win. Top SQL Server Expert and SQL Server MVP Madhivanan also announced to give away one of his subscription to this blog readers looking at the overwhelming response of the contest. The cost of this subscription is around USD 11,899 and I want to specially express my thanks to Madhivanan for his kind gesture.

I have received more than 150 comments on this blog. This was great response. There are some genius replies and it was not possible for me to pick two of the winners from 150 total comments. I ran to my friends and they offered me their help. Before I announce the winner, I would like to announce the judges of this contest. They are listed in alphabetical order.

Jacob Sebastian – SQL Server MVP

Jacob Sebastian a Microsoft MVP (SQL Server) and works with Excellence Infonet as CTO. Excellence Infonet is the Indian unit of a NY based Software Company and builds mission critical applications in sectors such as Health Care, Warehouse Management, Business Intelligence etc. Jacob started his database career in the early nineties with Dbase and then moved to Clipper, Foxpro and finally to SQL Server. He has been working with SQL Server for over 11 years starting with SQL Server 6.5. Jacob is an Internationally acclaimed SQL Server Speaker, Author and Trainier. He maintains the site: http://beyondrelational.com/

Madhivanan – SQL Server MVP

Madhivanan is an MSc computer Science graduate from Chennai, India and working as a Lead Analyst-Project at Ellaar Infotek Solutions Private Limited. He is basically a developer started with Visual Basic 6.0, SQL Server 2000 and Crystal Report 8. As years go on he started working more on writing queries in SQL Server in most of the projects developed in his company. He has some good level of knowledge in ORACLE, MySQL and PostgreSQL as well. He is recently promoted to Assistant Manager in his organization. He maintains the site: http://beyondrelational.com/blogs/madhivanan/

Pinal Dave – SQL Server MVP and Solid Quality Mentors

Pinalkumar Dave is a Microsoft SQL Server MVP, Mentor for Solid Quality India and Microsoft Certified Trainer (MCT). He has written over 1400 articles on the subject on his blog at http://blog.sqlauthority.com. He is a dynamic and proficient Principal Database Architect, Corporate Trainer and Project Manager, who specializes in SQL Server Programming and has 7 years of hands-on experience. He holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). He is also Regional Mentor for PASS Asia. He maintains the site: http://blog.sqlauthority.com

Without further ado here are the wining comments.

Winner #1 HARSHU

Winner #2 SAJID

Winners are requested to contact me by email for their winning MSDN subscription code.

Reference: Pinal Dave (http://blog.sqlauthority.com)