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

This month Rob Volk (blog|twitter) hosts the #TSQL2SDAY event (see the invitation). I am going to tell you about how I was learning SQL JOIN. Very often I used analogies to learn or understand something. In my work, I tried to find a similar example fitted to a job that I was currently dealing with.…

Read More T-SQL Tuesday #131: Data Analogies, or: Explain Databases Like I’m Five! – Magda

Wake me up when September ends Green Day Now I am fully awake and ready to contribute to the latest #TSQL2SDAY. This month’s host is Rob Volk (blog|twitter). Rob’s inspiration from Reddit ELI5 resulted in this great topic. AND vs OR Back in the days when I was tutoring math, I had two children who…

Read More T-SQL Tuesday #131: Data Analogies, or: Explain Databases Like I’m Five!

Roses are red,Violets are blue,Community loves dbatoolsdbatools love it too Author unknown what dbatools are? dbatools.io are a set of PowerShell commands to manage SQL Server, contained in a module. Plus it is open-source, created by people who work with the SQL Server and PowerShell for years. Some say it is a command-line version of…

Read More Install community tools with dbatools

Post thumbnail

Recently I have got a question about resources to learn PowerShell. There is plenty out there in the wild, but I came across an interesting module I would like to write today – PSKoans. What is PSKoans? The PSKoans module was created by Joel Sallow (blog|twitter) and here is its brief description taken from the…

Read More PSKoans – learn PowerShell with Pester

Post thumbnail

I always used VLOOKUP formula, I could do it even with my eyes closed, but now when I have Excel 365 I can use XLOOKUP, which is similar but not the same. When I have learned this new functionality I found out that I also have an option to use dynamic array formulas in a…

Read More XLOOKUP function and dynamic array formulas – Excel 365.

Saving emails attachments with PowerShell Saving emails attachments with PowerShell

Problem Save attachments from hundreds of emails received via Microsoft Outlook using PowerShell. Scenario One of the systems generates report daily and sends it out via email as an attachment, that is being saved in the Inbox subfolder MyAlerts. Sample email below. After 6 months someone decides to analyze all the reports from the attachments.…

Read More Saving Outlook attachments with PowerShell