Tools

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

Winter Spring is coming It is February already, and the good thing is that it is the shortest month, so March is around the corner. I have a pleasure to invite the community for another edition of #TSQL2SDAY. The T-SQL Tuesday is a monthly blog party that happens on the second Tuesday of each month.…

Read More T-SQL Tuesday #135: The outstanding tools of the trade that make your job awesome

Post thumbnail

Last release note for Azure Data Studio was about the update the SQL Server Import extension that was moved to General Availability last month. From now on it is possible to import flat files like *.txt or *.csv into SQL table using Azure Data Studio. Download a new version Azure Data Studio. At first, I…

Read More Azure Data Studio – extension for SQL Server Import

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

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 PowerShell. A quick look into Google search results and… Even though the name is not specified, both articles talk about the ImportExcel…

Read More PowerShell into Excel: ImportExcel Module Part 1