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

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

37 thoughts on “SQLAuthority News – Author’s Birthday – Top 7 Commenters – Volunteers

  1. 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.

    Like

  2. 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!.

    Like

  3. @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

    Like

  4. 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.

    Like

  5. 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

    Like

  6. 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

    Like

  7. @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

    Like

  8. @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

    Like

  9. 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

    Like

  10. 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

    Like

  11. @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.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s