SQLAuthority News – Article 1100 and Community Service

This is 1100 the post of on my blog post on this blog. Just looking at the last 100 post of my blog, I have realized besides writing blog posts there are lots of other community events, I have been involved with. Let me quickly list few of the important community events and post, I have been involved with.

There are three very important event in my life during last 100 posts.

Three Very Important Event

SQLAuthority News – 1000th Article Milestone – 8 Millions Views – Solid Quality Mentors

SQLAuthority News – MVP Award Renewed

SQLAuthority News – Shaivi Dave – Baby SQLAuthority

Community Events

SQLAuthority News – TechEd on Road Ahmedabad June 20, 2009 – An Astounding Success

SQLAuthority News – Authors Visit – K-MUG TechEd Trivandrum on June 27, 2009

SQLAuthority News – Authors Visit – DelhiBuzz TechEd on July 11, 2009

SQLAuthority News – Author Visit – Virtual Tech Days August 2009

SQLAuthority News – Community Tech Days Oct 3, 2009 – Ahmedabad

Community Posts

SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2009- Seattle

SQL SERVER – Why You Should Attend PASS Summit Unite 2009- Seattle

SQLAuthority News – Book Review – The Rational Guide to Building Technical User Communities (Rational Guides)

SQLAuthority News – A Quick Guide to Twitter

Personal Posts

SQLAuthority News – 1000th Article Milestone – 8 Millions Views – Solid Quality Mentors

SQLAuthority News – MVP Award Renewed

SQLAuthority News – Request SQLAuthority.com Stickers and SQL Server Cheat Sheet

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

SQLAuthority News – Beyond Relational Interview on SQL Server 2008 Beyond Relational

SQLAuthority News – Baby SQLAuthority is here!

SQLAuthority News – Shaivi Dave – Baby SQLAuthority

I thank you very much to all of you for your unconditional support.

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

MVP
Previous Post
SQL SERVER – Introduction to Service Broker and Sample Script
Next Post
SQL SERVER – Insert Values of Stored Procedure in Table – Use Table Valued Function

Related Posts

8 Comments. Leave new

  • jacob sebastian
    September 22, 2009 8:07 am

    Congratulations Pinal for achieving the “1100th post milestone”. Looking forward to see 1500th post on 18-07-2010 and 2000th Post on 30-11-2011 :-)

    (readers, ask me how I got those dates! :-))

    Reply
  • jacob sebastian
    September 22, 2009 10:15 am

    hint: I used a TSQL built-in function to get those dates
    :-)

    Reply
  • Congratulations Pinalbhai to achieve this milestone.

    What is the formula to calculate those dates?

    I tried but didn’t get idea behind it.

    Tejas

    Reply
  • Hi Pinal,

    Congratulations from hear!!!!! you are doing really great. keep doing great work and keep inspiring people like me :)

    thanks for all your direct and indirect support and many thanks for being always available for all technical and non-technical issues.

    Thanks,

    Ritesh Shah

    Reply
  • Vijay Anand Kannan
    September 23, 2009 9:46 pm

    Jacob,

    How you got those date?. If i go by 1500 Article Calculation, it matches for 2000th Article.

    But if i go current date, it does not matches.

    Select DateAdd(Day,400,GetDate()),DateAdd(Day,900,GetDate())

    Select DateAdd(Day,500,’07/18/2010′)

    Just for the Interest.

    Let me know

    Thanks

    Vijay Anand Kannan

    Reply
  • Hi Pinal,

    Congratulations for getting a huge achiement.

    Reply
  • Hello Pinal,

    I need to create wild query with following condition.

    Give all records where Name does not contain ‘Sto’ any where in data.

    I can get the correct result if I use query like this:
    –Correct query
    select * from Production.Location where Name not like ‘%Sto%’

    But I cannot use “not like” because some architectural constraints.

    So I am trying to use following kind of query:
    select * from Production.Location where Name like ‘%[^S][^t][^o]%’

    But this is not providing the correct result.

    Could you help me correcting this query?

    (Note: I have used “AdventureWorks” database in above query)

    Thanks,
    Hardik

    Reply

Leave a Reply

Menu
Exit mobile version