I have presented on various database technologies for almost 10 years now. SQL, Database and NoSQL have been part of my life. Earlier this month, I had the opportunity to present on the topic Performing an Effective Presentation. I must say it was blast to prepare as well as present this session. This event was part of the SQL Bangalore community. If you are in Bangalore, you must be part of this group.
SQL Bangalore is a wonderful community and we always have a great response when we present on technology. It is SQL User Group and we discuss everything SQL there. This month we had SQL Server 2014 theme and we had a community launch of SQL Server. We have the best of the best speakers presenting on SQL Server 2014 technology. The event had amazing speakers and each of them did justice to the subject. You can read about this over here.
In this session I told a story from my life. I talked about who inspired me and how I learned to speak in public. I told stories about two legends who have inspired me. There is no video recording of this session. If you want to get resources from this session, please sign up my newsletter at http://bit.ly/sqllearn.
Well, I had a great time at this event. We had over 250 people showed up at this event and had a grand time together. I personally enjoyed a session of Amit Benerjee, Balmukund Lakhani and Vinod Kumar. Ken and Surabh also entertained the audience. Overall, this was a grand event and if you were in Bangalore and did not make it to this event. You did miss out on a few things.
Here are a few photos of this event.
SQL Bangalore UG Nupur, Chandra, Shaivi, Balmukund, Amit, Vinod
SQL Bangalore UG Audience
Pinal Dave presenting at SQL UG in Bangalore
Here are few of the slides from this presentation:
It has been quite a long time since I posted SQL in Sixty Seconds Video. Here we are back with the new video.
One of the most popular question, I often receive is very similar to following:
“How do I reset the password for SA username?”
“I have forgotten the SA password, what should I do?”
“Our DBA just left the job and now noone knows how to reset the SA password. Please help.”
Honestly, it is pretty simple to reset the password for SA username. You just have to login to the system where your SQL Server is installed. Open SQL Server Management Studio and login with the help of Windows Authentication. As local system is the admin of the SQL Server, you will get access with administration privileges. Now, open the database, expand Security >> Login folder and right click over SA username. Now, it will bring up the screen where you can change the password for SA.
SQL in Sixty Seconds Video
I have attempted to explain the same subject in simple words over in following video.
Here are the blog posts I have previously written on the subject of SA password. You can read it over here:
The Great Indian Developer Conference (GIDS) is one of the most popular annual event held in Bangalore. This year GIDS is scheduled on April 22, 25. I will be presented total four sessions at this event and each session is very different from each other. Here are the details of four of my sessions, which I presented there.
This event was a great event and I had fantastic fun presenting a technology over here. I was indeed very excited that along with me, I had many of my friends presenting at the event as well. I want to thank all of you to attend my session and having standing room every single time. I have already sent resources in my newsletter. You can sign up for the newsletter over here.
Indexing is an Art
I was amazed with the crowd present in the sessions at GIDS. There was a great interest in the subject of SQL Server and Performance Tuning.
Audience at GIDS
I believe event like such provides a great platform to meet and share knowledge.
Pinal at Pluralsight Booth
Here are the abstract of the sessions which I had presented. They were recorded so at some point in time they will be available, but if you want the content of all the courses immediately, I suggest you check out my video courses on the same subject on Pluralsight.
Slow Running Queries are the most common problem that developers face while working with SQL Server. While it is easy to blame SQL Server for unsatisfactory performance, the issue often persists with the way queries have been written, and how Indexes has been set up. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.
Indexes are the most crucial objects of the database. They are the first stop for any DBA and Developer when it is about performance tuning. There is a good side as well evil side to indexes. To master the art of performance tuning one has to understand the fundamentals of indexes and the best practices associated with the same. We will cover various aspects of Indexing such as Duplicate Index, Redundant Index, Missing Index as well as best practices around Indexes.
SQL Server Performance Troubleshooting: Ancient Problems and Modern Solutions
Many believe Performance Tuning and Troubleshooting is an art which has been lost in time. However, truth is that art has evolved with time and there are more tools and techniques to overcome ancient troublesome scenarios. There are three major resources that when bottlenecked creates performance problems: CPU, IO, and Memory. In this session we will focus on High CPU scenarios detection and their resolutions. If time permits we will cover other performance related tips and tricks.
At the end of this session, attendees will have a clear idea as well as action items regarding what to do when facing any of the above resource intensive scenarios. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session. To master the art of performance tuning one has to understand the fundamentals of performance, tuning and the best practices associated with the same. We will discuss about performance tuning in this session with the help of Demos.
Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. However, not many people talk about MySQL and Performance Tuning as it is an extremely unexplored territory. In this session, we will talk about how we can tune MySQL Performance. We will also try and cover other performance related tips and tricks. At the end of this session, attendees will not only have a clear idea, but also carry home action items regarding what to do when facing any of the above resource intensive scenarios. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session. To master the art of performance tuning one has to understand the fundamentals of performance, tuning and the best practices associated with the same. You will also witness some impressive performance tuning demos in this session.
Hidden Secrets and Gems of SQL Server We Bet You Never Knew
It really amazes us every time when someone says SQL Server is an easy tool to handle and work with. Microsoft has done an amazing work in making working with complex relational database a breeze for developers and administrators alike. Though it looks like child’s play for some, the realities are far away from this notion. The basics and fundamentals though are simple and uniform across databases, the behavior and understanding the nuts and bolts of SQL Server is something we need to master over a period of time.
With a collective experience of more than 30+ years amongst the speakers on databases, we will try to take a unique tour of various aspects of SQL Server and bring to you life lessons learnt from working with SQL Server. We will share some of the trade secrets of performance, configuration, new features, tuning, behaviors, T-SQL practices, common pitfalls, productivity tips on tools and more.
This is a highly demo filled session for practical use if you are a SQL Server developer or an Administrator. The speakers will be able to stump you and give you answers on almost everything inside the Relational database called SQL Server.
Yesterday I attended the SQL Server Community Launch in Bangalore and presented on Performing an effective Presentation. It was a fun presentation and people very well received it. No matter on what subject, I present, I always end up talking about SQL. Here are two of the questions I had received during the event.
Q1) I want to install SQL Server on my development server, where can we get it for free or at an economical price (I do not have MSDN)?
A1) If you are not going to use your server in a production environment, you can just get SQL Server Developer’s Edition and you can read more about it over here.
Here is another favorite question which I keep on receiving it during the event.
Q2) I already have SQL Server installed on my machine, what are different feature pack should I install and where can I get them from.
The Microsoft SQL Server 2014 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft SQL Server. It includes tool and components for Microsoft SQL Server 2014 and add-on providers for Microsoft SQL Server 2014. Here is the list of component this product contains:
Microsoft SQL Server Backup to Windows Azure Tool
Microsoft SQL Server Cloud Adapter
Microsoft Kerberos Configuration Manager for Microsoft SQL Server
Microsoft SQL Server 2014 Semantic Language Statistics
Microsoft SQL Server Data-Tier Application Framework
Microsoft SQL Server 2014 Transact-SQL Language Service
Microsoft Windows PowerShell Extensions for Microsoft SQL Server 2014
Microsoft SQL Server 2014 Shared Management Objects
Microsoft Command Line Utilities 11 for Microsoft SQL Server
Microsoft ODBC Driver 11 for Microsoft SQL Server – Windows
Microsoft JDBC Driver 4.0 for Microsoft SQL Server
Microsoft Drivers 3.0 for PHP for Microsoft SQL Server
Microsoft SQL Server 2014 Transact-SQL ScriptDom
Microsoft SQL Server 2014 Transact-SQL Compiler Service
Microsoft System CLR Types for Microsoft SQL Server 2014
Microsoft SQL Server 2014 Remote Blob Store
SQL RBS codeplex samples page
SQL Server Remote Blob Store blogs
Microsoft SQL Server Service Broker External Activator for Microsoft SQL Server 2014
Microsoft OData Source for Microsoft SQL Server 2014
Microsoft Balanced Data Distributor for Microsoft SQL Server 2014
Microsoft Change Data Capture Designer and Service for Oracle by Attunity for Microsoft SQL Server 2014
Microsoft SQL Server 2014 Master Data Service Add-in for Microsoft Excel
Microsoft SQL Server StreamInsight
Microsoft Connector for SAP BW for Microsoft SQL Server 2014
Microsoft SQL Server Migration Assistant
Microsoft SQL Server 2014 Upgrade Advisor
Microsoft OLEDB Provider for DB2 v5.0 for Microsoft SQL Server 2014
Microsoft SQL Server 2014 PowerPivot for Microsoft SharePoint 2013
Microsoft SQL Server 2014 ADOMD.NET
Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server 2014
Microsoft SQL Server 2014 Analysis Management Objects
Microsoft SQL Server Report Builder for Microsoft SQL Server 2014
Microsoft SQL Server 2014 Reporting Services Add-in for Microsoft SharePoint
SQL Bangalore is a wonderful community and we always have a great response when we present on technology. It is SQL User Group and we discuss everything SQL there. This month we have SQL Server 2014 theme and we are going to have a community launch on this subject. We have the best of the best speakers presenting on SQL Server 2014 technology. Looking at the whole line of celebrity speakers, I have decided not to present on SQL Server.
I will be presenting on the performance tuning subject, but with the twist of soft skills. I will be presenting on “Performing an Effective Presentation“. Trust me, you do not want to miss this presentation, I will be presenting on how to present effectively when presenting SQL Server topics.
What this session will NOT have
I personally believe that we all are good presenters most of the time. We can all easily call out if someone is bad presenter. There is no point talking about basics like bigger bullet points, talk loudly, talk with confidence, use better analogies etc. In simple words – this is not going to some philosophy session and boring notes.
What this session will have
Well, this session will tell stories of my life. It will tell how we can present about technology and SQL Server with the help of stories and personal experience. I am going to tell stories about two legends who have inspired me. Right after that we will be doing two exercises together where we will learn quickly and effectively, how to become better speaker – instantly!
There is no video recording of this session. If you want to get resources from this session, please sign up my newsletter at http://bit.ly/sqllearn
Here are few of the slides from this presentation:
Here is the details about the event and location
Venue: Microsoft Corporation, Signature Building, Embassy Golf Links Business Park, Intermediate Ring Road, Domlur, Bangalore – 560071
The agenda is amazing – we have top line SQL Speakers.
Everyone is welcome and don’t forget to get your friend along for this event. Loads to learn and tons to share !!!
Keynote (20 mins) byAnupam Tiwari – Business Program Manager – GTSC
Backup Enhancements with SQL Server 2014 byAmit Banerjee – PFE Microsoft
Performance Enhancements with SQL Server 2014 bySourabh Agarwal – PFE Microsoft
Performing an effective Presentation byPinal Dave – Community Member (SQLAuthority.com)
InMemory Enhancements with SQL Server 2014 byBalmukund Lakhani – Support Escalation Engg. Microsoft
Some more lesser known enhancements with SQL Server 2014 byVinod Kumar – Technical Architect Microsoft MTC
Power Packed – Power BI with SQL Server byKane Conway – Support Escalation Engg. Microsoft
I am very big fan of Amit, Balmukund and Vinod – I have always watched their session and this time, I am going to once again attend their session without missing a single min. They are SQL legends, I am going to be there and learn when they are sharing their knowledge.
There are few feelings which are hard to describe in words. Here is one of the such post.
Earlier last month, I attended one of the largest conference in North India – C Sharp Corner Annual Event. This event is the brainchild of Mahesh Chand and Dhananjay Kumar. These two gentlemen are amazing people. There is one thing common between them – love for people and passion for technology. I think it is such a great combination – they together build such a vibrant community which thrives to build a harmony in the developer’s eco-system.
A great audience
Six Years Ago – History Lesson 1
Pinal and Mahesh
I was new in the community and I came across a community celebrity in Seattle, when I was standing in the corner of a big hall. I did not know anyone and he walked to me and said – “Hey Pinal, I am thinking of building a community platform which helps developers to progress in their career, when I do, will you join us?“. He was known for his famous site CSharp Corner and mentor in the community. I knew him, but I never knew that he also knows me by name. Such a delight. I said – “Yes, sir, I will.” Six years passed and we never met again, however, we exchanged quite a few emails and talked on the phone but never met. The conversation never came up again about working together in community. This guy was none other than Mahesh Chand.
Four Years Ago – History Lesson 2
Pinal and Dhananjay Kumar (DJ)
Four years ago, I met a guy, who just wanted to make a difference in the world. He was driven with all the good qualities of a good human. He wanted to give back to the community and build a place where everyone can learn and explore the wonders of the technology. He just wanted to contribute and make a positive impact on people’s life and career. This guy is selfless, kind of Yogi (ascetic practitioners of meditation, a learned one), and full of energy. He asked – “Hey Pinal Sir, I am thinking of building a community platform which helps developers to progress in their career, when I do, will you join us?“. I knew him, but I never knew that he is going to ask me such an interesting question. I said – “Yes, I will.” In the last four years, we met quite a lot of time and talked about pretty much everything under the blue sky but never talked about any event or conference. This guy grew from a merely a passionate developer to mentors to thousands of young people. He becomes role model of youth who wants to make a difference in the developer community. This guy was none other than Dhananjay Kumar (commonly known as DJ or Debug_Mode).
Presenting at C Sharp Corner Annual Event 2014
Fast Forward – A Month Ago
Something interesting happens. I woke up early morning and I read email, it was from DJ, telling me to call him back. I called him up.
DJ: Sir, remember your promise? Pinal: Which one? Remind me please. DJ: The one where you said, you will be with me when I try to give back something to the community in the best possible way. Pinal: Well, that you have done for last many years, I have been with you always. DJ: Great, then you are coming to C Sharp Corner, the largest technology conference of North India. Pinal: I guess, I am joining.
Presenting at C Sharp Corner Event
I said yes to DJ. The next day I receive email from Mahesh Chand. It was very short but something about it touched my heart.
“Pinal, I expect that you join us in our efforts to give back to the community. You once said you will join, I guess, you will join as you said it.”
I replied – “I guess, I am joining.”
Fast Forward – Two Weeks Ago
There was energy in the environment. People were flowing from every corner of the India. Delhi seems to be the hottest destination for developers across pan India. When I was flying from Bangalore. I had quite a few people along with me traveling towards to Delhi. I was amazed with the passion of people traveling towards to Delhi. It seemed at the point that all the roads lead to Delhi. I was delighted looking at the positive energy of the life. It seemed to me that the entire world is conspiring to make this event successful.
Presenting session on “How to be a successful speaker”
This event was of two days. The first day was exclusive for C Sharp Corner Chaper Leaders and the second day was for everybody. The first day, I was asked to present on the subject of “How to be a successful speaker?” I think it was a very much humbling experience as everybody there was an amazing speaker and I was asked to present in front of them. I just went with my natural flow and shared my experiences. I learned a lots of new insight from Mahesh Chand, Dhananjay Kumar, Gaurav Mantri and Prabhjot Singh Bakshi.
Gaurav Mantri, Pinal Dave and Prabhjot Singh Bakshi
The next day was an even bigger day – there were about 850+ developers attending this event. Every single person was there to learn and explore new technology. This event had amazing lineup of the speakers.
The story of Joins
I presented on three different topics – Story of SQL Joins, Indexes – The Unsung Hero, T-SQL Worst Practices. It was a blast for me. I never had such a great response to my sessions. Every single person in the event was full of energy. When I remember the event, I still feel the great vibe of energy which prevailed at the event.
Conference Director and Speakers
The biggest reason behind any successful conference is the Conference Director/Chair of the event. Dhananjay was a conference director this event. He amazed everybody with his tireless energy and attention to detail. Every single thing about this event was planned and executed to perfection. Speakers were picked up from the airport to the surprise gift package for every delegate. This event was mastered with great precision details. Dhananjay spent hours and hours of his personal time in this event and built a successful platform where everybody wins. Truly, he has mastered the art of giving back to the community.
DJ is giving guidance to Pinal about Conference
Here is one example of his simplicity – the event had received way higher response than what we had expected. At point we ran out of chairs to sit. DJ noticed it and immediately gave up his own chair for attendees of the event. He called up his friends and asked to arrange more chairs, while he was sitting on the floor. He is such a simple person who put the interest of others first. Hats Off!
Indexes – The Unsung Hero
Another important task of Conferance Director was to pick up the best speakers. This event had one of the best speaker line up I have ever seen in my life.
Mahesh Chand and Dhanajay Kumar – I have talked a lot about them and the entire world knows this international speakers so I will not write anything more.
Gaurav Mantri – He is an amazing speaker and I was fortunate to hear them very first time in my life. He has the skills to make a complex subject easy. One of the masters of Azure and greatest friend of community. I think there is no better speaker than Gaurav to present on Azure and cloud.
Prabhjot Singh Bakshi – I know him for quite a while. He is one of the best experts in .NET. A unique, humorous attitude towards technology made us engaged throughout his session.
Suchit Khanna and Pinal Dave
Suchit Khanna and Brij Mishra – My new friends from Delhi, I spent quite a while with them while I was there and learned a lot with regards to life and its lessons.
Pinal Dave and Brij Mishra
I must congratulate Dhananjay Kumar for this amazing event.
I think this was one of the best event I had attended a special thanks to Mahesh, Dhananjay, Dinesh, Praveen, Maneesh and the entire team of the C Sharp Corner. You guys made this event a huge success. If there is one event must not miss in their lifetime – this is the event. It is not an event – it is gathering of family – a truly unique experience. This conference is part of my life, I will be always there.
I have been an avid reader of books. I read pretty much one or two books every week. I believe reading helps me a lot in my day job as well as well writing blog post. I am an evangelist and my primary responsibility is to spread the love for the technology. When I read more, I learn more and that effectively leads me to communicate better with my audience. Here is one of the recent book which I read and I loved it. This book is about what motivates us and what is the best job for us. I have read this book a second time and I think finally I have digested the meaning of this book. I love every bit of it and if you do not have it, you should get it.
When money is used as an external reward for some activity, the subjects lose intrinsic interest for the activity.
Rewards can deliver a short-term boost – just as a jolt of caffeine can keep you cranking for a few more hours. But the effects wears off – and, worse, can reduce a person’s longer term motivation to continue the project.
Enjoyment-based intrinsic motivation, namely how creative a person feels when working on the project, is the strongest and most pervasive driver.
Intrinsic motivation is of great importance for all economic activities. It is inconceivable that people are motivated solely or even mainly by external incentives.
Intrinsic motivation is conductive to creativity; controlling extrinsic motivation is detrimental to creativity.
It is those who are least motivated to pursue extrinsic rewards who eventually receive them.
Greatness and nearsightedness are incompatible. Meaningful achievement depends on lifting one’s sights and pushing toward the horizon.
Any extrinsic reward should be unexpected and offered only after the task is complete.
Type Intrisic behavior emerges when people have autonomy over the four T’s: their task, their time, their technique, and their team.
If you want to work with more type Intresic’s the strategy is to become one yourself. Automony, it turns out, can be contagious.
There is complexity, autonomy, and a relationship between effort and reward in doing creative work, and that’s worth more to most of us than money.
Carrots & sticks are so last century. Drive says for 21st century work, we need to upgrade to autonomy, mastery & purpose.
This new approach has three essential elements: (1) Autonomy—the desire to direct our own lives; (2) Mastery—the urge to get better and better at something that matters; and (3) Purpose—the yearning to do what we do in the service of something larger than ourselves.
It has been almost 2 years since we had a poll on this blog so here a poll which ask you three simple questions. Trust me these questions, I have carefully picked after doing a beta testing on a small group of people. It was very intriguing to see that not everyone knows the answer to these simple questions. When I asked the users to answer these questions and later on asked to find out the real number they were extremely surprised to see that their estimate and answer were way off to the reality. Let us do this exercise together.
The contest has two parts. You need to take part in the both the contest.
Developers can write data access application that enables ideal connection resiliency with the .NET framework. An idle connection is the one that is active but it’s not executing a command or waiting for data. It is very important to understand how idle connection is reconnecting back in the .NET framework with SQL Server. This white paper actually discusses the same in very simple works. The user has to connect either to a SQL Server 2014 or Microsoft Azure, SQL Database to enable idle connection resiliency.
Here is a very interesting example in the of the idle connection resiliency provided in the Overview section of the Whitepaper.
Let’s imagine that you are a roaming worker that needs to use an Access application to connect to SQL Server. When you need to move from meeting to meeting, you normally close your notebook’s lid in order to move. In working online, every time this happens, you may end up disconnected either because your notebooks sleep or due to blind wireless spots in your building. To avoid the hassle of being disconnected, you may choose to avoid certain places (like elevators, for example) and walk with your notebook’s lid open. Now, imagine if you can close your lid and walk anywhere in your building (even take the elevator) and just arrive to your next meeting, open your lid and find your work there, waiting for you to continue. To address this and other scenarios when an idle connection drops, SQL Server introduced a new feature called Idle Connection Resiliency.
Well, that’s it. This white paper describes the internal working of the Idle Connection Resiliency. It further discusses about the Client’s idle connection, reconnect logic, Client session state handling and replay logic, Non-recoverable session states, and General Considerations.
I will be speaking at C-Sharp Corner Annual Conference 2014 – April 11-13 – Delhi. I am extremely excited and fortunate with the opportunity to present a technical session at the North India’s largest conference. The wonderful people at the conference has been doing this annual event for quite a few years and every year there are over thousands of attendees from all over the India attending it. C# Corner ANNUAL CONFERENCE is a 3 day annual meeting where C# Corner mentors, authors, chapter leaders, moderators, editors and experts meet, demonstrate, plan and hang out. One day of the conference is open to C# Corner members (this is when I am going to present technical session). There are only five days left for this extremely popular conference of India.
Here are the details of the technical session I am going to present:
Secrets of SQL Server: Database Worst Practices
Date and Time: April 12, 2014 9:45-10:30 AM
Abstract: “Oh my God! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. Shedding light on some of these perils and the tricks to avoid them may even save your current job. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their SharePoint implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session. Additionally, all attendees of the session will have access to learning material presented in the session.
Indexes – The Unsung Hero
Date and Time: April 12, 2014 1:30-2:15 AM
Abstract: 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 Indexes has been set up. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.
The event venue is Radisson Blu Hotel Ghaziabad. H3, Sector 14. Kaushambi Ghaziabad 201010 Uttar Pradesh. You do not want to miss out on any of the sessions. I will have surprise gifts for selected attendees. I will ask some question during the session and if you get it right, trust me, you will be extremely happy with the gift.
Registration for this event has been closed and there are over 2100 registered attendees to this event. It is a FREE event so there is no cost to attend this event.
I am looking forward to catch up with you at the event. Special mention to the team who is making this event a huge success: Mahesh, Dhananjay, Praveen, Dinesh!