An SSIS Training Video by Webucator

15 April, 2016 (12:38) | SSIS | By: Mark V

Greetings, noble readers!

A while back, Webucator, an organization that produces training videos on a number of topics, contacted me about doing a video walkthrough of one of my blog posts. The original post is Making Your SSIS Configuration Files More Readable. Their video walkthrough is here.

Feel free to check out this video and their others as well.

In the interests of full disclosure, I was in no way compensated for this and have no relationship with Webucator other than this video.

Brian Piccolo, Thanks, and the Number Five

29 February, 2016 (11:00) | Community | By: Mark V

6144002147_a5f02feee3_bThere have been a few times in the past few days that I was really reminded about the power of gratitude. The first came when I brought my third grader’s lunch to school for her after she forgot it at home. As I was leaving, she said, in the cutest little voice and full of joy, “Thank you, Dad!” It was one of those heart melting moments. In that moment, the words “thank you” translated as “I love you with the white-hot intensity of a thousand Suns.” Powerful stuff, that. I walked out of that school with a spectacular smile on my face.

The other came in the form of an email from a member of our fine SQL community. I’ll get to that in a moment. First, I want do some of my own thanking.

I have been pretty active in the SQL community over the years, mostly centered around PASS events and user groups. I have presented a lots of SQL Saturdays, the last three PASS Summits, several user groups both in person and remotely. And I have met a lot of people at various stages in their careers. I love that aspect of the community we call #SQLFamily. There were people early in my career that had a huge impact in pushing me into this community. Given that gratitude is a major theme of this post, I want to take a moment to call out two people who had a huge impact on me and my career. Lara Rubbelke (Blog|Twitter) and Jason Strate (Blog|Twitter) both encouraged me to jump into the community when I first started out as a consultant. They not only pushed me in a positive way, but they showed me how as well. They led by example. I will always be grateful for their influence.

1132534644_e8e3f986fa_oNow, onto that email mentioned above. I am going to keep the sender of the email confidential. However, I did get permission to use a few quotes from it for the purpose of this post. I hereby say, “Thank you” to that person. Hehe.

The email discussed how this person has done a lot in the past year to help out their local user groups and started doing presentations as well. They had felt the urge to stop and thank me for a conversation we had about a year ago. “This random bit of email comes to you as I sit here late at night putting the final touches on another presentation to be given. And I just felt the need to take a break and say thanks.” I have to say that is pretty cool. Taking the time to thank people for the help they provide others is something I believe in very strongly. To me, even simple things are well worth a Thank You when they provide value, no matter how small.

My advice to people in any community is to make sure to thank the people that help you. Whether they answer a question for you that helps you solve a problem or just quietly inform you of that piece of lettuce stuck to your teeth, they are making an effort to provide value. Thanking them helps reinforce their decision to help others. It helps move everyone forward.

“Thank you for taking a few moments out of your day last summer to encourage and motivate a random stranger…” The email continues. “To me, it is irrelevant if you recall the 5 minute walk to the parking garage after the event. What is relevant, is that you took that time to listen and encourage a wise cracking … guy to pursue his dreams. That chance encounter was a huge motivator for me to want to become more involved.”

Enter the number five. Here is someone thanking me for a casual conversation that lasted about five minutes and happened a year ago. Five minutes. By the way, I do remember the conversation. I had no idea, at the time, the impact those few minutes would have. It felt totally awesome to learn about this.

Brian Piccolo was a running back for the Chicago Bears in the late 1960s. My English teacher introduce me to Brian in eighth grade via the movie Brian’s Song. Gale Sayers was another running back for the Bears at the time and known for long runs. There is a quote from Piccolo that I always liked: “I won’t get you 60 yards in one crack like Sayers, but I’ll get you six yards ten times in a row.” My teacher had paraphrased it for us while we discussed the film: “I won’t get you 60 yards, but I’ll get you ten sixes.” That has always stuck with me.

So, what does this have to do with this post? To me, that line is a reminder that you don’t have to do huge flashy things to make a difference. You don’t have to move mountains to be of value. Sometimes, making a huge difference can be as simple as a five-minute conversation. I have friends that write books and teach classes and travel the world as super experts. These people provide a ton of value to the community. Just don’t think you have to do just as much as they do in order to matter. Start small, but start. Do something for someone, even if it’s something you think is tiny and may not matter. Do it anyway. It could matter a lot to the person you help.

Achievement Unlocked: Microsoft Employee

19 January, 2016 (14:43) | Professional Development | By: Mark V

After almost 9 years of consulting around SQL Server and other Microsoft Data Platform technologies, I have joined Microsoft. Today was my first day as a Cloud Solution Architect – Data Platform. Basically, I will be helping Microsoft customers by designing data solutions using Azure (both pure cloud and hybrid). My role is in Minneapolis, so I won’t be moving. There will be a little bit of travel here and there as I have onsite meetings with customers.

I will need to learn a LOT more about Azure than I currently know. That is a large part of what made this opportunity so attractive. My content here will start having more of an Azure bent to it as I dig deeper into it. There will still be some Power BI here and there as well.

I am incredibly excited about this new direction. Microsoft has really been doing such exciting work and I am proud that I will get to be a part of it.

PASS Summit 2015 Women in Technology Luncheon Live Blog

29 October, 2015 (13:52) | Live Blog, PASS, Professional Development | By: Mark V

Getting ready for the Women in Technology luncheon.

 

07.59

Good morning!

08.06

About to get started!

08.07

Dr. Stephen Levitt taking the stage!

08.09

Dear Presenters: please note that Dr. Levitt is NOT reading to us. :)

08.11

About 1 in 10 children reported on tax forms were fictional. Ended up causing the loss of billion in revenue for IRS.

08.13

In 1987, when the SSN of children was required on tax forms for deductions, 7 million children vanished from the face of the Earth.

08.14

What reasons do people have to innovate? Necessity. Business Pain. Lost Revenue.

08.15

Simplicity returns to the discussion. SSN on tax forms is obvious. But it wasn’t there until 1987.

08.16

Dr. Levitt: “Most people in Business don’t have time to think.” #ouch #TrueStory

08.17

“I spend 500 hours per year thinking about new ideas. It’s a great year when i get one.” ROI requires the I(nvestment).

08.19

Dr. Levitt studied things like Prostitution and Drug Cartels, things other economists wouldn’t touch. #innovate

08.22

When you see a stranger that clearly knows YOU, GATHER DATA. Turn it into insight. You might get lucky and remember them. :)

08.24

Dr. Levitt hated math. He is a noted economist, professor, and author. Path from A to B may not be a straight line.

08.26

Dr. Levitt: Sometimes clarity only comes from having the courage to ask the right question.

08.28

Incentive can lead someone who doesn’t like math to become an economist. How bad to you want your goals?

08.31

Dr. Levitt’s Dad: “I have not talent; you have not talent. Take on topics no self-respecting person would tackle.”

08.32

Dr. Levitt: If nobody is willing to defend a group of people, perhaps there are too many misconceptions about that group.

08.33

“If you have the choice between walking drunk and driving drunk, driving is far safer, at least according to the data.”

08.37

Following the Grateful Dead for 6 months can be an excellent primer for Grad School in Sociology? Think outside the classroom.

08.43

Dr Levitt telling about a Sociologist who stumbles into a Street Gang and how it made is career. #Innovation #TackleToughTopics

08.45

If you write down the organizational chart of a street gang, and removed the names, it could look just like corporate America.

08.47

The economics of street gangs amazingly similar to that of the “legitimate” business world. #ThinkAboutIt

08.48

Dr. Levitt: According to the data, It was 7 times more dangerous to sell crack in Chicago than it was being in combat in Iraq.

08.50

If you showed gang members the data, how many would still choose that life?

08.51

Are drug gangs a new, up-tapped market for Business Analytics? #TongueInCheek

08.52

Dr. Levitt: Business People LOVE to buy books. Don’t know if they read them….

08.54

Dear Presenters: Note how Dr. Levitt is making eye contact with people ALL OVER THE ROOM. #ConnectWithYourAudience

08.58

Dr. Levitt: Asking questions is worthless if you don’t correlate it with data to see what answers are correct.

08.59

Misconceptions can cripple you. Let the data speak, even when it might be difficult. #TrueStory

09.01

Dr. Levitt: Experimentation with data is vital. That’s where insights come from.

09.02

“Do you want the TRUTH?” How often to we find ourselves wanting to ask this of our clients/customers?

09.03

Dr. Levitt: “We got fired and all of our projects were cancelled. It was the best day our consulting company ever had.”

09.04

“Why in the world would you work for a company that when you tell them the TRUTH, they don’t want to hear it??”

09.04

Awesome: Dr. Levitt has opened the floor to questions.

09.06

Q: What kind of research are you doing now?

09.07

A: We have a “Parent Academy” and are teaching parents about things they can do to help their kids succeed.

09.09

Dr. Levitt: 5-10% of people we survey about tough decisions are swayed by a toss of a coin and actually take that action.

09.11

Dr. Levitt: Everybody and their brother is telling me I should use R right now.

09.12

Q: What kind of newly available data sets are you REALLY excited about?

09.13

A: Business data is FAR more interesting than Government data right now. Much more fun to be in the data generation business.

09.15

Dr. Levitt: Connect the data together and let people play with it. Sounds like using Excel for analytics.

09.16

Dr. Levitt: In shortest supply in Business is people who know how to think about data. #THIS

09.17

Dr. Levitt: “It turns out I am much better at telling funny stories than solving big problems.” Sometimes the data’s story leads you to ROI.

09.23

Dr. Levitt: Economists and Prostitutes have this in common – the word “Can’t” is not part of our vocabulary.

09.25

Dr: Levitt: “If you know a Prostitute, you send her my way. I guarantee I can affect her bottom line.”

09.26

That wraps up the Live Blogging for the conference. Thanks for following. And thanks to PASS for inviting me to participate.

09.53

Attendees are filing into the Dell Grand Ballroom.

09.55

I have to apologize to my fellow live bloggers for being so handsome and witty. I can’t help it.

10.02

Attendees continue to file in. We should be getting started in a few minutes.

10.05

Here we go, yo.

10.05

“Business Intelligence and Business Analytics are at the forefront of business today.” #Truth

10.06

PASS President Thomas LaRock taking the stage.

10.07

Tom: We get paid to work with data every day. How awesome is that? #Truth

10.08

Regardless of your title, if you work with Data, you are the lifeblood of your organization.

10.09

Tom: @sqlpass has over 100,000 members! Awesome!

10.10

Tom: Find a way to get involved with @sqlpass somehow. There are so many ways to get involved.

10.11

Tom: Pick up networking buttons at the Community Zone. Minimum count of “pieces of flair” is 31.

10.11

Make sure you spend some time with the sponsors. They make events like this possible. Woohoo!

10.12

Tom: Give the sponsors a hug. #Embracing

10.13

Tom: Next year’s PASS BA Conference will be in Santa Clara, CA

10.14

John Wittaker of Dell taking the stage: Big Data, Predictive, & The Middle Market

10.15

John: Big Data projects are not just for the enterprise

10.16

John: Not only is Big Data happening, but it is being invested in at the appropriate level

10.16

John: When IT and Business COLLABORATE, we are much more likely to have a successful outcome. #NoBrainer

10.18

John: “Real Time” and Predictive Analytics are the most valuable Big Data tools, according to Dell’s survey

10.18

John: Big Data Challenges = Complexity, Volume, and Budget

10.19

John: Data Complexity, though, is the major challenge today.

10.21

John: You will see vendors like Dell and others abstracting that complexity to make things easier.

10.24

John: Dell’s goal is to offer an end to end Information Management solution to manage, integrate, and protect data

10.25

Microsoft’s Amir Netz and Kamal Hathi taking the stage. This is going to be awesome!

10.26

Kamal: It’s been an amazing year of innovation at Microsoft: Power BI, Power Query, Power Map, HDInsight, SQL 2014…

10.27

Amir: We have a new CEO, Satya Nadella. Satya introduced SQL 2014. A CEO has never introduced SQL like that before.

10.28

Kamal: While I like Satya for a lot of reasons… Satya has made Indian accents “cool” now. #WellPlayed

10.29

Kamal: 2 million+ #PowerPivot downloads. 100 thousand + #PowerQuery downloads since Feb 2014

10.29

Kamla: Let’s ditch this Power Point and get over to #PowerBI and look at data the way we want to.

10.30

Kamal: #PowerBI Tennants by country in Q and A: It is all over the world. Way cool

10.31

Kamal: In Iceland, #PowerBI is kind of hot. #MyKindOfHumor

10.32

Kamal: Q&A has been a huge driver for #PowerBI adoption

10.33

Kamal: Over 1 million questions asked in Q&A in April 2014. Wow. Way cool.

10.34

Kamal is using Q&A in #PowerBI to learn about usage of Q&A in #PowerBI.

10.35

Kamal is doing #PowerView style data exploration directly in Q&A: “We made this feature more discoverable” #Awesomesauce

10.36

Amir: Power BI In Action discussing the #PowerIB Demo Contest. Winner: Michael Carper, who is taking the stage now.

10.37

Amir is walking through Michael’s contest entry about realtionship between Tweets and #NBA Game results

10.39

Amir could make watching paint dry sound exciting. Love his style.

10.40

Kamal now showing data by browser usage by using by #PowerIB in #Chrome #HTML5

10.41

Kamal: We’re doing this demo on a Samsung Chromebook. #HTML5 #PowerBI will just work on any platform

10.42

Amir: Native IOS app for #PowerBI will be available this summer.

10.43

Kamal: We want you to be able to take the investments you have already made on prem and use them in the Cloud #NotAllOrNothing

10.44

Amir: When was the last time you saw AdventureWorks in a keynote demo???

10.45

Amir: Reporting Services will become a natively integrated component of #PowerBI this Summer #ssrs Great News!

10.45

Kamal: The data exists in YOUR environment, but we can still render it with #SSRS in the cloud.

10.46

Kamal: In premise is still hugely important. We are working on bringing more of #PowerIB to on prem.

10.47

Kamal: YOUR BI ON YOUR TERMS. That is our promise to you. #LoveIt #MSBI

10.48

Amir: Today, we are on the verge of a new age. DATA CULTURE: Give the power to EVERYONE #BIToTheMasses

10.49

Amir: Data Culture is when everyone in an organization can use data

10.49

Amir: Aloha to a demo on Hawaii

10.50

Amir: Hawaii collects information forms from travelers on what they did in Hawaii just so we can have a cool demo today.

10.51

You guys, Q&A is just friggin cool. #NuffSaid

10.53

Amir: Moloka’i, known for it Leper Colony, is not the top of the list on most visited Hawaiian Islands. #TheMoreYouKnow

10.54

Amir analyzing when people from various nations visit Hawaii in Q&A directly. Not in #PowerView. IN Q&A.

10.55

Amir: Hawaii is the Niagara Falls for the Japanese.

10.56

Amir: You want a great investment? Invest in Honeymoon Suites for the Japanese in Hawaii. #ActionableInsight

10.57

Amir introducing KPIs in #PowerBI #AweYeah

10.58

Amir created a cool dashboard in less than a minute just using natural language. NO CODE. #PowerBi

10.59

Amir: How can we make Predictive Analytics and Data Science so easy that anyone can use it?

10.59

Amir: Announcing FORECASTING in #PowerView! #PredictiveAnalytics

11.00

Amir: We have some of the best Data Scientists and Researchers at @Microsoft. We put them to work to make it easy.

11.01

Amir: Forecasting is available NOW in every Line Chart in #PowerView Just click and drag the line forward to forecast

11.03

Amir: You can even correct for one-time events by clicking and dragging in the chart.

11.04

Amir: You can even TEST your forecast against older data to compare with actual results. #IWorkInSuchAGreatIndustry

11.05

Amir and Kamal bring Julie (audience volunteer) on stage for live BI demo.

11.06

Amir: here we have a #PowerView create around shark attacks. What if the user has other questions NOT answered by the report?

11.08

You can now get the Field List for a report in #PowerBI. So, users can tweak an existing report for their needs

11.08

Treemap introduced for #PowerView

11.09

Julie is dragging fields from one chart to another to explore a report and change it on the fly. #BIToTheMasses

11.11

Kamal: It’s a good time to caveat, this is a pre-release item… #AsTheDemoHiccups

11.12

Wow. Drag items out of one chart into a blank are to create a NEW chart

11.12

Amir: Getting attacked by a shark while swimming is not a very good thing. #ActionableInsight

11.13

Amir: If you go into the Ocean, take a weapon with you. Shark attacks while spear fishing have higher survival rate.

11.14

Amir: This “Gender” field is about the victim, not the shark. Not time to check while getting attacked. #NotRealTime

11.14

Amir: Which shark likes the ladies the most? The Bull Shark. #Duh

11.15

This demo with shark data is not just a fish story. #TellingStoriesWithData

11.16

Amir just did the “bump and shake” to combine two charts in #PowerView. Wow. Way cool.

11.17

Amir: The data does not lie – If you put sharks in swimming pools, people will learn to swim much faster #Truth

11.17

Amir: These features aren’t just for BI Pros, they are for EVERYONE! #BIToTheMasses

11.18

Amir: We are starting a new journey and we are so excited you are coming along with us. #MeToo

11.18

HUGE thanks to Microsoft’s Amir Netz and Kamal Hathi on another awesome keynote. #ILoveMyJob

11.19

That wraps it up for this morning’s Keynote. Thanks for following. I hope you found it helpful.

10.02

Getting ready for the Day 2 Keynote. People are filing in.

10.07

Lights are dimming. Here we go.

10.08

Denise McInerney taking the stage to introduce David McCandless.

10.09

David’s in the house…

10.09

David’s key phrase: Information is Beautiful. I have to agree.

10.10

Let’s start with Billions. Billions of dollars or something else. What do Billions look like?

10.11

David showing a Treemap. Hey, I saw one of those yesterday! #PowerBI

10.11

Americans give over 0 Billion per year to charitable causes.

10.13

David showing Daily Bread: Infographic on how much we, as Americans, spend per day on programs like NASA, Housing, etc

10.14

David showing blocks falling into place representing various economic expenditures, etc: Debtris (Playing on Tetris)

10.14

David: I LOVE to play with data. Just like children learn through play, so can we if we play with out data. #Explore

10.16

David is showing a chart of Fears that look like mountains in our way. Nice touch.

10.17

Highlighting the Fear of violent video games. Spike in November. And a Spike in April (related to Columbine tragedy)

10.17

Columbine often associated in media with violent video games. #Garbage

10.20

Most common “Break Up” times according to Facebook status updates. Mondays are apparently a poplar day to break up. #TheMoreYouKnow

10.21

Data is the New Oil #GreatMetaphor David’s is better: Data is the New Soil

10.22

The best way to start really using your data? Start asking questions.

10.22

“Do horoscopes always say the same thing?”

10.24

David scraped most common words in horoscopes. Boiled down: Whatever the situation or secret moment, enjoy everything a lot.

10.25

I learned a LOT in this process, just by playing

10.26

US Military Budget is MUCH larger than everyone else. But does that mean we are way militaristic?

10.27

When you compare military budgets as a percentage of GDP, US is 6th. #GoingOneMoreLayerToFineMeaning

10.28

Context is SO important to get a clear, true picture of our data. “Let the data set change your mindset”

10.30

Visualization what a Million Lines of Code looks like. Large Hadron Collider has more than 50 million lines of code. Healthcare.gov… I can’t even count them.

10.32

Cool visualization: Our galaxy creates 7 new stars per year. Planets are the norm, rather than the rarity we thought they were.

10.32

Given all that, statistically speaking, there could be 46 communicating civilizations in our galaxy.

10.33

“Pimp your data”

10.34

Of all the work I have done in my career, there is one thing I am most famous for: a Helicopter game that was ripped off by Flappy Birds Ninja

10.36

Our brains are incredibly visual. Three out of four neurons in our brain are visual.

10.36

We process visual images far better than text.

10.38

David showing a visualization: Who’s Suing Whom in Telecoms? Crazy pattern. Begs question: Do decreasing profits lead to increase in lawsuits?

10.41

David showing most popular Internet Search Terms laid out in maps of the countries in which they were used. Brilliant.

10.42

Great Venn Diagram showing how Pigs, Birds, and Humans relate by Flu: Influ-Venn-Za #MyKindOfHumor

10.43

If Twitter were made up of 100 users, 20 would be Dead (Empty accounts), and 75% of the Tweets would come from 5 users (Loud Mouths).

10.46

Showing visualization of most commonly used PIN numbers (gathered from previous data breaches). You guys, please choose better ones.

10.47

Data Visualization lets you see the Invisible

10.48

Is there a relationship between the efficacy and the popularity of vitamin supplements? Not much.

10.49

87% of supplements have no research behind them that indicates they have value. #Marketing

10.49

Key aspect of Data Visualization: You can compress a massive amount of information into a small, meaningful space.

10.50

Data Visualization is SO important for Mobile where you have much less screen space to work with.

10.52

David: It used to take me three days to make that Billion dollar Treemap. Now it takes 3 milliseconds. #ProgressYo

10.53

Qualitative Data is also Invisible. But you can Visualize it to fix that.

10.55

David, when visualizing some political comparisons, I REALLY wanted my viewpoint to look better than the other, but I couldn’t do that. #Honesty

10.57

There are organizations that use data visualization to LIE. Learn more about Data Viz so you can see the signs of impropriety.

10.58

Data Visualization of views can better reveal the places where opposing viewpoints actually overlap.

10.59

In the Newspapers, there is often an anxiety over white space: They Fear it. As a result, the meaning of the data is lost in noise.

11.00

In Data Visualization, Bling can create a barrier to understanding. It is the Data that should POP, not the shiny.

11.01

In Data Visualization, you should use your scissors more than your paint brush. #LessIsMore

11.02

Key takeaway from David: PLAY. Play leads to insight and understanding.

11.07

David showing visualization: Who is more Popular: Han Solo or Luke Skywalker? David: Interesting, no mention of either prior to 1977…

11.08

David: There is so much data in the world; what else can you do but play with it? #Exactly

11.10

Go to http://www.informationisbeautiful.net/  for David’s visualizations and great insights and data.

11.11

David: I never design ANYTHING until the data is sorted and clean. #FollowThisExample

11.15

David has created a symbology of stars so that they are not just points of light, but lack the resources to build it. Kickstarter?

11.17

David: Data is not this empirical thing that is immune from bias. It takes work and effort to keep bias out.

11.19

David: In terms of color, sometimes you need to come up with a meaningful metric that will be served well by color.

11.20

That wraps up the Day 2 Keynote here at the PASS Business Analytics Conference. Thanks much for following. I hope you found it helpful.

10.06

The Show will be starting in about ten minutes.

10.11

It’s great to see so many attendees filing in taking pictures of the room and the crowd. #SQLPASS

10.17

Today’s Keynote speakers include high level Data Platform executives within Microsoft. #WhereAreWeGoing #SQLPASS

10.19

James Phillips is the head of Azure/BI. This includes owning the direction of #PowerBI #sqlpass

10.20

Joseph Sirosh heads up the Information Management and Machine Learning group. #sqlpass

10.20

Ranga Rengarajan leads the Database and Big Data engineering business. #sqlpass

10.21

I love that Microsoft sees the value in #sqlpass and takes it seriously. #WeArePass

10.22

Today’s Theme: Evolving Microsoft’s Data Platform – The Journey to Cloud and Continues #sqlpass

10.23

PASS President Thomas LaRock on the stage. #HiTom #sqlpass

10.24

Round of applause for the makers of the “Best Data Platform on the planet” #DigIt #sqlpass

10.25

I want to thank the PASS Board Members for the hard work they put in to make PASS awesome. #sqlpass

10.25

PASS Board Q&A on Friday at 1 pm in Room 307-308 #sqlpass

10.26

First PASS Summit in Chicago in 1999 with 1200 attendees. #sqlpass

10.27

Today, PASS summit has 5899 attendees! #sqlpass

10.28

Tom: Community = Opportunities #sqlpass I am living proof of that. PASS has been HUGE for my career.

10.30

Tom: I challenge you to get involved. #sqlpass #DOTHIS Networking at Summit is AMAZING

10.31

The SQL Clinic is a spectacular place to get help with the products. #sqlpass

10.32

New This Year: Abstract workshops with speakers and Program Committee. #sqlpass

10.32

I will be at a Business Intelligence focused table at the Birds of a Feather lunch tomorrow. #sqlpass

10.33

PLEASE make sure to visit the Exhibit Hall to give the partners/sponsors a big THANK YOU! #sqlpass

10.34

Tom: Give vendors/sponsors a hug. #ChuckHuggers cc/ @sqlboywonder #sqlpass

10.36

Tom: PASS has been the cornerstone of my career since 2004. #sqlpass

10.40

Ranga taking the stage. #sqlpass

10.41

Ranga: We’re the only company that has this hyper scale cloud and the Enterprise presence to do magic. #sqlpass

10.42

Ranga: I love maps. I became a member of AAA when I found out they gave me free maps. #sqlpass

10.43

From maps to MapQuest…. #GrowUpStory #sqlpass

10.44

Ranga: Our success at Microsoft in the data world is because of YOU. #sqlpass

10.44

Ranga: EVERY YEAR, there is 41% more data than there was the year before. #sqlpass

10.45

Ranga: Data is the thing that is going to light up future productivity. #TRUTH #sqlpass

10.46

Ranga: “Data Culture” happens when people get the data they need and want when they need it. #sqlpass

10.47

Ranga: The Microsoft data platform enables that progress toward Data Culture. #sqlpass

10.47

Ranga: I am going to focus on the Capture and Manage parts of the data story. #sqlpass

10.48

Ranga: Microsoft is a data platform that doesn’t require you to make compromises. Culture of AND. #sqlpass

10.49

Ranga: Do more; achieve more. #sqlpass

10.50

Ranga: Capture diverse data; Achieve elastic data; Maximize performance & availability; simplify the cloud. #sqlpass

10.51

Azure DocumentDB: NoSQL DB service in the cloud, schema-free, ranging from ACID to eventual consistency. #sqlpass

10.52

Ranga: every application that is made expects a Search window. #Yup #sqlpass #DudeWheresMyData

10.53

Ranga: We think combining On-Premise and Cloud is necessary for the whole data story. #BestOfBothWorlds #sqlpass

10.54

Ranga: Scale Up = on prem SQL Server 2014 AND VMs in Azure. Scale Out = Azure SQL Database. #sqlpass

10.54

Ranga: Use the best tool for the job. #sqlpass

10.55

Tracy Daugherty of Pier1 Imports taking the stage. #sqlpass

10.56

Tracy: One thing we have a LOT of right now: orange pumpkins. #NoDoubt #sqlpass

10.56

Tracy: Azure Search lets us enable “fuzzy” search matching with great ease. #MakeItSimple #sqlpass

10.57

Tracy: Azure Search allows for a Scoring Profile so you can control how results are returned. #sqlpass

10.57

Ranga: Scoring Profile lets you weight the relevance of Search results. #sqlpass

10.58

Azure Search lets you squash the amount of code you need to find pumpkins…. #CouldNotResist #sqlpass

10.59

Tracy: JSON for the win. #sqlpass

11.00

JSON (Java Script Object Notation) is a very popular format for sharing data across platforms. #sqlpass

11.01

Watch me use #PowerQuery on Friday to consume JSON with ZERO CODE with a few clicks. #sqlpass

11.03

Tracy showing how they use Sharding in Azure SQL Database to scale workload easily. #sqlpass

11.05

Tracy is configuring Geo Replication for the main Pier 1 database easily in the Azure Management Portal. #sqlpass

11.06

Geo Replication: Where in the world is my database? There. AND There. AND There. #sqlpass #CultureOfAND

11.07

Ranga: Azure SQL Database has a 99.99% SLA. No one else has that. #sqlpass

11.08

Ranga: When we engineers at Microsoft run a million databases EVERY DAY, we learn things very quickly. #sqlpass

11.08

Ranga: lessons from the cloud enhance the On-Premise products. #CloudFirstFTW #sqlpass

11.09

Ranga: Use the right tool. Sometimes that is cloud. Sometimes on prem. We want that to be seemless. #sqlpass

11.10

Ranga: Take the data from wherever you find it, put it in the RIGHT engine and leave it in the cloud. #sqlpass

11.11

Ranga: Stackoverflow is a key customer. They have broken through limits on SQL Server using clever techniques. #sqlpass

11.12

Ranga: Stackoverflow takes advantage of In-Memory technology and uses it well. #sqlpass

11.13

Ranga: Samsung has seen 24x performance boost using SQL Server In-Memory technology. #sqlpass

11.15

Great to see Microsoft really embracing the idea that Relational is not everything. #PickTheRightEngine #sqlpass

11.15

Ranga: over 1.2 million downloads of #SQLServer 2014 #sqlpass

11.16

Ranga: Announcing a major update to Azure SQL Database. Will be in Preview by end of 2014. #sqlpass

11.17

Ranga: new features include leap in TSQL compatibility, parallel queries, Extended Events, In-Memory ColumnStore #sqlpass

11.19

Ranga: Introducing Mike Zwilling to show some cool stuff around Pier 1 Imports. #DatabaseEngineGoodness #sqlpass

11.19

Mike: People want real-time analytic queries on transcriptional data. #IWantItNow #sqlpass

11.20

Mike: I need your help to generate some load: go to http://aka.ms/gopass to help this demo out. #sqlpass

11.21

Mike: you are generating load on a beck-end SQL Server running In-Memory OLTP. #sqlpass

11.22

Mike showing LIVE analytics on top of transnational database we are hitting. Really cool. #sqlpass

11.23

Mike: we have a combination of the In-Memory engine AND a non-clustered ColumnStore index on the SAME table. #sqlpass

11.25

Mike: that ability to STRETCH a table to reach from On-Premise to Azure. The SAME table. #sqlpass

11.26

While the table is being stretched, you can still query it. #sqlpass

11.27

Looks like Ranga bought a “Hug Chuck” T shirt. #ChuckHuggers /cc @SQLBoyWonder #sqlpass

11.28

Mike: When you stretch a table, the bulk of the work happens with resources in Azure, not On-Premise. #sqlpass

11.29

Mike: we lost the on-premise server. I need to restore JUST THE LOCAL portion of the database. #sqlpass

11.29

In a few seconds, the on prem was restored and synchronized from Azure and we are back up and running. #sqlpass

11.30

Ranga: With this technology, you get the benefit of the Hyper Scale cloud in an invisible way. #sqlpass

11.30

Joseph Sirosh taking the stage to talk about Machine Learning, etc. #sqlpass

11.31

Joseph calling on the crowd to do the wave. #ContinuousIntegration #sqlpass

11.32

…and people actually did it. #sqlpass

11.33

Joseph: You want to understand the past, analyze the present, and predict what’s next. #sqlpass

11.34

Joseph: Azure Data Factory is in-Cloud data movement for moving data around. #sqlpass

11.35

Joseph: ANNOUNCING Free Azure Machine Learning at azure.com/ml #sqlpass

11.36

Joseph: We are democratizing data and capabilities. #BIToTheMasses #sqlpass

11.36

Sanjay Soni taking the stage to lead a demo around Pier 1. #sqlpass

11.37

Do we see a Pier 1 Import/Output Wizard in the future? #Joking #sqlpass

11.37

Sanjay showing In-Store Analytics using Kinect as a source…. #sqlpass

11.39

Sanjay showing heat map in #PowerMap visualization the customer movement in the store. #sqlpass

11.39

Sanjay showing how they used Azure Data Factory. “Think of SSIS to the power of X in the cloud.” #sqlpass

11.40

Joseph: You’re seeing a browser-based authoring environment. #sqlpass

11.41

Joseph: The speed at which you can get Data to work for you using this tool is amazing. #sqlpass

11.41

Joseph: all this through a browser and JSON documents. #sqlpass

11.42

Joseph: The data is flowing into Azure via Kinect sensors, ADF, and Azure Streaming Analytics. #sqlpass

11.43

Sanjay showing real-time (seconds) data visualizations about what is happening in the store RIGHT NOW. #NoPieCharts #sqlpass

11.44

Sanjay: How many lines of code to make this happen? FOURTEEN. #sqlpass

11.44

Sanjay: Azure Machine Learning is my new favorite product. AWESOME! #sqlpass

11.46

Sanjay now showing a Pier 1 app on his phone. #sqlpass

11.47

It’s not an iPhone. #JustSaying #sqlpass

11.47

Pier 1 was able to send Sanjay recommendations to his phone, with speech. #sqlpass

11.48

Sankay using speech recognition to find what he asked for and display it on the in-store map. #cool #WhereDoYouWantToGoToday #sqlpass

11.49

Since he searched for glasses, the app determined he might also be interested in other table ware. #sqlpass

11.50

Joseph: We are trying to make the BEST platform to analytics across On-Premise and Cloud. #sqlpass

11.50

James Phillips taking the stage. #PowerBI #ILoveIt #sqlpass

11.51

James: We want to bring insights to more people – faster #sqlpass

11.51

ANYONE that makes decisions can make better ones with better information. Not just for the C-Suite anymore. #sqlpass

11.52

James: Simplify data discovery. #PowerQuery #PowerPivot #sqlpass

11.53

#PowerQuery has had over 320,000 downloads since February of 2014. #sqlpass

11.54

James: Do more; achieve more: Simplify data discovery; deliver faster insight; connect to on-premise; enable data culture. #sqlpass

11.55

James: ANNOUNCING: Interactive Query – from Power BI, connect back to on-premise SSAS while keeping the data on prem. #sqlpass

11.55

James: Data sitting at rest has potential. We want to unlock that. #DataDividends #sqlpass

11.56

James: LIVE OPERATIONAL DASHBOARD #sqlpass

11.57

This is a NEW Power BI, not the same one we know and love right now. #sqlpass

11.57

The current one is NOT going away. We are just getting a new story to go along with it. #PowerBI #sqlpass

11.59

James is not using Q & A to create new visualizations based on corporate data and “pinning” them to his dashboard. #sqlpass

12.00

YOU get a dashboard. And YOU get a dashboard. And YOU get a dashboard… #Oprah #sqlpass #PowerBI

12.01

James: I don’t like Pie charts so I am going to make this a tree map, instead. #Winning #DataViz #sqlpass

12.01

James just signed into One-Drive and is connecting to an Excel Spreadsheet FROM POWER BI IN THE CLOUD #sqlpass

12.02

James combining charts by dragging one chart onto another. #Boom #sqlpass

12.03

James: This new #PowerBI is in private preview and will be hitting public preview soon. PowerBI.com #sqlpass

12.04

Ranga: Try Azure Machine Learning to day for a free trial with a Live ID. #NotTotallyFreeIfItIsJustATrial #sqlpass

12.04

Ranga: Be the hero of your data-driven business. #sqlpass

12.06

That wraps up the PASS Summit 2014 Keynote day 1. Thanks for following along. See you tomorrow morning! #sqlpass

10.14

I love the smell of #SQLServer in the morning. Smells like Awesome.

10.16

Adam Jorgensen taking the stage. #HiAdam #sqlpass

10.18

Adam: PASS Summit generates .9 Million in revenue. The PASS BA Conference generates .3 Million. #sqlpass

10.21

Adam: Starting in Fiscal 2015, we will budget budget summaries. #sqlpass

10.24

Sorry for the silence. Having connectivity issues… #SadPanda #sqlpass

10.25

Grant Fritchey joining the board on January 1. #ScaryBoardMember #sqlpass

10.25

PASS TV makes Summit a global experience. #sqlpass

10.26

Denise: PASS is a great enabler for personal growth. #Truth #sqlpass

10.28

PASSion Award Winner: Andrey Korshikov! #sqlpass

10.29

Andrey is a PASS Regional Mentor and organizer of several Russian language PASS Events. Awesome! #sqlpass

10.32

PASS Business Analytics Conference 2015 in Santa Clara, CA April 20-22 #sqlpass

10.33

Denise: Make sure to update your member profile on sqlpass.org to find out opportunities to volunteer. #sqlpass

10.34

Make sure to bring your attendee badge to get into the Community Appreciation Party tonight. #sqlpass

10.34

PASS Summit back here in Seattle October 27-30 2015. #sqlpass

10.36

Rimma Nehme, Principal Engineer at Microsoft Jim Gray System Lab, taking the stage. #sqlpass

10.36

Cloud Databases 101: Cloudy with a chance of more clouds, all with data. #ThingsAreLookingUp #sqlpass

10.38

Rimma: Trying to be a man is a waste of a woman. #Awesome #sqlpass #WIT

10.39

Rimma: I know a little bit about databases. #Understatement #sqlpass

10.39

Rimma: I’m a HUGE fan of the PASS community! #LoveIt #sqlpass

10.41

Rimma: Why cloud computing? #sqlpass

10.41

Rimma: With cloud technology being relatively new, it creates “Shiny Object Syndrome” #sqlpass

10.42

Rimma: Cloud = Service. On demand, anywhere, anytime. #sqlpass

10.43

Rimma: Blame networking people for the name Cloud Computing. #sqlpass

10.44

Rimma: Cloud Computing = On demand self-service. #DoItYourSelfYo #sqlpass

10.45

Rimma: One person and a credit can tap into the largest computing resource pool in the world. #sqlpass

10.45

Hm. I wonder what my Data Credit Score is…. #sqlpass

10.46

Rimma: Cloud computing reduces dev time and effort as you don’t need to spin up your own infrastructure. #sqlass

10.47

First wave of Massive Computing started in the 1960s with Super-Computers and Mainframes. #sqlpass

10.49

Rimma: The future of the Data Center is shipping containers full of servers. #ModularDataHomes #sqlpass

10.51

Rimma: Resources are NOT infinite. Optimizing for energy efficiency is leadership. #sqlpass

10.54

Take advantage of Evaporative Cooling. #DataScience? #sqlpass

10.56

Rimma: So that is Why Cloud. Now, what is Cloud DB? Take Earthed DB and add Service. Voila! #sqlpass

10.59

Rimma: Pizza as a service. On prem: you do it all. #sqlpass

10.59

Rimma: The other extreme is Cloud: Dining Out. The vendor manages everything. #sqlpass

11.00

Showing Pizza as a Service with no Pie Charts! Woohoo! #sqlpass

11.04

Dr. Nehme giving so much awesome information, I am having trouble keeping up. #GoodProblemToHave #sqlpass

11.05

Dr. Nehme: Maybe you will invite me back for another Keynote. #YesPlease #sqlpass

11.07

Dr. Nehme: starting up the bathroom analogy for virtualization. #sqlpass Hard to share efficiently.

11.07

Dr. Nehme: With virtualization, you lose direct access to computing resources. #sqlpass

11.08

Dr. Nehme: Virtualization is wonderful, but you have to keep in mind the trade-offs. #OftenWorthIt #sqlpass

11.09

Dr. Nehme: Server consolidation can lead to great energy savings as well. #sqlpass

11.11

High Availability with Pizza: If your delivery person gets lost, you still get the pizza from another. #sqlpass

11.13

Dr. Nehme: If application independence is VERY important to you, avoid the share schema approach of Multi-Tenancy. #sqlpass

11.14

Dr. Nehme is making the complex simple through great analogies. Fantastic job and a great example to follow. #sqlpass

11.15

Dear presenters: Please not that Dr. Nehme has not read to us. Not even once. :) #sqlpass

11.16

Dr. Nehme: a quick peek at the Azure SQL DB architecture. (I will try to keep up). #sqlpass

11.17

Dr. Nehme: Designed with High Availability in mind. #sqlpass

11.18

Azure SQL DB includes layers of abstraction to that you don’t need to deal with it. #DatabasesToTheMasses #sqlpass

11.20

Dr. Nehme: SQL Node architecture – The log files are shared across multiple databases. #SomeSharing #sqlpass

11.21

Dr. Nehme: The SQL Azure Gateway Service manages the traffic to make Azure SQL DB work. #sqlpass

11.22

Dr. Nehme: Do we still need a DBA in the Cloud Era? YES. ABSOLUTELY. #StretchToCloud #sqlpass

11.23

With Cloud Era, the on-premise story does NOT go away. There will be lots of hyrbid solutions REQUIRING on-prem. #sqlpass

11.23

Dr. Nehme: DBAs should add Cloud expertise and start calling themselves a Cloud DBA. #sqlpass

11.25

Dr. Nehme: You DBAs will become the Cloud DBAs. Embrace it! #sqlpass

11.26

Dr. DeWitt joining Dr. Nehme on the stage. “He has been a great mentor.” #NoDoubtAboutIt #sqlpass

11.26

Thank you, Dr. Nehme. That was fantastic. #sqlpass

11.27

Dr. Nehme received a well-deserved standing ovation. #sqlpass

11.28

Dr. Nehma: All you guys in kilts, please come take a picture with me in front of the stage. That is really cool. #sqlpass #SQLKilt

11.29

That wraps up the keynotes for Pass Summit 2014. Thanks so much for following. #sqlpass

10.14

It’s so fun to watch everyone file into the room for the keynotes.

10.20

Showtime.

10.22

PASS President Thomas LaRock taking the stage.

10.23

Official Announcement: #SQLHugs are a thing.

10.23

Folks from 58 countries present at Summit.

10.26

PASS Board Q&A at 3:30pm. Come ask questions and get answers.

10.26

Big welcome to the first time Summit attendees! Get ready for an awesome ride.

10.28

Tom: Data Professional are the true life force for companies around the globe. #ItsAllAboutTheData

10.29

For me, PASS has been a HUGE factor and my taking my career to where it is today. Thank you!

10.30

Stop by the Community Zone on the 4D Skybridge! Great place to Connect Share and Learn.

10.31

Hurray for Speaker Idol! Growing new speakers is AWESOME!

10.33

Super huge thanks to sponsors who help PASS have such a tremendous impact for us.

10.35

Thanks for your service as PASS President, Tom!

10.35

Microsoft Corporate VP Joseph Sirosh about to take the stage!

10.38

Sirosh: The ability to understanding data is transforming our daily lives.

10.39

Sirosh: Once data got an IP Address, we got abilities to connect everything.

10.40

Sirosh: In the Age of Software, the goal was to digitize everything. A computer on every desktop.

10.41

Sirosh: In the Age of Data, data and the analysis of data is driving us forward.

10.42

Dartmouth-Hitchcock used Microsoft technologies to create a new health care platform called ImagineCare

10.43

ImagineCare: The Internet of People Things – personalized care using devices and cloud-based monitoring

10.44

Sirosh: In the new world, Data will predict everything.

10.45

Sirosh: Today’s hospitals are optimized for treating things that already happened instead of preventing them from happening.

10.46

Sirosh: It used to cost 0 million to sequence one person’s genome. Now it costs less than 00.

10.47

The future of HealthCare: Instead of the treatment that works for others, you get the treatment that will work for YOU.

10.48

Sirosh: A lot of genomic analysis is done in R

10.50

Sirosh: DocuSign has 50 million users today. Someone signs electronically with DocuSign every .4 seconds!

10.50

DocuSign Chief Architect Eric Fleischman taking the stage

10.51

DocuSign uses #SQLServer for their OLTP systems. #YouShouldToo

10.52

Fleischman: We bet BIG on Always On #sqlserver

10.53

Fleischman: We’re not database people. We don’t want to write a database engine. I want to USE one. #sqlserver

10.54

Fleischman: We made a major investment into the telemetry inside the system. We have systems for tracking the systems.

10.55

Fleischman: Always Encrypted is a big deal for us. We’re in the Trust business.

10.56

Sirosh: High-performance OLTP has been vital for a long time. The importance of USING that data effectively is on the rise.

10.57

Stop just STORING your data. Start USING it.

10.58

Sirosh: We have our feet on the ground and our head in the cloud

10.59

Sirosh: When we have that and a community like PASS, you help us become #1

11.02

Shawn Bice Micrrosoft GM for Database Systems Group taking the stage

11.03

Bice: In this era, companies who embrace data will be far more competitive than those who don’t

11.04

Bice: SQL Server 2016 is backbone of Azure. Billions of queries hit that every single day

11.05

Bice: Everything I am going to show you on SQL Server 2016 today is BUILT IN

11.06

Bice: SQL Server is mission critical ready – It is backbone for train transportation in an entire country

11.08

Bice: R is the #1 choice for data scientists and statisticians in the world. Welcome to SQL Server!

11.09

You want cloud? Choose Microsoft. You want on-prem? Choose Microsoft. You want to straddle both? Choose Microsoft.

11.11

Bice: Do you realize you can enroll an Azure VM in an on-premises availability group in about 5 minutes?

11.12

Bice: We had a data center ACTUALLY LIGHT ON FIRE. We failed over all our customers there in 5 hours.

11.13

Bice: Polybase is baked right into SQL Server 2016 #TheNeedsOfTheMany

11.14

Bice: Auto insurers tying telemetry data to customers for rate calculation using SQL Server

11.15

Bice: Real-time is not just throughput. It’s the ability to learn and adjust as tings are happening.

11.15

Sometimes, you need to learn NOW, not just AFTER ETL ran…

11.16

Bice: Real-Time Operational Analytics ftw!

11.17

Operational Analytics with R in SQL Server: Learn from your data where it lives

11.18

Rohan Jumar, Microsoft Partner Director in Engineer is joinig Shawn Bice on stage

11.19

Jumar showing map of PCubed showing lighted dots based on financial transactions everywhere in the world.

11.20

Bice to Jumar: With that kind of scale, how do you even begin???

11.22

Jumar showing the realtime dashboard used by PCubed to track their system. #NoPies

11.23

Jumar: With SQL Server 2016, you can achieve the realtime analytic without impacting our OLTP queries

11.29

Jumar showing an R script directly into a T-SQL stored procedure while the data never leaves the safety of SQL Server

11.30

Typos…. Kumar, not Jumar… sorry.

11.31

Bice: We have invested more on security in SQL Server 2016 than ever before

11.33

Bice: There is a big hole in the data world – open access to the buffer pool. Always Encrypted fixes that for SQL Server

11.33

Bice: With Always Encrypted, the work happens on the client side, not in the engine

11.34

Rohan Kumar coming back on the stage

11.38

Kumar: Always Encrypted allows encryption at rest AND in transit.

11.39

Dear Man-in-the-Middle Attackers, SUCK IT. Sincerely, SQL Server 2016 Always Encrypted

11.41

Bice: This is a new SQL Server. We’ll take the most complex things and simplify them for you.

11.42

Bice: Stretch DB allows “stretching” tables into Azure for CHEAP storage while keeping data queryable!

11.44

Bice: Stretch Database and Always Encrypted work awesome together

11.44

Do you want speed or security? With SQL Server 2016 you get BOTH

11.47

Kumar: We worked to make Stretch Database easily usable by DBAs who have not done much in Azure

11.49

Kumar showing a query from two tables, one Stretched, one not.

11.50

Kumar: We’ve built Stretch on the distributed query infrastructure we have had with SQL Server

11.52

Joseph Sirosh taking the stage again.

11.52

Sirosh: Building great projects is a journey. SQL Server 2016 took twenty years of work

11.54

Sirosh: We believe in dog-fooding all of these. We are using this ourselves

11.55

Sirosh: We don’t believe in nickle-and-diming customers for every new feature

11.56

Sirosh: We are creating better and new human experience – WITH DATA

11.57

Sirosh: This is the age of the data professional. It is our time.

11.57

That wraps up this keynote. Thanks for following along. These are great times we live in, friends.

10.10

Folks are filing into the hall. There is quite a bit of excitement in this room.

10.21

Here we go, yo.

10.22

Adam Jorgensen taking the stage.

10.24

All PASS financial information is available at www.sqlpass.org/governance

10.25

Summit attendees have doubled since 2007! I have certainly gained weight…

10.26

In 2008, there were 5 SQL Saturdays… in the US. In fiscal 2015, there were 99 globally….

10.27

PASS has over 150,000 members worldwide from 163 countries. This covers 86% of the countries in the world.

10.29

Total fiscal year 2015 spend was a bit over million. 78% of those dollars went directly back into the community

10.30

Starting this fiscal year 2016, PASS will be publishing portfolio budget summaries for better transparency

10.32

SQL Rally resources are being routed to SQL Saturday

10.32

Also this year, a goal is to do a redesign of sqlpass.org

10.33

Denise McInerney taking the stage

10.36

Great recognition for Amy Lewis and Bill Graziano for their contributions to PASS on the board.

10.37

Volunteers work so hard to make PASS what it is. THANK YOU!

10.37

Passion Award goes to Lance Harra!

10.39

Wow. Lance has done so much that I can’t keep up. Way to go, sir!

10.40

There are 3000 people tuning in LIVE on PASSTV from 95 countries right now. HI!

10.42

Since 2009 12 24 Hours of PASS events have been delivered in Spanish, Portuguese, or Russian. Awesome!

10.43

PASS Summit 2016 will be October 25-28 here in Seattle!

10.45

Welcome to Dr. David DeWitt and Dr. Rimma Nehme! If you want to learn about presenting, watch them. They rock!

10.45

Dr. Nehme (Nehme) taking the stage!

10.46

Nehme: I will be the appetizer, David will be the entree, then I will be the dessert.

10.47

Nehme: We thought the Internet of Things (Thingernet) would be a great topic.

10.47

Nehme: Why should you, as data professionals, care about this technology?

10.48

Nehme: What is IOT? A collection of connected devices that work together to do something useful.

10.48

No pizza this year.

10.50

Nehme: Two types of IOT: Consumer (wearables, etc), Industrial IOT (machines etc)

10.50

Nehme: Consumer IOT examples, Fitbit, Nest, etc

10.51

Nehme: Industrial IOT…. Can we build more intelligent roads? Hospitals?

10.52

Nehme: Significant value will be realized from the Industrial IOT

10.53

Nehme: Four Types of IOT Capabilities: Monitoring, Control, Optimization, Autonomy

10.53

Nehme: We are somewhere between monitoring and control right now. I call it the Terrible Twos of IOT

10.54

Nehme: In 2003 we have about 500 million devices connected to the Internet. In 2010, we had 12.5 billion.

10.55

Nehme: Somewhere in 2008, the number of Internet connected devices exceeded the population of the Earth

10.56

DeWitt taking the stage to talk about the HOW if IOT…

10.57

DeWitt: Lots of challenges to IOT. Huge variety of sensors. Lots of devices. Dirty sensor readings. Data volume/scale

10.58

DeWitt: Device security is a huge challenge as well. Challenges also with cloud to device messaging

10.58

DeWitt: the last major challenge is deployment. When you have billions of “things” how do you manage that?

10.59

I say it every year. But notice that neither Dr. Nehme nor Dr. DeWitt have READ to us…

11.00

DeWitt: Even the cutting edge IOT is still rather primitive

11.01

DeWitt: Pretty much every IOT device has a sensor. Most of them also have an actuator to perform an action

11.02

DeWitt: Once the data gets to the Cloud, you have a lot of options for what you can do with it

11.03

DeWitt: Occasionally, a command will be sent from the Cloud back to the device: Cloud to Device Command

11.03

DeWitt: IOT Hubs are cloud-based services for interacting with the “things”

11.04

DeWitt: Real-time streaming systems, like Azure Stream Analytics, operating on a finite window of time

11.05

DeWitt: They only PROCESS data. They don’t have time to store it.

11.06

DeWitt: The Azure IOT hub provides device authentication since security is so critical

11.06

There is not way I can keep up with either Dr. Nehme or Dr. DeWitt. But trying is really fun

11.08

DeWitt: If you want to store the IOT data, you need a consumer that will take it out of the hub to store it

11.10

DeWitt: You have a number of options for storage, but SQL DW is the best one. #WinkWink

11.10

DeWitt: Azure Machine Learning is a great solution for “predicting when the boiler will explode” #NoPressure

11.12

DeWitt: So what IS a real-time query engine? In my mind, it is a streaming database system

11.12

DeWitt: You have queries that operate over events across time windows.

11.13

Now I have “Islands in the Stream” in my head. Thanks, Doc.

11.14

DeWitt: The stream can send the ID values of boilers about to explode to a system to open the release valve

11.15

DeWitt: Raspberry Pi is not running SQL Server.. yet. That’s NOT a product announcement…

11.16

If you visualize an array of Raspberry Pi devices, that is a Pi Chart. #JustSaying

11.17

DeWitt: Right now Azure IOT is pretty limited. Currently, metadata is not stored in a DBMS. So, no query support

11.18

DeWitt: Devices must poll in order to keep checking for commands.

11.18

DeWitt: IOT events are PUSHED up into the cloud.

11.19

DeWitt: issues with pushing only: bandwidth, connectivity, latency, data deluge, storage

11.20

DeWitt: In our opinion, pushing everything to the cloud is a huge waste of resources

11.21

DeWitt: Have a streaming query engine near the device to aggregate and send results to the cloud instead of each event

11.22

DeWitt: This reduces what we push into the cloud, and allows for dealing only with IMPORTANT events

11.22

Dr. Nehme taking the stage again.

11.23

Nehme: Fog Computer aka Edge Computing. This is not Cloud VERSUS Fog. It is Cloud + Fog

11.24

Nemhe: We are taught that you never move the data to the computation. You move the computation to the data.

11.24

Nemhe: The Cloud is basically this big gorilla… #TheOneAndOnlyIvan

11.25

Nehme: IOT is not just a Networking problem. It is also a database problem.

11.25

Nemhe: Polybase for IOT. This is NOT a product announcement… but if you make enough noise…

11.26

Nehme: Today you have to specify everything you want to do about IOT

11.27

Nehme: How about IOT-SQL? Why not query Devices like we query Tables? #Dude

11.28

Nehme: Regular attributes can be inserted, deleted, etc. Extended Attributes are set by the device alone

11.29

Nemhe: Scalable metadata management with a Shell Database. Essentially, metadata only.

11.31

Nehme: Where could the Shell be stored? Anywhere, really. DocDB, HDInsight, Azure SQL DB… It’s just a database.

11.34

Nehme: Make sure only meaningful, important, information is sent up to the cloud.

11.35

Nehme: Larger computations happen in the Fog near the device instead of sending it all to the Cloud

11.36

Nehme: Why should as Data Professionals care? You either part of the steamroller, or part of the road.

11.37

Nemhe: The amount of data to manage is increasing exponentially. So, what does success look like?

11.37

Nehme: This is our last PASS Keynote. #Noooooooooooooooooooooooooooooooooooooooo

11.38

HUGE THANK YOU to Dr. Dewitt and Dr. Nehme for so many AWESOME keynotes. We will miss you!

11.39

DeWitt: It is time to give up on the full time gig and start collecting Social Security. #YouHaveEarnedIt

11.41

HUGE Standing Ovation for Dr. DeWitt and Dr. Nehme.

11.41

That wraps up the Day 2 Keynote. Thanks for following along.

13.55

Huge thanks to SQL Sentry for sponsoring!

13.57

This year’s special guest is Angie Chang of Hackbright Academy, an engineering school for women.

13.59

Angie will sit down with Denise McInerney, PASS VP of Marketing.

14.00

I love looking around the room at the Women in Technology Luncheon and seeing so many men in attendance.

14.18

Denise McInerney taking the stage. Here we go.

14.18

Angie Chang joining Denise on stage.

14.19

Chang has a BA in English and is in Technology. Me too. Liberal Arts = Learning How to Learn

14.21

Chang has long been involved in helping women network and improve themselves

14.21

Chang: Hackbright has graduated over 300 women at this point.

14.22

Chang: Hackbright started by folks who attended a coding bootcamp in San Francisco.

14.23

Hackbright: We’ll teach you how to code in ten weeks.

14.24

Chang: we are teaching python as a full stack framework. We also do Angular and teach women how to mentor each other

14.24

Chang: Each student gets three mentors to help with code reviews, etc

14.25

Chang: People choose Hackbright because of the Community. #CommunityMatters

14.26

Chang: Hackbright students and alumna have come from so many various backgrounds.

14.27

McInerney: I know you have a high rate of job placement from Hackbright. Can you share success stories?

14.28

Chang: We have several women who have gone onto senior software engineering positions and engineering managers

14.28

Chang: Survey Monkey has, I think, hired more Hackbright alums than any other company

14.29

McInerney: How are companies supporting Hackbright Academy?

14.29

Chang: We invite partners companies to a career day to come and meet all our graduating students.

14.30

Chang: Several companies also offer scholarships for Hackbright students

14.31

Chang: For the first GirlGeek dinner I hosted in the Bay Area, we have 400 people sign up in 5 days. #Winning

14.32

Chang: Often, people get hired based on networking, etc, at Girl Geek dinners.

14.33

Chang: Train your managers so that women who are already IN tech have a good experience

14.34

Chang: There are so many roles that women of ANY age can fill. It’s a shame we only focus on the youngest

14.35

Chang: Making sure women can start having a better experience in Tech is going to help with retention of women in in Tech.

14.36

Chang: We encourage our students to BE THE CHANGE THEY WANT TO SEE #GoodAdviceForAllOfUs

14.38

McInerney: What advice to you have for parents that want to make a difference in this area?

14.39

Chang: Don’t just enroll your boys in tech camps, etc. Enroll your girls, too. #ProudToSayIDoThat

14.39

Chang: Encourage your girls to be brave instead of afraid they are going to break things. #ItsOKToFail

14.40

McInerney: How can people help support Hackbright Academy?

14.41

We are opening up to questions. People online can ask via hashtag #passwit

14.42

McInerney: What’s your perspective on how schools need to change?

14.42

Chang: One example is a project called Technovation that helps girls write Android apps and pitch them

14.44

Chang: I was really lucky to have a computer programming class in high school. We need more of that.

14.44

McInerney: There is a documentary on Technovation coming to YouTube next week called Code Girl

14.45

Chang: We have never had a student directly out of high school. We’re wondering why that would be.

14.46

Chang: At Hackbright, we have lots of hackathons and they have been women of all ages.

14.47

Twitter Question: Are there plans for paths other than software engineering at Hackbright?

14.48

Chang: Currently, we are trying to fill the gap in software engineering. These are good-paying jobs, etc.

14.48

Question: Have you seen blowback form that fact that Hackbright is not a four-year degree?

14.49

Chang: It’s kind of silly that so many positions require a four-year degree. It is just not that important these days.

14.50

Chang: Eliminating the degree requirements does NOT lower the bar. It just makes the job description more accessible.

14.53

Chang: We’re working on piloting some Hackbright hackathons in companies to help them elevate their women

14.54

Question: Why more women in tech?

14.55

Chang: Diverse teams have better results. The helps everyone.

14.58

Chang: Autodesk is one our partners. Internet of Things and Data Science have been interesting topics for our graduates.

15.01

Twitter: Do you think it is damaging to refer to females as Girls instead of Women?

15.01

Chang: There are far more important things to worry about than Girls vs Women

15.03

McInerney: There’s a lot of information our there about Unconscious Bias.

15.04

Chang: In a lot of companies, some managers bring up women in there team, others… not so much

15.05

Chang: Good mentors are needed. So many women leave tech over a bad manager

15.07

Chang: Field trips are great. They have inspired our students tremendously. Show them a good tech experience.

15.08

Chang: We also mentor our mentors to make sure they learn how to be good mentors.

15.08

Chang to Mentors: If you are asking me how you are doing, you are probably doing a good job.

15.09

Chang: THANK YOU for having this conversation!

15.10

Thanks to Angie Chang, Denise McInerney, and sponsor SQL Sentry for a great Women in Technology Luncheon.

15.11

That wraps up the live blogging to this Summit. Thanks for following along.

PASS Summit 2015 Keynote Live Blog – Day 2

29 October, 2015 (10:06) | Live Blog, PASS, Professional Development, SQL | By: Mark V

Good morning! It’s almost time for the Day 2 keynote!

 

07.59

Good morning!

08.06

About to get started!

08.07

Dr. Stephen Levitt taking the stage!

08.09

Dear Presenters: please note that Dr. Levitt is NOT reading to us. :)

08.11

About 1 in 10 children reported on tax forms were fictional. Ended up causing the loss of billion in revenue for IRS.

08.13

In 1987, when the SSN of children was required on tax forms for deductions, 7 million children vanished from the face of the Earth.

08.14

What reasons do people have to innovate? Necessity. Business Pain. Lost Revenue.

08.15

Simplicity returns to the discussion. SSN on tax forms is obvious. But it wasn’t there until 1987.

08.16

Dr. Levitt: “Most people in Business don’t have time to think.” #ouch #TrueStory

08.17

“I spend 500 hours per year thinking about new ideas. It’s a great year when i get one.” ROI requires the I(nvestment).

08.19

Dr. Levitt studied things like Prostitution and Drug Cartels, things other economists wouldn’t touch. #innovate

08.22

When you see a stranger that clearly knows YOU, GATHER DATA. Turn it into insight. You might get lucky and remember them. :)

08.24

Dr. Levitt hated math. He is a noted economist, professor, and author. Path from A to B may not be a straight line.

08.26

Dr. Levitt: Sometimes clarity only comes from having the courage to ask the right question.

08.28

Incentive can lead someone who doesn’t like math to become an economist. How bad to you want your goals?

08.31

Dr. Levitt’s Dad: “I have not talent; you have not talent. Take on topics no self-respecting person would tackle.”

08.32

Dr. Levitt: If nobody is willing to defend a group of people, perhaps there are too many misconceptions about that group.

08.33

“If you have the choice between walking drunk and driving drunk, driving is far safer, at least according to the data.”

08.37

Following the Grateful Dead for 6 months can be an excellent primer for Grad School in Sociology? Think outside the classroom.

08.43

Dr Levitt telling about a Sociologist who stumbles into a Street Gang and how it made is career. #Innovation #TackleToughTopics

08.45

If you write down the organizational chart of a street gang, and removed the names, it could look just like corporate America.

08.47

The economics of street gangs amazingly similar to that of the “legitimate” business world. #ThinkAboutIt

08.48

Dr. Levitt: According to the data, It was 7 times more dangerous to sell crack in Chicago than it was being in combat in Iraq.

08.50

If you showed gang members the data, how many would still choose that life?

08.51

Are drug gangs a new, up-tapped market for Business Analytics? #TongueInCheek

08.52

Dr. Levitt: Business People LOVE to buy books. Don’t know if they read them….

08.54

Dear Presenters: Note how Dr. Levitt is making eye contact with people ALL OVER THE ROOM. #ConnectWithYourAudience

08.58

Dr. Levitt: Asking questions is worthless if you don’t correlate it with data to see what answers are correct.

08.59

Misconceptions can cripple you. Let the data speak, even when it might be difficult. #TrueStory

09.01

Dr. Levitt: Experimentation with data is vital. That’s where insights come from.

09.02

“Do you want the TRUTH?” How often to we find ourselves wanting to ask this of our clients/customers?

09.03

Dr. Levitt: “We got fired and all of our projects were cancelled. It was the best day our consulting company ever had.”

09.04

“Why in the world would you work for a company that when you tell them the TRUTH, they don’t want to hear it??”

09.04

Awesome: Dr. Levitt has opened the floor to questions.

09.06

Q: What kind of research are you doing now?

09.07

A: We have a “Parent Academy” and are teaching parents about things they can do to help their kids succeed.

09.09

Dr. Levitt: 5-10% of people we survey about tough decisions are swayed by a toss of a coin and actually take that action.

09.11

Dr. Levitt: Everybody and their brother is telling me I should use R right now.

09.12

Q: What kind of newly available data sets are you REALLY excited about?

09.13

A: Business data is FAR more interesting than Government data right now. Much more fun to be in the data generation business.

09.15

Dr. Levitt: Connect the data together and let people play with it. Sounds like using Excel for analytics.

09.16

Dr. Levitt: In shortest supply in Business is people who know how to think about data. #THIS

09.17

Dr. Levitt: “It turns out I am much better at telling funny stories than solving big problems.” Sometimes the data’s story leads you to ROI.

09.23

Dr. Levitt: Economists and Prostitutes have this in common – the word “Can’t” is not part of our vocabulary.

09.25

Dr: Levitt: “If you know a Prostitute, you send her my way. I guarantee I can affect her bottom line.”

09.26

That wraps up the Live Blogging for the conference. Thanks for following. And thanks to PASS for inviting me to participate.

09.53

Attendees are filing into the Dell Grand Ballroom.

09.55

I have to apologize to my fellow live bloggers for being so handsome and witty. I can’t help it.

10.02

Attendees continue to file in. We should be getting started in a few minutes.

10.05

Here we go, yo.

10.05

“Business Intelligence and Business Analytics are at the forefront of business today.” #Truth

10.06

PASS President Thomas LaRock taking the stage.

10.07

Tom: We get paid to work with data every day. How awesome is that? #Truth

10.08

Regardless of your title, if you work with Data, you are the lifeblood of your organization.

10.09

Tom: @sqlpass has over 100,000 members! Awesome!

10.10

Tom: Find a way to get involved with @sqlpass somehow. There are so many ways to get involved.

10.11

Tom: Pick up networking buttons at the Community Zone. Minimum count of “pieces of flair” is 31.

10.11

Make sure you spend some time with the sponsors. They make events like this possible. Woohoo!

10.12

Tom: Give the sponsors a hug. #Embracing

10.13

Tom: Next year’s PASS BA Conference will be in Santa Clara, CA

10.14

John Wittaker of Dell taking the stage: Big Data, Predictive, & The Middle Market

10.15

John: Big Data projects are not just for the enterprise

10.16

John: Not only is Big Data happening, but it is being invested in at the appropriate level

10.16

John: When IT and Business COLLABORATE, we are much more likely to have a successful outcome. #NoBrainer

10.18

John: “Real Time” and Predictive Analytics are the most valuable Big Data tools, according to Dell’s survey

10.18

John: Big Data Challenges = Complexity, Volume, and Budget

10.19

John: Data Complexity, though, is the major challenge today.

10.21

John: You will see vendors like Dell and others abstracting that complexity to make things easier.

10.24

John: Dell’s goal is to offer an end to end Information Management solution to manage, integrate, and protect data

10.25

Microsoft’s Amir Netz and Kamal Hathi taking the stage. This is going to be awesome!

10.26

Kamal: It’s been an amazing year of innovation at Microsoft: Power BI, Power Query, Power Map, HDInsight, SQL 2014…

10.27

Amir: We have a new CEO, Satya Nadella. Satya introduced SQL 2014. A CEO has never introduced SQL like that before.

10.28

Kamal: While I like Satya for a lot of reasons… Satya has made Indian accents “cool” now. #WellPlayed

10.29

Kamal: 2 million+ #PowerPivot downloads. 100 thousand + #PowerQuery downloads since Feb 2014

10.29

Kamla: Let’s ditch this Power Point and get over to #PowerBI and look at data the way we want to.

10.30

Kamal: #PowerBI Tennants by country in Q and A: It is all over the world. Way cool

10.31

Kamal: In Iceland, #PowerBI is kind of hot. #MyKindOfHumor

10.32

Kamal: Q&A has been a huge driver for #PowerBI adoption

10.33

Kamal: Over 1 million questions asked in Q&A in April 2014. Wow. Way cool.

10.34

Kamal is using Q&A in #PowerBI to learn about usage of Q&A in #PowerBI.

10.35

Kamal is doing #PowerView style data exploration directly in Q&A: “We made this feature more discoverable” #Awesomesauce

10.36

Amir: Power BI In Action discussing the #PowerIB Demo Contest. Winner: Michael Carper, who is taking the stage now.

10.37

Amir is walking through Michael’s contest entry about realtionship between Tweets and #NBA Game results

10.39

Amir could make watching paint dry sound exciting. Love his style.

10.40

Kamal now showing data by browser usage by using by #PowerIB in #Chrome #HTML5

10.41

Kamal: We’re doing this demo on a Samsung Chromebook. #HTML5 #PowerBI will just work on any platform

10.42

Amir: Native IOS app for #PowerBI will be available this summer.

10.43

Kamal: We want you to be able to take the investments you have already made on prem and use them in the Cloud #NotAllOrNothing

10.44

Amir: When was the last time you saw AdventureWorks in a keynote demo???

10.45

Amir: Reporting Services will become a natively integrated component of #PowerBI this Summer #ssrs Great News!

10.45

Kamal: The data exists in YOUR environment, but we can still render it with #SSRS in the cloud.

10.46

Kamal: In premise is still hugely important. We are working on bringing more of #PowerIB to on prem.

10.47

Kamal: YOUR BI ON YOUR TERMS. That is our promise to you. #LoveIt #MSBI

10.48

Amir: Today, we are on the verge of a new age. DATA CULTURE: Give the power to EVERYONE #BIToTheMasses

10.49

Amir: Data Culture is when everyone in an organization can use data

10.49

Amir: Aloha to a demo on Hawaii

10.50

Amir: Hawaii collects information forms from travelers on what they did in Hawaii just so we can have a cool demo today.

10.51

You guys, Q&A is just friggin cool. #NuffSaid

10.53

Amir: Moloka’i, known for it Leper Colony, is not the top of the list on most visited Hawaiian Islands. #TheMoreYouKnow

10.54

Amir analyzing when people from various nations visit Hawaii in Q&A directly. Not in #PowerView. IN Q&A.

10.55

Amir: Hawaii is the Niagara Falls for the Japanese.

10.56

Amir: You want a great investment? Invest in Honeymoon Suites for the Japanese in Hawaii. #ActionableInsight

10.57

Amir introducing KPIs in #PowerBI #AweYeah

10.58

Amir created a cool dashboard in less than a minute just using natural language. NO CODE. #PowerBi

10.59

Amir: How can we make Predictive Analytics and Data Science so easy that anyone can use it?

10.59

Amir: Announcing FORECASTING in #PowerView! #PredictiveAnalytics

11.00

Amir: We have some of the best Data Scientists and Researchers at @Microsoft. We put them to work to make it easy.

11.01

Amir: Forecasting is available NOW in every Line Chart in #PowerView Just click and drag the line forward to forecast

11.03

Amir: You can even correct for one-time events by clicking and dragging in the chart.

11.04

Amir: You can even TEST your forecast against older data to compare with actual results. #IWorkInSuchAGreatIndustry

11.05

Amir and Kamal bring Julie (audience volunteer) on stage for live BI demo.

11.06

Amir: here we have a #PowerView create around shark attacks. What if the user has other questions NOT answered by the report?

11.08

You can now get the Field List for a report in #PowerBI. So, users can tweak an existing report for their needs

11.08

Treemap introduced for #PowerView

11.09

Julie is dragging fields from one chart to another to explore a report and change it on the fly. #BIToTheMasses

11.11

Kamal: It’s a good time to caveat, this is a pre-release item… #AsTheDemoHiccups

11.12

Wow. Drag items out of one chart into a blank are to create a NEW chart

11.12

Amir: Getting attacked by a shark while swimming is not a very good thing. #ActionableInsight

11.13

Amir: If you go into the Ocean, take a weapon with you. Shark attacks while spear fishing have higher survival rate.

11.14

Amir: This “Gender” field is about the victim, not the shark. Not time to check while getting attacked. #NotRealTime

11.14

Amir: Which shark likes the ladies the most? The Bull Shark. #Duh

11.15

This demo with shark data is not just a fish story. #TellingStoriesWithData

11.16

Amir just did the “bump and shake” to combine two charts in #PowerView. Wow. Way cool.

11.17

Amir: The data does not lie – If you put sharks in swimming pools, people will learn to swim much faster #Truth

11.17

Amir: These features aren’t just for BI Pros, they are for EVERYONE! #BIToTheMasses

11.18

Amir: We are starting a new journey and we are so excited you are coming along with us. #MeToo

11.18

HUGE thanks to Microsoft’s Amir Netz and Kamal Hathi on another awesome keynote. #ILoveMyJob

11.19

That wraps it up for this morning’s Keynote. Thanks for following. I hope you found it helpful.

10.02

Getting ready for the Day 2 Keynote. People are filing in.

10.07

Lights are dimming. Here we go.

10.08

Denise McInerney taking the stage to introduce David McCandless.

10.09

David’s in the house…

10.09

David’s key phrase: Information is Beautiful. I have to agree.

10.10

Let’s start with Billions. Billions of dollars or something else. What do Billions look like?

10.11

David showing a Treemap. Hey, I saw one of those yesterday! #PowerBI

10.11

Americans give over 0 Billion per year to charitable causes.

10.13

David showing Daily Bread: Infographic on how much we, as Americans, spend per day on programs like NASA, Housing, etc

10.14

David showing blocks falling into place representing various economic expenditures, etc: Debtris (Playing on Tetris)

10.14

David: I LOVE to play with data. Just like children learn through play, so can we if we play with out data. #Explore

10.16

David is showing a chart of Fears that look like mountains in our way. Nice touch.

10.17

Highlighting the Fear of violent video games. Spike in November. And a Spike in April (related to Columbine tragedy)

10.17

Columbine often associated in media with violent video games. #Garbage

10.20

Most common “Break Up” times according to Facebook status updates. Mondays are apparently a poplar day to break up. #TheMoreYouKnow

10.21

Data is the New Oil #GreatMetaphor David’s is better: Data is the New Soil

10.22

The best way to start really using your data? Start asking questions.

10.22

“Do horoscopes always say the same thing?”

10.24

David scraped most common words in horoscopes. Boiled down: Whatever the situation or secret moment, enjoy everything a lot.

10.25

I learned a LOT in this process, just by playing

10.26

US Military Budget is MUCH larger than everyone else. But does that mean we are way militaristic?

10.27

When you compare military budgets as a percentage of GDP, US is 6th. #GoingOneMoreLayerToFineMeaning

10.28

Context is SO important to get a clear, true picture of our data. “Let the data set change your mindset”

10.30

Visualization what a Million Lines of Code looks like. Large Hadron Collider has more than 50 million lines of code. Healthcare.gov… I can’t even count them.

10.32

Cool visualization: Our galaxy creates 7 new stars per year. Planets are the norm, rather than the rarity we thought they were.

10.32

Given all that, statistically speaking, there could be 46 communicating civilizations in our galaxy.

10.33

“Pimp your data”

10.34

Of all the work I have done in my career, there is one thing I am most famous for: a Helicopter game that was ripped off by Flappy Birds Ninja

10.36

Our brains are incredibly visual. Three out of four neurons in our brain are visual.

10.36

We process visual images far better than text.

10.38

David showing a visualization: Who’s Suing Whom in Telecoms? Crazy pattern. Begs question: Do decreasing profits lead to increase in lawsuits?

10.41

David showing most popular Internet Search Terms laid out in maps of the countries in which they were used. Brilliant.

10.42

Great Venn Diagram showing how Pigs, Birds, and Humans relate by Flu: Influ-Venn-Za #MyKindOfHumor

10.43

If Twitter were made up of 100 users, 20 would be Dead (Empty accounts), and 75% of the Tweets would come from 5 users (Loud Mouths).

10.46

Showing visualization of most commonly used PIN numbers (gathered from previous data breaches). You guys, please choose better ones.

10.47

Data Visualization lets you see the Invisible

10.48

Is there a relationship between the efficacy and the popularity of vitamin supplements? Not much.

10.49

87% of supplements have no research behind them that indicates they have value. #Marketing

10.49

Key aspect of Data Visualization: You can compress a massive amount of information into a small, meaningful space.

10.50

Data Visualization is SO important for Mobile where you have much less screen space to work with.

10.52

David: It used to take me three days to make that Billion dollar Treemap. Now it takes 3 milliseconds. #ProgressYo

10.53

Qualitative Data is also Invisible. But you can Visualize it to fix that.

10.55

David, when visualizing some political comparisons, I REALLY wanted my viewpoint to look better than the other, but I couldn’t do that. #Honesty

10.57

There are organizations that use data visualization to LIE. Learn more about Data Viz so you can see the signs of impropriety.

10.58

Data Visualization of views can better reveal the places where opposing viewpoints actually overlap.

10.59

In the Newspapers, there is often an anxiety over white space: They Fear it. As a result, the meaning of the data is lost in noise.

11.00

In Data Visualization, Bling can create a barrier to understanding. It is the Data that should POP, not the shiny.

11.01

In Data Visualization, you should use your scissors more than your paint brush. #LessIsMore

11.02

Key takeaway from David: PLAY. Play leads to insight and understanding.

11.07

David showing visualization: Who is more Popular: Han Solo or Luke Skywalker? David: Interesting, no mention of either prior to 1977…

11.08

David: There is so much data in the world; what else can you do but play with it? #Exactly

11.10

Go to http://www.informationisbeautiful.net/  for David’s visualizations and great insights and data.

11.11

David: I never design ANYTHING until the data is sorted and clean. #FollowThisExample

11.15

David has created a symbology of stars so that they are not just points of light, but lack the resources to build it. Kickstarter?

11.17

David: Data is not this empirical thing that is immune from bias. It takes work and effort to keep bias out.

11.19

David: In terms of color, sometimes you need to come up with a meaningful metric that will be served well by color.

11.20

That wraps up the Day 2 Keynote here at the PASS Business Analytics Conference. Thanks much for following. I hope you found it helpful.

10.06

The Show will be starting in about ten minutes.

10.11

It’s great to see so many attendees filing in taking pictures of the room and the crowd. #SQLPASS

10.17

Today’s Keynote speakers include high level Data Platform executives within Microsoft. #WhereAreWeGoing #SQLPASS

10.19

James Phillips is the head of Azure/BI. This includes owning the direction of #PowerBI #sqlpass

10.20

Joseph Sirosh heads up the Information Management and Machine Learning group. #sqlpass

10.20

Ranga Rengarajan leads the Database and Big Data engineering business. #sqlpass

10.21

I love that Microsoft sees the value in #sqlpass and takes it seriously. #WeArePass

10.22

Today’s Theme: Evolving Microsoft’s Data Platform – The Journey to Cloud and Continues #sqlpass

10.23

PASS President Thomas LaRock on the stage. #HiTom #sqlpass

10.24

Round of applause for the makers of the “Best Data Platform on the planet” #DigIt #sqlpass

10.25

I want to thank the PASS Board Members for the hard work they put in to make PASS awesome. #sqlpass

10.25

PASS Board Q&A on Friday at 1 pm in Room 307-308 #sqlpass

10.26

First PASS Summit in Chicago in 1999 with 1200 attendees. #sqlpass

10.27

Today, PASS summit has 5899 attendees! #sqlpass

10.28

Tom: Community = Opportunities #sqlpass I am living proof of that. PASS has been HUGE for my career.

10.30

Tom: I challenge you to get involved. #sqlpass #DOTHIS Networking at Summit is AMAZING

10.31

The SQL Clinic is a spectacular place to get help with the products. #sqlpass

10.32

New This Year: Abstract workshops with speakers and Program Committee. #sqlpass

10.32

I will be at a Business Intelligence focused table at the Birds of a Feather lunch tomorrow. #sqlpass

10.33

PLEASE make sure to visit the Exhibit Hall to give the partners/sponsors a big THANK YOU! #sqlpass

10.34

Tom: Give vendors/sponsors a hug. #ChuckHuggers cc/ @sqlboywonder #sqlpass

10.36

Tom: PASS has been the cornerstone of my career since 2004. #sqlpass

10.40

Ranga taking the stage. #sqlpass

10.41

Ranga: We’re the only company that has this hyper scale cloud and the Enterprise presence to do magic. #sqlpass

10.42

Ranga: I love maps. I became a member of AAA when I found out they gave me free maps. #sqlpass

10.43

From maps to MapQuest…. #GrowUpStory #sqlpass

10.44

Ranga: Our success at Microsoft in the data world is because of YOU. #sqlpass

10.44

Ranga: EVERY YEAR, there is 41% more data than there was the year before. #sqlpass

10.45

Ranga: Data is the thing that is going to light up future productivity. #TRUTH #sqlpass

10.46

Ranga: “Data Culture” happens when people get the data they need and want when they need it. #sqlpass

10.47

Ranga: The Microsoft data platform enables that progress toward Data Culture. #sqlpass

10.47

Ranga: I am going to focus on the Capture and Manage parts of the data story. #sqlpass

10.48

Ranga: Microsoft is a data platform that doesn’t require you to make compromises. Culture of AND. #sqlpass

10.49

Ranga: Do more; achieve more. #sqlpass

10.50

Ranga: Capture diverse data; Achieve elastic data; Maximize performance & availability; simplify the cloud. #sqlpass

10.51

Azure DocumentDB: NoSQL DB service in the cloud, schema-free, ranging from ACID to eventual consistency. #sqlpass

10.52

Ranga: every application that is made expects a Search window. #Yup #sqlpass #DudeWheresMyData

10.53

Ranga: We think combining On-Premise and Cloud is necessary for the whole data story. #BestOfBothWorlds #sqlpass

10.54

Ranga: Scale Up = on prem SQL Server 2014 AND VMs in Azure. Scale Out = Azure SQL Database. #sqlpass

10.54

Ranga: Use the best tool for the job. #sqlpass

10.55

Tracy Daugherty of Pier1 Imports taking the stage. #sqlpass

10.56

Tracy: One thing we have a LOT of right now: orange pumpkins. #NoDoubt #sqlpass

10.56

Tracy: Azure Search lets us enable “fuzzy” search matching with great ease. #MakeItSimple #sqlpass

10.57

Tracy: Azure Search allows for a Scoring Profile so you can control how results are returned. #sqlpass

10.57

Ranga: Scoring Profile lets you weight the relevance of Search results. #sqlpass

10.58

Azure Search lets you squash the amount of code you need to find pumpkins…. #CouldNotResist #sqlpass

10.59

Tracy: JSON for the win. #sqlpass

11.00

JSON (Java Script Object Notation) is a very popular format for sharing data across platforms. #sqlpass

11.01

Watch me use #PowerQuery on Friday to consume JSON with ZERO CODE with a few clicks. #sqlpass

11.03

Tracy showing how they use Sharding in Azure SQL Database to scale workload easily. #sqlpass

11.05

Tracy is configuring Geo Replication for the main Pier 1 database easily in the Azure Management Portal. #sqlpass

11.06

Geo Replication: Where in the world is my database? There. AND There. AND There. #sqlpass #CultureOfAND

11.07

Ranga: Azure SQL Database has a 99.99% SLA. No one else has that. #sqlpass

11.08

Ranga: When we engineers at Microsoft run a million databases EVERY DAY, we learn things very quickly. #sqlpass

11.08

Ranga: lessons from the cloud enhance the On-Premise products. #CloudFirstFTW #sqlpass

11.09

Ranga: Use the right tool. Sometimes that is cloud. Sometimes on prem. We want that to be seemless. #sqlpass

11.10

Ranga: Take the data from wherever you find it, put it in the RIGHT engine and leave it in the cloud. #sqlpass

11.11

Ranga: Stackoverflow is a key customer. They have broken through limits on SQL Server using clever techniques. #sqlpass

11.12

Ranga: Stackoverflow takes advantage of In-Memory technology and uses it well. #sqlpass

11.13

Ranga: Samsung has seen 24x performance boost using SQL Server In-Memory technology. #sqlpass

11.15

Great to see Microsoft really embracing the idea that Relational is not everything. #PickTheRightEngine #sqlpass

11.15

Ranga: over 1.2 million downloads of #SQLServer 2014 #sqlpass

11.16

Ranga: Announcing a major update to Azure SQL Database. Will be in Preview by end of 2014. #sqlpass

11.17

Ranga: new features include leap in TSQL compatibility, parallel queries, Extended Events, In-Memory ColumnStore #sqlpass

11.19

Ranga: Introducing Mike Zwilling to show some cool stuff around Pier 1 Imports. #DatabaseEngineGoodness #sqlpass

11.19

Mike: People want real-time analytic queries on transcriptional data. #IWantItNow #sqlpass

11.20

Mike: I need your help to generate some load: go to http://aka.ms/gopass to help this demo out. #sqlpass

11.21

Mike: you are generating load on a beck-end SQL Server running In-Memory OLTP. #sqlpass

11.22

Mike showing LIVE analytics on top of transnational database we are hitting. Really cool. #sqlpass

11.23

Mike: we have a combination of the In-Memory engine AND a non-clustered ColumnStore index on the SAME table. #sqlpass

11.25

Mike: that ability to STRETCH a table to reach from On-Premise to Azure. The SAME table. #sqlpass

11.26

While the table is being stretched, you can still query it. #sqlpass

11.27

Looks like Ranga bought a “Hug Chuck” T shirt. #ChuckHuggers /cc @SQLBoyWonder #sqlpass

11.28

Mike: When you stretch a table, the bulk of the work happens with resources in Azure, not On-Premise. #sqlpass

11.29

Mike: we lost the on-premise server. I need to restore JUST THE LOCAL portion of the database. #sqlpass

11.29

In a few seconds, the on prem was restored and synchronized from Azure and we are back up and running. #sqlpass

11.30

Ranga: With this technology, you get the benefit of the Hyper Scale cloud in an invisible way. #sqlpass

11.30

Joseph Sirosh taking the stage to talk about Machine Learning, etc. #sqlpass

11.31

Joseph calling on the crowd to do the wave. #ContinuousIntegration #sqlpass

11.32

…and people actually did it. #sqlpass

11.33

Joseph: You want to understand the past, analyze the present, and predict what’s next. #sqlpass

11.34

Joseph: Azure Data Factory is in-Cloud data movement for moving data around. #sqlpass

11.35

Joseph: ANNOUNCING Free Azure Machine Learning at azure.com/ml #sqlpass

11.36

Joseph: We are democratizing data and capabilities. #BIToTheMasses #sqlpass

11.36

Sanjay Soni taking the stage to lead a demo around Pier 1. #sqlpass

11.37

Do we see a Pier 1 Import/Output Wizard in the future? #Joking #sqlpass

11.37

Sanjay showing In-Store Analytics using Kinect as a source…. #sqlpass

11.39

Sanjay showing heat map in #PowerMap visualization the customer movement in the store. #sqlpass

11.39

Sanjay showing how they used Azure Data Factory. “Think of SSIS to the power of X in the cloud.” #sqlpass

11.40

Joseph: You’re seeing a browser-based authoring environment. #sqlpass

11.41

Joseph: The speed at which you can get Data to work for you using this tool is amazing. #sqlpass

11.41

Joseph: all this through a browser and JSON documents. #sqlpass

11.42

Joseph: The data is flowing into Azure via Kinect sensors, ADF, and Azure Streaming Analytics. #sqlpass

11.43

Sanjay showing real-time (seconds) data visualizations about what is happening in the store RIGHT NOW. #NoPieCharts #sqlpass

11.44

Sanjay: How many lines of code to make this happen? FOURTEEN. #sqlpass

11.44

Sanjay: Azure Machine Learning is my new favorite product. AWESOME! #sqlpass

11.46

Sanjay now showing a Pier 1 app on his phone. #sqlpass

11.47

It’s not an iPhone. #JustSaying #sqlpass

11.47

Pier 1 was able to send Sanjay recommendations to his phone, with speech. #sqlpass

11.48

Sankay using speech recognition to find what he asked for and display it on the in-store map. #cool #WhereDoYouWantToGoToday #sqlpass

11.49

Since he searched for glasses, the app determined he might also be interested in other table ware. #sqlpass

11.50

Joseph: We are trying to make the BEST platform to analytics across On-Premise and Cloud. #sqlpass

11.50

James Phillips taking the stage. #PowerBI #ILoveIt #sqlpass

11.51

James: We want to bring insights to more people – faster #sqlpass

11.51

ANYONE that makes decisions can make better ones with better information. Not just for the C-Suite anymore. #sqlpass

11.52

James: Simplify data discovery. #PowerQuery #PowerPivot #sqlpass

11.53

#PowerQuery has had over 320,000 downloads since February of 2014. #sqlpass

11.54

James: Do more; achieve more: Simplify data discovery; deliver faster insight; connect to on-premise; enable data culture. #sqlpass

11.55

James: ANNOUNCING: Interactive Query – from Power BI, connect back to on-premise SSAS while keeping the data on prem. #sqlpass

11.55

James: Data sitting at rest has potential. We want to unlock that. #DataDividends #sqlpass

11.56

James: LIVE OPERATIONAL DASHBOARD #sqlpass

11.57

This is a NEW Power BI, not the same one we know and love right now. #sqlpass

11.57

The current one is NOT going away. We are just getting a new story to go along with it. #PowerBI #sqlpass

11.59

James is not using Q & A to create new visualizations based on corporate data and “pinning” them to his dashboard. #sqlpass

12.00

YOU get a dashboard. And YOU get a dashboard. And YOU get a dashboard… #Oprah #sqlpass #PowerBI

12.01

James: I don’t like Pie charts so I am going to make this a tree map, instead. #Winning #DataViz #sqlpass

12.01

James just signed into One-Drive and is connecting to an Excel Spreadsheet FROM POWER BI IN THE CLOUD #sqlpass

12.02

James combining charts by dragging one chart onto another. #Boom #sqlpass

12.03

James: This new #PowerBI is in private preview and will be hitting public preview soon. PowerBI.com #sqlpass

12.04

Ranga: Try Azure Machine Learning to day for a free trial with a Live ID. #NotTotallyFreeIfItIsJustATrial #sqlpass

12.04

Ranga: Be the hero of your data-driven business. #sqlpass

12.06

That wraps up the PASS Summit 2014 Keynote day 1. Thanks for following along. See you tomorrow morning! #sqlpass

10.14

I love the smell of #SQLServer in the morning. Smells like Awesome.

10.16

Adam Jorgensen taking the stage. #HiAdam #sqlpass

10.18

Adam: PASS Summit generates .9 Million in revenue. The PASS BA Conference generates .3 Million. #sqlpass

10.21

Adam: Starting in Fiscal 2015, we will budget budget summaries. #sqlpass

10.24

Sorry for the silence. Having connectivity issues… #SadPanda #sqlpass

10.25

Grant Fritchey joining the board on January 1. #ScaryBoardMember #sqlpass

10.25

PASS TV makes Summit a global experience. #sqlpass

10.26

Denise: PASS is a great enabler for personal growth. #Truth #sqlpass

10.28

PASSion Award Winner: Andrey Korshikov! #sqlpass

10.29

Andrey is a PASS Regional Mentor and organizer of several Russian language PASS Events. Awesome! #sqlpass

10.32

PASS Business Analytics Conference 2015 in Santa Clara, CA April 20-22 #sqlpass

10.33

Denise: Make sure to update your member profile on sqlpass.org to find out opportunities to volunteer. #sqlpass

10.34

Make sure to bring your attendee badge to get into the Community Appreciation Party tonight. #sqlpass

10.34

PASS Summit back here in Seattle October 27-30 2015. #sqlpass

10.36

Rimma Nehme, Principal Engineer at Microsoft Jim Gray System Lab, taking the stage. #sqlpass

10.36

Cloud Databases 101: Cloudy with a chance of more clouds, all with data. #ThingsAreLookingUp #sqlpass

10.38

Rimma: Trying to be a man is a waste of a woman. #Awesome #sqlpass #WIT

10.39

Rimma: I know a little bit about databases. #Understatement #sqlpass

10.39

Rimma: I’m a HUGE fan of the PASS community! #LoveIt #sqlpass

10.41

Rimma: Why cloud computing? #sqlpass

10.41

Rimma: With cloud technology being relatively new, it creates “Shiny Object Syndrome” #sqlpass

10.42

Rimma: Cloud = Service. On demand, anywhere, anytime. #sqlpass

10.43

Rimma: Blame networking people for the name Cloud Computing. #sqlpass

10.44

Rimma: Cloud Computing = On demand self-service. #DoItYourSelfYo #sqlpass

10.45

Rimma: One person and a credit can tap into the largest computing resource pool in the world. #sqlpass

10.45

Hm. I wonder what my Data Credit Score is…. #sqlpass

10.46

Rimma: Cloud computing reduces dev time and effort as you don’t need to spin up your own infrastructure. #sqlass

10.47

First wave of Massive Computing started in the 1960s with Super-Computers and Mainframes. #sqlpass

10.49

Rimma: The future of the Data Center is shipping containers full of servers. #ModularDataHomes #sqlpass

10.51

Rimma: Resources are NOT infinite. Optimizing for energy efficiency is leadership. #sqlpass

10.54

Take advantage of Evaporative Cooling. #DataScience? #sqlpass

10.56

Rimma: So that is Why Cloud. Now, what is Cloud DB? Take Earthed DB and add Service. Voila! #sqlpass

10.59

Rimma: Pizza as a service. On prem: you do it all. #sqlpass

10.59

Rimma: The other extreme is Cloud: Dining Out. The vendor manages everything. #sqlpass

11.00

Showing Pizza as a Service with no Pie Charts! Woohoo! #sqlpass

11.04

Dr. Nehme giving so much awesome information, I am having trouble keeping up. #GoodProblemToHave #sqlpass

11.05

Dr. Nehme: Maybe you will invite me back for another Keynote. #YesPlease #sqlpass

11.07

Dr. Nehme: starting up the bathroom analogy for virtualization. #sqlpass Hard to share efficiently.

11.07

Dr. Nehme: With virtualization, you lose direct access to computing resources. #sqlpass

11.08

Dr. Nehme: Virtualization is wonderful, but you have to keep in mind the trade-offs. #OftenWorthIt #sqlpass

11.09

Dr. Nehme: Server consolidation can lead to great energy savings as well. #sqlpass

11.11

High Availability with Pizza: If your delivery person gets lost, you still get the pizza from another. #sqlpass

11.13

Dr. Nehme: If application independence is VERY important to you, avoid the share schema approach of Multi-Tenancy. #sqlpass

11.14

Dr. Nehme is making the complex simple through great analogies. Fantastic job and a great example to follow. #sqlpass

11.15

Dear presenters: Please not that Dr. Nehme has not read to us. Not even once. :) #sqlpass

11.16

Dr. Nehme: a quick peek at the Azure SQL DB architecture. (I will try to keep up). #sqlpass

11.17

Dr. Nehme: Designed with High Availability in mind. #sqlpass

11.18

Azure SQL DB includes layers of abstraction to that you don’t need to deal with it. #DatabasesToTheMasses #sqlpass

11.20

Dr. Nehme: SQL Node architecture – The log files are shared across multiple databases. #SomeSharing #sqlpass

11.21

Dr. Nehme: The SQL Azure Gateway Service manages the traffic to make Azure SQL DB work. #sqlpass

11.22

Dr. Nehme: Do we still need a DBA in the Cloud Era? YES. ABSOLUTELY. #StretchToCloud #sqlpass

11.23

With Cloud Era, the on-premise story does NOT go away. There will be lots of hyrbid solutions REQUIRING on-prem. #sqlpass

11.23

Dr. Nehme: DBAs should add Cloud expertise and start calling themselves a Cloud DBA. #sqlpass

11.25

Dr. Nehme: You DBAs will become the Cloud DBAs. Embrace it! #sqlpass

11.26

Dr. DeWitt joining Dr. Nehme on the stage. “He has been a great mentor.” #NoDoubtAboutIt #sqlpass

11.26

Thank you, Dr. Nehme. That was fantastic. #sqlpass

11.27

Dr. Nehme received a well-deserved standing ovation. #sqlpass

11.28

Dr. Nehma: All you guys in kilts, please come take a picture with me in front of the stage. That is really cool. #sqlpass #SQLKilt

11.29

That wraps up the keynotes for Pass Summit 2014. Thanks so much for following. #sqlpass

10.14

It’s so fun to watch everyone file into the room for the keynotes.

10.20

Showtime.

10.22

PASS President Thomas LaRock taking the stage.

10.23

Official Announcement: #SQLHugs are a thing.

10.23

Folks from 58 countries present at Summit.

10.26

PASS Board Q&A at 3:30pm. Come ask questions and get answers.

10.26

Big welcome to the first time Summit attendees! Get ready for an awesome ride.

10.28

Tom: Data Professional are the true life force for companies around the globe. #ItsAllAboutTheData

10.29

For me, PASS has been a HUGE factor and my taking my career to where it is today. Thank you!

10.30

Stop by the Community Zone on the 4D Skybridge! Great place to Connect Share and Learn.

10.31

Hurray for Speaker Idol! Growing new speakers is AWESOME!

10.33

Super huge thanks to sponsors who help PASS have such a tremendous impact for us.

10.35

Thanks for your service as PASS President, Tom!

10.35

Microsoft Corporate VP Joseph Sirosh about to take the stage!

10.38

Sirosh: The ability to understanding data is transforming our daily lives.

10.39

Sirosh: Once data got an IP Address, we got abilities to connect everything.

10.40

Sirosh: In the Age of Software, the goal was to digitize everything. A computer on every desktop.

10.41

Sirosh: In the Age of Data, data and the analysis of data is driving us forward.

10.42

Dartmouth-Hitchcock used Microsoft technologies to create a new health care platform called ImagineCare

10.43

ImagineCare: The Internet of People Things – personalized care using devices and cloud-based monitoring

10.44

Sirosh: In the new world, Data will predict everything.

10.45

Sirosh: Today’s hospitals are optimized for treating things that already happened instead of preventing them from happening.

10.46

Sirosh: It used to cost 0 million to sequence one person’s genome. Now it costs less than 00.

10.47

The future of HealthCare: Instead of the treatment that works for others, you get the treatment that will work for YOU.

10.48

Sirosh: A lot of genomic analysis is done in R

10.50

Sirosh: DocuSign has 50 million users today. Someone signs electronically with DocuSign every .4 seconds!

10.50

DocuSign Chief Architect Eric Fleischman taking the stage

10.51

DocuSign uses #SQLServer for their OLTP systems. #YouShouldToo

10.52

Fleischman: We bet BIG on Always On #sqlserver

10.53

Fleischman: We’re not database people. We don’t want to write a database engine. I want to USE one. #sqlserver

10.54

Fleischman: We made a major investment into the telemetry inside the system. We have systems for tracking the systems.

10.55

Fleischman: Always Encrypted is a big deal for us. We’re in the Trust business.

10.56

Sirosh: High-performance OLTP has been vital for a long time. The importance of USING that data effectively is on the rise.

10.57

Stop just STORING your data. Start USING it.

10.58

Sirosh: We have our feet on the ground and our head in the cloud

10.59

Sirosh: When we have that and a community like PASS, you help us become #1

11.02

Shawn Bice Micrrosoft GM for Database Systems Group taking the stage

11.03

Bice: In this era, companies who embrace data will be far more competitive than those who don’t

11.04

Bice: SQL Server 2016 is backbone of Azure. Billions of queries hit that every single day

11.05

Bice: Everything I am going to show you on SQL Server 2016 today is BUILT IN

11.06

Bice: SQL Server is mission critical ready – It is backbone for train transportation in an entire country

11.08

Bice: R is the #1 choice for data scientists and statisticians in the world. Welcome to SQL Server!

11.09

You want cloud? Choose Microsoft. You want on-prem? Choose Microsoft. You want to straddle both? Choose Microsoft.

11.11

Bice: Do you realize you can enroll an Azure VM in an on-premises availability group in about 5 minutes?

11.12

Bice: We had a data center ACTUALLY LIGHT ON FIRE. We failed over all our customers there in 5 hours.

11.13

Bice: Polybase is baked right into SQL Server 2016 #TheNeedsOfTheMany

11.14

Bice: Auto insurers tying telemetry data to customers for rate calculation using SQL Server

11.15

Bice: Real-time is not just throughput. It’s the ability to learn and adjust as tings are happening.

11.15

Sometimes, you need to learn NOW, not just AFTER ETL ran…

11.16

Bice: Real-Time Operational Analytics ftw!

11.17

Operational Analytics with R in SQL Server: Learn from your data where it lives

11.18

Rohan Jumar, Microsoft Partner Director in Engineer is joinig Shawn Bice on stage

11.19

Jumar showing map of PCubed showing lighted dots based on financial transactions everywhere in the world.

11.20

Bice to Jumar: With that kind of scale, how do you even begin???

11.22

Jumar showing the realtime dashboard used by PCubed to track their system. #NoPies

11.23

Jumar: With SQL Server 2016, you can achieve the realtime analytic without impacting our OLTP queries

11.29

Jumar showing an R script directly into a T-SQL stored procedure while the data never leaves the safety of SQL Server

11.30

Typos…. Kumar, not Jumar… sorry.

11.31

Bice: We have invested more on security in SQL Server 2016 than ever before

11.33

Bice: There is a big hole in the data world – open access to the buffer pool. Always Encrypted fixes that for SQL Server

11.33

Bice: With Always Encrypted, the work happens on the client side, not in the engine

11.34

Rohan Kumar coming back on the stage

11.38

Kumar: Always Encrypted allows encryption at rest AND in transit.

11.39

Dear Man-in-the-Middle Attackers, SUCK IT. Sincerely, SQL Server 2016 Always Encrypted

11.41

Bice: This is a new SQL Server. We’ll take the most complex things and simplify them for you.

11.42

Bice: Stretch DB allows “stretching” tables into Azure for CHEAP storage while keeping data queryable!

11.44

Bice: Stretch Database and Always Encrypted work awesome together

11.44

Do you want speed or security? With SQL Server 2016 you get BOTH

11.47

Kumar: We worked to make Stretch Database easily usable by DBAs who have not done much in Azure

11.49

Kumar showing a query from two tables, one Stretched, one not.

11.50

Kumar: We’ve built Stretch on the distributed query infrastructure we have had with SQL Server

11.52

Joseph Sirosh taking the stage again.

11.52

Sirosh: Building great projects is a journey. SQL Server 2016 took twenty years of work

11.54

Sirosh: We believe in dog-fooding all of these. We are using this ourselves

11.55

Sirosh: We don’t believe in nickle-and-diming customers for every new feature

11.56

Sirosh: We are creating better and new human experience – WITH DATA

11.57

Sirosh: This is the age of the data professional. It is our time.

11.57

That wraps up this keynote. Thanks for following along. These are great times we live in, friends.

10.10

Folks are filing into the hall. There is quite a bit of excitement in this room.

10.21

Here we go, yo.

10.22

Adam Jorgensen taking the stage.

10.24

All PASS financial information is available at www.sqlpass.org/governance

10.25

Summit attendees have doubled since 2007! I have certainly gained weight…

10.26

In 2008, there were 5 SQL Saturdays… in the US. In fiscal 2015, there were 99 globally….

10.27

PASS has over 150,000 members worldwide from 163 countries. This covers 86% of the countries in the world.

10.29

Total fiscal year 2015 spend was a bit over million. 78% of those dollars went directly back into the community

10.30

Starting this fiscal year 2016, PASS will be publishing portfolio budget summaries for better transparency

10.32

SQL Rally resources are being routed to SQL Saturday

10.32

Also this year, a goal is to do a redesign of sqlpass.org

10.33

Denise McInerney taking the stage

10.36

Great recognition for Amy Lewis and Bill Graziano for their contributions to PASS on the board.

10.37

Volunteers work so hard to make PASS what it is. THANK YOU!

10.37

Passion Award goes to Lance Harra!

10.39

Wow. Lance has done so much that I can’t keep up. Way to go, sir!

10.40

There are 3000 people tuning in LIVE on PASSTV from 95 countries right now. HI!

10.42

Since 2009 12 24 Hours of PASS events have been delivered in Spanish, Portuguese, or Russian. Awesome!

10.43

PASS Summit 2016 will be October 25-28 here in Seattle!

10.45

Welcome to Dr. David DeWitt and Dr. Rimma Nehme! If you want to learn about presenting, watch them. They rock!

10.45

Dr. Nehme (Nehme) taking the stage!

10.46

Nehme: I will be the appetizer, David will be the entree, then I will be the dessert.

10.47

Nehme: We thought the Internet of Things (Thingernet) would be a great topic.

10.47

Nehme: Why should you, as data professionals, care about this technology?

10.48

Nehme: What is IOT? A collection of connected devices that work together to do something useful.

10.48

No pizza this year.

10.50

Nehme: Two types of IOT: Consumer (wearables, etc), Industrial IOT (machines etc)

10.50

Nehme: Consumer IOT examples, Fitbit, Nest, etc

10.51

Nehme: Industrial IOT…. Can we build more intelligent roads? Hospitals?

10.52

Nehme: Significant value will be realized from the Industrial IOT

10.53

Nehme: Four Types of IOT Capabilities: Monitoring, Control, Optimization, Autonomy

10.53

Nehme: We are somewhere between monitoring and control right now. I call it the Terrible Twos of IOT

10.54

Nehme: In 2003 we have about 500 million devices connected to the Internet. In 2010, we had 12.5 billion.

10.55

Nehme: Somewhere in 2008, the number of Internet connected devices exceeded the population of the Earth

10.56

DeWitt taking the stage to talk about the HOW if IOT…

10.57

DeWitt: Lots of challenges to IOT. Huge variety of sensors. Lots of devices. Dirty sensor readings. Data volume/scale

10.58

DeWitt: Device security is a huge challenge as well. Challenges also with cloud to device messaging

10.58

DeWitt: the last major challenge is deployment. When you have billions of “things” how do you manage that?

10.59

I say it every year. But notice that neither Dr. Nehme nor Dr. DeWitt have READ to us…

11.00

DeWitt: Even the cutting edge IOT is still rather primitive

11.01

DeWitt: Pretty much every IOT device has a sensor. Most of them also have an actuator to perform an action

11.02

DeWitt: Once the data gets to the Cloud, you have a lot of options for what you can do with it

11.03

DeWitt: Occasionally, a command will be sent from the Cloud back to the device: Cloud to Device Command

11.03

DeWitt: IOT Hubs are cloud-based services for interacting with the “things”

11.04

DeWitt: Real-time streaming systems, like Azure Stream Analytics, operating on a finite window of time

11.05

DeWitt: They only PROCESS data. They don’t have time to store it.

11.06

DeWitt: The Azure IOT hub provides device authentication since security is so critical

11.06

There is not way I can keep up with either Dr. Nehme or Dr. DeWitt. But trying is really fun

11.08

DeWitt: If you want to store the IOT data, you need a consumer that will take it out of the hub to store it

11.10

DeWitt: You have a number of options for storage, but SQL DW is the best one. #WinkWink

11.10

DeWitt: Azure Machine Learning is a great solution for “predicting when the boiler will explode” #NoPressure

11.12

DeWitt: So what IS a real-time query engine? In my mind, it is a streaming database system

11.12

DeWitt: You have queries that operate over events across time windows.

11.13

Now I have “Islands in the Stream” in my head. Thanks, Doc.

11.14

DeWitt: The stream can send the ID values of boilers about to explode to a system to open the release valve

11.15

DeWitt: Raspberry Pi is not running SQL Server.. yet. That’s NOT a product announcement…

11.16

If you visualize an array of Raspberry Pi devices, that is a Pi Chart. #JustSaying

11.17

DeWitt: Right now Azure IOT is pretty limited. Currently, metadata is not stored in a DBMS. So, no query support

11.18

DeWitt: Devices must poll in order to keep checking for commands.

11.18

DeWitt: IOT events are PUSHED up into the cloud.

11.19

DeWitt: issues with pushing only: bandwidth, connectivity, latency, data deluge, storage

11.20

DeWitt: In our opinion, pushing everything to the cloud is a huge waste of resources

11.21

DeWitt: Have a streaming query engine near the device to aggregate and send results to the cloud instead of each event

11.22

DeWitt: This reduces what we push into the cloud, and allows for dealing only with IMPORTANT events

11.22

Dr. Nehme taking the stage again.

11.23

Nehme: Fog Computer aka Edge Computing. This is not Cloud VERSUS Fog. It is Cloud + Fog

11.24

Nemhe: We are taught that you never move the data to the computation. You move the computation to the data.

11.24

Nemhe: The Cloud is basically this big gorilla… #TheOneAndOnlyIvan

11.25

Nehme: IOT is not just a Networking problem. It is also a database problem.

11.25

Nemhe: Polybase for IOT. This is NOT a product announcement… but if you make enough noise…

11.26

Nehme: Today you have to specify everything you want to do about IOT

11.27

Nehme: How about IOT-SQL? Why not query Devices like we query Tables? #Dude

11.28

Nehme: Regular attributes can be inserted, deleted, etc. Extended Attributes are set by the device alone

11.29

Nemhe: Scalable metadata management with a Shell Database. Essentially, metadata only.

11.31

Nehme: Where could the Shell be stored? Anywhere, really. DocDB, HDInsight, Azure SQL DB… It’s just a database.

11.34

Nehme: Make sure only meaningful, important, information is sent up to the cloud.

11.35

Nehme: Larger computations happen in the Fog near the device instead of sending it all to the Cloud

11.36

Nehme: Why should as Data Professionals care? You either part of the steamroller, or part of the road.

11.37

Nemhe: The amount of data to manage is increasing exponentially. So, what does success look like?

11.37

Nehme: This is our last PASS Keynote. #Noooooooooooooooooooooooooooooooooooooooo

11.38

HUGE THANK YOU to Dr. Dewitt and Dr. Nehme for so many AWESOME keynotes. We will miss you!

11.39

DeWitt: It is time to give up on the full time gig and start collecting Social Security. #YouHaveEarnedIt

11.41

HUGE Standing Ovation for Dr. DeWitt and Dr. Nehme.

11.41

That wraps up the Day 2 Keynote. Thanks for following along.

13.55

Huge thanks to SQL Sentry for sponsoring!

13.57

This year’s special guest is Angie Chang of Hackbright Academy, an engineering school for women.

13.59

Angie will sit down with Denise McInerney, PASS VP of Marketing.

14.00

I love looking around the room at the Women in Technology Luncheon and seeing so many men in attendance.

14.18

Denise McInerney taking the stage. Here we go.

14.18

Angie Chang joining Denise on stage.

14.19

Chang has a BA in English and is in Technology. Me too. Liberal Arts = Learning How to Learn

14.21

Chang has long been involved in helping women network and improve themselves

14.21

Chang: Hackbright has graduated over 300 women at this point.

14.22

Chang: Hackbright started by folks who attended a coding bootcamp in San Francisco.

14.23

Hackbright: We’ll teach you how to code in ten weeks.

14.24

Chang: we are teaching python as a full stack framework. We also do Angular and teach women how to mentor each other

14.24

Chang: Each student gets three mentors to help with code reviews, etc

14.25

Chang: People choose Hackbright because of the Community. #CommunityMatters

14.26

Chang: Hackbright students and alumna have come from so many various backgrounds.

14.27

McInerney: I know you have a high rate of job placement from Hackbright. Can you share success stories?

14.28

Chang: We have several women who have gone onto senior software engineering positions and engineering managers

14.28

Chang: Survey Monkey has, I think, hired more Hackbright alums than any other company

14.29

McInerney: How are companies supporting Hackbright Academy?

14.29

Chang: We invite partners companies to a career day to come and meet all our graduating students.

14.30

Chang: Several companies also offer scholarships for Hackbright students

14.31

Chang: For the first GirlGeek dinner I hosted in the Bay Area, we have 400 people sign up in 5 days. #Winning

14.32

Chang: Often, people get hired based on networking, etc, at Girl Geek dinners.

14.33

Chang: Train your managers so that women who are already IN tech have a good experience

14.34

Chang: There are so many roles that women of ANY age can fill. It’s a shame we only focus on the youngest

14.35

Chang: Making sure women can start having a better experience in Tech is going to help with retention of women in in Tech.

14.36

Chang: We encourage our students to BE THE CHANGE THEY WANT TO SEE #GoodAdviceForAllOfUs

14.38

McInerney: What advice to you have for parents that want to make a difference in this area?

14.39

Chang: Don’t just enroll your boys in tech camps, etc. Enroll your girls, too. #ProudToSayIDoThat

14.39

Chang: Encourage your girls to be brave instead of afraid they are going to break things. #ItsOKToFail

14.40

McInerney: How can people help support Hackbright Academy?

14.41

We are opening up to questions. People online can ask via hashtag #passwit

14.42

McInerney: What’s your perspective on how schools need to change?

14.42

Chang: One example is a project called Technovation that helps girls write Android apps and pitch them

14.44

Chang: I was really lucky to have a computer programming class in high school. We need more of that.

14.44

McInerney: There is a documentary on Technovation coming to YouTube next week called Code Girl

14.45

Chang: We have never had a student directly out of high school. We’re wondering why that would be.

14.46

Chang: At Hackbright, we have lots of hackathons and they have been women of all ages.

14.47

Twitter Question: Are there plans for paths other than software engineering at Hackbright?

14.48

Chang: Currently, we are trying to fill the gap in software engineering. These are good-paying jobs, etc.

14.48

Question: Have you seen blowback form that fact that Hackbright is not a four-year degree?

14.49

Chang: It’s kind of silly that so many positions require a four-year degree. It is just not that important these days.

14.50

Chang: Eliminating the degree requirements does NOT lower the bar. It just makes the job description more accessible.

14.53

Chang: We’re working on piloting some Hackbright hackathons in companies to help them elevate their women

14.54

Question: Why more women in tech?

14.55

Chang: Diverse teams have better results. The helps everyone.

14.58

Chang: Autodesk is one our partners. Internet of Things and Data Science have been interesting topics for our graduates.

15.01

Twitter: Do you think it is damaging to refer to females as Girls instead of Women?

15.01

Chang: There are far more important things to worry about than Girls vs Women

15.03

McInerney: There’s a lot of information our there about Unconscious Bias.

15.04

Chang: In a lot of companies, some managers bring up women in there team, others… not so much

15.05

Chang: Good mentors are needed. So many women leave tech over a bad manager

15.07

Chang: Field trips are great. They have inspired our students tremendously. Show them a good tech experience.

15.08

Chang: We also mentor our mentors to make sure they learn how to be good mentors.

15.08

Chang to Mentors: If you are asking me how you are doing, you are probably doing a good job.

15.09

Chang: THANK YOU for having this conversation!

15.10

Thanks to Angie Chang, Denise McInerney, and sponsor SQL Sentry for a great Women in Technology Luncheon.

15.11

That wraps up the live blogging to this Summit. Thanks for following along.

PASS Summit 2015 Keynote Live Blog – Day 1

28 October, 2015 (10:09) | Live Blog, PASS, Professional Development, SQL | By: Mark V

The PASS Summit Day 1 Keynote is about to get under way.

 

07.59

Good morning!

08.06

About to get started!

08.07

Dr. Stephen Levitt taking the stage!

08.09

Dear Presenters: please note that Dr. Levitt is NOT reading to us. :)

08.11

About 1 in 10 children reported on tax forms were fictional. Ended up causing the loss of billion in revenue for IRS.

08.13

In 1987, when the SSN of children was required on tax forms for deductions, 7 million children vanished from the face of the Earth.

08.14

What reasons do people have to innovate? Necessity. Business Pain. Lost Revenue.

08.15

Simplicity returns to the discussion. SSN on tax forms is obvious. But it wasn’t there until 1987.

08.16

Dr. Levitt: “Most people in Business don’t have time to think.” #ouch #TrueStory

08.17

“I spend 500 hours per year thinking about new ideas. It’s a great year when i get one.” ROI requires the I(nvestment).

08.19

Dr. Levitt studied things like Prostitution and Drug Cartels, things other economists wouldn’t touch. #innovate

08.22

When you see a stranger that clearly knows YOU, GATHER DATA. Turn it into insight. You might get lucky and remember them. :)

08.24

Dr. Levitt hated math. He is a noted economist, professor, and author. Path from A to B may not be a straight line.

08.26

Dr. Levitt: Sometimes clarity only comes from having the courage to ask the right question.

08.28

Incentive can lead someone who doesn’t like math to become an economist. How bad to you want your goals?

08.31

Dr. Levitt’s Dad: “I have not talent; you have not talent. Take on topics no self-respecting person would tackle.”

08.32

Dr. Levitt: If nobody is willing to defend a group of people, perhaps there are too many misconceptions about that group.

08.33

“If you have the choice between walking drunk and driving drunk, driving is far safer, at least according to the data.”

08.37

Following the Grateful Dead for 6 months can be an excellent primer for Grad School in Sociology? Think outside the classroom.

08.43

Dr Levitt telling about a Sociologist who stumbles into a Street Gang and how it made is career. #Innovation #TackleToughTopics

08.45

If you write down the organizational chart of a street gang, and removed the names, it could look just like corporate America.

08.47

The economics of street gangs amazingly similar to that of the “legitimate” business world. #ThinkAboutIt

08.48

Dr. Levitt: According to the data, It was 7 times more dangerous to sell crack in Chicago than it was being in combat in Iraq.

08.50

If you showed gang members the data, how many would still choose that life?

08.51

Are drug gangs a new, up-tapped market for Business Analytics? #TongueInCheek

08.52

Dr. Levitt: Business People LOVE to buy books. Don’t know if they read them….

08.54

Dear Presenters: Note how Dr. Levitt is making eye contact with people ALL OVER THE ROOM. #ConnectWithYourAudience

08.58

Dr. Levitt: Asking questions is worthless if you don’t correlate it with data to see what answers are correct.

08.59

Misconceptions can cripple you. Let the data speak, even when it might be difficult. #TrueStory

09.01

Dr. Levitt: Experimentation with data is vital. That’s where insights come from.

09.02

“Do you want the TRUTH?” How often to we find ourselves wanting to ask this of our clients/customers?

09.03

Dr. Levitt: “We got fired and all of our projects were cancelled. It was the best day our consulting company ever had.”

09.04

“Why in the world would you work for a company that when you tell them the TRUTH, they don’t want to hear it??”

09.04

Awesome: Dr. Levitt has opened the floor to questions.

09.06

Q: What kind of research are you doing now?

09.07

A: We have a “Parent Academy” and are teaching parents about things they can do to help their kids succeed.

09.09

Dr. Levitt: 5-10% of people we survey about tough decisions are swayed by a toss of a coin and actually take that action.

09.11

Dr. Levitt: Everybody and their brother is telling me I should use R right now.

09.12

Q: What kind of newly available data sets are you REALLY excited about?

09.13

A: Business data is FAR more interesting than Government data right now. Much more fun to be in the data generation business.

09.15

Dr. Levitt: Connect the data together and let people play with it. Sounds like using Excel for analytics.

09.16

Dr. Levitt: In shortest supply in Business is people who know how to think about data. #THIS

09.17

Dr. Levitt: “It turns out I am much better at telling funny stories than solving big problems.” Sometimes the data’s story leads you to ROI.

09.23

Dr. Levitt: Economists and Prostitutes have this in common – the word “Can’t” is not part of our vocabulary.

09.25

Dr: Levitt: “If you know a Prostitute, you send her my way. I guarantee I can affect her bottom line.”

09.26

That wraps up the Live Blogging for the conference. Thanks for following. And thanks to PASS for inviting me to participate.

09.53

Attendees are filing into the Dell Grand Ballroom.

09.55

I have to apologize to my fellow live bloggers for being so handsome and witty. I can’t help it.

10.02

Attendees continue to file in. We should be getting started in a few minutes.

10.05

Here we go, yo.

10.05

“Business Intelligence and Business Analytics are at the forefront of business today.” #Truth

10.06

PASS President Thomas LaRock taking the stage.

10.07

Tom: We get paid to work with data every day. How awesome is that? #Truth

10.08

Regardless of your title, if you work with Data, you are the lifeblood of your organization.

10.09

Tom: @sqlpass has over 100,000 members! Awesome!

10.10

Tom: Find a way to get involved with @sqlpass somehow. There are so many ways to get involved.

10.11

Tom: Pick up networking buttons at the Community Zone. Minimum count of “pieces of flair” is 31.

10.11

Make sure you spend some time with the sponsors. They make events like this possible. Woohoo!

10.12

Tom: Give the sponsors a hug. #Embracing

10.13

Tom: Next year’s PASS BA Conference will be in Santa Clara, CA

10.14

John Wittaker of Dell taking the stage: Big Data, Predictive, & The Middle Market

10.15

John: Big Data projects are not just for the enterprise

10.16

John: Not only is Big Data happening, but it is being invested in at the appropriate level

10.16

John: When IT and Business COLLABORATE, we are much more likely to have a successful outcome. #NoBrainer

10.18

John: “Real Time” and Predictive Analytics are the most valuable Big Data tools, according to Dell’s survey

10.18

John: Big Data Challenges = Complexity, Volume, and Budget

10.19

John: Data Complexity, though, is the major challenge today.

10.21

John: You will see vendors like Dell and others abstracting that complexity to make things easier.

10.24

John: Dell’s goal is to offer an end to end Information Management solution to manage, integrate, and protect data

10.25

Microsoft’s Amir Netz and Kamal Hathi taking the stage. This is going to be awesome!

10.26

Kamal: It’s been an amazing year of innovation at Microsoft: Power BI, Power Query, Power Map, HDInsight, SQL 2014…

10.27

Amir: We have a new CEO, Satya Nadella. Satya introduced SQL 2014. A CEO has never introduced SQL like that before.

10.28

Kamal: While I like Satya for a lot of reasons… Satya has made Indian accents “cool” now. #WellPlayed

10.29

Kamal: 2 million+ #PowerPivot downloads. 100 thousand + #PowerQuery downloads since Feb 2014

10.29

Kamla: Let’s ditch this Power Point and get over to #PowerBI and look at data the way we want to.

10.30

Kamal: #PowerBI Tennants by country in Q and A: It is all over the world. Way cool

10.31

Kamal: In Iceland, #PowerBI is kind of hot. #MyKindOfHumor

10.32

Kamal: Q&A has been a huge driver for #PowerBI adoption

10.33

Kamal: Over 1 million questions asked in Q&A in April 2014. Wow. Way cool.

10.34

Kamal is using Q&A in #PowerBI to learn about usage of Q&A in #PowerBI.

10.35

Kamal is doing #PowerView style data exploration directly in Q&A: “We made this feature more discoverable” #Awesomesauce

10.36

Amir: Power BI In Action discussing the #PowerIB Demo Contest. Winner: Michael Carper, who is taking the stage now.

10.37

Amir is walking through Michael’s contest entry about realtionship between Tweets and #NBA Game results

10.39

Amir could make watching paint dry sound exciting. Love his style.

10.40

Kamal now showing data by browser usage by using by #PowerIB in #Chrome #HTML5

10.41

Kamal: We’re doing this demo on a Samsung Chromebook. #HTML5 #PowerBI will just work on any platform

10.42

Amir: Native IOS app for #PowerBI will be available this summer.

10.43

Kamal: We want you to be able to take the investments you have already made on prem and use them in the Cloud #NotAllOrNothing

10.44

Amir: When was the last time you saw AdventureWorks in a keynote demo???

10.45

Amir: Reporting Services will become a natively integrated component of #PowerBI this Summer #ssrs Great News!

10.45

Kamal: The data exists in YOUR environment, but we can still render it with #SSRS in the cloud.

10.46

Kamal: In premise is still hugely important. We are working on bringing more of #PowerIB to on prem.

10.47

Kamal: YOUR BI ON YOUR TERMS. That is our promise to you. #LoveIt #MSBI

10.48

Amir: Today, we are on the verge of a new age. DATA CULTURE: Give the power to EVERYONE #BIToTheMasses

10.49

Amir: Data Culture is when everyone in an organization can use data

10.49

Amir: Aloha to a demo on Hawaii

10.50

Amir: Hawaii collects information forms from travelers on what they did in Hawaii just so we can have a cool demo today.

10.51

You guys, Q&A is just friggin cool. #NuffSaid

10.53

Amir: Moloka’i, known for it Leper Colony, is not the top of the list on most visited Hawaiian Islands. #TheMoreYouKnow

10.54

Amir analyzing when people from various nations visit Hawaii in Q&A directly. Not in #PowerView. IN Q&A.

10.55

Amir: Hawaii is the Niagara Falls for the Japanese.

10.56

Amir: You want a great investment? Invest in Honeymoon Suites for the Japanese in Hawaii. #ActionableInsight

10.57

Amir introducing KPIs in #PowerBI #AweYeah

10.58

Amir created a cool dashboard in less than a minute just using natural language. NO CODE. #PowerBi

10.59

Amir: How can we make Predictive Analytics and Data Science so easy that anyone can use it?

10.59

Amir: Announcing FORECASTING in #PowerView! #PredictiveAnalytics

11.00

Amir: We have some of the best Data Scientists and Researchers at @Microsoft. We put them to work to make it easy.

11.01

Amir: Forecasting is available NOW in every Line Chart in #PowerView Just click and drag the line forward to forecast

11.03

Amir: You can even correct for one-time events by clicking and dragging in the chart.

11.04

Amir: You can even TEST your forecast against older data to compare with actual results. #IWorkInSuchAGreatIndustry

11.05

Amir and Kamal bring Julie (audience volunteer) on stage for live BI demo.

11.06

Amir: here we have a #PowerView create around shark attacks. What if the user has other questions NOT answered by the report?

11.08

You can now get the Field List for a report in #PowerBI. So, users can tweak an existing report for their needs

11.08

Treemap introduced for #PowerView

11.09

Julie is dragging fields from one chart to another to explore a report and change it on the fly. #BIToTheMasses

11.11

Kamal: It’s a good time to caveat, this is a pre-release item… #AsTheDemoHiccups

11.12

Wow. Drag items out of one chart into a blank are to create a NEW chart

11.12

Amir: Getting attacked by a shark while swimming is not a very good thing. #ActionableInsight

11.13

Amir: If you go into the Ocean, take a weapon with you. Shark attacks while spear fishing have higher survival rate.

11.14

Amir: This “Gender” field is about the victim, not the shark. Not time to check while getting attacked. #NotRealTime

11.14

Amir: Which shark likes the ladies the most? The Bull Shark. #Duh

11.15

This demo with shark data is not just a fish story. #TellingStoriesWithData

11.16

Amir just did the “bump and shake” to combine two charts in #PowerView. Wow. Way cool.

11.17

Amir: The data does not lie – If you put sharks in swimming pools, people will learn to swim much faster #Truth

11.17

Amir: These features aren’t just for BI Pros, they are for EVERYONE! #BIToTheMasses

11.18

Amir: We are starting a new journey and we are so excited you are coming along with us. #MeToo

11.18

HUGE thanks to Microsoft’s Amir Netz and Kamal Hathi on another awesome keynote. #ILoveMyJob

11.19

That wraps it up for this morning’s Keynote. Thanks for following. I hope you found it helpful.

10.02

Getting ready for the Day 2 Keynote. People are filing in.

10.07

Lights are dimming. Here we go.

10.08

Denise McInerney taking the stage to introduce David McCandless.

10.09

David’s in the house…

10.09

David’s key phrase: Information is Beautiful. I have to agree.

10.10

Let’s start with Billions. Billions of dollars or something else. What do Billions look like?

10.11

David showing a Treemap. Hey, I saw one of those yesterday! #PowerBI

10.11

Americans give over 0 Billion per year to charitable causes.

10.13

David showing Daily Bread: Infographic on how much we, as Americans, spend per day on programs like NASA, Housing, etc

10.14

David showing blocks falling into place representing various economic expenditures, etc: Debtris (Playing on Tetris)

10.14

David: I LOVE to play with data. Just like children learn through play, so can we if we play with out data. #Explore

10.16

David is showing a chart of Fears that look like mountains in our way. Nice touch.

10.17

Highlighting the Fear of violent video games. Spike in November. And a Spike in April (related to Columbine tragedy)

10.17

Columbine often associated in media with violent video games. #Garbage

10.20

Most common “Break Up” times according to Facebook status updates. Mondays are apparently a poplar day to break up. #TheMoreYouKnow

10.21

Data is the New Oil #GreatMetaphor David’s is better: Data is the New Soil

10.22

The best way to start really using your data? Start asking questions.

10.22

“Do horoscopes always say the same thing?”

10.24

David scraped most common words in horoscopes. Boiled down: Whatever the situation or secret moment, enjoy everything a lot.

10.25

I learned a LOT in this process, just by playing

10.26

US Military Budget is MUCH larger than everyone else. But does that mean we are way militaristic?

10.27

When you compare military budgets as a percentage of GDP, US is 6th. #GoingOneMoreLayerToFineMeaning

10.28

Context is SO important to get a clear, true picture of our data. “Let the data set change your mindset”

10.30

Visualization what a Million Lines of Code looks like. Large Hadron Collider has more than 50 million lines of code. Healthcare.gov… I can’t even count them.

10.32

Cool visualization: Our galaxy creates 7 new stars per year. Planets are the norm, rather than the rarity we thought they were.

10.32

Given all that, statistically speaking, there could be 46 communicating civilizations in our galaxy.

10.33

“Pimp your data”

10.34

Of all the work I have done in my career, there is one thing I am most famous for: a Helicopter game that was ripped off by Flappy Birds Ninja

10.36

Our brains are incredibly visual. Three out of four neurons in our brain are visual.

10.36

We process visual images far better than text.

10.38

David showing a visualization: Who’s Suing Whom in Telecoms? Crazy pattern. Begs question: Do decreasing profits lead to increase in lawsuits?

10.41

David showing most popular Internet Search Terms laid out in maps of the countries in which they were used. Brilliant.

10.42

Great Venn Diagram showing how Pigs, Birds, and Humans relate by Flu: Influ-Venn-Za #MyKindOfHumor

10.43

If Twitter were made up of 100 users, 20 would be Dead (Empty accounts), and 75% of the Tweets would come from 5 users (Loud Mouths).

10.46

Showing visualization of most commonly used PIN numbers (gathered from previous data breaches). You guys, please choose better ones.

10.47

Data Visualization lets you see the Invisible

10.48

Is there a relationship between the efficacy and the popularity of vitamin supplements? Not much.

10.49

87% of supplements have no research behind them that indicates they have value. #Marketing

10.49

Key aspect of Data Visualization: You can compress a massive amount of information into a small, meaningful space.

10.50

Data Visualization is SO important for Mobile where you have much less screen space to work with.

10.52

David: It used to take me three days to make that Billion dollar Treemap. Now it takes 3 milliseconds. #ProgressYo

10.53

Qualitative Data is also Invisible. But you can Visualize it to fix that.

10.55

David, when visualizing some political comparisons, I REALLY wanted my viewpoint to look better than the other, but I couldn’t do that. #Honesty

10.57

There are organizations that use data visualization to LIE. Learn more about Data Viz so you can see the signs of impropriety.

10.58

Data Visualization of views can better reveal the places where opposing viewpoints actually overlap.

10.59

In the Newspapers, there is often an anxiety over white space: They Fear it. As a result, the meaning of the data is lost in noise.

11.00

In Data Visualization, Bling can create a barrier to understanding. It is the Data that should POP, not the shiny.

11.01

In Data Visualization, you should use your scissors more than your paint brush. #LessIsMore

11.02

Key takeaway from David: PLAY. Play leads to insight and understanding.

11.07

David showing visualization: Who is more Popular: Han Solo or Luke Skywalker? David: Interesting, no mention of either prior to 1977…

11.08

David: There is so much data in the world; what else can you do but play with it? #Exactly

11.10

Go to http://www.informationisbeautiful.net/  for David’s visualizations and great insights and data.

11.11

David: I never design ANYTHING until the data is sorted and clean. #FollowThisExample

11.15

David has created a symbology of stars so that they are not just points of light, but lack the resources to build it. Kickstarter?

11.17

David: Data is not this empirical thing that is immune from bias. It takes work and effort to keep bias out.

11.19

David: In terms of color, sometimes you need to come up with a meaningful metric that will be served well by color.

11.20

That wraps up the Day 2 Keynote here at the PASS Business Analytics Conference. Thanks much for following. I hope you found it helpful.

10.06

The Show will be starting in about ten minutes.

10.11

It’s great to see so many attendees filing in taking pictures of the room and the crowd. #SQLPASS

10.17

Today’s Keynote speakers include high level Data Platform executives within Microsoft. #WhereAreWeGoing #SQLPASS

10.19

James Phillips is the head of Azure/BI. This includes owning the direction of #PowerBI #sqlpass

10.20

Joseph Sirosh heads up the Information Management and Machine Learning group. #sqlpass

10.20

Ranga Rengarajan leads the Database and Big Data engineering business. #sqlpass

10.21

I love that Microsoft sees the value in #sqlpass and takes it seriously. #WeArePass

10.22

Today’s Theme: Evolving Microsoft’s Data Platform – The Journey to Cloud and Continues #sqlpass

10.23

PASS President Thomas LaRock on the stage. #HiTom #sqlpass

10.24

Round of applause for the makers of the “Best Data Platform on the planet” #DigIt #sqlpass

10.25

I want to thank the PASS Board Members for the hard work they put in to make PASS awesome. #sqlpass

10.25

PASS Board Q&A on Friday at 1 pm in Room 307-308 #sqlpass

10.26

First PASS Summit in Chicago in 1999 with 1200 attendees. #sqlpass

10.27

Today, PASS summit has 5899 attendees! #sqlpass

10.28

Tom: Community = Opportunities #sqlpass I am living proof of that. PASS has been HUGE for my career.

10.30

Tom: I challenge you to get involved. #sqlpass #DOTHIS Networking at Summit is AMAZING

10.31

The SQL Clinic is a spectacular place to get help with the products. #sqlpass

10.32

New This Year: Abstract workshops with speakers and Program Committee. #sqlpass

10.32

I will be at a Business Intelligence focused table at the Birds of a Feather lunch tomorrow. #sqlpass

10.33

PLEASE make sure to visit the Exhibit Hall to give the partners/sponsors a big THANK YOU! #sqlpass

10.34

Tom: Give vendors/sponsors a hug. #ChuckHuggers cc/ @sqlboywonder #sqlpass

10.36

Tom: PASS has been the cornerstone of my career since 2004. #sqlpass

10.40

Ranga taking the stage. #sqlpass

10.41

Ranga: We’re the only company that has this hyper scale cloud and the Enterprise presence to do magic. #sqlpass

10.42

Ranga: I love maps. I became a member of AAA when I found out they gave me free maps. #sqlpass

10.43

From maps to MapQuest…. #GrowUpStory #sqlpass

10.44

Ranga: Our success at Microsoft in the data world is because of YOU. #sqlpass

10.44

Ranga: EVERY YEAR, there is 41% more data than there was the year before. #sqlpass

10.45

Ranga: Data is the thing that is going to light up future productivity. #TRUTH #sqlpass

10.46

Ranga: “Data Culture” happens when people get the data they need and want when they need it. #sqlpass

10.47

Ranga: The Microsoft data platform enables that progress toward Data Culture. #sqlpass

10.47

Ranga: I am going to focus on the Capture and Manage parts of the data story. #sqlpass

10.48

Ranga: Microsoft is a data platform that doesn’t require you to make compromises. Culture of AND. #sqlpass

10.49

Ranga: Do more; achieve more. #sqlpass

10.50

Ranga: Capture diverse data; Achieve elastic data; Maximize performance & availability; simplify the cloud. #sqlpass

10.51

Azure DocumentDB: NoSQL DB service in the cloud, schema-free, ranging from ACID to eventual consistency. #sqlpass

10.52

Ranga: every application that is made expects a Search window. #Yup #sqlpass #DudeWheresMyData

10.53

Ranga: We think combining On-Premise and Cloud is necessary for the whole data story. #BestOfBothWorlds #sqlpass

10.54

Ranga: Scale Up = on prem SQL Server 2014 AND VMs in Azure. Scale Out = Azure SQL Database. #sqlpass

10.54

Ranga: Use the best tool for the job. #sqlpass

10.55

Tracy Daugherty of Pier1 Imports taking the stage. #sqlpass

10.56

Tracy: One thing we have a LOT of right now: orange pumpkins. #NoDoubt #sqlpass

10.56

Tracy: Azure Search lets us enable “fuzzy” search matching with great ease. #MakeItSimple #sqlpass

10.57

Tracy: Azure Search allows for a Scoring Profile so you can control how results are returned. #sqlpass

10.57

Ranga: Scoring Profile lets you weight the relevance of Search results. #sqlpass

10.58

Azure Search lets you squash the amount of code you need to find pumpkins…. #CouldNotResist #sqlpass

10.59

Tracy: JSON for the win. #sqlpass

11.00

JSON (Java Script Object Notation) is a very popular format for sharing data across platforms. #sqlpass

11.01

Watch me use #PowerQuery on Friday to consume JSON with ZERO CODE with a few clicks. #sqlpass

11.03

Tracy showing how they use Sharding in Azure SQL Database to scale workload easily. #sqlpass

11.05

Tracy is configuring Geo Replication for the main Pier 1 database easily in the Azure Management Portal. #sqlpass

11.06

Geo Replication: Where in the world is my database? There. AND There. AND There. #sqlpass #CultureOfAND

11.07

Ranga: Azure SQL Database has a 99.99% SLA. No one else has that. #sqlpass

11.08

Ranga: When we engineers at Microsoft run a million databases EVERY DAY, we learn things very quickly. #sqlpass

11.08

Ranga: lessons from the cloud enhance the On-Premise products. #CloudFirstFTW #sqlpass

11.09

Ranga: Use the right tool. Sometimes that is cloud. Sometimes on prem. We want that to be seemless. #sqlpass

11.10

Ranga: Take the data from wherever you find it, put it in the RIGHT engine and leave it in the cloud. #sqlpass

11.11

Ranga: Stackoverflow is a key customer. They have broken through limits on SQL Server using clever techniques. #sqlpass

11.12

Ranga: Stackoverflow takes advantage of In-Memory technology and uses it well. #sqlpass

11.13

Ranga: Samsung has seen 24x performance boost using SQL Server In-Memory technology. #sqlpass

11.15

Great to see Microsoft really embracing the idea that Relational is not everything. #PickTheRightEngine #sqlpass

11.15

Ranga: over 1.2 million downloads of #SQLServer 2014 #sqlpass

11.16

Ranga: Announcing a major update to Azure SQL Database. Will be in Preview by end of 2014. #sqlpass

11.17

Ranga: new features include leap in TSQL compatibility, parallel queries, Extended Events, In-Memory ColumnStore #sqlpass

11.19

Ranga: Introducing Mike Zwilling to show some cool stuff around Pier 1 Imports. #DatabaseEngineGoodness #sqlpass

11.19

Mike: People want real-time analytic queries on transcriptional data. #IWantItNow #sqlpass

11.20

Mike: I need your help to generate some load: go to http://aka.ms/gopass to help this demo out. #sqlpass

11.21

Mike: you are generating load on a beck-end SQL Server running In-Memory OLTP. #sqlpass

11.22

Mike showing LIVE analytics on top of transnational database we are hitting. Really cool. #sqlpass

11.23

Mike: we have a combination of the In-Memory engine AND a non-clustered ColumnStore index on the SAME table. #sqlpass

11.25

Mike: that ability to STRETCH a table to reach from On-Premise to Azure. The SAME table. #sqlpass

11.26

While the table is being stretched, you can still query it. #sqlpass

11.27

Looks like Ranga bought a “Hug Chuck” T shirt. #ChuckHuggers /cc @SQLBoyWonder #sqlpass

11.28

Mike: When you stretch a table, the bulk of the work happens with resources in Azure, not On-Premise. #sqlpass

11.29

Mike: we lost the on-premise server. I need to restore JUST THE LOCAL portion of the database. #sqlpass

11.29

In a few seconds, the on prem was restored and synchronized from Azure and we are back up and running. #sqlpass

11.30

Ranga: With this technology, you get the benefit of the Hyper Scale cloud in an invisible way. #sqlpass

11.30

Joseph Sirosh taking the stage to talk about Machine Learning, etc. #sqlpass

11.31

Joseph calling on the crowd to do the wave. #ContinuousIntegration #sqlpass

11.32

…and people actually did it. #sqlpass

11.33

Joseph: You want to understand the past, analyze the present, and predict what’s next. #sqlpass

11.34

Joseph: Azure Data Factory is in-Cloud data movement for moving data around. #sqlpass

11.35

Joseph: ANNOUNCING Free Azure Machine Learning at azure.com/ml #sqlpass

11.36

Joseph: We are democratizing data and capabilities. #BIToTheMasses #sqlpass

11.36

Sanjay Soni taking the stage to lead a demo around Pier 1. #sqlpass

11.37

Do we see a Pier 1 Import/Output Wizard in the future? #Joking #sqlpass

11.37

Sanjay showing In-Store Analytics using Kinect as a source…. #sqlpass

11.39

Sanjay showing heat map in #PowerMap visualization the customer movement in the store. #sqlpass

11.39

Sanjay showing how they used Azure Data Factory. “Think of SSIS to the power of X in the cloud.” #sqlpass

11.40

Joseph: You’re seeing a browser-based authoring environment. #sqlpass

11.41

Joseph: The speed at which you can get Data to work for you using this tool is amazing. #sqlpass

11.41

Joseph: all this through a browser and JSON documents. #sqlpass

11.42

Joseph: The data is flowing into Azure via Kinect sensors, ADF, and Azure Streaming Analytics. #sqlpass

11.43

Sanjay showing real-time (seconds) data visualizations about what is happening in the store RIGHT NOW. #NoPieCharts #sqlpass

11.44

Sanjay: How many lines of code to make this happen? FOURTEEN. #sqlpass

11.44

Sanjay: Azure Machine Learning is my new favorite product. AWESOME! #sqlpass

11.46

Sanjay now showing a Pier 1 app on his phone. #sqlpass

11.47

It’s not an iPhone. #JustSaying #sqlpass

11.47

Pier 1 was able to send Sanjay recommendations to his phone, with speech. #sqlpass

11.48

Sankay using speech recognition to find what he asked for and display it on the in-store map. #cool #WhereDoYouWantToGoToday #sqlpass

11.49

Since he searched for glasses, the app determined he might also be interested in other table ware. #sqlpass

11.50

Joseph: We are trying to make the BEST platform to analytics across On-Premise and Cloud. #sqlpass

11.50

James Phillips taking the stage. #PowerBI #ILoveIt #sqlpass

11.51

James: We want to bring insights to more people – faster #sqlpass

11.51

ANYONE that makes decisions can make better ones with better information. Not just for the C-Suite anymore. #sqlpass

11.52

James: Simplify data discovery. #PowerQuery #PowerPivot #sqlpass

11.53

#PowerQuery has had over 320,000 downloads since February of 2014. #sqlpass

11.54

James: Do more; achieve more: Simplify data discovery; deliver faster insight; connect to on-premise; enable data culture. #sqlpass

11.55

James: ANNOUNCING: Interactive Query – from Power BI, connect back to on-premise SSAS while keeping the data on prem. #sqlpass

11.55

James: Data sitting at rest has potential. We want to unlock that. #DataDividends #sqlpass

11.56

James: LIVE OPERATIONAL DASHBOARD #sqlpass

11.57

This is a NEW Power BI, not the same one we know and love right now. #sqlpass

11.57

The current one is NOT going away. We are just getting a new story to go along with it. #PowerBI #sqlpass

11.59

James is not using Q & A to create new visualizations based on corporate data and “pinning” them to his dashboard. #sqlpass

12.00

YOU get a dashboard. And YOU get a dashboard. And YOU get a dashboard… #Oprah #sqlpass #PowerBI

12.01

James: I don’t like Pie charts so I am going to make this a tree map, instead. #Winning #DataViz #sqlpass

12.01

James just signed into One-Drive and is connecting to an Excel Spreadsheet FROM POWER BI IN THE CLOUD #sqlpass

12.02

James combining charts by dragging one chart onto another. #Boom #sqlpass

12.03

James: This new #PowerBI is in private preview and will be hitting public preview soon. PowerBI.com #sqlpass

12.04

Ranga: Try Azure Machine Learning to day for a free trial with a Live ID. #NotTotallyFreeIfItIsJustATrial #sqlpass

12.04

Ranga: Be the hero of your data-driven business. #sqlpass

12.06

That wraps up the PASS Summit 2014 Keynote day 1. Thanks for following along. See you tomorrow morning! #sqlpass

10.14

I love the smell of #SQLServer in the morning. Smells like Awesome.

10.16

Adam Jorgensen taking the stage. #HiAdam #sqlpass

10.18

Adam: PASS Summit generates .9 Million in revenue. The PASS BA Conference generates .3 Million. #sqlpass

10.21

Adam: Starting in Fiscal 2015, we will budget budget summaries. #sqlpass

10.24

Sorry for the silence. Having connectivity issues… #SadPanda #sqlpass

10.25

Grant Fritchey joining the board on January 1. #ScaryBoardMember #sqlpass

10.25

PASS TV makes Summit a global experience. #sqlpass

10.26

Denise: PASS is a great enabler for personal growth. #Truth #sqlpass

10.28

PASSion Award Winner: Andrey Korshikov! #sqlpass

10.29

Andrey is a PASS Regional Mentor and organizer of several Russian language PASS Events. Awesome! #sqlpass

10.32

PASS Business Analytics Conference 2015 in Santa Clara, CA April 20-22 #sqlpass

10.33

Denise: Make sure to update your member profile on sqlpass.org to find out opportunities to volunteer. #sqlpass

10.34

Make sure to bring your attendee badge to get into the Community Appreciation Party tonight. #sqlpass

10.34

PASS Summit back here in Seattle October 27-30 2015. #sqlpass

10.36

Rimma Nehme, Principal Engineer at Microsoft Jim Gray System Lab, taking the stage. #sqlpass

10.36

Cloud Databases 101: Cloudy with a chance of more clouds, all with data. #ThingsAreLookingUp #sqlpass

10.38

Rimma: Trying to be a man is a waste of a woman. #Awesome #sqlpass #WIT

10.39

Rimma: I know a little bit about databases. #Understatement #sqlpass

10.39

Rimma: I’m a HUGE fan of the PASS community! #LoveIt #sqlpass

10.41

Rimma: Why cloud computing? #sqlpass

10.41

Rimma: With cloud technology being relatively new, it creates “Shiny Object Syndrome” #sqlpass

10.42

Rimma: Cloud = Service. On demand, anywhere, anytime. #sqlpass

10.43

Rimma: Blame networking people for the name Cloud Computing. #sqlpass

10.44

Rimma: Cloud Computing = On demand self-service. #DoItYourSelfYo #sqlpass

10.45

Rimma: One person and a credit can tap into the largest computing resource pool in the world. #sqlpass

10.45

Hm. I wonder what my Data Credit Score is…. #sqlpass

10.46

Rimma: Cloud computing reduces dev time and effort as you don’t need to spin up your own infrastructure. #sqlass

10.47

First wave of Massive Computing started in the 1960s with Super-Computers and Mainframes. #sqlpass

10.49

Rimma: The future of the Data Center is shipping containers full of servers. #ModularDataHomes #sqlpass

10.51

Rimma: Resources are NOT infinite. Optimizing for energy efficiency is leadership. #sqlpass

10.54

Take advantage of Evaporative Cooling. #DataScience? #sqlpass

10.56

Rimma: So that is Why Cloud. Now, what is Cloud DB? Take Earthed DB and add Service. Voila! #sqlpass

10.59

Rimma: Pizza as a service. On prem: you do it all. #sqlpass

10.59

Rimma: The other extreme is Cloud: Dining Out. The vendor manages everything. #sqlpass

11.00

Showing Pizza as a Service with no Pie Charts! Woohoo! #sqlpass

11.04

Dr. Nehme giving so much awesome information, I am having trouble keeping up. #GoodProblemToHave #sqlpass

11.05

Dr. Nehme: Maybe you will invite me back for another Keynote. #YesPlease #sqlpass

11.07

Dr. Nehme: starting up the bathroom analogy for virtualization. #sqlpass Hard to share efficiently.

11.07

Dr. Nehme: With virtualization, you lose direct access to computing resources. #sqlpass

11.08

Dr. Nehme: Virtualization is wonderful, but you have to keep in mind the trade-offs. #OftenWorthIt #sqlpass

11.09

Dr. Nehme: Server consolidation can lead to great energy savings as well. #sqlpass

11.11

High Availability with Pizza: If your delivery person gets lost, you still get the pizza from another. #sqlpass

11.13

Dr. Nehme: If application independence is VERY important to you, avoid the share schema approach of Multi-Tenancy. #sqlpass

11.14

Dr. Nehme is making the complex simple through great analogies. Fantastic job and a great example to follow. #sqlpass

11.15

Dear presenters: Please not that Dr. Nehme has not read to us. Not even once. :) #sqlpass

11.16

Dr. Nehme: a quick peek at the Azure SQL DB architecture. (I will try to keep up). #sqlpass

11.17

Dr. Nehme: Designed with High Availability in mind. #sqlpass

11.18

Azure SQL DB includes layers of abstraction to that you don’t need to deal with it. #DatabasesToTheMasses #sqlpass

11.20

Dr. Nehme: SQL Node architecture – The log files are shared across multiple databases. #SomeSharing #sqlpass

11.21

Dr. Nehme: The SQL Azure Gateway Service manages the traffic to make Azure SQL DB work. #sqlpass

11.22

Dr. Nehme: Do we still need a DBA in the Cloud Era? YES. ABSOLUTELY. #StretchToCloud #sqlpass

11.23

With Cloud Era, the on-premise story does NOT go away. There will be lots of hyrbid solutions REQUIRING on-prem. #sqlpass

11.23

Dr. Nehme: DBAs should add Cloud expertise and start calling themselves a Cloud DBA. #sqlpass

11.25

Dr. Nehme: You DBAs will become the Cloud DBAs. Embrace it! #sqlpass

11.26

Dr. DeWitt joining Dr. Nehme on the stage. “He has been a great mentor.” #NoDoubtAboutIt #sqlpass

11.26

Thank you, Dr. Nehme. That was fantastic. #sqlpass

11.27

Dr. Nehme received a well-deserved standing ovation. #sqlpass

11.28

Dr. Nehma: All you guys in kilts, please come take a picture with me in front of the stage. That is really cool. #sqlpass #SQLKilt

11.29

That wraps up the keynotes for Pass Summit 2014. Thanks so much for following. #sqlpass

10.14

It’s so fun to watch everyone file into the room for the keynotes.

10.20

Showtime.

10.22

PASS President Thomas LaRock taking the stage.

10.23

Official Announcement: #SQLHugs are a thing.

10.23

Folks from 58 countries present at Summit.

10.26

PASS Board Q&A at 3:30pm. Come ask questions and get answers.

10.26

Big welcome to the first time Summit attendees! Get ready for an awesome ride.

10.28

Tom: Data Professional are the true life force for companies around the globe. #ItsAllAboutTheData

10.29

For me, PASS has been a HUGE factor and my taking my career to where it is today. Thank you!

10.30

Stop by the Community Zone on the 4D Skybridge! Great place to Connect Share and Learn.

10.31

Hurray for Speaker Idol! Growing new speakers is AWESOME!

10.33

Super huge thanks to sponsors who help PASS have such a tremendous impact for us.

10.35

Thanks for your service as PASS President, Tom!

10.35

Microsoft Corporate VP Joseph Sirosh about to take the stage!

10.38

Sirosh: The ability to understanding data is transforming our daily lives.

10.39

Sirosh: Once data got an IP Address, we got abilities to connect everything.

10.40

Sirosh: In the Age of Software, the goal was to digitize everything. A computer on every desktop.

10.41

Sirosh: In the Age of Data, data and the analysis of data is driving us forward.

10.42

Dartmouth-Hitchcock used Microsoft technologies to create a new health care platform called ImagineCare

10.43

ImagineCare: The Internet of People Things – personalized care using devices and cloud-based monitoring

10.44

Sirosh: In the new world, Data will predict everything.

10.45

Sirosh: Today’s hospitals are optimized for treating things that already happened instead of preventing them from happening.

10.46

Sirosh: It used to cost 0 million to sequence one person’s genome. Now it costs less than 00.

10.47

The future of HealthCare: Instead of the treatment that works for others, you get the treatment that will work for YOU.

10.48

Sirosh: A lot of genomic analysis is done in R

10.50

Sirosh: DocuSign has 50 million users today. Someone signs electronically with DocuSign every .4 seconds!

10.50

DocuSign Chief Architect Eric Fleischman taking the stage

10.51

DocuSign uses #SQLServer for their OLTP systems. #YouShouldToo

10.52

Fleischman: We bet BIG on Always On #sqlserver

10.53

Fleischman: We’re not database people. We don’t want to write a database engine. I want to USE one. #sqlserver

10.54

Fleischman: We made a major investment into the telemetry inside the system. We have systems for tracking the systems.

10.55

Fleischman: Always Encrypted is a big deal for us. We’re in the Trust business.

10.56

Sirosh: High-performance OLTP has been vital for a long time. The importance of USING that data effectively is on the rise.

10.57

Stop just STORING your data. Start USING it.

10.58

Sirosh: We have our feet on the ground and our head in the cloud

10.59

Sirosh: When we have that and a community like PASS, you help us become #1

11.02

Shawn Bice Micrrosoft GM for Database Systems Group taking the stage

11.03

Bice: In this era, companies who embrace data will be far more competitive than those who don’t

11.04

Bice: SQL Server 2016 is backbone of Azure. Billions of queries hit that every single day

11.05

Bice: Everything I am going to show you on SQL Server 2016 today is BUILT IN

11.06

Bice: SQL Server is mission critical ready – It is backbone for train transportation in an entire country

11.08

Bice: R is the #1 choice for data scientists and statisticians in the world. Welcome to SQL Server!

11.09

You want cloud? Choose Microsoft. You want on-prem? Choose Microsoft. You want to straddle both? Choose Microsoft.

11.11

Bice: Do you realize you can enroll an Azure VM in an on-premises availability group in about 5 minutes?

11.12

Bice: We had a data center ACTUALLY LIGHT ON FIRE. We failed over all our customers there in 5 hours.

11.13

Bice: Polybase is baked right into SQL Server 2016 #TheNeedsOfTheMany

11.14

Bice: Auto insurers tying telemetry data to customers for rate calculation using SQL Server

11.15

Bice: Real-time is not just throughput. It’s the ability to learn and adjust as tings are happening.

11.15

Sometimes, you need to learn NOW, not just AFTER ETL ran…

11.16

Bice: Real-Time Operational Analytics ftw!

11.17

Operational Analytics with R in SQL Server: Learn from your data where it lives

11.18

Rohan Jumar, Microsoft Partner Director in Engineer is joinig Shawn Bice on stage

11.19

Jumar showing map of PCubed showing lighted dots based on financial transactions everywhere in the world.

11.20

Bice to Jumar: With that kind of scale, how do you even begin???

11.22

Jumar showing the realtime dashboard used by PCubed to track their system. #NoPies

11.23

Jumar: With SQL Server 2016, you can achieve the realtime analytic without impacting our OLTP queries

11.29

Jumar showing an R script directly into a T-SQL stored procedure while the data never leaves the safety of SQL Server

11.30

Typos…. Kumar, not Jumar… sorry.

11.31

Bice: We have invested more on security in SQL Server 2016 than ever before

11.33

Bice: There is a big hole in the data world – open access to the buffer pool. Always Encrypted fixes that for SQL Server

11.33

Bice: With Always Encrypted, the work happens on the client side, not in the engine

11.34

Rohan Kumar coming back on the stage

11.38

Kumar: Always Encrypted allows encryption at rest AND in transit.

11.39

Dear Man-in-the-Middle Attackers, SUCK IT. Sincerely, SQL Server 2016 Always Encrypted

11.41

Bice: This is a new SQL Server. We’ll take the most complex things and simplify them for you.

11.42

Bice: Stretch DB allows “stretching” tables into Azure for CHEAP storage while keeping data queryable!

11.44

Bice: Stretch Database and Always Encrypted work awesome together

11.44

Do you want speed or security? With SQL Server 2016 you get BOTH

11.47

Kumar: We worked to make Stretch Database easily usable by DBAs who have not done much in Azure

11.49

Kumar showing a query from two tables, one Stretched, one not.

11.50

Kumar: We’ve built Stretch on the distributed query infrastructure we have had with SQL Server

11.52

Joseph Sirosh taking the stage again.

11.52

Sirosh: Building great projects is a journey. SQL Server 2016 took twenty years of work

11.54

Sirosh: We believe in dog-fooding all of these. We are using this ourselves

11.55

Sirosh: We don’t believe in nickle-and-diming customers for every new feature

11.56

Sirosh: We are creating better and new human experience – WITH DATA

11.57

Sirosh: This is the age of the data professional. It is our time.

11.57

That wraps up this keynote. Thanks for following along. These are great times we live in, friends.

10.10

Folks are filing into the hall. There is quite a bit of excitement in this room.

10.21

Here we go, yo.

10.22

Adam Jorgensen taking the stage.

10.24

All PASS financial information is available at www.sqlpass.org/governance

10.25

Summit attendees have doubled since 2007! I have certainly gained weight…

10.26

In 2008, there were 5 SQL Saturdays… in the US. In fiscal 2015, there were 99 globally….

10.27

PASS has over 150,000 members worldwide from 163 countries. This covers 86% of the countries in the world.

10.29

Total fiscal year 2015 spend was a bit over million. 78% of those dollars went directly back into the community

10.30

Starting this fiscal year 2016, PASS will be publishing portfolio budget summaries for better transparency

10.32

SQL Rally resources are being routed to SQL Saturday

10.32

Also this year, a goal is to do a redesign of sqlpass.org

10.33

Denise McInerney taking the stage

10.36

Great recognition for Amy Lewis and Bill Graziano for their contributions to PASS on the board.

10.37

Volunteers work so hard to make PASS what it is. THANK YOU!

10.37

Passion Award goes to Lance Harra!

10.39

Wow. Lance has done so much that I can’t keep up. Way to go, sir!

10.40

There are 3000 people tuning in LIVE on PASSTV from 95 countries right now. HI!

10.42

Since 2009 12 24 Hours of PASS events have been delivered in Spanish, Portuguese, or Russian. Awesome!

10.43

PASS Summit 2016 will be October 25-28 here in Seattle!

10.45

Welcome to Dr. David DeWitt and Dr. Rimma Nehme! If you want to learn about presenting, watch them. They rock!

10.45

Dr. Nehme (Nehme) taking the stage!

10.46

Nehme: I will be the appetizer, David will be the entree, then I will be the dessert.

10.47

Nehme: We thought the Internet of Things (Thingernet) would be a great topic.

10.47

Nehme: Why should you, as data professionals, care about this technology?

10.48

Nehme: What is IOT? A collection of connected devices that work together to do something useful.

10.48

No pizza this year.

10.50

Nehme: Two types of IOT: Consumer (wearables, etc), Industrial IOT (machines etc)

10.50

Nehme: Consumer IOT examples, Fitbit, Nest, etc

10.51

Nehme: Industrial IOT…. Can we build more intelligent roads? Hospitals?

10.52

Nehme: Significant value will be realized from the Industrial IOT

10.53

Nehme: Four Types of IOT Capabilities: Monitoring, Control, Optimization, Autonomy

10.53

Nehme: We are somewhere between monitoring and control right now. I call it the Terrible Twos of IOT

10.54

Nehme: In 2003 we have about 500 million devices connected to the Internet. In 2010, we had 12.5 billion.

10.55

Nehme: Somewhere in 2008, the number of Internet connected devices exceeded the population of the Earth

10.56

DeWitt taking the stage to talk about the HOW if IOT…

10.57

DeWitt: Lots of challenges to IOT. Huge variety of sensors. Lots of devices. Dirty sensor readings. Data volume/scale

10.58

DeWitt: Device security is a huge challenge as well. Challenges also with cloud to device messaging

10.58

DeWitt: the last major challenge is deployment. When you have billions of “things” how do you manage that?

10.59

I say it every year. But notice that neither Dr. Nehme nor Dr. DeWitt have READ to us…

11.00

DeWitt: Even the cutting edge IOT is still rather primitive

11.01

DeWitt: Pretty much every IOT device has a sensor. Most of them also have an actuator to perform an action

11.02

DeWitt: Once the data gets to the Cloud, you have a lot of options for what you can do with it

11.03

DeWitt: Occasionally, a command will be sent from the Cloud back to the device: Cloud to Device Command

11.03

DeWitt: IOT Hubs are cloud-based services for interacting with the “things”

11.04

DeWitt: Real-time streaming systems, like Azure Stream Analytics, operating on a finite window of time

11.05

DeWitt: They only PROCESS data. They don’t have time to store it.

11.06

DeWitt: The Azure IOT hub provides device authentication since security is so critical

11.06

There is not way I can keep up with either Dr. Nehme or Dr. DeWitt. But trying is really fun

11.08

DeWitt: If you want to store the IOT data, you need a consumer that will take it out of the hub to store it

11.10

DeWitt: You have a number of options for storage, but SQL DW is the best one. #WinkWink

11.10

DeWitt: Azure Machine Learning is a great solution for “predicting when the boiler will explode” #NoPressure

11.12

DeWitt: So what IS a real-time query engine? In my mind, it is a streaming database system

11.12

DeWitt: You have queries that operate over events across time windows.

11.13

Now I have “Islands in the Stream” in my head. Thanks, Doc.

11.14

DeWitt: The stream can send the ID values of boilers about to explode to a system to open the release valve

11.15

DeWitt: Raspberry Pi is not running SQL Server.. yet. That’s NOT a product announcement…

11.16

If you visualize an array of Raspberry Pi devices, that is a Pi Chart. #JustSaying

11.17

DeWitt: Right now Azure IOT is pretty limited. Currently, metadata is not stored in a DBMS. So, no query support

11.18

DeWitt: Devices must poll in order to keep checking for commands.

11.18

DeWitt: IOT events are PUSHED up into the cloud.

11.19

DeWitt: issues with pushing only: bandwidth, connectivity, latency, data deluge, storage

11.20

DeWitt: In our opinion, pushing everything to the cloud is a huge waste of resources

11.21

DeWitt: Have a streaming query engine near the device to aggregate and send results to the cloud instead of each event

11.22

DeWitt: This reduces what we push into the cloud, and allows for dealing only with IMPORTANT events

11.22

Dr. Nehme taking the stage again.

11.23

Nehme: Fog Computer aka Edge Computing. This is not Cloud VERSUS Fog. It is Cloud + Fog

11.24

Nemhe: We are taught that you never move the data to the computation. You move the computation to the data.

11.24

Nemhe: The Cloud is basically this big gorilla… #TheOneAndOnlyIvan

11.25

Nehme: IOT is not just a Networking problem. It is also a database problem.

11.25

Nemhe: Polybase for IOT. This is NOT a product announcement… but if you make enough noise…

11.26

Nehme: Today you have to specify everything you want to do about IOT

11.27

Nehme: How about IOT-SQL? Why not query Devices like we query Tables? #Dude

11.28

Nehme: Regular attributes can be inserted, deleted, etc. Extended Attributes are set by the device alone

11.29

Nemhe: Scalable metadata management with a Shell Database. Essentially, metadata only.

11.31

Nehme: Where could the Shell be stored? Anywhere, really. DocDB, HDInsight, Azure SQL DB… It’s just a database.

11.34

Nehme: Make sure only meaningful, important, information is sent up to the cloud.

11.35

Nehme: Larger computations happen in the Fog near the device instead of sending it all to the Cloud

11.36

Nehme: Why should as Data Professionals care? You either part of the steamroller, or part of the road.

11.37

Nemhe: The amount of data to manage is increasing exponentially. So, what does success look like?

11.37

Nehme: This is our last PASS Keynote. #Noooooooooooooooooooooooooooooooooooooooo

11.38

HUGE THANK YOU to Dr. Dewitt and Dr. Nehme for so many AWESOME keynotes. We will miss you!

11.39

DeWitt: It is time to give up on the full time gig and start collecting Social Security. #YouHaveEarnedIt

11.41

HUGE Standing Ovation for Dr. DeWitt and Dr. Nehme.

11.41

That wraps up the Day 2 Keynote. Thanks for following along.

13.55

Huge thanks to SQL Sentry for sponsoring!

13.57

This year’s special guest is Angie Chang of Hackbright Academy, an engineering school for women.

13.59

Angie will sit down with Denise McInerney, PASS VP of Marketing.

14.00

I love looking around the room at the Women in Technology Luncheon and seeing so many men in attendance.

14.18

Denise McInerney taking the stage. Here we go.

14.18

Angie Chang joining Denise on stage.

14.19

Chang has a BA in English and is in Technology. Me too. Liberal Arts = Learning How to Learn

14.21

Chang has long been involved in helping women network and improve themselves

14.21

Chang: Hackbright has graduated over 300 women at this point.

14.22

Chang: Hackbright started by folks who attended a coding bootcamp in San Francisco.

14.23

Hackbright: We’ll teach you how to code in ten weeks.

14.24

Chang: we are teaching python as a full stack framework. We also do Angular and teach women how to mentor each other

14.24

Chang: Each student gets three mentors to help with code reviews, etc

14.25

Chang: People choose Hackbright because of the Community. #CommunityMatters

14.26

Chang: Hackbright students and alumna have come from so many various backgrounds.

14.27

McInerney: I know you have a high rate of job placement from Hackbright. Can you share success stories?

14.28

Chang: We have several women who have gone onto senior software engineering positions and engineering managers

14.28

Chang: Survey Monkey has, I think, hired more Hackbright alums than any other company

14.29

McInerney: How are companies supporting Hackbright Academy?

14.29

Chang: We invite partners companies to a career day to come and meet all our graduating students.

14.30

Chang: Several companies also offer scholarships for Hackbright students

14.31

Chang: For the first GirlGeek dinner I hosted in the Bay Area, we have 400 people sign up in 5 days. #Winning

14.32

Chang: Often, people get hired based on networking, etc, at Girl Geek dinners.

14.33

Chang: Train your managers so that women who are already IN tech have a good experience

14.34

Chang: There are so many roles that women of ANY age can fill. It’s a shame we only focus on the youngest

14.35

Chang: Making sure women can start having a better experience in Tech is going to help with retention of women in in Tech.

14.36

Chang: We encourage our students to BE THE CHANGE THEY WANT TO SEE #GoodAdviceForAllOfUs

14.38

McInerney: What advice to you have for parents that want to make a difference in this area?

14.39

Chang: Don’t just enroll your boys in tech camps, etc. Enroll your girls, too. #ProudToSayIDoThat

14.39

Chang: Encourage your girls to be brave instead of afraid they are going to break things. #ItsOKToFail

14.40

McInerney: How can people help support Hackbright Academy?

14.41

We are opening up to questions. People online can ask via hashtag #passwit

14.42

McInerney: What’s your perspective on how schools need to change?

14.42

Chang: One example is a project called Technovation that helps girls write Android apps and pitch them

14.44

Chang: I was really lucky to have a computer programming class in high school. We need more of that.

14.44

McInerney: There is a documentary on Technovation coming to YouTube next week called Code Girl

14.45

Chang: We have never had a student directly out of high school. We’re wondering why that would be.

14.46

Chang: At Hackbright, we have lots of hackathons and they have been women of all ages.

14.47

Twitter Question: Are there plans for paths other than software engineering at Hackbright?

14.48

Chang: Currently, we are trying to fill the gap in software engineering. These are good-paying jobs, etc.

14.48

Question: Have you seen blowback form that fact that Hackbright is not a four-year degree?

14.49

Chang: It’s kind of silly that so many positions require a four-year degree. It is just not that important these days.

14.50

Chang: Eliminating the degree requirements does NOT lower the bar. It just makes the job description more accessible.

14.53

Chang: We’re working on piloting some Hackbright hackathons in companies to help them elevate their women

14.54

Question: Why more women in tech?

14.55

Chang: Diverse teams have better results. The helps everyone.

14.58

Chang: Autodesk is one our partners. Internet of Things and Data Science have been interesting topics for our graduates.

15.01

Twitter: Do you think it is damaging to refer to females as Girls instead of Women?

15.01

Chang: There are far more important things to worry about than Girls vs Women

15.03

McInerney: There’s a lot of information our there about Unconscious Bias.

15.04

Chang: In a lot of companies, some managers bring up women in there team, others… not so much

15.05

Chang: Good mentors are needed. So many women leave tech over a bad manager

15.07

Chang: Field trips are great. They have inspired our students tremendously. Show them a good tech experience.

15.08

Chang: We also mentor our mentors to make sure they learn how to be good mentors.

15.08

Chang to Mentors: If you are asking me how you are doing, you are probably doing a good job.

15.09

Chang: THANK YOU for having this conversation!

15.10

Thanks to Angie Chang, Denise McInerney, and sponsor SQL Sentry for a great Women in Technology Luncheon.

15.11

That wraps up the live blogging to this Summit. Thanks for following along.

Cross Filtering Versus Slicers In Power BI

15 October, 2015 (12:58) | Power BI | By: Mark V

This post is inspired by a question on the Power BI Community site: PBI Graph Scaling. The question relates to the behavior of scaling of graphs when using Cross Filtering in a Report. It seems, as Seth Bauer (Eno1978) pointed out, that they may want to use a Slicer instead.

I figured an analysis of the behavior of cross filtering and slicers would help people learn what to expect in each situation and guide folks in choosing which feature they want to use. For this example, we will use the report shown in Figure 1 relating to student chocolate bar sales for a fundraiser.

Figure 1

image

This report features three visuals in Power BI Desktop:

1. Column chart showing Sales Amount – Total by Flavor

2. Bar Chart showing Sales Amount – Total by Size

3. Slicer allowing for filtering by Size

Cross Filtering

Cross Filtering is the feature that allows clicking on a part of a visual, like a Column in a Column chart, and filtering all other data on the Report page to highlight the values associated with that Column. Doing this allows for comparison to the full totals by leaving references to data not meeting the filter in each visual, but shown faded. For example, if we click the Large bar in the Sales Amount – Total by Size Bar chart, we will filter the visuals to highlight the values relating to Large bar sales as shown in Figure 2.

Figure 2

image

Note that the values for the Small bar sales are still visible for comparison, but are clearly lightened so that the Large sales are easily seen. We can return to the unfiltered view by clicking the Large bar again.

Slicer

Slicers actually remove the values that do not meet the filter from the visuals entirely. For example, if we click the Large option on the Size slicer, we get the view shown in Figure 3.

Figure 3

image

Notice in this view that the Small bar has been completely removed from the bar chart. With quick comparison to Figure 2, you can also see that the scale of the column chart has changed so that the top value is just over $3k, which corresponds to the columns in the cross filtered version. The portion of the sales corresponding to the Small bars is completely removed.

Incidentally, the behavior of a Slicer matches the behavior you would see if you put the Size field in the Filter area at the Report or Page level.

Conclusion

As we can see, the behavior of cross filtering is certainly different from the behavior of using a Slicer. Cross Filtering allows you to see how the filtered value(s) compares to the overall total. A Slicer filters such that only values meeting the filter are allowed to appear at all. There are occasions when one or the other might be preferred. Understanding which is which will save you time and effort while visualizing your data with Power BI.

While the example here is from Power BI Desktop, the behavior in the Power BI Service is currently the same.

Note: The behavior here is current as of October 15th, 2015. It is subject to change in the future as Microsoft continues to make the awesomeness of Power BI even better.

Current Power BI Service Limits

23 September, 2015 (11:04) | Power BI | By: Mark V

Not long ago, Microsoft announced that the limits for Datasets and Reports per Dataset had been increased to 200. You can read their announcement here. That raised some additional questions for me. I asked Microsoft and have now gotten the answers I sought.

Please note that these answers are valid as of September 23, 2015, but are subject to change in the future.

image

Datasets

A Dataset is a connection to a single source of data, a single file, a single database, etc. So, this means you can connect to up to 200 distinct sources from your Power BI service account. Note that a Power BI Desktop file, which can connect to many sources at once, counts as a single Dataset in the Power BI service. Therefore, effective use of Power BI Desktop raises your limit of data sources well above 200.

NOTE: I don’t, as of the time of this writing, have the limit on sources supported by a Power BI Desktop file. I will provide that info once I have it.

Reports per Dataset

A Report in Power BI connects to one and only one Dataset. If you think 200 Reports per dataset does not seem like much, remember that Reports can have multiple pages of visualizations. I don’t have a maximum on number of pages at the moment.

NOTE: I got confirmation from Microsoft that tiles created via Q&A DO NOT count against this 200-Report limit. So, with effective use of Q&A for creating Dashboard tiles, you can get a lot of mileage out of 200 Reports by only using them for things that a Q&A tile cannot do.

Reports

With 200 Datasets each supporting up to 200 Reports, some simple arithmetic leads to the conclusion that you can have up to 40,000 Reports in your Power BI account. I have not seen an Enterprise environment with anything close to that number of Reports. I would think they could be out there, but, still: That’s a LOT of Reports.

Dashboards

You can have up to 100 Dashboards in your Power BI account. To me, this is the most limiting out of all of these numbers. The reason is that there is no real wiggle-room here as there is no comparable alternative to Dashboards. While there is not a technical reason that dictates your Dashboard tiles have to all fit on a single screen without scrolling, it is definitely a best practice to keep them to a single screen. Still, if you remember that your dashboards should be for the MOST important information that needs to be seen at a glance, you can make good choices about what gets pinned to Dashboards and what stays on the underlying Report(s). Keep in mind, too, that Dashboards can support Tiles from multiple Reports and from multiple Datasets via Q&A. So, it is possible to to have multi-purpose Dashboards if you are approaching this limit. That said, I would recommend you avoid mixing unrelated data in the same Dashboard as it could create confusion and make the Dashboard less effective overall.

Conclusion

There you have it. I hope that provides some clarification. I have to say, for a service with the elegance and flexibility of Power BI, and price points of FREE and $10/Month, these limits are VERY generous.

PASS Board of Directors Election

17 September, 2015 (22:20) | PASS | By: Mark V

Greetings. It’s time to vote for the open PASS Board of Directors positions. I want to start by thanking some folks.

Thank you to the Nomination Committee for their time and effort on this process:

Bill Grazziano
Grant Fritchey
Robert Davis
Lori Edwards
Bob Pusateri

I would like to thank the four candidates, all of whom have shown a passion for this community, not just with their words, but with their actions.

Ryan Adams
Tim Ford
Argenis Fernandez
Jen Stirrup

This is never an easy decision to make. I know each of these great people and have no doubt that the outcome would be great for PASS for any of them to sit on the Board.

Here are my votes, with the rationale behind each.

Jen Stirrup

I know that Jen is the only candidate for EMEA and a vote here isn’t really necessary. I am voting for her anyway because I have tremendous respect for her and the work she has already done on the PASS Board. I love how great she has been in terms of transparency. I love how she has served as a champion for the data professionals out there that aren’t DBAs or Database Developers. While the core of PASS has long been, and continues to be, with our Database Administrators and Developers, it is vital, in my opinion, for PASS to also embrace the data analysts, data scientists, and consumers of data. One way is via the PASS Business Analytics Conference. Our DBA and Database Developer friends put a lot of time and effort into helping to store our vital data and keep it safe and secure. We keep and safeguard that data so we can USE it. Jen has served well in speaking for those people.

Tim Ford

Tim has shown excellent leadership in continuing the success of the SQL Saturday program, which I believe in very strongly. To me, between his direct involvement with SQL Saturdays, his efforts on SQL Cruise are also fantastic. I hope to do one some day. :) I think Tim has demonstrated his passion and ability to lead and I would like to see him continue those efforts. I do also appreciate his support for the PASS Business Analytics Conference and serving that community.

Ryan Adams

I met Ryan Adams when I was a PASS Regional Mentor. We chatted at a Regional Mentor’s meeting at PASS Summit and participated in discussions at the PASS Chapter Leaders meeting as well. I was amazed to hear how he performed that role. I was amazed at his organization and his passion for his chapters and for PASS. He made me want to be a better Regional Mentor myself. I chatted a bit with the Chapter Leaders in his region. They were in awe at how helpful he was for them and had nothing but praise and appreciation for Ryan. I knew during those conversations that it was only a matter of time before I would see his name on a ballot for the PASS Board. I also knew that I would vote for him when it happened. The time has come.

 

I mentioned that this is a very hard decision. Argenis is a brilliant SQL Server professional with a tremendous passion for this community. I think he is a great candidate for the PASS Board. I have every confidence that we will see his name on a ballot again. At this time, I feel that my three choices above are the ones I need to make.

My fellow PASS members, I implore you to vote. Please make your voice heard.

Power BI Weekly Update: Oh, The Places You’ll Go

16 September, 2015 (19:14) | Power BI | By: Mark V

Microsoft has released this week’s update to the PowerBI.com service. You can find the details here. There are a few updates this week, but I want to focus on just one.

How many times have I added a Dataset and created a Report only to discover I did so in the context of the wrong dashboard? OMG so many times. I am a slow learner, apparently. Well, it no longer matters.

As of TODAY, when pinning a visualization to a Dashboard in the Power BI service (PowerBI.com), you get to select which Dashboard to pin it to. What??? I know! So cool. Not only that, but you can ALSO choose to create NEW dashboard during this process instead of pinning to an existing one.

I have broken this post into two sections. The first section will be a straightforward blog post on this new feature of Power BI. The second section will cover this feature again, this time via poetry as I channel my own inner Dr. Seuss.

Straightforward

When you are choosing to pin a visualization (either in a report OR already on a dashboard) in the Power BI service, you now have some choices to make. Until today, those choices were made for you. Figure 1 shows a shiny new visualization I created against my Chocolate Sales dataset in a Report.

Figure 1

image

The Pin button is located in the upper-right, as shown by the red arrow in Figure 1. Yesterday, clicking that pinned that visualization to the last dashboard you visited. For me, that was often NOT the right one. And, since there was no way to change this after the fact, I had to delete that visualization (and sometimes entire Reports) and start again after going to the right dashboard, even just for a moment. Gr.

NOW, clicking that Pin button brings up the dialog shown in Figure 2

Figure 2

image

Bam! The dropdown list shown by the red arrow in Figure 2 contains the list of all my dashboards so I can select which one to pin my fabulous visualization to. OR, I can choose New Dashboard and have this be the first visualization on that dashboard.

The post from Microsoft referenced at the beginning also includes the ability to choose whether to use the theme of the dashboard or keep the formatting (colors) you have on the report. That option didn’t appear for me in this case. I’ll have to play with that a bit. For now, I wanted to focus on choosing the dashboard.

I am so very happy about this.

Dr. Seuss

Congratulations!
Today is your day!
You have Power BI!
You’re off and away!

You have data to use.
And questions to ask.
You can do it yourself.
You’re up to the task.
You head to the cloud, with that login you know.
To Power BI; you even have Pro.

You have your dataset already there.
You click on Explore and take to the air!
You click a few clicks and a bar chart appears
With no help at all! Hey, Microsoft: Cheers!

Your dataviz done, you just have to share.
You click on the Pin, and pin it to… where?
It went to some dashboard. You’re not sure which one.
You hope it’s the right one… It isn’t… Son (of a…)

Has this happened to you? Or friends that you know?
It’s happened to me. It ends happy, though.
Do not despair. Do not get the blues.
For as of TODAY: YOU GET TO CHOOSE!

Oh, the places you’ll go, now, when you pin your viz!
I hope I am clear on how awesome this is.