Ethics in Data Science and Artificial Intelligence

Microsoft redid its Data Science Track not too long ago and they added several courses and new progress points. One of those progress points is Apply Ethics and Law in Analytics and the course to cover this point is Microsoft DAT249x: Ethics and Law in Data and Analytics, offered through edX.

I’m enjoying this course even though it’s not a hard-core data analysis one. This course is great because it asks the questions about how data should be used, what biases might be present, and how we look at both before moving forward both ethically and legally. Even if you aren’t working on the data science track, if you’re a data professional of any type, I would recommend taking this free course (assuming you are only auditing and not looking for the certificate).

As a segue with respect to the importance of this course, once upon a time I was a college student who became hooked on Sociology. I had a professor teaching his last semester before retirement and I had two courses with him: Introduction to Sociology and Criminology. He had worked with police departments much of his professional life, and I remember how much he talked about bias not only in the data, but also how it was collected. He also talked about bias by proxy, though he didn’t use that phrase. A proxy is where you don’t want to use one statistic, such as race, so you find something that isn’t called race but effectively gives you the same thing because there’s a strong correlation between the two. An example is zip code here in the United States. We tend to live more segregated than we’d like to admit, so if you’re making decisions based on zip code with respect to people, much of the time you’re actually making decisions about race. This course looks at those types of things – topics that are easy to overlook as we got caught up in our analyses.


How do I ask for SQL Server help on Twitter?

For those of us who have been on twitter for a long time, we are familiar with the #sqlhelp hashtag. However, I was giving a presentation to a user group last night and came across a case where folks in the room didn’t know about the hashtag. I mentioned this was available when someone indicated they were basically a one-man shop and wanted to get more help. That person said he didn’t know about it. Another indicated she hadn’t heard of it, either.

So if you’re in the SQL Server community and you are stuck on a SQL Server related-issue, try out the #sqlhelp hashtag. Try to define your issue as clearly as possible. Likely you’ll see a group of folks with expertise jumping in. That’s one of the great things about the SQL Community: the willingness to help one another.

Free Training: Videos from Tim Mitchell

I’m always on the looking our excellent training, especially free training. Tim Mitchell, Microsoft Data Platform MVP, (twitter | website) has a number of great videos available on YouTube around SSIS and ETL. Definitely spend some time checking them out!

Tim Mitchell’s YouTube Channel

Tim is a great teacher who breaks down into digestible chunks. His examples are clear and to the point. Therefore, if you’re looking for training videos on SSIS and ETL that you can put into practice right away, Tim’s channel is a great resource.

Slides and Scripts from IT/Dev Connections

If you attended either of my presentations for this past IT/Dev Connections, here are the promised slides and scripts.

As I mentioned at the presentation, there’s nothing special about the scripts, so feel free to use them as you’d like.

Top Down SQL Server Security (.zip file – 815 KB)

SQL Server Forensics (.zip file – 786 KB)


Upcoming #SQLChat on Making the Most of Conferences

This month’s #SQLChat is hosted by Rie Irish (twitter | blog). It’s a timely topic: Making the Most of Conferences. With the PASS Summit just around the corner, this is a great way to get you thinking about your activities and how to get as much out of attending as possible. Participating is easy! Simply follow the #SQLChat hashtag on Twitter.

The #SQLChat is scheduled for Wednesday, October 24, 2018, at 11 AM Central Time (convert to your time zone).


Rescheduled Performance Troubleshooting Webinar

With Hurricane Florence no longer a hurricane, we have rescheduled the webinar for next Wednesday, September 26, 2018.

Free sign up for the webinar!

Here is what I’ll be covering:

How do go about finding poorly performing SQL Server queries in your environment? And once you find them, what can you do about them?

In this webinar, I will show you the built-in functionality within SQL Server that will help you identify these problem queries on your system. We’ll also look at some cases where SQL Server is collecting data which may reveal an issue even if you don’t happen to catch the query in flight. Finally, we’ll look at the steps to tuning those queries so your overall system will perform better.

Midlands PASS Reboot!

If you’re in or near the Columbia, SC area, we are rebooting the Midlands PASS Chapter. Here is our first meeting information.

Oct 2, 2018

5:30 PM – Meet & Greet
6-8 PM – Technical Presentation by K. Brian Kelley


440 Knox Abbott Drive Suite 425
Columbia/Cayce, SC 29033


Please RSVP if you’re able to attend:

Midlands PASS – RSVP Link


Since this is a restart, we don’t have a member list. Please share that we are restarting.

Previous Older Entries Next Newer Entries