June 2020

ImportExcel - PowerShell module ImportExcel - PowerShell module

Last week I have introduced you to ImportExcel PowerShell module and its capability to manipulate the worksheets and create pivot tables and pivot charts. This week let’s jump on some other features: conditional formatting and charts. ImportExcel – how to? If you have not installed the module before, use the below code to do so…

Read More PowerShell into Excel:ImportExcel Module Part 2

dbatools = command-line SSMS dbatools = command-line SSMS

I am using dbatools.io in day-to-day work. That amazing set of tools helped me a lot. I have also met people who have some reservations or do not know where to start. I have heard: I will not learn new language, for example PowerShell SQL Server Management Studio is all I need We already have…

Read More dbatools.io = command-line SQL Server Management Studio

ImportExcel - PowerShell module ImportExcel - PowerShell module

While ago I needed to do some manipulation on Excel spreadsheets but had no Office installed on the server. For the specific case, I looked for a way to complete my task with the PowerShell. A quick look into Google search results and… Even though the name is not specified, both articles talk about the…

Read More PowerShell into Excel:ImportExcel Module Part 1

Post thumbnail

Last time I have joined the T-SQL Tuesday was about life hacks, and this month thanks to Kenneth Fisher’s (blog|twitter) invitation I will show you something I have used recently. While ago I had to draw some diagrams. At that time I did not have MS Visio available. Additionally, I wanted to use something I…

Read More T-SQL Tuesday #127: Non SQL Tips and tricks