SQLAuthority News – Presenting at Sarasota IT Pro Camp, Florida on February 16, 2013

I am traveling the entire month of February 2013 in USA. First 18 days I am Florida and later part I am heading to another part of the country. When I am in India, every weekend I make a point to attend one of the User Group Meeting in the city. However, the same becomes a bit difficult when I am traveling across the globe. Well, it does not matter where I am and what position I am – if there is a community event, I am going to be there.

Tomorrow on February 16, 2013 Saturday, I am going to present at Sarasota IT Pro Camp, Florida. Special thanks to Jose Chinchilla (Twitter|Blog) for making everything possible for the event. Here are the details about the event:

Location:
Keiser University
6151 Lake Osprey Drive
Sarasota, FL 34240

Date & Time:
9:00 AM February 16, 2013 Saturday

Session Details:
Tips and Tricks for Blazing Fast SQL Server Performance
Slow Running Queries are the most common problem that developers face while working with SQL Server. While it is easy to blame the SQL Server for unsatisfactory performance, however the issue often persists with the way queries have been written, and how SQL Server has been set up. The session will focus on the ways of identifying problems that slow down SQL Servers, and tricks to fix them. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

Hope to see you there soon!

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

SQL SERVER – Get 2 of My Books FREE at Koenig Tech Day – Where Technologies Converge!

As a regular reader of my blog – you must be aware of that I love to write books and talk about various subjects of my book. The founders of Koenig Solutions are my very old friends, I know them for many years. They have been my biggest supporter of my books. Coming weekend they have a technology event at their Bangalore Location. Every attendee of the technology event will get a set of two books worth Rs. 450 – ‘SQL Server Interview Questions And Answers‘ and ‘SQL Wait Stats Joes 2 Pros‘. I am going to cover a couple of topics of the books and present  as well. I am very confident that every attendee will be having a great time.

I will be covering following subjects:

SQL Server Tricks and Tips for Blazing Fast Performance

Slow Running Queries (SQL) are the most common problem that developers face while working with SQL Server. While it is easy to blame the SQL Server for unsatisfactory performance, however the issue often persists with the way queries have been written, and how SQL Server has been set up. The session will focus on the ways of identifying problems that slow down SQL Servers, and tricks to fix them. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

After the session is over – I will point to what exact location in the book where you can continue for the further learning. I am pretty excited, this is more like book reading but in entire different format.

The one day event will cover four technologies in four separate interactive sessions on:

  • Microsoft SQL Server
  • Security
  • VMware/Virtualization
  • ASP.NET MVC

Date of the event:
Dec 15, 2012 9 AM to 6PM.

Location of the event: 
Koenig Solutions Ltd.
# 47, 4th Block,
100 feet Road, 3rd Floor,
Opp to Shanthi Sagar,
Koramangala,
Bangalore- 560034
Mobile : 09008096122
Office : 080- 41127140

Organizers have informed me that there are very limited seats for this event and technical session based on my book will start at Sharp 9 AM. If you show up late there are chances that you will not get any seats. Registration for the event is a MUST.

Please visit this link for further information.

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – #SQLPASS 2012 Book Signing Photos

I am at SQLPASS 2012 and the event is going great. Here are few of the random photos and random news.

We had participated in three different book signing event today.

  1. SQL Queries 2012 Joes 2 Pros Book 1 Launch and Book Signing
  2. SQL 2012 Functions Book Launch at Embarcadero
  3. SQL Backup and Recovery Book Launch at Idera

Rick Morelan and I authored the first two books 1) SQL 2012 Functions and 2) SQL Queries 2012 Joes 2 Pros Volume 1. Our dear friend Tim Randney authored SQL Backup and Recovery Book. In the book signing event of Tim Radney I went ahead of the time and stood in the line. I was fortunate to receive the very first copy of the autographed book from Tim Radney.

We have one more book signing event of the book SQL Backup and Recovery by Tim Randey on Friday 9, 2012 between 12 to 1 PM at Joes 2 Pros booth #117. This is your last chance to shake hands with us and meet us in person.

Reference: Pinal Dave (http://blog.sqlauthority.com)

 

SQLAuthority News – Presented at Bangalore DevCon August 4, 2012

Bangalore Devcon 2012 was a great fun. Earlier this month I was fortunate to be invited to present at Dev Con. The event was very well planned and had excellent response. There were more than 140 attendees at any time in the sessions. There were two tracks and both tracks were running parallel to each other in the Microsoft Bangalore building. The venue is fantastic and the enthusiasm of the community is impeccable.

We had a total of 12 sessions during the day. I had decided to attend each session if I can. We have so many fantastic speakers and I did not want to miss any of the sessions. As sessions were running parallel, I attended every session for 30 minutes and switched to another session. I had fun doing this experiment as tit gave me a good idea about every session.

I presented personally on the session of SQL Tips and Tricks for Web Developer. DBA is a very common word and every time when we say SQL Server – lots of people think of DBA in their mind, however, SQL Server is used by many developers as well. In this session I tried to cover a few of the simple concepts where developers must pay special attention while writing T-SQL code. Sometimes a very small mistake can be very fatal on performance in the future.

Here are few of the photos of the event.

Btw, the two sessions which clearly stand out were Vinod Kumar‘s session on Leadership and Lohith‘s session on Visual Studio Tips and Tricks.

Additional Read:

Following are the blog posts by community on the Bangalore DevCon Experience. I encourage you to read them all and leave a comment which one you liked the most.

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQL SERVER – Weekend Project – Visiting Friend’s Company – Koenig Solutions

I have decided to do some interesting experiments every weekend and share it next week as a weekend project on the blog. Many times our business lives and personal lives are very separate, however this post will talk about one instance where my two lives connect.

This weekend I visited my friend’s company. My friend owns Koenig, so of course I am very interested so see that they are doing well.  I have been very impressed this year, as they have expanded into multiple cities and are offering more and more classes about Business Intelligence, Project Management, networking, and much more. Koenig Solutions originally were a company that focused on training IT professionals – from topics like databases and even English language courses.  As the company grew more popular, Koenig began their blog to keep fans updated, and gradually have added more and more courses.

I am very happy for my friend’s success, but as a technology enthusiast I am also pleased with Koenig Solutions’ success.  Whenever anyone in our field improves, the field as a whole does better.  Koenig offers high quality classes on a variety of topics at a variety of levels, so anyone can benefit from browsing this blog. I am a big fan of technology (obviously), and I feel blessed to have gotten in on the “ground floor,” even though there are some people out there who think technology has advanced as far as possible – I believe they will be proven wrong.  And that is why I think companies like Koenig Solutions are so important – they are providing training and support in a quickly growing field, and providing job skills in this tough economy.

I believe this particular post really highlights how I, and Koenig, feel about the IT industry.  It is quickly expanding, and job opportunities are sure to abound – but how can the average person get started in this exciting field?  This post emphasizes that knowledge is power – know what interests you in the IT field, get an education, and continue your training even after you’ve gotten your foot in the door.

Koenig Solutions provides what I feel is one of the most important services in the modern world – in person training.  They obviously offer many online courses, but you can also set up physical, face-to-face training through their website.  As I mentioned before, they offer a wide variety of classes that cater to nearly every IT skill you can think of.  If you have more specific needs, they also offer one of the best English language training courses.  English is turning into the language of technology, so these courses can ensure that you are keeping up the pace. Koenig Solutions and I agree about how important training can be, and even better – they provide some of the best training around.  We share ideals and I am very happy see the success of my friend.

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – Presenting at Great Indian Developer Summit 2012 – SQL Server Misconception and Resolutions

Earlier during TechEd 2012, I presented a session on SQL Server Misconception and Resolutions. It was a pleasure to present this session with Vinod Kumar during the event. Great Indian Developer Summit is around the corner and I will be presenting there once again with the same topic. We had an excellent response during the last event; the hall was so filled, but there were plenty who were not able to get into the session as there was no place for them to sit or stand inside. Well, here is another chance for all who missed the presentation.

New Additions

During the last session, we were a two-presenter tag team, and we presented the session in a sense that it would suit two speakers in one stage. But this time, I am the only presenter, so I decided to present this session in a much different way. I will still assume there are two presenters. One of the presenters will be me, of course, and the second person will be YOU! Yes, you read that right – you will be presenting this session with me. If you wonder how, well, you will have to attend the session to figure it out.

Talking Points

We will be talking about the following topics in the session which we will relate to SQL Server:

  • Moon Landing
  • Napoléon Bonaparte
  • Wall of China
  • Bollywood

…and of course, SQL Server itself. I promise that this 45 minute- presentation will be the one of the highlights of the event for you.

Goodies

I can only promise 20 goodies as of the moment. I might bring more when you meet me there.

Session Details

Title: SQL Server Misconceptions and Resolution – A Practical Perspective (Add to Calendar)

Abstract:

“The earth is flat”! – An ancient common misconception, which has been proven incorrect as we progressed in modern times. In this session, we will see various database misconceptions prevailing and their resolutions with the aid of the demos. In this unique session, the audience will be a part of the conversation and resolution.

Date and Time: April 17, 2012, 16:55 to 17:40

Location:
 J. N. Tata Auditorium, National Science Symposium Complex (NSSC), Bangalore, India

Add to Calendar

Reference : Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – Reliving TechEd with Vinod Kumar at Bangalore User Groups

TechEd India 2012 was held in Bangalore last March 21 to 23, 2012. Just like every year, this event is bigger, grander and inspiring. Here is my blog post reviewing the event SQLAuthority News – #TechEdIn – TechEd India 2012 Memories and Photos. For me this is family event – I get to meet my friends who are dear as my family. I like to call User Groups as family too. Family shares life’s personal happiness and experience – the same way User Group shares professional experiences and quite often UG members become just like family member.

When I learned that follower user group together building up a unique event I was pretty excited to learn who is going to be speaker for the event.

  1. BDotNet.in – Bangalore .NET Usergroup
  2. BITPro.in – Bangalore ITPro Usergroup

It was indeed joy when I learned that presenter will be Vinod Kumar, who is integral part of user groups and hardcore SQL Server enthusiast.

Vinod Kumar is going to present on following two sessions which are both focused on internals of the Windows and SQL Server.

  1. Understanding Windows with SysInternals Tools – This session will cover various tools from usage of Memory, x86 architecture, x64, WOW mode, Page faults, Virtual Memory mapping, OOM scenario, Perf Tool, PAL tool, Logman and more.
  2. Peeling the Onion: SQL Server Internals Demystified – This session will cover advanced disk formats, SQL Server 2012 security changes, memory changes, indirect checkPoint and more.
I am very excited as this time I will get opportunity to sit in front rows (as I will be reaching there to get best possible position) and learn. I am looking forward to the event and I hope you will join us as well.

Event Details:

Date: Saturday, April 7, 2012 (10:30am until 1:30pm)

Venue: Microsoft, Domlur, Bangalore.

Event Details: https://www.facebook.com/events/139444029517882/

This session is FREE for all and everybody and anybody can walk in.

Community Blog Posts

Here are few of the blog post written by the community on this subject.

Reference: Pinal Dave (http://blog.sqlauthority.com)