The official PASS Blog is where you’ll find the latest blog posts from PASS community members and the PASS Board. Contributors share their thoughts and discuss a wide variety of topics spanning PASS and the data community.

Data, AI and Cloud: The Top Data Jobs of Tomorrow

Good news for the PASS community. World Economic Forum’s 2020 Future of Jobs report continues to forecast an exceptionally bright outlook for Data, AI, and Cloud Computing professionals. The Jobs of Tomorrow: Mapping Opportunity in the New Economy examines digital era changes and top emerging professions. World Economic Forum sourced the data from partnerships between New Metrics CoLab, Burning Glass Technologies, Coursera and LinkedIn. Let’s peek at the highlights.

Read more

Speaker Diversity Analytics with the AI Face API

How do we increase diversity amongst our event speakers?  To improve something, we must first measure it.  The Face API allows us to collect some of these demographics from past events that we may not otherwise be able to collect, which may allow us greater insight into how we can improve these trends.

The Facial Recognition API is part of the Microsoft AI Cognitive Services suite.  The Face service detects human faces in an image and returns the rectangle coordinates of their locations. Optionally, face detection can extract a series of face-related attributes. Examples are head pose, gender, age, emotion, facial hair, and glasses.  The Face API is Azure based and is a subset of the Vision API functionality.  To leverage the Face API an image can be programmatically sent to the API via a number of languages.  Along with the image file, the caller can also submit parameters detailing which subset of return values to send back.

Read more

Go Azure SQL!

Pardon the pun in title here, but the goal for this post is to introduce how to start interacting with Azure SQL through Go (https://golang.org/), an open source programming language gaining lots of traction in developers’ community thanks to its simplicity and efficiency in scenarios like microservices and server apps (did I mention that Kubernetes itself is written in Go?).  

Azure SQL provides full support for Go developers on both control plane (deploy, manage and configure Azure SQL servers and databases), and data plane activities (connect, execute commands and queries against Azure SQL instances) through Azure SDK for Go and Microsoft SQL Server Driver for Go.

A companion code sample for this article, written using VS Code, can be found here.

Read more

February Board Meeting Recap

We hosted our first in-person PASS Board meeting of 2020 in Kirkland, Washington, from February 3-4. This was also our first in-person meeting with newly appointed Board members Mindy Curnutt, Melody Zacharias, and Hamish Watson. We look forward to their experience and insights as we continue to work together on the Board.

To kick off the meeting, we reiterated our commitment to our FY 2020 priorities and focusEducational Content, Accessibility, and Engagement. These pillars provide us with a strong foundation to grow our organization, and will allow us to pivot as needed in the future to support our membership.

Read more

#SQLLove Story

COMMUNITY MEMBERS SHARE HOW THEY FOUND LOVE AT PASS SUMMIT

While people attend PASS Summit for many different reasons, including the fantastic speakers or opportunities to network, most don’t come expecting to attend a wedding.

Tamera Clark and Kerry Tyler started dating after meeting at Purdue University in Indiana. Both working as data professionals, they both dreamed of the day where each of their respective companies would pay their registration fees to attend PASS Summit. They started an inside joke saying “it’s all fun and games until you go to PASS Summit,” and told one another that if they ever got the opportunity to attend the conference, they would get married there. It was October 2011, when they finally got their chance.

Read more

How to Pass a List of Values Into a Stored Procedure

Say we have a stored procedure that queries the Stack Overflow Users table to find people in a given location. Here's what the table looks like:

And here's what my starting stored procedure looks like:

Read more

Handling Flexible Search Needs Using Stored Procedures and Dapper

Introduction

Data access from applications has traditionally followed one of two routes: either using stored procedures or using ORMs. Both have their advantages and drawbacks. In this article, we look at how to handle flexible searching needs using the stored procedure approach.

Problem

Traditionally, even systems that perform data access only through stored procedures face challenges when it comes to searching data. While simple CRUD is easy, searching on multiple fields can lead to one of several suboptimal solutions. Developers may introduce a stored procedure for each search combination – this often happens when a system evolves its search capabilities – or they may introduce branching logic to existing stored procedures, or they may decide to introduce an ORM just for searching, such as Entity Framework or LINQ-to-SQL.

Read more

PASS Summit: A Big Part of My Life

I attended my first PASS Summit in Seattle in 2003 after about eighteen months in my job as a DBA. SQL Server Central had a post about a price increase coming up for Summit, and I showed the information to my manager not really thinking she would approve. Attending the conference meant a week away from the office as well as the expense of the conference and travel so I was thrilled when she said yes.

Read more

What’s the Secret to Long-Term Career Success for Technologists?

The US Department of Defense spends massive amounts of money every year on research for ways to improve leadership, team cohesion, and goal achievement. That makes a lot of sense, of course, because there are few organizations where failure in these areas have a greater potential for loss of lives. One fascinating area of research set out to answer the question “Among cadets at the DoD’s flagship universities, what metric is the best indicator that they will go on to become generals/admirals?”

Read more

Filling a Vacant Board Seat

I wanted to share a change to the composition of our current PASS Board. Jennifer Moser has resigned from her role as a community elected Director-at Large on the Board and this resignation has now taken effect.

When a Director-at Large seat becomes vacant outside of a standard election cycle, the PASS Bylaws indicate that the Board of Directors may appoint a candidate for up to one year, by a majority vote, to fill the remainder of the term until it can be added to a general election.

Read more

RSS
12345

Theme picker

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids