Passing Credential Asset in Azure Automation Test Pane

8 August, 2016 (11:00) | Automation, Azure, PowerShell | By: Mark V

Lately, I have been learning Azure Automation. If you are not familiar with it, I encourage you to follow the link in the previous sentence. The remainder of this post will assume you have some familiarity with it.

Note: The solution presented here works today. As Azure Automation continues to evolve, there is no guarantee this will always be the answer.

Also Note: If you just want the answer, and would prefer to skip over my brilliant description of this epic journey contained in the Saga section, feel free to scroll down to the Out With It, Man! section at the bottom of this post.

Saga

Today, I was working on a Runbook to create a shiny new Azure SQL Database Server, as long as that server does not already exist. I have other Runbooks for creating the Server Firewall Rules and the Azure SQL Database itself. Keeping Runbooks small and very targeted is a recommended practice. Later, I will create another Runbook that calls each of the ones above to create the overall Azure SQL Database solution I am after.

One of my favorite features of Azure Automation is the ability to use Assets, which essentially allow you to store Variables, Credentials, and others pieces of information you can reuse across Runbooks. The key for this post is the Credential. This allows you to store a Username and Password pair that is stored encrypted for you in Azure. This allows you to have your Azure Automation Runbooks use this Credential to authenticate to some other service without embedding ANY part of the Username or Password in the Automation script itself. Boom. This is huge. It also allows you to utilize the Credential without having to know that Username or Password. I know, right?

To create this Azure SQL Database Server, my Runbook uses the New-AzureRmSqlServer PowerShell cmdlet. Rather than paste my entire Runbook here, I will just show the key pieces that are necessary for this post.

In accordance with recommended practices, my Runbook has a section at the top that lays out the parameters, shown in Figure 1.

Figure 1

param

(

      [Parameter(Mandatory=$True)] `

      [string] `

      $resourceGroupName

    , [Parameter(Mandatory=$True)] `

      [string] `

      $location    

    , [Parameter(Mandatory=$True)] `

      [string] `

      $serverName    

    , [Parameter(Mandatory=$True)] `

      [string] `

      $serverVersion    

    , [Parameter(Mandatory=$True)] `

      [PSCredential] `

      $sqlAdminstratorCredentials    

)

 

The last parameter, $sqlAdministratorCredentials, has a type of PSCredential. The other parameters are just strings.

The call that actually creates the Server is shown in Figure 2.

Figure 2

New-AzureRmSqlServer `

    -ResourceGroupName $resourceGroupName `

    -ServerName $serverName `

    -Location $location `

    -ServerVersion $serverVersion `

    -SqlAdministratorCredentials $sqlAdminstratorCredentials 

 

There is certainly more code in the Runbook. I am just focusing on the key areas related to this particular post.

In Figure 2, you can see that I am mapping the parameters in my param section in Figure 1 with the parameters of the New-AzureRmSqlServer Powershell cmdlet. The first parameter in Figure 1, $resourceGroupName, will be passed to the –ResourceGroupName paramter of the cmdlet. And so on.

As we all know, and sometimes even practice, Testing is important. Thus, I fully test each of my Runbooks multiple times to make sure they do what I want them to. For example, this Runbook should create a new Azure SQL Database Server. It should most definitely NOT put Max in Space. Azure Automation includes a feature in Edit mode of a Runbook called the Test Pane. It allows you to enter in parameters and run the Runbook before you publish it to make sure it works the way you want it to. Note that the Test Pane does not pretend to do things. It ACTUALLY performs the actions. So, running a Runbook that creates a server in the Test Pane will ACTUALLY create that server. Just keep that in mind.

The Parameters section of the Test Pane for my Runbook looked like Figure 3.

Figure 3

image

With that String parameters, it is easy to just type what I want in the textbox. But, for the PSCredential parameter at the bottom, I was unsure what to do. I figured, since this is just a textbox, I couldn’t just magically pass in a Credential Asset. So, I tried passing in an expression that used the Get-AzureRmAutomationCredential cmdlet that returns the Credential Asset specified. That didn’t work very well. I then started digging through documentation, figuring I would see references and examples of passing a Credential Asset in the Test Pane. It took me a bit, but I finally landed on an Azure.com blog post titled Azure Automation: Runbook Input, Output, and Nested Runbooks. While this post didn’t match all that closely with the search criteria around the Test Pane, it did contain my answer in a section on starting Runbooks:

If a runbook parameter takes a PSCredential type then you need to pass the string name of a Azure Automation credential asset.  Behind the scenes, the Azure Automation credential asset with that name will be retrieved and passed to the runbook.

It turns out, I was not giving the super smart folks on Azure Automation team enough credit. It IS as magical as just putting the name of the Credential Asset in the textbox. While that section of text from the blog post did not mention the Test Pane, the Test Pane is essentially a means of running the Runbook currently in Edit mode without having to Publish it first. So, using the Test Pane IS running the Runbook. Therefore, the above worked just fine.

I learned some valuable things here:

1. Sometimes, the simple answer you dismiss because it is too simple is ACTUALLY the answer.

2. The Azure Automation team is very smart. I knew this one already. But this was a great reminder.

3. My kids have never seen Space Camp.

 

Out With It, Man!

Just put the name of the Credential Asset into the textbox for the Credential parameter in the Test Pane. For example, if your Credential Asset is named MyCredentialAsset, then the Test Pane could look like Figure 4.

Figure 4

image

Yeah. That’s really it.

Connect Suggestion: SSAS Tabular Images In Azure VM Gallery

7 July, 2016 (12:19) | Azure, Connect, SSAS, Tabular | By: Mark V

Greetings, noble readers.

Currently, when utilizing the SQL Server images in the VM Gallery in Azure, any installations of SQL Server Analysis Services default to Multidimensional. Thus, if you want SSAS Tabular, you have additional work to perform.

I was just chatting with a Senior Program Manager on the SQL Server Analysis Services product team. They currently don’t have anything in their plans for providing SQL Server Gallery Images with SSAS Tabular instead of Multidimensional. We agreed that it is a good idea for that to happen. We also agreed that a Connect suggestion would be a great way to gauge broader community support/appetite for providing Gallery images with Tabular installed.

<insert fanfare and trumpets and stuff>

Below is the link to the suggestion I made on Connect.Microsoft.com. If you agree that having SQL Server Images in the Azure VM Gallery with SSAS Tabular already installed would be a good thing, please vote up the suggestion as it will help the Product Team to justify the effort it would take to do so. If you don’t have strong feelings either way, please vote it up for those of us that do. Smile

Provide SQL Server Image in Azure VM Gallery With SSAS Tabular Installed

Your participation in this endeavor is much appreciated.

Thank you for your support.

Anyone Can SQL

10 May, 2016 (12:56) | Community, Professional Development | By: Mark V

I love the SQL Community. Plain and simple. I will extend that to the overall Microsoft Data community as well. We are a hugely supportive bunch. That fact that many of us refer to it as #SQLFamily is not an accident. There are so many ways to reach out for and provide help. A huge number of folks in this community blog and present and offer help on Twitter, StackOverflow, MSDN, etc. It is truly astounding to me the depth of help you can get from this community.

I get a lot of joy out of seeing people welcomed into the SQL Community. You want to learn SQL? Come join us. We’ll help. I love encouraging people to get involved. I often tell folks just starting out about how welcoming and supportive this community is. Sometimes they get involved and encourage others to do the same. Typically, it works out wonderfully for everyone.

Courtesy of ktylerconk on FlickrHowever, recently, I was told of a pretty terrible experience that happened at a SQL-related event. People with certain backgrounds were treated with derision and scorn. They were laughed at. They were told they would not be taken seriously in this community because of their extensive experience with database technologies other than SQL Server. This is the exact opposite of what this community stands for.

In Pixar’s Ratatouille, August Gusteau is a famous chef. He writes books, does interviews, etc. One thing he is famous for is his closely held belief that “Anyone can cook.” A key antagonist, and infamous food critic, Anton Ego, doesn’t agree with Gusteau.

Note: There will be some spoilers for the movie coming shortly. If you haven’t seen it, fix it. It is another fine example of Pixar’s spectacular ability to craft stories and characters that resonate. It’s charming.

Anton Ego prides himself on his ability to eviscerate chefs and restaurants with his scathing reviews. He raises himself up by tearing others down. In this sense, the name of the character is spot on.

It isn’t until near the end of the film, when he enjoys an amazing meal that takes him back to his childhood, a dish prepared by a chef who is a rat, that he comes to understand what Gusteau was talking about.

In his review, Ego writes, “The world is often unkind to new talent, new creations. The new needs friends. Last night, I experienced something new, an extra-ordinary meal from a singularly unexpected source. To say that both the meal and its maker have challenged my preconceptions about fine cooking is a gross understatement. They have rocked me to my core. In the past, I have made no secret of my disdain for Chef Gusteau’s famous motto: ‘Anyone can cook.’ But I realize, only now do I truly understand what he meant. Not everyone can become a great artist, but a great artist can come from anywhere. It is difficult to imagine more humble origins than those of the genius now cooking at Gusteau’s, who is, in this critic’s opinion, nothing less than the finest chef in France.”

My goal with this post is not to rant or to point fingers or to vent my or anyone else’s anger or disappointment over this situation. Rather, it is to remind all of us that EVERYONE is born knowing NOTHING about databases in general and SQL Server in particular. We all come from somewhere. I started with Access. I know many people who did. Some people started with FoxPro. Others with Sybase. Others with DB2, or Oracle, or FileMaker. The list goes on and on. The fact that we have such varying experiences helps to make the community rich and varied. Like Ego came to learn, we will not raise ourselves up by tearing others down.

The onus is upon us, in my opinion, to ensure that we can live up to the promise of this outstanding community and treat people who want to learn with respect and encouragement. The onus is upon us to apply Gusteau’s most cherished belief to our community as well: Anyone can SQL.

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.