Sunday, May 27, 2018

What I did for the week ending 2018/05/26


I am slowly going through all of the PowerShell + DevOps Global Summit 2018 talks that I find interesting.

I took advantage of the following learning opportunities:

  • Whip Your Scripts into Shape: Optimizing PowerShell for Speed by Joshua King on YouTube
  • Application Provisioning with DSC and Octopus Deploy by Josh Duffney on YouTube
  • PlatyPS: PowerShell Help meets Markdown by Sergei Vorobev on YouTube
  • Defending against PowerShell Attacks-In theory and in practice by Lee Holmes on YouTube

Friday, May 25, 2018

Certified, as opposed to merely Certifiable

I passed the 70-767 Implementing a Data Warehouse exam this week.

I first read Kimball's Data Warehouse Lifecycle Toolkit and The Data Warehouse Toolkit over fifteen years ago, so it's about time. I still have those books, although many other books have hit the recycling bin. A lot of the underlying technology has changed in the data warehousing area, but a grounding the basics of facts and dimensions is still important.

I passed the exams for Querying Microsoft Server 2012/2014 and Administering Microsoft SQL Server 2012/2014 Databases, a while back. My Microsoft Learning dashboard points tout that this third success qualifies me as a "Microsoft Certified Professional". The last time I was Microsoft-certified in anything was in 1998, when I had a certification in Windows 98 desktop support, or some such thing. I don't think I ever did anything with that.

Co-incidentally, I used the last of my last business cards while attending a talk on Machine Learning at Jacquette Consulting on Wednesday. It must be time for new cards.

Sunday, May 20, 2018

What I did for the week ending 2018/05/19

Here are the learning opportunities that I took advantage of last week:

  • The Build Release Pipeline Model for Mere Mortals by Ryan Coates on YouTube
  • PowerShell Team: Inventory Your Server Environment and Detect Change at Scale by Jenny Hunter on YouTube



Sunday, May 13, 2018

What I did for the week ending 2018/05/12


Here are the learning opportunities that I took advantage of last week.

Due to my interest in and use of DbaChecks, I need to get a better handle on PowerBI:

  • Introduction to Power BI Desktop with Dustin Ryan on YouTube


PowerBI seems to be the only reasonable way to visualize the results of the tens of thousands of tests I'm running.

I could not resist watching a several things from the PowerShell + DevOps Global Summit 2018. The following are all from the Global Summit:

  • Beyond Syntax: Pester Testing with Dave Wyatt on YouTube
  • Keynote: State of the Community with Don Jones on YouTube
  • PowerShell 2018: State of the Art with Jeffrey Snover on YouTube
  • A Historical Architectural Tour of PowerShell with Bruce Payette on YouTube
  • Become a PowerShell Debugging Ninja with Kirk Munro on YouTube

I don't usually listen to things like keynotes, but I find that Don Jones and Jeff Snover always have something valuable to share.

I am surprised with the renaming of PowerShell Core to PowerShell. I am sure that won't be confusing to casual scripters. /s

If you'd like to keep tabs on what I am watching more closely, you can head over to the official Ashdar Partners twitter feed. I am not big on chitchat. It's mainly YouTube sharing what I watch and (what I hope are mostly) quality retweets.

Sunday, May 6, 2018

What I did for the week ending 2018/05/05


I took advantage of these learning opportunities:

  • Building Your T-SQL Tool Kit: Window Function Fundamentals with Christina E. Leo on YouTube
  • SQL Server Query Plan Analysis: The 5 Culprits That Cause 95% of Your Performance Headaches with Adam Machanic on YouTube
  •  Beyond Pester 101: Applying testing principles to PowerShell by Glenn Sarti on YouTube.


The PowerShell + DevOps Global Summit has released their 2018 videos (62 in all!) and all I want to do is watch PowerShell videos all day. Life intervenes, however...



Sunday, April 29, 2018

What I did for the week ending 2018/04/28



I attended SQL Saturday in Blue Bell, PA. Specifically, I attended these sessions:
  • Effective DW Storage Patterns with Miner
  • Azure SQL DW Migrate On-Premise to Cloud, with Zhang
  • Extending DevOps to SQL Server with Fritchey
  • Data Governance and Master Data Management, with Napoli
  • Successfully Running SQL in AWS, with Carrig


I took advantage of these additional learning opportunities:
  • I watched Creative Uses of the APPLY Operator, session 1, with Itzik Ben-Gan at SQLug.se on YouTube
  • I watched Creative Uses of the APPLY Operator, session 2, with Itzik Ben-Gan at SQLug.se on YouTube

Sunday, April 22, 2018

What I did for the week ending 2018/04/21

The big thing for this week is SQL Saturday #714, which will be held at Montgomery County Community College on 4/21. I'm writing this post a little early, as I won't have time to write over the weekend.

The time I had planned to spend on finishing up 70-767 has been taken up by finishing up the annual and quarterly book keeping and a strange issue with my backup laptop (an old Core Duo ThinkPad T500) refusing to update to a recent version of Windows 10. If I get the laptop working, I will post a more detailed entry. Unfortunately, I'm starting to think that it's time to retire the old workhorse or put Ubuntu on it.