March 2021

Carnac by Code52 Carnac by Code52

A while ago I was talking at Southampton and Reading user group about Azure Data Studio shortcuts. I thought it would be a good idea to add the keystrokes I am pressing on the screen while I am presenting. Code52 After a short search, I found the tool I really liked. It is called Carnac…

Read More Carnac by Code52 – unusual way to expose the shortcuts

ImportExcel - PowerShell module ImportExcel - PowerShell module

In this last post of the series, I am going to mix Excel, PowerShell and VBA. If you weren’t using PowerShell to manage Excel files before, you might have used VBA (Visual Basic for Applications) to do so. Excel is a powerful tool and even this area can be improved a little bit with PowerShell.…

Read More How to setup VBA macro with PowerShell?

ImportExcel - PowerShell module ImportExcel - PowerShell module

Spreadsheets’ main purpose is data: storing, manipulating and analyzing them. We can add some colours or charts to make the data more friendly, but sometimes we may want to add something else – like a logo or picture and all that can be achieved with PowerShell. Preparation Firstly, let’s prepare our environment to make sure…

Read More How to add pictures to Excel with PowerShell?

This month the #TSQL2SDAY invitation comes from Brent Ozar (blog|twitter). Brent wants us to write about our favourite (or least favourite) data types. The invitation is in this post. sql_variant Of all data types available in SQL Server – sql_variant is one of the most interesting to me. The Microsoft documentation writes all about it,…

Read More T-SQL Tuesday #136: sql_variant to the rescue

ImportExcel - PowerShell module ImportExcel - PowerShell module

Microsoft Excel helps to format any single cell in many ways. From setting background colours, through adding border styles to presenting date in different formats. In this post we will play with styles and formatting a little bit. Preparation Let’s prepare our environment now to make sure the file does not exist. As an illustration,…

Read More How to set Excel style with PowerShell?