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

Showing posts with label sqlpass. Show all posts
Showing posts with label sqlpass. Show all posts

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

5/15/2016

SQLPASS SUMMIT 2016 Discount Code

SQLPASS SUMMIT 2016 is around, only few months left for this super event. Probably you all would have heard about the SQLPASS SUMMIT but let me just brief you about this event. This event happens every year during October in different cities in USA, 3 days event. Well, you would also ask why I would bother even if it's an event that run for 3 or 4 days? I would say, my friend, you just need to go to SQLPASS SUMMIT 2015 website and read some numbers, you will surprise to see that there are thousands of people travelling to attend this SUMMIT and to listens the renown speakers including MCM, MVPs. Edwin Sarmiento ( T | B ), my colleague, SQL MVP, MCM and friend is kind of enough to write a guide for SQLPASS SUMMIT First Timer.  

So, let me end the surprise here, want to attend the SQLPASS SUMMIT 2016? Then I have something that would make you happy, and, that is the discount code worth 150$, yes, you've read it right. What you need to do is, while you are registering you need to provide the below details and avail 150$ discount. 

Your Chapter: Surat User Group
Unique Discount Code: LC15KCF8
*The discount code cannot be combined with any other PASS Summit 2016 registration, and cannot be applied retroactively

I would also suggest that you:
  1. Don't forget to read a guide for SQLPASS SUMMIT First Timer by Edwin Sarmiento ( T | B )
  2. Use the Unique discount code when you register for SQL PASS SUMMIT
  3. I am attending the SUMMIT this year, if you happened to attend this year, let's meet. I will be on twitter  




Thank you
Hemantgiri S. Goswami

1/20/2016

SQL Server Community Activities under Surat User Group

I am very pleased to announce that I will be speaking about SQL Server Storage Structure, Level 100 session on 23rd Jan 2016 at 5 PM.  


Well, this will be the first appearance as a speaker after 2012, since this is on-demand session there will be limited number of audience of 10~20 but I will be very happy to speak.  There will be some announcement to be made after the discussion of this UG meet and I will wrote another post and make those announcement public.

The Venue will be:

Inkey Solutions
406, Empire State Building, Ring Road, Nr Udhna Darwaja

4/20/2009

Get Discount of 25% to first 25 people for Surat SQL Server User group - TechEd India 2009

Dear Surat SQL Server User Group members,

Culminis, INETA APAC and PASS, have worked along with Microsoft to secure a unique discount for our user group members. TechEd is happening in after a period of 3 years. http://www.microsoft.com/india/teched2009/. With Steve Balmer, CEO of Microsoft is giving the Keynote, and illustrious speakers presenting.

Tech.Ed-India 2009 is all about getting yourself ready for the next wave of technology innovations and trends. In today's economic scenario, more than ever before, it has become pertinent that we stay ahead of the curve so as to establish ourselves as the future trend- setters. Tech.Ed-India 2009 - with its offering of sub-events - offers you this opportunity to interact with some of the leading lights in the business and technology space globally, talk to Microsoft product development teams directly, and get in-depth hands-on-trainings and certifications in some of the most coveted and anticipated technologies of our time.

Special Discount for Surat SQL Server User Group Members

If you are attending TechEd, as a member of "Surat SQL Server User Group" you can get a 25% discount. This discount is available to the first 25 people to respond via an email to inteched2009@surat-user-group.org the first 25 people to respond will receive instructions on how to avail the discount.
You are requested to Share your User name and email id which you use to sign in to Surat User Group Website while submitting your request.

Hey, if you are not the registered member of Surat User Group, do not worry. Get your self registered here and grab the opportunity!!!!

3/30/2009

2009 PASS SUMMIT UNITE


Its a time to get register for the great event, yes I am talking about the the SQLPASS Summit 2009 event to be happen during Nov 2~5 at Seattle; there are lots of saying about this event and there are more then single good reason to join the event explore the reasons "Why to attend SQLPASS SUMMIT?"

Get the full details of 2009 PASS Summit UNITE and get registered

Get early bid rate, do register for your seat at 2009 SQL PASS Summit UNITE