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
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
I found the CTRL+D shortcut key as an interesting feature in many programs. It can duplicate without using copy and paste. But not always. It is also D like DELETE, DISPLAY, or HIGHLIGHT… Microsoft Office Excel and Google Docs Spreadsheets. In Excel or Google Spreadsheet, CTRL +D duplicates content from the cell/cells row above. We need to…Read More D like Duplicate.
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
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