PASS Summit Live Keynote – Release 5

pass_2016_website

Julie Koesmarno, Senior Project Manager at Microsoft, takes the stage to talk about business analytics utilizing War and Peace.

Tracing emotions of each key characters via a heat map…..pretty cool to see application of SQL Light language.

Cognitive capabilities managed with big data……


Deep learning is everywhere; this means that SQL Server 2016 falls into that category. Seeing a demo on drone functionality and feeling the pulse of the power grid


Jen Stirrup (Data “Whisperer”) takes the stage and talks Pokemon…..yes folks Pokemon but there is more than that.

Utilizing Power BI for the activity for each Pokemon sprinkled in with some “R”. The data itself is stored in the Azure SQL Database with utilizing the Azure Services.

 

 

PASS Summit Live Keynote – Release 4

pass_2016_website

Document DB: Blazing fast planet-scale NoSQL:

  • Guaranteed Low Latency
  • Elastically Scaling Storage
  • Elastically Scaling Throughput
  • No Impedance Mismatch
  • Choice of Consistency
  • Enterprise Level SLA

Azure + DocumentDB with leading game technology. A game and TV show integration of Walking Dead that brings exclusive clip content into the game using Azure media services.

15 million installs

120 GB of new data each day

11,500 DocumentDB requests per second

43 million Walkers eliminated each day

1.9 million matches made each day utilizing DocumentDB

1 million guilds

10 million chat messages per day

250 million leader board entries


Integral Analytics Scott Smith VP of Product has come on stage that discusses how data science and software company that provides core operational, planning, and valuation applications for utilities and other participants in the electric-energy industry.

Visualization of data that is important being able to keep lights and data centers running with giving respect to the electric grid – – all using the Azure Data Warehouse capabilities.

Electric Grid: from 100K to 500M records per 1M customers a day in the past 5 years

PASS Summit Live Keynote – Release 3

pass_2016_website

 

Justin Silver, Scientist Pros, takes the stage……

Taking data science out of the lab settings and placing it into real world scenarios.

Azure has tremendously been able to allow enhanced functionality into the realm of data science bridging the gap 100x faster with SQL Server 2016.

Microsoft is the only vendor that has the depth and breathe to handle the capacity the Pros company needs in order to succeed.


Sneak preview after Just leaves the stage……HTAP solution scaled out.

What can we do to solve a data visualization problem within SQL server and how can we expand its capabilities. SQL Server 2016 shipped with Polybase to  help provide this type of solution….the always on functionality can replicate 10 times the data from where we were in the past.


Intelligent Database Service – machine learning to capture behaviors for intelligent capabilities.

Better together with Windows Server – unparalleled SMP capability

_________________________________________________________________

Yes folks…just saw a restore onto SQL Server running on Linux…..installed SQL; restored backup from windows…..keeps getting better.

22,000+ registrations >50% of fortune 500

 

 

PASS Summit Live Keynote -Release 2

pass_2016_website

Rohan Kumar, General Manager of Microsoft, takes the stage hyping up SQL Server 2016. We keep hearing the word “Sharing” among databases.

Intelligent Database:

  1. In-Memory Analytics
  2. In-Memory OLTP

Wow, 100X faster analytics + 30x faster transactions

Azure SQL database is the first in the world to support HTAP technology

Two worlds coming together – industry leading in-memory enhancements with built-in advanced analytics with R

One million transactions per second using SQL 2016 – that’s right….you heard that.

R services integration into SQL 2016 – is pretty powerful

 

PASS Summit Live Keynote – Release 1

pass_2016_website

Joseph Sirosh taking the stage by first telling us a story with over 400 million children in India. Only 50% of them attend school regularly. Consider the loss of potential that could have been a doctor.

Millions more like these children; a world of lost human potential. Millions who drop out on opportunities. Enter the term Data. The school infrastructure and other parameters will allow them to predict school drop out and the risk of under performance.

All this from data? Over 5 million children will be scored by data machine learning and the Azure cloud?

A.C.I.D. Intelligence – Algorithms/Cloud IOT/Data

Intelligence of software in every piece of software that we have. Finished applications like office 365 to many more by sprinkling the so cold pixie dust of A.C.I.D into the mix.

Intelligence DB – Intelligent Lake – Deep Intelligence

Intelligence DB – pushing intelligence to where data lives. Sharing machine learning around marketable applications is key. This pattern will allow intelligence to become just like data.

SQL 2016 is truly becoming the platform for data intelligence

 

 

PASS Summit 2016 – Live Keynote

pass_2016_website

Good morning from PASS Summit 2016!

Today will be the first keynote session at 8:15 a.m. with Joseph Sirosh. I’ve found myself back at the bloggers table this year during the keynotes so check back here for updates and highlights.

In addition to these updates (plan on sending 4-5 mass live updates throughout the keynote) I will also be live tweeting with the hashtag #SQLSummit.

Have a great day and enjoy the time we have here.

T-SQL Tuesday #83: We’re still dealing with the same problems

tsql2sday-300x300It’s about time I got back into participating in the T-SQL Tuesday block parties that are hosted by community members each month. First, let’s take care of some house keeping rules.

Who Is Hosting?

This month Andy Mallon (b|t) is hosting and has chosen a topic of We’re still dealing with the same problems. This topic can have very many avenues to go down; with that said Andy….great topic sir. I suggest you stop by Andy’s blog when you get a chance; he has some great posts along with Shortcut’s Cheat Sheet that I ran across the other day.

So what are some of the same problems?

Again, we can take this path down several different roads. We can get extremely technical or we can get extremely general. For the sake of time and having you in mind as I type I may sprinkle a little of both into this post.

Professional Level

From all different levels of a database professional’s life one can see repetitive things being done:

  • Resume fluff – by this I mean interviewees having a little to much fluff on the resume that has to be weeded out.
  • Dev/DBA/Infrastructure – do I need to expound? The age old silos that are often built with blame moving to and from each unit.
  • Overworked personnel – being in management my team is key. It’s time to look at the people as that, people, and not just a number.
  • Routines – we all get stuck in a routine at times; how do we get ourselves out of so called “ruts” and light the fire that we once had?
  • Meetings – this topic can have its own blog and how to handle them. These are important in some cases and in some cases they aren’t, but the fact remains I still see a lot of shops with an endless supply of meetings.

SQL Level

Up next are the SQL scenarios I still see as ongoing battles:

  • Max Memory Setting – when installing SQL please check this setting.
  • SA – every vendor wants SA for their app; it’s how the world goes round.
  • Backups – yes I take backups….that is great news; have you ever restored any? Nope…..you see where I’m going with this.
  • Trace Flags – I see a lot of people not taking advantages of these across all SQL platforms.
  • SQL Versions – a lot of shops are not keeping up to date with their SQL versioning as often as they should.

Automation

You may ask why I put this topic in a section all by itself? I learned earlier on from John Sansom (b|t) that automation is key to becoming a successful DBA. I don’t see enough of it really? There are a lot of new tools and methods that are available to data professionals that, if taken the time, can be set up to automate a lot of the mundane tasks I see small to medium shops experiencing. Heck, even some bigger shops still struggle with the art of automation.

Professional Development

Anyone who knows me knows I like to challenge myself. Each and every person has their own set of goals and desires as they move through life and no one else can define that. I see over and over again where we tell people that they need to do this and need to do that. No, I’m not talking about mentoring or leadership. Those are separate entities; this section is meant to encourage the readers of this post that you control where you want to go in your career and not the other way around. Some knew technology comes out and you want to learn it then go for it.

What Is T-SQL Tuesday Anyway?

Well, I’m glad you asked. Adam Machanic (b|t) started this party about (I’m approximating here) 7-8 yrs ago. Each month a new blogger is chosen to host the party and they in turn get to pick the topic. If you blog about SQL and have been keeping up to date with it for a while now then drop Adam a line and let him know you are interested.

Conclusion

As you can see there are still items that occur all around us on a daily basis in the same manner. I challenge you to see, if what, can be changed. Where can you make a difference? Time to get after it ~ Let’s Roll.

Thanks Andy for taking the time out of your day to host this month.

PASS Summit Advice For First Timers

As I scrolled through the twitter feeds I ran across one from Tom LaRock (b|t) on PASS Summit being three weeks away:

rockstar

Now, what caught my eye was the fact that he mentions the word “advice” to first timers. It wasn’t that long ago when I attended my first PASS Summit. In fact it was the first year at my new shop and I knew nothing about the PASS Summit. The year was 2011 and I had made the trek out to Seattle with a colleague. From the moment I stepped into the convention center I was caught hook, line and sinker.

I got to thinking about what I could share with you, the reader, who may be attending your first PASS Summit and what to expect. Can it be overwhelming? You bet it can be, but guess what? That’s okay.

I’m excited that this year will be my fifth year attending, and it has been one heck of a ride. I’ve learned and have grown so much from it over the years that I would recommend attending to any data professional.

Things To Expect

  • The People – You will find out quickly that there will be numerous opportunities to interact and network with an endless supply of data professionals from all over the world.  I’m not here to tell you how you should step out of your comfort zone; you do what you feel you should do. I will say, for me, getting to know several people over the years has been beneficial to my career growth as a data professional.
  • The Sessions – There will be sessions you want to go to at the same time. Don’t fret; PASS Summit has an offer to purchase all the recordings so you can go back and review a play by play. This is something that I and my shop have taken advantage of over the years and it has proved beneficial.
  • The Community Zone – When you are on your way to the cafeteria you’ll notice a community zone section filled with bean bags and people; stop in and say hello if you get a chance. It’s a great opportunity to catch up with other professionals, leaders, and speakers.
  • The Volunteer – You will see these people all over the convention center. Do me a favor, stop and thank one of them while you are there. Doesn’t take long and a thank you goes a long way. I remember back in 2012 I stopped and thanked a volunteer standing by the entrance to the main room. They proceeded to say they were having a rough day and that it meant a lot for someone to stop. You and I will never know what someone else is going through; take time to make an impact on someone.
  • The Key Note(s) – I suggest you attend these if you can; they are a great way to get a wealth of information from some of the most talented individuals you will ever meet. You will learn direction of products, some new features coming on various platforms, along with some humor thrown in for good measure.
  • The Excitement – You will be excited yet overwhelmed – I know I was. It’s okay to feel this way and don’t beat yourself up if you miss opportunities. Consider it part of your growth on your journey. If you want to ask a question and feel you don’t want to in front of people then fine; go up to the speaker or catch them in the various spots of the community zone. Never met a speaker who does not like to spend some time talking with other data professionals.

The Why?

Back in 2011, my first PASS Summit, I was trying to take it all in. We brought back a lot of information to the shop and implemented some things such as CMS etc. It was a great learning experience, but something struck a chord in me with what is known as the “SQL community”. A few weeks went by and I couldn’t shake the concept so I reached out to Chris Shaw (b|t) who would one day become one of my good friends and mentors in the community. He helped me to get on a path that has led to some outstanding things:

  1. Community Involvement
  2. Blogging
  3. Article writing
  4. Contributor for DBA Jumpstart
  5. SQL Saturday Co-Organizer
  6. Speaker
  7. Co-Chapter Lead – Louisville SQL and Power BI UG
  8. HA/DR Virtual Chapter Marketing

And the list could go on. Why am I telling you all of this? If I can go out and set my mind to accomplish these things then there is no reason why you, the reader, can’t do the same. There will be many opportunities for you, the question that you will have to ask yourself is if you want to pursue them? If you do pursue them great; and if you don’t great. Your career path is just that – YOURS. Only you, yourself, will be able to answer that question and whatever your answer is it’s okay because it is yours.

The Leadership

This is a topic that is near and dear to my heart. I am living proof of what PASS Summit can do for someone. It is time we harvest more leaders and continue to cultivate the very essence of our growth and community. We need to continue to be transparent yet candid all the while staying humble in realizing the journey that we take is sometimes not the journey all data professionals take.

Networking

This conference will be your chance to meet data professionals from all over the world. Take advantage of the many opportunities you will be presented with on a daily basis. One thing to keep in mind are the vendor areas, community zone, and Microsoft Engineers who are onsite to assist you with various questions that you may be encountering.

Conclusion

While PASS Summit will be a great opportunity to expand your knowledge, grow as a data professional, and network galore; I do realize that it can be overwhelming especially if it is your first time being to the event.

Take a second and catch your breathe; realize that you are not alone; we all have been in the same shoes you were in at one point and time. Feel free to reach out to me or if you see me walking around, talking at the community zone, or outside the convention center don’t hesitate to walk up and introduce yourself. I’ll be happy to help you out as much as I can.

Is ROI for Vendors Worth the SQL Saturday Investment?

networkingPiggy backing onto the recent SQL Saturday post here in Louisville, I wanted to take a more in-depth look, from my perspective, on how vendors all fit into these events.

Having the opportunity to work alongside these vendors has been both a learning experience for myself along with forming new bonds along the way. Louisville has been fortunate enough to have some of the best vendors in our industry who see the importance of investing time in others for a few reasons.

  • Networking
  • Getting their products name out
  • Growing their local community pool
  • Bringing exposure to their company

SQL Saturday events provide a much more intimate setting with a lower number of attendees. Example our event for the past two years had over 220 users sign up. This is a much smaller scale then say what a PASS conference has signed up where over five thousand of your closest friends attend.

The SQL Saturday events allow the attendees to get up close and personal with the vendors on products that they may or may not use. That’s great Chris, but I’m a vendor and how would I get ROI out of it; because at the end of the day if I want to sponsor an event there needs to be some gains on my end?

This therein is a valid question and one that is not taken lightly. In speaking with a vendor they had this to say about our event:

Our sponsorship of SQL Saturday allowed us to connect with a wealth of developers and DBAs, in a single day. The event was organized, productive, and time well spent furthering our business in Louisville.

I am starting to see soft metrics, such as intangibles, in determining the business value sending data professionals for respective vendors to such events. What kind of intangibles? They’re the stuff that doesn’t show up in traditional cost-accounting methods but that truly makes a difference in maximizing the potential knowledge growth of the organization. These include employee learning, vendor interaction, business relationships, and networking. Some of these are clearly more quantifiable than others, but all are important to a vendors success.

Some outside thoughts on how ROI for vendors is applicable:

  • You have to evaluate your audience.
  • Make sure your input channel, in this case your interaction with attendees, has some new features for viewing.
  • List of attendees for potential future clients.
  • Make your presence known prior to event (outside the marketing done by said event).
  • Commitment from potential attendees
  • Flexibility

End of the day, vendors are a huge part from all angles in regards to SQL Saturday events. Getting a great local base at events like this continues to build and solidify companies advancement in the technology space; specifically around the Microsoft stack.

Conclusion

If you are interested in getting involved you can check out or view upcoming schedules at the SQL Saturday home page here.

From personal experience I know that talking with vendors at said events it has opened doors and opportunities for business in my current and previous shops along with building a network base for future discussions.

SQL Sentry Does It Again–Plan Explorer 3.0

planexplorer-logo-300x78Being in a shop that utilizes Plan Explorer it was awesome to hear of the news release from SQL Sentry on upcoming changes around their product.

In case you missed this news you can check out Greg Gonzalez’s (B|T) post at http://blogs.sqlsentry.com/greggonzalez/plan-explorer-pro-goes-free/

So, what does this mean for you, the readers and community members?

  • All features are completely FREE
  • There is one SKU now
  • Registration is still not required ( I’ll give you an added hint here; if you register there are some other benefits, so why not?)
  • You ready for this one – – two powerful features have been included in Plan Explorer 3.0:
    • Index Analysis
    • Performance Profiling

Now, for an added benefit SQL Sentry’s very own Aaron Bertrand (B|T) will be hosting a webinar on Friday, September 9th at 11:00 a.m. EDT. You can register for this webinar at https://attendee.gotowebinar.com/register/6543832890155002369

Why Plan Explorer?

I can tell you from personal experience that having Plan Explorer in your tool belt gives the data professional some added fire power on a daily basis. For a full listing of these features check out http://www.sqlsentry.com/products/plan-explorer/sql-server-query-view and see for yourself what you are missing.

My Favorite Features

One of my favorite features is the SSMS add-in; however there are several more features that might tickle your fancy such as:

  • History and comments – did I just hear some cheers? As you go through tuning and optimizing these queries you can keep notes and comments along the way.
  • Statistics Analysis with Histograms
  • Expressions
  • Tree Statements
  • Query Columns
  • Table/IO

Conclusion

SQL Sentry has hit a home run with this new release. The product continues to build out nicely; the team there gets a “job well done” in my book