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.

Tags: , , , , , ,

This entry was posted on Wednesday, January 4th, 2012 at 07:00 and is filed under Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.


7 Responses to “SQLSaturday #116–My session”

  1. Shreesha Kumar says:

    Vinod, Your session on Security with SQL Server was really informative. There was a question on Grant taking precedence over Deny in one particular condition. As per MSDN “A table-level DENY does not take precedence over a column-level GRANT. This inconsistency in the permissions hierarchy has been preserved for the sake of backward compatibility. It will be removed in a future release.” under following link http://msdn.microsoft.com/en-us/library/ms187965.aspx Is this the one you were referring to?

  2. Swarna Siva Kumar says:

    Thanks for Vinod, Lohit, Pinal Dave, Balmukund and Rick Morelan(Front end check boxes) to conduct this session in Bangalore, and thanks to GTSC Team & backend(code)team for there support. Its nice experience for me to recollect/learn SQL from this session. We are all eagerly waiting for next sessions…

    Regards,
    Swarna Siva Kumar

  3. Pinal Dave says:

    I agree… I am eagerly waiting for Lohith in action… he is fabulous speaker.

  4. Lohith says:

    Vinod, thanks for the pig back to my post. Will be first time i will be sharing stage with you :) excited …

    Lohith

Leave a Reply