Archive for January 4th, 2012

SQLSaturday #116–My session January 4th, 2012

Vinod Kumar

What a nice way to start the New Year 2012? We will be hosting the first ever SQL Saturday #116 in India here in Bangalore on Jan 7th. With just 2 days to go, I am super excited to speak at the event.

The Technology Evangelism within me will never die and love to be with you folks in every opportunity I get. So the new year and SQL Saturday #116 was such an incentive that I thought I shouldn’t miss the request of applying for a session. I am really glad to hear that the SQL PASS chapter folks were kind enough to accept my session.

Security with SQL Server – Discovering Pitfalls

The session that I plan to deliver will be a dry topic around security. This is the second time I thought this will be interesting to talk on this very topic because it allows me to innovate something new and interesting that people will find interesting. The previous time I talked around Security was at TechEd India 2011 which I still remember was a houseful session with some really interesting demos. Even this session that I plan to discuss will on some common interesting practical problems that an administrator will need to tackle day-in-day-out.

  1. Have you ever thought of the concepts around “Principal of least privileges” inside SQL Server?
  2. Do you use an administrative account to access SQL Server?
  3. How do you prevent access of SQL Server and data from Administrator?
  4. How will you prevent unnecessary access to SQL Server and restrict with just the enough permission for an Administrator for the activity that they need to do?

If you are grappling and thinking on these questions, don’t forget to attend my session on Jan 7th at SQL Saturday #116, India at 2:30PM IST.

Some really cool and interesting demo’s available to enthrall you for close to 60 minutes. I will also give away couple of my books during the session if you answer correctly or manage to stump me with a witty tricky question on SQL Server :).

What else to expect?

Since this is the first ever SQL Server Saturday event in India, there are some interesting lineup of speakers and content up for grab.

  1. SQL Clinic Introduced: As the GTSC Team says – “We love the challenge of new problems that we have not seen before and derive immense amount of satisfaction in helping someone resolve a tough or difficult issue involving SQL Server! If you have a specific problem to solve, it helps to bring the details. ERRORLOG files, error messages, specific query syntax, or details of your environment. The more background context you provide us with, the more we can narrow down with our suggestions. No presentations, just some serious troubleshooting and on-the-spot assistance from 2:30PM IST – 5PM IST under the Practical track.“. In this session meet the real experts from the SQL Server team available for you exclusively at the event. Don’t forget to do your homework on the SQL Error you want to discuss with the experts. As I hear there will be people from SQL Server Engine side, BI, Reporting etc.
  2. Two awesome Technical sessions lined up. I will be at the Community track with Rick Morelan is founder of Joes 2 Pros series, Lohith, Pinal Dave and Balmukund.

With the whole event already overbooked we are excited to meet you all at the event. If you want to drop us a line, please feel free to use the #SQLSat116 tag over twitter.

If you are planning to be at this in-person event, you must be registered already on the SQL Saturday site, else entry will not be guaranteed.

Check what my friends Lohit, Pinal Dave, Amit Banerjee have to say in their respective blogs about this event.

Continue reading...