Live Blogging from WIT Luncheon October 29

UPDATE: Watch the recording of the original session.

Denise McInerney introduces Angie Chang.

She started a networking dinner for women. Started Women 2.0. Organized conferences of 1000 women. Hackbright found her to organize a geek dinner. She joined them.

You can become a software engineer after a 3 month bootcamp. Women can become managers and CTOs in a few years if mentored. Hackbright is training technical and leadership skills.

Hackbright was started by people who attended a bootcamp. Women learn differently. They started experiments of 10 week women only class. The women got jobs after the class. The team has grown, the curriculum has grown. They are teaching several languages and work in teams and ask questions.  100 software engineers donate 1 hour per week to help these women.

What does Hackbright do differently? Pair with a programmer. All women programming school. It has a very casual environment.

Mentoring with women professionals is key.

Several women through the program have been promoted to engineering management. One former student now comes back and hires new engineers from Hackbright. Quite a few have been promoted. Former admin assistants and more are now engineers.

Partner companies help students improve resumes and interviewing skills. They have a career day and the partner companies meet the students. Facebook sponsors a student. Intuit has a scholarship.

Girl Geek dinners started in London in 2006. She started in the Bay area. Google sponsored the first dinner in 2008. 400 attended the first event. They have 2 or 3 a month. It’s a great networking event, and women professionals speak. Often people hire from this event. It sells out in 5 minutes.

It’s a leaky pipeline, not a pipeline problem. Need to train managers to hire for diversity. It’s a retention problem.

The Hackbright alumni have a great community and network. They have a support system. This helps stop the leaky pipeline.

One of the alumni started the “I look like an engineer” campaign.

An engineer was always hearing “you don’t look like an engineer”. She started the program and many Hackbright alumn are in the photos on bill boards.

Enroll your daughters in robotics and tech camps. Talk to your kids about roles. Buy engineering toys and books. Don’t tell girls that they are going to break things if they touch things. Encourage girls to be a tomboy. Send the kids to science and technology camps. People are not sending girls.

You can get involved as a mentor or sponsor or partner company. They can help with senior talent as well as new developers.

12:41 Time for questions

Our education system. She took AP Computer Science in high school. A company promotes robotics with high school girls. Technovation — girls pitch a product that they think of.

What is hackbright doing to help high school kids? They can talk to mentors. HB gets mostly career changers, not people right out of high school. They have night classes for women, an intro to programming class. HS girl can attend. Workshops and hackathons for all ages.

Are there plans for other programs? They are now focused on software engineering. It’s a high paying job and women are needed. May expand in the future.

Are degrees important? It’s in the job description. It’s not encouraging for women. It would be better to hear about their experience than asking about a degree. Women don’t apply if they don’t meet all requirements. Job descriptions need to be more accessible.

Everyone here should be mentors. There are so many things for coders. Data is missing from these. Let’s get database mentoring going.

Will Hackbright scale out to rest of the country? They are focused on San Francisco now, but may expand next year. Talking to companies about growing women into managers.

What is the atmosphere in all women learning? Women are more supportive. There is a great energy. They go to meetups, they organize events. They give back.

What is the advantage of having more women in male majority teams? Diverse teams have better results. They are high paying jobs and women want these jobs. They go out and inspire others. Tech is often for women consumers.

Makers groups around the countries, learning robotics and programming. Males look at women with different eyes when the women build cool things.

Males start out interested in tech by playing games; how do we encourage girls to play video games? Girls are playing Minecraft which is great for learning programming. There are lots of games on iPad to learn how to program games.

How to get women to speak at events? Invite them. Women will often not apply because that feels like bragging.

Is the term “girls” insulting when applied to professional women? The Girl Geek term started in UK because they are “cheeky”. There are better things to worry about.

How to get IT culture more accessible for women? Managers need to learn about unconscious bias. This happens in teams. Have team take implicit bias test. Results are surprising. They need to track managers to see which actually promote women and reward those who do.

How do we expand to smaller towns? They are a school  but don’t have unlimited resources. There are many organizations who send speakers. Bring girls to the workplace so they can see what working in tech is like.

Do you have mentors for your new mentors? Yes, we do train our new mentors. Be careful how they criticize. Their job is to mentor and be supportive.

Thanks to SQL Sentry for supporting the event. Thanks to Angie! Bringing out a gift basket with PASS and Seattle swag. There is a meet and greet.

Her Twitter @thisgirlangie

 

 

 

 

 

Posted in Uncategorized | Leave a comment

Live Blogging PASS Summit Keynote October 29

8:21 Video of community members.

Adam Jorgensen, Executive Vice President of PASS

He will be president as Tom retires.

PASS needs to grow leaders. He is covering the financial aspects of PASS. Revenue is up 10%. Summit is the biggest part of revenue. But, it helps us deliver education programs all year. Attendees doubled since 2007. Events are growing as well. 99 SQL Saturdays in FY 2015.

PASS is a community for all data professionals. 150K members from 163 countries. We cover 86% of the countries around the world.

Our money is spent on many educational community programs. Reserves of 1.14 million. These are earmarked as a rainy day fund, for example a natural disaster cancelling summit.

They will start publishing portfolios of the financials. In 2015, several goals including establishing venue for Summit though 2019. It is in Seattle.

In 2016, there will be a redesign of the website.

Amy Lewis is out outgoing board member. Thanks, Amy!!

8:33 Denise McInerney , Vice President of Marketing

Thanks, Bill Graziano! He has been a member of the board for 10 years. He is retiring as Tom moves into the past president role.

Bill receives award. He is in his kilt.

PASS would not exist except for volunteers. 71 have been nominated for outstanding volunteers since 2012.

The PASSion award! This is the highest award at PASS. 10 people were nominated this year.

It’s Lance Harra!!!!!

Interested in volunteering? Stop by the community zone.

PASS TV has 2 channels streaming. 3K are watching.

New Foundation Sessions.

You can take advantage of SQL Saturdays and virtual chapters. 38 languages!

WIT Luncheon today. Angie Chang will be keynote speaker. VP of Hackbright.

Community Appreciation party tonight at EMP!!

Birds of a feather lunch tomorrow. You can eat lunch with people with same interest.

Speaker Idol continues.

Next year, we are back in Seattle, October 25 – 28.

8:44 David DeWitt and Rimma Nehme from Jim Gray Systems Lab

Rimma — Based on feedback both will do keynote together.

Rimma is appetizer, David is entrée, Rimma is desert (the best part).

IOT, Databases and a word starting with F.

They are not announcing a product. this is only educational.

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

Sensors + Connectivity + Big Data = New services + Optimization.

Two types of IOT. Consumer like appliances or wearable. Industrial, factory, grids.

You can learn a lot from a person by monitoring.

Value from Industrial IOT – unconvential revenue, incremental revenue plus operational efficiency.

4 types of IOT: capabilities. Monitoring, Control, Optimization, Autonomy

We are in the terrible twos of the IOT development.

Why IOT? We are in the peak of hype cycle.

IN 2008 the number of things connected exceeded the number of people on Earth.

The power of 1%.

8:55 David DeWitt

Technical Challenges: variety of sensors, 50 B devices, dirty readings, volume of data, security, offline devices can’t receive message, setup and maintenance

David is interested in the industry side. On consumer side you need a low cost device and battery. On industrial you have money and unlimited power and wired.

One size fits none. One application won’t solve everything. IOT is DIY right now.

The device has a sensor and actuator. In the cloud there is an event/data aggregateor. D2C.

Once in cloud can feed to application, can store for later. can use real-time processing engine. A message can be sent back to device. C2D commands.

Azure IOT – Azure IoT hubs and Event hubs.

Data management — Azure stream analytics, document DB, SQL DW, hdinsight, machine learning.

Visual applications, excel and PowerBI

Real time event monitoring runs over a stream of data.

Azure IOT Hub, cornerstone of Azure IoT

Routes events as they come into devices. Scalable to millions of devices. Per-device authentication. sends commands back to the devices.

You can store events. An event consumer pulls messages and stores them. They can go to SQL Azure, or HDFS, or Azure storage, or DocDB.

Use events to learn. Azure Machine Learning models. Predictions. Use a real time query engine: Azure Stream Analytics (similar to Stream Insight). Apache Storm on HDInsight.

A real time database system is streaming. Query operates over events. A window of a time. For example, look at pressure over last 60 seconds.

Event to action. IDs of boilers with too high pressure to boiler control program that opens the release valve.

He is holding a Raspberry PI. It can run SQL. Field gateway. Sends sensor readings to IOT hub for devices that can’t send signal. For complex objects like smart car with multiple sensors.

The field gateways are processors with memory and communication.

Metadata management. it is not stored in metadata. So, you can’t query it.

Device security. Per-device identities to authenticate D2C. Devices must pull to get C2D commands. Reduces attack surface.

Pushing to the cloud, lots of problems. Connectivity, latency, data deluge, etc.

Exploit the capability of the field gateway to help solve the problems. It is running streaming engine. Install the boiler control program. The events don’t have to go to the cloud. Send only specific info to the cloud and store in Azure.

9:22 Rema

Fog computing. Computing on the edge. Move computation to the data.

IOT is a database problem and networking problem. Not a db-centric problem.

Build on existing Azure services. Vision: Polybase for IOT. This is not a product announcement. We need to ask for this and maybe they will build it.

VISION

Declarative language. IoT-SQL? Query the devices like a regular table.

Modeling complex objects

Scalable metadata management – IoT Shell

Querying devices. Execute once, Execute forever. Also Execute Action query.

Execute once is done mostly in the cloud.

Execute forever query, runs over a time window. Execute on device. Push interesting data to cloud.

Execute action, perform on device, push results to clouds.

Multi-purpose querying “multi-sink” query. Results go to different targets.

Why should we care? The amount of data to manage is exponentially going up.

This is their last PASS keynote. They have done 8 keynotes. It is time for new speakers. Rima is taking a new assignment. David is retiring. We will hear about Rima for years to come. PASS keynotes has been a highlight of his career. The community is amazing.

Standing ovation!!

Posted in Uncategorized | 1 Comment

Live Blogging from PASS Summit Keynote Oct 28

I will be live blogging this morning from PASS Summit. Check here for updates!

8:21 The intro welcome has started! Welcome to PASS Summit 2015! PASS President Thomas LaRock is speaking first!

This is the 16th PASS! 58 countries 2K companies!

This is SQL Family, our family reunion. Connect, share, learn!

Visit the SQL Clinic to talk to the people who make SQL Server, the best data platform on the planet. (I guess you will be on your own on Mars).

Ryan Adams (Linchpin Teammate) is the newest board member!

8:25 Board Q&A on Thursday at 3:30.

In Orlando 2004, only 1,730 registrations. This year, over 5000. We are here with a desire to grow. Summit is a key part of the journey. The people you meet will help you shape your career.

We love data more than is healthy. But data is the life force of companies. PASS has helped Tom get his dream job.

Volunteers are the backbone of PASS. PASS is the gold standard for communities in the world. We help others before we help ourselves. Get involved!! Check out the community zone to meet people from your chapter and around the world. Connect with us!

8:30 New this year: Workshops! Check out Get to Know PASS with community sessions. Speaker Idol this year!! WIT lunch on Thursday with Angie from Hackbright academy. Birds of a Feather on Friday.

Tomorrow night, EMP, including Karaoke with a live band.

8:32

Take time to visit our sponsors! Thank them for supporting PASS!

Tom is proud to be a member of PASS SQL Family

8:38

Joseph Sirosh, Corp Vice President of Data platform.

Data used to be linear. Now data is digital and is increasingly in the cloud. 50 million petabytes of data.

Now we are in the age of data.

Video about healthcare. Data from home is collected. Cortana Analytics to look for problems. Patient is reminded of medication, etc.

8:43

Use analytics to predict health crises before they happen to prevent heart attacks, etc.

Our DNA is big data. A person is 2 GB of data in DNA.

First sequence of genome took 10 years and too 100 million dollars. Now it costs about a week and $100. In the future, the doctor will analyze your DNA.

He received from 23andMe his genome. They ran analytics on his DNA using R to see risks of disease. He is 3x at risk for prostrate cancer. He knows that so can be proactive.

8:48

DocuSign for signing documents. 50 millions uses. It runs on SQL Server!

Eric Fleischman, Chief Architect at DocuSign.

The data doubles every year. That is impressive and scary! After he joined they made major changes including flash storage and upgrades. Tons of engineering changes to app as well. Availability Groups, too.

Original schema had lots of bad choices.

They looked at open source, but SQL Server made more sense. They had the expertise and counted on MS to help. One throat to choke!

8:53

Running telemetry system to see how system is running.

They are looking at SQL 2016. Always encrypted is big. They are using 2016 already.

8:55

Joseph Sirosh: Engines of Data

Mission critical OLTP, High performance DW, end to end mobile BI, Advanced analytics

SQL Server 2016 has all the pieces. Innovate first in the cloud, then on premises. MS is the only company doing this.  The community has helped make SQL #1.

MS data platform is the Gartner leader.

Video of MVPs talking about SQL Server. Stretch databases, Always Encrypted, R support. It’s amazing!

9:01 Shawn Bice, General Manager Database Systems Group

Companies who embrace data are going to be more competitive than those who don’t. SQL Server 2016 is powering Azure today. They are learning a lot about what works and doesn’t work.  Petabytes of telemetry.

2016 will be the best release in its history. 7 big bets.

Everything is built in, from mission critical to analytics.

Telling story about a light rail system running on SQL. SQL Server is the most secure platform. Runs some of the biggest data warehouses in the world. Mobile BI is built in to SQL Server. The BI will run on all platforms.  In database advanced analytics. R + in memory. R is the choice for data scientists. The language used in medicine and science.

Consistent experience from on-premises to the cloud.

DocuSign had requirements for AG. Those requests will be in 2016. Better compression, parallelism. Easy set up, even in hybrid. Domain joining not required (because of db mirroring). Round robin load balancing. This is used in Azure today.

9:11 They are failing  over daily. A fire in a data center in China caused them to fail over all databases.

Polybase for T-SQL over Hadoop. Create an external table in Hadoop, then use t-sql.

JSON support.

Real-time analytics. Real-time is the ability to learn and adjust as things are happening. Old way has a lot of steps. Now combine in-memory with column store. Use R to add intelligence. R is the language of statistics. Embedded R in SQL for real-time analytics.

9:17 Rohan Kumar, Partner Directory, Engineering

World map with customer engagement. Transactions happening now. Time for a demo!

HP Super Dome. running a proc that is part of the world map process. A single query is fully utilizing CPUs in parallel.

Real time dashboard showing transactions per minute and reward points. Request to see your reward points in real time, not waiting a month. Older way has a lot of moving parts. They are using an updatable non-clustered column store index. No impact against system.

Showing execution plan. It is only touching the column store index, not table. Impact to OLTP queries is very low.

Europe has the lowest transactions, but highest points. What is going on? Showing month over month points. October is sig higher. Alerting system tells something is wrong. Used to detect fraud. They are not pulling the data out of SQL to analyze it. That’s not real time.

Advanced analytics (R language) to avoid pulling data out of SQL for analysis.

Showing script that has R. Can grab the R syntax from anywhere. Tons of algorithms available. It runs fast!

Using this with in-memory and column store is really fast!

9:30 Shawn Bice

Security — lots of new features. TDE is built in. Auditing. Data masking. Always Encrypted.

Man in the middle attacks, reads memory. Hard to detect. Always Encrypted closes that gap.

To set up, run a simple wizard. All encryption happens client side. Master key is client side. Need to use a new ADO.Net library. Replace the data with cipher text. The client app works with SQL for this.

9:34 demo

Rohan.

October was more rewards than normal. Click on the bar graph. Shows Sally Jones has excessive reward points.

Runs query and some columns encrypted. Creating a trace to show that the column is encrypted in the buffer pool.

How to we change existing application to work with this?

Runs a query with data, CC, in clear text. Right-click table and kick off wizard. Choose the columns to encrypt. Can choose if determistic so can be searched. That’s all the DBA needs to do.  Now when he runs the query, the columns are encrypted.

I’m still not clear how existing apps will work with this.

9:41 Shawn

Stretch databases.

Where to put old data that is not needed frequently? Table goes straight to Azure. It’s cheap to do compared to storing on premises.  It’s completely transparent to the app. Compatible with Always Encrypted.

9:44 Rohan

Looking at customers with reward points. Sally Jones has the most reward points. Click to see Sally’s history. Six months of data is on premises, history is in the cloud.

There is a wizard for enabling Stretch on a table. Need to specify the Azure subscription and logical server name. Used Cortana to sign in, 2 step authentication. That was cool. There are many security steps built in during this wizard.

We need two tables with same schema. One is local, one is in cloud. The query against the stretched table takes a little longer. The execution plan shows it as Remote Query.

9:50 End to end mobile BI on any device

SSRS has been completely overhauled! That is news!

9:51 Joseph

Let’s give the team a big hand! Lots of good stuff in 2016.

Innovation for the future. The cloud gives a way to innovate very fast.

Features are built-in to SQL Server. Don’t buy pieces. But, in my experience the good stuff is always on Enterprise Edition.

We are in the age of Data. Intelligent devices will impact our lives. The cloud is making this go faster.

This is the age of the data professional. Woo hoo!

That’s it!

Posted in Uncategorized | Leave a comment