Certified, as opposed to merely Certifiable

By -
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.

Comments

Post a Comment

Popular posts from this blog

Parsing SQLIO output with Powershell

By -
Anyone who has used sqlio knows that it's output files are not particularly readable. I used to manually run sqlio tests, then retype the output into a spreadsheet so that I could more easily analyze the data. This proved time-consuming, error-prone and boring, so I wrote a script that parses all of the data that I wanted from the sqlio output file. This post provides that code, and some background on how I use it. I will return to my series on my Powershell set up next time. The first thing to do is to run your tests with sqlio and get it's results into files. This is left as an excercise to the reader. I have a .cmd file that I use to do this. I use a .cmd file because most of the machines that I test do not have Powershell installed on them. I am including this file in the SQLIO.scripts.zip file. The reason that I break the running of the tests and the parsing of the output into two seperate processes is to decouple them. It can take quite a while for sqlio to run, especial...
Read more

What I'm working on now

By -
I hope that you are all safe in this time of COVID. I am (slowly) working through the "Automate the Boring Things (with Python)" class over at Udemy. I am keeping my code/notes/experiments in an open GitHub repository . You can read my raw files and see how I think when I write programs in a language I am not at all familiar with. I have also been (slowly) updating my old "Tools I use" wiki at github . This includes things like programmer's editors and some of the languages I have used over the decades.
Read more

In Memoriam: Azure Data Studio

By -
Recently, Microsoft announced that they will be sunsetting Azure Data Studio (ADS).  In other words, ADS is off to Software Valhalla, where it will join Query Analyzer and SQL Enterprise Manager. (And SQL Server for Itanium and SQL Server for Alpha and Multiplan and Professional Development System and QuickBasic and QuickC and many, many other things (Microsoft or not) that exist only as memories.) This announcement  was a bummer, but I was surprised at my lack of surprise. It was more of a "yeah, I guess that makes sense" rather than a "oh, wait-what?" or "I thought they were going to get rid of SSMS". Remember when Microsoft helpfully (?) installed ADS when you installed SSMS? I've been using SSMS since SQL Server 2005 When I started working with SQL Server, I used Query Analyzer because that is what was available. Which means that I used Query Analyzer for about six or seven years. How could it have been that long? No one remembers good old QA anymo...
Read more