Another week and another tip for Excel using Powershell. This post was inspired by one of my readers (thank you Harsha). Conditional formatting is important, however by default we change the look of the cells that have specific values. What about changing the entire row if a specific cell meets certain conditions? Preparation Let’s prepare…Read More How to format an entire Excel row based on the cell values with PowerShell?
This blog post is part of the Festive Tech Calendar. If you want to practice the whole thing I have prepared an interactive notebook for you that could be opened with Azure Data Studio for example (link to the notebook). For more things about the PowerShell module check this post out. I would like to…Read More The MS Excel: An Unexpected Journey with PowerShell
While ago I have posted an introduction to the PowerShell module to manage Excel. This year I have created a series about dbatools.io. This week winter has come to this part of the world and I thought that a bit of PowerShell magic can be used to warm up our data hearts. This winter I…Read More How to Excel with PowerShell (ImportExcel)
In this series I would like to give you some examples of the power of PowerShell module to manage Excel files without MS Excel being installed on the server – it is ImportExcel I have introduced while ago. This week I am going to share how to merge and unmerge Excel cells with PowerShell via…Read More How to merge/unmerge Excel cells with PowerShell?
Table of contents for the How to Excel with PowerShell series. How to merge cells/split cells in Excel with PowerShell?By default Excel spreadsheet is a grid made of same size cells, but this can be changed by merging cells. How to format an entire Excel row based on the cell values with PowerShell?Conditional formatting is…Read More How to Excel with PowerShell: Table of contents
Last month of the year brings a great topic proposed by Lisa Bohm (blog|twitter). Lisa asks about technical things we have learned from writing or giving the presentation. While ago I have written a post about saving Outlook attachments with PowerShell and that that was actually the thing I learned from the topic I want…Read More T-SQL Tuesday #133: What (Else) Have You Learned from Presenting?
This week I have been introduced to the awesome coding challenge by my friend – Jess Pomfret (blog|twitter). It is a daily puzzle that has two parts (I am on day 2, so that’s all I can tell for now). Participants are getting an input file and in order to complete the task one need…Read More Advent of Code 2020
I am happy to announce I will be speaking at SQL Saturday #1004 – Bangladesh Virtual event on November 28th, 2020. I am going to present the session Multi-server agent jobs administration with happy faces and pigeons about MSX/TSX and CMS in SQL Server. Below is the schedule of the day (GMT time): 03:10 –…Read More Speaking at SQL Saturday 1004 – Bangladesh Virtual
This month Taiob Ali (blog|twitter) asks the community about the ways to handle the challenging 2020. See the #132 #tsql2sday invitation. Here is my story. Background Just before the virus outbreak, I have changed the job (the main reason was to spend more time with the family and work from home more often). The change…Read More T-SQL Tuesday #132: How Are You Coping with Pandemic?
A few weeks ago I had a pleasure to talk about MSX/TSX as part of the SQL Friday series ran by Magnus Ahlkvist (blog|twitter) (if you have missed it see the YouTube recording). What is a multi-server administration? The SQL Server Management Studio offers two components that enable users to manage multiple servers from a…Read More Multi-server administration with CMS/MSX/TSX