SQLAuthority News – Author’s Birthday – Top 7 Commenters – Volunteers

« SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table

SQL SERVER – Introduction to Cloud Computing »

SQLAuthority News – Author’s Birthday – Top 7 Commenters – Volunteers

July 30, 2009 by pinaldave

Today is July 30 and I am very happy; it’s my Birthday, celebration time!!! The most common question I receive on my every birthday is -what are my plans for birthday. Let me share my plans here today. Additionally, if you are interested to know when SQL Server was born read my post SQLAuthority News – Author BirthDay – SQL Server Birthday.

My first plan is that I am going to take a break from blogging on anything technical today and spend more time with my family.

Let me tell you about my second plan. I am very much pleased and encouraged with active participation from many of you on this blog. I have received so far more than 10s of thousands of comments on my blog. These comments are open for you all to read and you can use them in any fashion that can help you out. Without good participation there is no life in any community, whether it is offline or online.

For the same reason, I have introduced Top 7 Commenters section in the side bar of SQLAuthority.com. There are many active users who have been participating for a long time. One of them I just recognized is Imran Mohammed. This SQL Expert has been extremely helpful to the community and has been providing comprehensive answers to hundreds of questions. Hats Off to you Imran! I totally appreciate your knowledge and dedication to SQL community. Without passion and love toward helping community, this is absolutely not possible.

You can subscribe to SQLAuthority.com feed, which will display all the new posts of my blog as they are published.

You can subscribe to SQLAuthority.com comments, which will show all the new comments posted on the blog as they are published.

If you prefer to receive SQLAuthority.com articles in email, you will get all the fresh posts in email.

There is no automated feature for top commenters where I host, so I will have to calculate this manually. I will keep it updated on weekly basis. Every week we will see new names there. First column is number of post, and second column is number name with link to experts website or blog or email.

Every day I receive a couple of emails about starting a forum on SQLAuthority.com. I do plan to start the forum in future. Currently, there are plenty of very good forums on the web. SQLAuthority.com is a blog and below every blog post there is a discussion related to the subject discussed in the blog post.

SQLAuthority.com is all about community and people who are passionate about SQL. Everyone is welcome to participate here. There are many ways to participate.

Discussing blog post
Helping user who have posted their issues on blog
Asking questions
Writing Guest Post
Submitting useful SQL Scripts
Reviewing any Microsoft-related products
Reviewing Books

Let me know if you have any other useful and interesting suggestions on how I can involve YOU more in my efforts to take SQL community to the next level.

If you are interested in participating in volunteer program do send me email at pinal ‘at’ SQLAuthority.com and we can discuss something out.

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

About these ads

Posted in About Me, Database, DBA, Pinal Dave, Software Development, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology | 37 Comments

37 Responses

on July 30, 2009 at 9:31 am | Reply Ashish

Hi Sir….
Happy Birthday to you….
many many congrats…….
to you i wish you get all what you want and deserve in ..
Thanks again.
- on July 30, 2009 at 9:39 am | Reply pinaldave
  
  Thank you Ashish!
  
  You are great star!
  - on January 5, 2012 at 1:52 am | Reply SUBBAREDDY
    
    Hi sir,
    
    happy birthday
on July 30, 2009 at 10:28 am | Reply Tejas Shah

Hi,

Many Many Happy returns the day.

You are SQLGuru.

Thanks,

Tejas
on July 30, 2009 at 10:35 am | Reply Kuldip

Hi Sir,

Many Many happy returns of the day,
This One Quote is appropriate for you sir,

“Your birthday is a special time to celebrate the gift of ‘you’ to the world”

Have Nice day and enjoy your birthday Today.
on July 30, 2009 at 10:37 am | Reply Hiten Sahai

Hello Pinal Sir,
Happy birthday. May God Bless you and showers his blessing on you.
I may not be a regular blogger or user in your blog list but still I have taken so much reference from you that I admire you a lot. You have been a source of inspiration for all the young aspirants.
In short you are great.
Happy birthday once again and cheers sir!.
on July 30, 2009 at 10:43 am | Reply K.K.B

Wish a Many Happy Returns of the Day !
…
Your best years are still ahead of you.

GOD Bless You

Waiting for PARTY Invitation

:)
on July 30, 2009 at 10:46 am | Reply Jacob Sebastian

Happy Birthday Pinal!
on July 30, 2009 at 10:55 am | Reply Atif Shehzad

Hi Pinal,
Happy birth day to you.
on July 30, 2009 at 11:28 am | Reply monica

Hello sir,

Wish you a very very happy birthday..God bless
Have a great day.
:)
on July 30, 2009 at 11:47 am | Reply Akash

Wishing you a Very vary Happy BirthDay.

I hope u remember me, i met you at Mount Carmel School.

Regard
Akash Agarwal
on July 30, 2009 at 1:00 pm | Reply Gangadhar Naidu

Hi pinaldave,

MANY MANY HAPPY RETURNS OF THE DAY.

You are the best SQL Guru.

Regards,
Gangadhar.
on July 30, 2009 at 2:14 pm | Reply pinaldave

@Tejas Shah, @Kuldip, @Hiten Sahai, @K.K.B., @Jacob Sebastian, @Atif Shehzad, @Monica, @Akash, @Gangadhar Naidu

Thank you very much for your kind wishes.

Best Regards,
Pinal
on July 30, 2009 at 4:48 pm | Reply Ritesh Shah

Hi Pinal,

Many Many Happy Returns of the day.

wish you have rocking day.

Now let us come to the point, when & where should I come for party?

Regards,

Ritesh Shah
on July 30, 2009 at 6:26 pm | Reply viral

wish you many many happy returns of the day..
Viral Shah
on July 30, 2009 at 6:36 pm | Reply Krunal

Hi Pinal,

Wish you a very happy birthday….
“TUM JIYO HAZAARO SAAL”

Enjoy the day……

Krunal
on July 30, 2009 at 7:14 pm | Reply Ramdas

Hi Pinal,
Wish you a happy and fun filled Birthday.
on July 30, 2009 at 8:10 pm | Reply Rushik

Hello Sir,

Happy BirthDay!!!
on July 30, 2009 at 10:18 pm | Reply Anthony

Just my luck. Got a noob problem with trying to count 2 different record types in one proceure and you have your Birthday. haha.
Hope you have a good time.
on July 31, 2009 at 3:50 am | Reply Imran Mohammed

Hello

Happy BirthDay Pinal.

Thanks for all good words you spoke about me.

Enjoy your Day.

Thanks,
Imran.
on July 31, 2009 at 5:19 pm | Reply Brian Tkatch

@Pinal

Many happy returns of the day!
on August 1, 2009 at 10:25 am | Reply Ganesh

My belated birthday greetings to you pinal. May you be ever healthy and happy…
on August 3, 2009 at 12:59 pm | Reply Koteswararao

My Belated Happy Birthday Wishes to you . You are a very good SQL server expert .

Regards,

-Koteswararao .kadiyam
on August 19, 2009 at 9:53 pm | Reply harish

Hi Pinal sir ,

how send message to you,
how to add this blog to me ,

i have new learner in sqlserverDba.

thanks sir,
harishkumar.M
on August 19, 2009 at 9:57 pm | Reply harish

hi pinal sir,

1) how to find out uncommitted transcation in sqlserver using Dbcc command

2)In Data base one table is Updated are not how to findout please tell me sir.

thank
harishkumar.M
on August 20, 2009 at 7:51 am | Reply Jacob Sebastian

@harish
DBCC OPENTRAN will show the active transactions.

I think your second question is not clear enough.
on August 21, 2009 at 10:09 pm | Reply harish

Hi jacob sir,

thank you sir ,Giving answer………………

1)IN my production server, The backup before how to find out which tables are updated (or) not ?

2) how to find out in my table or database in indexes through using DBCC command.

3) i have ten lacks records in my table that rows move to warehouse without using import&export

i want spilt my records to 1 to 100000

2)100000 to 200000
3)200000 to 300000
………….

…………

n)900000 to 100000

with using hints ,i don’t barden to my production server .

use any commands …………………………

please tell me

thank you

harishkumar.M
on August 21, 2009 at 10:20 pm | Reply harish

hi Jacob Sir,

1)IN my production server, The backup before how to find out which tables are updated (or) not ?

thank you

harishkumar. M
on August 22, 2009 at 9:27 am | Reply Jacob Sebastian

@harish,
Is it important to know what are the tables modified before a backup? What are you going to do with this information?

SQL Server does not give an out-of-the-box solution to this. If this information is important to your application logic, you should probably keep a timestamp column in your tables to keep track of the modifications.

You might also be able to identify this by using some of the third party tools that can read the trn log and get this info.

regards
Jacob
on August 22, 2009 at 10:40 am | Reply Ritesh Shah

@harish,

There should not be any question with Jacob’s word, this should be final as long as SQL Server and XML concern. I am agree with him too. There is no native way to do so, however you can have ApexSQL tool which can read your log file and can give you information, if you don’t want to buy 3rd party tool than you have to go for Audit trail and creating audit trail for all tables manually, is really big and tedious process and it can also reduce the performance.

If you can explain your need further, we may be able to give you some other workaround.

Regards,

Ritesh Shah
on August 24, 2009 at 1:28 pm | Reply harishkumar

Hi jacob sir,

1) how to find out in my table or database in indexes through using DBCC command.

2) i have 30 lacks records in my table that rows move to warehouse without using import&export

i want spilt my records to 1 to 100000 using time period.

1)100000 to 200000
2)200000 to 300000
………….

…………

n)2900000 to 3000000

with using hints ,i don’t barden to my production server when i move to where house .using Bcp -b this command this ………………………….

use any commands …………………………

please tell me sir

Thank you

harishkumar.M
on August 24, 2009 at 2:28 pm | Reply harishkumar

Hi pinal sir,

1)how to my Identity column RESEED

ex: EMPid 1000

………5000

in this time some identity column are deleted .

identity column order is not good .

so, how to reseed to start newly

Thankyou
harishkumar.M
on August 25, 2009 at 8:37 am | Reply Imran Mohammed

@Harish,

Before you ask any question, please make use of search, looks like most of the question asked by you are answered at-least 100 times on this blog. Why are you repeating the same questions again.

Please make use of google search, or search available in SQLAuthority.com

Now answering your question:
Read these articles:

http://blog.sqlauthority.com/2009/04/01/sql-server-reseed-identity-of-table-table-missing-identity-values-gap-in-identity-column/

~ IM.
on September 24, 2009 at 1:20 pm | Reply Pravin Kadam

You are a very good SQL server expert .
on November 15, 2009 at 5:29 pm | Reply Steve Call

Thanks a lot for your nice article. But I had difficulty navigating through your website because I kept getting 502 bad gateway error. Just thought to let you know.
on February 19, 2010 at 1:41 pm | Reply Madhivanan

Currently you show TOP 5 commentators with comment count
But the count doesn’t seem to be updated

Also is dynamically changed based on the comments or are you running an update?
on May 23, 2012 at 12:44 am | Reply birthday wishes

Happy birthday! Thanks for your great contribution!