This month I headed out to the PASS Summit 2014 Conference which is the largest gathering of SQL Server and BI Professionals. I was fortunate enough to be able to attend this year because the Microsoft MVP Summit was also held that same week. So it had been a few years since I had attended the PASS Summit and I was excited to go back. I really appreciated the coordination of the two events and the fact that Microsoft was able to adjust the schedule for the SQL Server MVPs up one day to be able to attend, it was quite remarkable to partake in both events. I also have to thank my company, Superior Consulting Services, for providing me the opportunity to attend as well.
The first major event that I participated in at the conference was the #sqllongrun. Adam Machanic (b|t) organized an 11 or 14 mile run event this year in Seattle. It has been a goal of mine to run a 1/2 marathon, so I decided that this was going to be it! Unfortunately with my schedule I didn’t get to train as much as I probably should have, but I pushed myself the week prior to the event and I was quite impressed with my results. It turns out that not only did I run a 1/2 marathon, but I went a couple of miles more because apparently I didn’t start my watch at the start, sorry Reeves Smith (b|t), but I greatly appreciate your support and running the extra mile at the end with me when I thought I had only ran 12 miles!
What a great event and looking forward to my next 1/2 marathon now that I have a benchmark, thanks to Adam for organizing, SQL Sentry for sponsoring, and everyone that participate for your support and encouragement!
Now on to the main event, but not until we do a few more runs, right? I ended up running each morning with some of the other #SQLFamily members such as Ted Krueger (b|t) and Tim Radney (b|t). Each day I ran a 5k with the exception of Thursday (took one day off for rest). I also took part in the #sqlrun organized by Jes Borland (b|t) and thanks SQL Sentry for sponsoring.
So the main event, the PASS Summit.
Day 1
On Wednesday we found out from the PASS President Thomas LaRock (b|t) that there were 50 countries, 2000 companies, and around 5900 attendees at the conference, simply amazing! Currently there are 285 PASS Chapters, 27 Virtual Chapters, and there were 86 SQLSaturday events this year, over 1.3 million hours of training provided by the community, awesome!!! I was really looking forward to the Day 1 keynote to hear each of the three core leaders of the Microsoft Data Platform talk – T.K. “Ranga” Rengarajan, James Phillips, and Joseph Sirosh.
Ranga was up first and he covers the Capture + Manage side of the image below. He came to Microsoft from SAP. In the Pier 1 Imports demos during his portion we saw Azure Search (34:37), Azure DocumentDB (along with elastic scaling) (37:59), and Azure SQL Database Geo Replication (in just a few clicks! 44:18). They also showed a video of Dell.com with SQL 2014 use of in-memory OLTP to increase performance and remove blocking(53:00). In addition there was a technology sneak peek at an in-memory columnstore nonclustered index on an in-memory table(1:02:00)! It didn’t stop there, Ranga and his team continued on with the demos showing how to stretch an on-premise SQL database table to Azure (1:04:00)!
Joseph was up next and he covers the Transform + Analyze portions. He actually came to Microsoft from Amazon. He talked about Azure Data Factory (like SSIS in the cloud), Azure Stream Analytics, and Azure Machine Learning (this is now free for anyone to try with a Microsoft account, no subscription or credit card information required – https://studio.azureml.net). They showed demos with Pier 1 Imports again doing a demo of in-store analytics using Kinect as a senor to gather data where shoppers are spending their time and what products they are looking at, pretty cool (1:16:50)! Using this data they used Azure Data Factory to pull it in using a pipeline to orchestrate the data(1:18:45). On top of that they used Azure Stream Analytics to analyze the top 5 products in realtime (from the Kinect sensors)(1:21:00). Then it was off to the future using Azure Machine Learning to be able to recommend products for next purchase (1:24:00). The last part of the demo was using the Pier 1 Imports mobile app using voice and Cortana recommended products based on your profile and used Azure Machine Learning to do the recommendations and then asked where to find the products in the store (even displaying an in-store map!)(1:25:53).
James was up last and he covers Visualize + Decide. He came to Microsoft from one of his startups Couchbase. He pre-announced being able to connect from Power BI back to on-premise SSAS data. Live Power BI Dashboards were demoed – see below (1:36:30). The dashboards have built-in Q&A and through the dashboards you can connect to data and pull information in to create more datasets, reports, and items to pin to create dashboards. The results of Q&A questions could also be pinned as well. More visualizations have been added included combo charts, tree maps, sunburst, filled map, and gauges. All of the dashboarding was done in HTML5!
The day did not stop there, I checked out the community zone, some great sessions, and got special seating up front because of my PASS Outstanding Volunteer recognition. I even attended the PASS Virtual Chapter meeting and met my Paras Doshi (b|t) who is the other chapter leader for the PASS Business Analytics VC with me! Paras is awesome to have on the team, simply amazing, can’t say enough, great asset to have and really looking forward to next year to see what we can do next!
Day 2
My friend Adam Jorgensen (b|t) the PASS Executive Vice President of Finance kicked off the keynote on day 2 and discussed plans and revenue, incredible that the PASS Summit brings in $5.9M. Denise McInerney (b|t) the PASS VP of Marketing also talked and went her personal growth story going from attending a local event up to where she is today, amazing! They announced the PASSion Award winner, Andrey Korshikov (b|t), congrats! Then Rimma Nehme gave the big talk on Cloud Databases 101 (21:55). Her humor and slides were outstanding and made the content easy to relate to and enjoyable, thanks! Who can’t understand the cloud services when you compare it to PIZZA (see image below)! Now DBAs that are learning and using the cloud based services can update their titles to Cloud DBA, time to soak it in and make the most out of this opportunity while it is really kicking in high gear now with the hybrid solutions.
While I was out there I also noticed a couple of great books in the bookstore that I was able to contribute to
I wish I could have stayed around for Day 3, lots of more great sessions that I had to miss out on, I had to get home to my family, it had been a long and exciting week with the MVP and PASS Summit events.
Let the countdown begin, PASS Summit 2015 will be October 27-30 next year! Register now and the rate is only $1195 (over 1/2 off until January 11)!
CONNECT + SHARE + LEARN = PASS SUMMIT!!!
My career journey leading up to Microsoft
Posted by denglishbi on September 29, 2022
I thought I would do a short post outlining my career journey up to the point where I finally was hired and accepted a position to join Microsoft❤️I will try and keep it brief because along the way I could highlight lots of stories regarding the people, companies, and customers I have worked with which would get lengthy😉
My first big job coming out of college was at a casino in Minnesota (where I have always lived) that my oldest sister referred me to. I graduated with a Finance degree with Accounting and Economic minors and the position was in the Revenue Audit department (got to audit the daily gaming revenue numbers which included slots, blackjack, pull tabs, and bingo). I really got interested in technology here, not that I hadn’t used computers prior since my dad was a computer programmer, but I started to get into MS Access (Office 2.0) which led me down the path of eventually getting recruited by the IT Department.
In the IT Department I worked with MS Access, FoxPro, Visual Basic, SQL Server, Oracle, SharePoint, and a few more technologies like DataStage and ProClarity just to name a couple more. My passion was always around the Microsoft technologies and in particular the data and reporting side which led me down the path of data warehousing and business intelligence. I still remember loading data into SQL Server OLAP Services and slicing and dicing the gaming revenue numbers, it was amazing🤓
From the casino I was recruited into the consulting world and I will admit that was a scary transition because I had worked at the casino for over 10 years and was very comfortable there. I worked for two different consulting companies over another 10 year stretch that both focused on Microsoft technologies and I got an opportunity to work with lots of different customers and projects, it was a great experience and it was stressful at times when all of the eyes are on you and you are being looked to for all of the answers – hopefully you have built a good internal network and can leverage others when you are stuck or have a question. I have lots of great stories I could go over, but will save them to discuss over a cold one sometime off the record😁
During the consulting years I also helped run the local Minnesota SQL Server User Group, Minnesota BI User Group, PASS Business Analytics Virtual Group, and helped with some of the Minnesota SQLSaturday events. I also did a lot of presentations, helped out in the Microsoft forums, tech edited books, got to co-author a book and was a Microsoft Data Platform MVP. Also during this time I coached my son’s soccer and helped coach his basketball (spending time with the kids was one of those things that I didn’t want to miss out on and the reason I stayed away from a job that required travel).
Eventually I decided to leave consulting and move back to a full-time position at a company. I worked for two different companies over the next 5 years and the last job prior to joining Microsoft is the one that got me the hands-on real-world experience with Azure and the Microsoft cloud technologies. Sure I had dabbled in the cloud a bit being a Microsoft MVP, but using it at a large enterprise is a different story and glad I got that opportunity before joining Microsoft.
So now if you see this slide, or one similar, during one of my presentations maybe this post will shed a little light on my journey going from the business world into the land of data warehousing and business intelligence and to the current position at Microsoft (what a dream, I am a huge #MicrosoftAdvocate and #MicrosoftNerd).
Posted in Personal Comments | Tagged: career, personal | Leave a Comment »