By -

If you want to see a cool ten-minute, "lightning" demo of how you can use PowerShell and Excel together to analyze data or produce nice reports, watch this YouTube video, from 7:47 to 18:22. This is presented by Doug Finke, the author of the Import-Excel PowerShell module.

Comments

Post a Comment

Popular posts from this blog

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

News Flash: Old dog learns new tricks (or tries to)

By -
Lately, I have been trying to up my game a bit and one of the things I am doing is using some of the latest tools and bits of things. (Partly, this is because I have been working with some old technology lately and I am feeling "dated". Ask me about Fox Pro, if you dare.) PowerShell After many years of not seeing value in updating, I am moving to PowerShell 6. (Version 6.2, specifically.) Frankly, more things work than I expected. I haven't seen any performance regressions and things have gone smoothly. I think I spent more time incorporating the PowerShell version into my Prompt function than anything else that I had to do because of the upgrade. SSMS I am running the absolutely-latest build of SSMS. I skipped some SSMS builds when the removed the diagramming functionality. Now that it has been put back into the product, I am on the update train again. Aside: The diagramming feature isn't awesome but it is easy to use, requires no installation, doesn't ...
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