SQL Server security best practice

Security! This is the word comes in mind of every concerned person when it come...

Change the Collation Settings in MS SQL Server

This post will show you how to change the collation settings in MS SQL Server for specific database...

Resolve collation conflict

In this post I will show you how you can resolve collation conflict error...

Book: SQL Server 2008 High Availability

In this book I have tried to cover every single piece of information that might requires for installing and configuring SQL Server HA option like Clustering, Replication, Log Shipping and Database Mirroring...

Why to recompile Stored Procedure

Generally, we create views and stored procedures (proc here after) ...

11/20/2016

New home for SQL Server Citation



Change is inevitable, it's natural. I would like to quote few lines from Shrimad Bhagavad Gita says     Change is the law of the the universe.  In my opinion, change will bring good to your life, always. 

In 2004, I have started this blog, like others, this blog was started to make notes for myself so that it's available for me whenever and wherever I want to refer. Initially this blog was not public, as I was thinking and fearing that whoever is going to read will laugh at the way I am writing, the grammatical mistakes I do, the topic I choose to write and so on, and the most stupid reason was no one is going to read my blog.  I was reading few articles based on Shrimad Bhagvad Gita, where I read the above quote, and I thought, okay, let's begin the change. I made this blog public, conquer my fear of thinking people laughing at me and my mistakes. Now, I thought, the only way to learn new things is to read, and try, unless you don't do mistake you will have very less chance to learn how to improve, and that's why I never believe in perfection - it will never make you think of improvement, there is no 100% in my dictionary, it's always 90%. I remember the days when SQL Server Pedia and was managed by Brent Ozar, I wanted my blog to get syndicate there but I could not do that. The reason was grammatical mistake, and, since my attitude was to correct my mistake, Brent introduced me to Lori Edwards ( B ), Jeremiah Peschka ( B ) and Patrick Kansa ( B ) who have helped me tremendously to proof read my writing, suggesting and help modification in my posts. I would like to thank Brent Ozar, Lori Edwards, Jeremiah Peschka and Patrick Kansa for helping and inspiring me, and everyone who have helped me grow .

When  HA was newly introduced and was buzz word, I have been on some projects where I have to helped customer, and I failed it but then, I was able to author a book on that very topic, for beginners though. That means, I love and believe in the quote that I have mentioned in starting.  I was amateur blogger then, and I am still. 

This blog space is hosted on Blogger platform, it has served me well. But as I already mentioned, changed is inevitable and is only constant. Few days back, in my last post I have mentioned that it will be the new beginning. Well, here is an announcement, this blog space is moving to somewhere else. It will be on word press platform. It is still in in designing phase, I will make an announcement of it's new home in my next post. 

Keep loving me and keep visiting.


photo credit: forrest.wheatey Moving box via photopin (license)

photo credit: Yevy Photography paint via photopin (license)

11/07/2016

A New Beginning #SQLFamily

For the years I have been watching the SQLPASS session recording and hearing that it's really a different experience to see all that happening for real, In-Person!! I was always wondering if I can get a chance to attend SQLSummit and after little while I have my chance - thanks to @sqlpass and +Pythian for helping me.

In the month of May I was able to secure my seat to #SQLSummit and I was so happy and excited as it was my first time, I was excited to see my extended family - #SQLFamily and lots of other folks  whom I have interacted past 6~7 years and haven't had chance to meet In-Person, and, of course there are many technical sessions to attend and learn.

Preparing - Not much on this part, as I have already read my friend Edwin Sarmiento's ( B | T ) guide to First Timers, I would recommend every one to read this guide, extremely helpful. 

I have started my journey on 22nd October from Surat, my native and the city I live and reached Seattle on 23rd October. It was a long journey but it's okay as I was excited to see my colleagues, at the airport I met Amit Bansal ( B | T ) and Luan Moreno ( B | T ) later meet Edwin Sarmiento, Murilo Miranda ( B | T ). We've been working since 4 years and had many conference/video calls but this was the first time we see each other. +Pythian has sponsored our stay which was nice and just about a block away from conference hall, so convenient, Thank you +Pythian. Technically (according to IST), it was my birthday which I have spent with my friend Ashish Sharma ( L | T ), Shreya Sharma ( L ) and Luan. Ashish and I know each other since 2008, not so long but we share a relation like brothers do, he lives in Vancouver, Canada, and he drive all the way to Seattle just to meet me, we had lunch, did some shopping and of course we talk a lot, love you bro!!  

Day - 0
24th October, the day started with fun, Luan started taking sadistic pleasure and confusing me around time zone difference, every hour he reminds me what time it would be for me. At the end of the day, headed towards Pike Street and visited StarBuck's first every coffee shop.

Day - 1
On the 25th October I completed my registration and headed to attend chapter leaders meeting where I met Gogul Aryalingam ( B | T ) who is RM for APAC region of SQLPASS for the first time, and we are friend now. Later that day, I met my good friend Pinal Dave ( B | T ) and make a new friend Paras Doshi ( B | T ), and we recall old memories. 

Day - 2
Here comes the real excitement, the actual first day of the #SQLSummit, attended the key notes and then I saw Zaheer Khan (No, not an Indian Cricketer) who was my Team Manager when I was working with Satyam back in 2007, and it was this time I met him after 2007 and I wasn't aware that he's attending. Since I have developed my interest in Azure, most of the sessions I have attended are around Azure, along with Leadership (non-technical) and HA related sessions. This day I met few more colleagues of mine - Warner Chaves ( B | T ), Alejandro Cordero ( B | T ), Chris Presley ( B | T ), Scott McCromic ( B | T ) and Shara French (B | T ). met John Eisbrener ( B | T ) who was my Team Manager in recent past, aah I met Amit Banerjee ( B | T ) as well, Luan and Murilo presented on Enterise Database Administration and Deployment in lightening talk. 

Day - 3
Again, attended few more sessions and during break I met few more people, like Yvonn Vansalageren, Sourav Mukharjee ( B | T ).  This evening, attended the annual blogger's meet organized by my employer where I met Paul Vallee ( B | T ) who is a founder and CEO of +Pythian, he is amazing person, also meet some of other bloggers.

Day - 4 
Since the morning, it was mix feeling of excitement and sadness as it was the last day of the event. Again, had attended some sessions and meet my new and old friends, felt so sad to say good bye until next time to my extended #sqlfamily and I am agree with each word written by Edwin in his post - I so hate leaving my #SQLFamily.

Day - 5 
Edwin left the place early morning to catch his next flight, Luan left couple of hours later to catch his flight to his home while I and Murilo was waiting for our cab as our flight will take off about noon. We both boarded in the same flight and bid good bye each other at Paris airport, promising each other to see you soon (team meeting). 

Day - 6,7 & 8........
Guys, this is the fun part, I build a story, a conspiracy to surprise my family - since the day I landed in Seattle I was saying my family that I will be back home on 4th November on my daughter's birthday,. After I landed at Mumbai airport on 31st mid night I headed to Andheri station to catch train to my native, I have already talked to my wife and kids that I will be calling on Skype about 11 AM and we'll have video call so we can see each other, as, 31st is celebrated as new year in Guajrat, everyone was agreed, technically "on the same page".  And, when I reach home, I was surprised, no ones at home, they went to temple to have blessings and I waited for them in reception area of my society. But yes, it paid off finally, my daughter was so happy to see me, and my son too!!  For next 2 days, I was like zombie due to Jetleg.  

I know, it hast to end but that's the sad part, and there is a happy part as well, a new beginning - I am so happy that I have decided to meet my #SQLFamily in one or other conference, sessions in India and other part of world, and to do so, I would participate in more activities hereafter. Starting with joint event of Surat and Mumbai SQLPASS Chapter, I will post more details after we freeze schedule, keep watching this place for more details.

I met Pinal afte 6 years and we talk a lot during conference, almost daily and we talk about NoSQL; I mean, not about SQL, its about family, city, leaving, job etc everything but SQL :). Sameway, a lots of discussion with Luan, Murilo and Edwin and we never discuss about techical stuff, we have team meeting for that, those days were for friends, and I really enjoyed it very much. I wish I could have some more time to meet amazing people like Brent Ozar ( B | T ), Parikshit Savjani ( B | T ) and Kevin Kline ( B | T ), I believe that the world is small, we'll meet in some other conference if not, for sure next time at SQLSummit. 

A photo album of the event, #SQLSummit

Source of Image: http://gph.is/1XOVmky