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 – 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)
8 Comments. Leave new
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! :-))
hint: I used a TSQL built-in function to get those dates
:-)
Congratulations Pinalbhai to achieve this milestone.
What is the formula to calculate those dates?
I tried but didn’t get idea behind it.
Tejas
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
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
Hi Pinal,
Congratulations for getting a huge achiement.
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