Finding Max Concurrent Operations With T-SQL (Part 2)

Last Time On 36 Chambers Yesterday, I wrote a large number of words to give us some sample data that we could use today. To give you a quick reminder of the problem we're trying to solve, we can have multiple concurrent work items processing for a customer, but we want to limit that number to…

Finding Max Concurrent Operations With T-SQL (Part 1)

Not too long ago, a co-worker had an issue that he asked me about.  The gist of it is, we can have multiple concurrent work items processing for a customer, but we want to limit that number to 2.  The development team wanted to make sure that their code was working as expected, but they…

PASS Summit 2018 Evaluation Ratings & Comments

Following up on Brent Ozar's post on the topic, I figured I'd post my own ratings (mostly because they're not awful!).  This was my first PASS Summit at which I was a speaker, so I don't have a good comp for scores except what other speakers publish.  I had the privilege of giving three presentations…

What Comes After Go-Live?

This is part eight of a series on launching a data science project. At this point in the data science process, we've launched a product into production.  Now it's time to kick back and hibernate for two months, right?  Yeah, about that... Just because you've got your project in production doesn't mean you're done.  First…

Deploying A Model: The Microservice Approach

This is part seven of a series on launching a data science project. Up to this point, we've worked out a model which answers important business questions.  Now our job is to get that model someplace where people can make good use of it.  That's what today's post is all about:  deploying a functional model.…

The Basics Of Data Modeling

This is part five of a series on launching a data science project. At this point, we have done some analysis and cleanup on a data set.  It might not be perfect, but it's time for us to move on to the next step in the data science process:  modeling. Modeling has five major steps,…

Data Processing: An Example

This is part four of a series on launching a data science project. An Example Of Data Processing Last time around, I spent a lot of time talking about data acquisition, data cleansing, and basic data analysis.  Today, we're going to walk through a little bit of it with the data professional salary survey. First,…

Data Processing: The Other 90%

This is part three of a series on launching a data science project. The Three Steps Of Data Processing Data processing is made up of a few different activities:  data gathering, data cleansing, and data analysis.  Most estimates are that data scientists spend about 80% of their time in data processing (particularly in data cleansing). …

Building Business Understanding

This is part two of a series on launching a data science project. How Is Babby Data Science Project Formed? Behind each data science project, there is (hopefully) someone higher up on the business side who wants it done.  This person might have been the visionary behind this project or might simply be the sponsor…

The Microsoft Team Data Science Process

This is part one of a series on launching a data science project. This is the beginning of a series of posts around growing a data science project from the germ of an idea to its fruition as a stable oak.  Before I get into the process, I want to start with a few data…