2020

ImportExcel - PowerShell module ImportExcel - PowerShell module

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

ImportExcel - PowerShell module ImportExcel - PowerShell module

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)

ImportExcel - PowerShell module ImportExcel - PowerShell module

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?

ImportExcel - PowerShell module ImportExcel - PowerShell module

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?

SQLSATURDAY 1004 Bangladesh – Virtual, Bangladesh SQLSATURDAY 1004 Bangladesh – Virtual, Bangladesh

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?

Girl feeding pigeons Girl feeding pigeons

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