Friday, January 26, 2018

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


What useful things did I do last week?


  • I caught up with Kalen Delaney's Weekly Webinar, up to and including Episode 11. These cover a variety of technical details on how SQL Server stores data and are probably too gory for newbs. I have been working on these talks for several months, on and off. Much of the material is familiar to me, but it's easy to forget details here and there. I did learn more about the implantation details of row vs. page compression.
  • I watched Advanced PowerShell Module Development with Visual Studio Code with David Wilson, again. I've never gotten PowerShell debugging in VSCode to behave properly and this will motivate me to take another swing at it.
  • I watched "What’s New for Business Analytics in Excel 2016", with Eli Schwartz. I can't find a Twitter handle or a blog URL for Eli.

I did start another two or three talks but gave up 15 or 20 minutes in because they weren't really what I was looking for or expecting.

I've also got a project going to "Pester all the scripts", so to speak. This helps me grow my Pester and VSCode skills.

Saturday, January 20, 2018

Keeping up with the SQL Server (things)

I've been a member of PASS for so long that I'm no longer sure when I actually joined. I attended PASS Summit 2004, which was in Orlando, FL. I must have been a member before then. I started with SQL Server in 1998. I feel like someone from the old, long-dead Swynk.com SQL Server email list suggested that I join.

(For the uninitiated, membership in PASS is free and you get access to talks from past PASS Summit events. Even though the talks are two or three years old, many subjects are still relevant and many people are still dealing with older versions of SQL Server. In short, you can get good information from some of the best-educated SQL Server experts in the world.)

I don't go to as many of the monthly meetings in Malvern, PA as I used to. The main reason for this is that there are many good online venues that provide good talks on SQL Server. My three favorite venues are:
  • PASS
  • YouTube (many PASS 'Virtual Groups' will publish monthly talks here.)
  • SQLBITS (look towards the right side of page, under "Conference").
Both PASS and SQLBITS post recordings of old sessions on their web sites.

Over the last several weeks, I have been going through the backlog of old PASS Summit 2015 videos. Here are a few stand-outs, with links to the Twitter feeds of the speakers, that I've watched over the last few weeks, in no particular order:
  • Kicking and Screaming: Replacing Profiler with Extended Events with Erin Stellato
  • Run Your DBA Morning Checklist with Policy-Based Management with Pieter Vanhove
  • PowerShell and the Art of SQL Server Deployment with Michael Fal
  • Testing SSIS Packages with Tim Mitchel
  • A Few Of My Favourite Plan Operators with Rob Farley
  • What's New in SQL Server 2016 Reporting Services with Riccardo Muti
The nature of the PASS site does not allow direct links so I can't point you directly at the talks, but it is easy enough to search for a talk after you log in.

It seems that the PASS Summit 2016 talks are already online. I've got another 25 talks from PASS Summit 2015 that I'd like to go through, then I'll be talking on the talks from 2016.

Lastly, but not least, I also watched a talk public by the PASS Business Analytics Virtual Group: