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

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



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

Using Powershell in a SQL Server 2008 job step

By -
I have been using Powershell since I first got wind of the beta and realized that all of my Windows Scripting Host skills would become obsolete.  However, I've never had the opportunity to try out the Powershell job step type for SQL Agent jobs until today. I know that the Powershell that "comes with SQL Server" isn't the same as the regular Powershell but, other than some fiddling around with the SQL Server file system provider, I've bumped up against those differences before. It's just different enough to be frustrating, so I'm blogging about it. It's a bit of a rant, but maybe it will save someone some time or someone can point out something that I've overlooked. My goal is to have a simple script that I can use in a SQL Agent job that can automatically discover and backup any SSAS database that exists on the same computer that as the SQL Agent. (This is an improvement over my old method, which used hard-coded XMLA queries to backup speci...
Read more

What to do about Google terminating Reader?

By -
So, at about 1 am this morning, I found out that Google is shutting down it's widely-used Reader application. I read four different takes on it (I think I saw it on BGR first) and only then headed off to Reddit. (It's all over the Internet now. Apparently, other writers recovered from the shock more quickly than I did.)   Ironically, I found out that Google was smothering Reader while using Reader.    This is particularly frustrating to me. I use Reader more than any other single thing. Reader channels probably 95% of my Internet interaction. I use it for a few hours every day. I use it at my desk. I use it during commercial breaks on TV. I use it when my wife falls asleep on the TV couch and when I can't sleep. I use it while waiting on line at McDonald's. I use it on commuter trains and on long car trips. It's a constant companion, I've spent more time with it than any pet and nearly any human. If my phone is charged and I'm not doing someth...
Read more