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
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 dbatools = command-line SSMS
Table of contents for the dbatools.io = command-line SQL Server Management Studio series. An overview of how to start using dbatools to run queries against your SQL Server instance.dbatools: Connect, Query and Save If you want to look at your SQL instance and see your objects here is how you can do it.dbatools: Let me…
Read More dbatools.io = command-line SQL Server Management Studio: Table of contents 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
Meet chocolatey
Recently, I’ve got a new laptop and decided to get all new software with the scripts – to avoid clicking and downloading stuff manually. I’ve heard about Chocolatey in the past but had no opportunity to use it. A new laptop was a great excuse to play with some chocolate. What is chocolatey? Everyone I…
Read More Meet chocolatey