This Friday, October 23rd I am going to deliver a session about MSX and TSX and pigeons at SQL Friday #21. What is SQL Friday? It’s the online meetup that occurs every Friday at noon CEST hosted by Magnus Ahlkvist (blog|twitter) and financed by Transmokopter SQL AB. All sessions are being recorded and available on…Read More Speaking at SQL Friday
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 coming Saturday the second edition of the #DataWeekender online conference is going to take place. The conference contains 45 main sessions & 15 Lightning Talks. I am honoured to inform that my topic An introduction to the ImportExcel PowerShell module has been selected as one of the 15 short talks. The ImportExcel module by…Read More Speaking at #DataWeekender
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
Today I have learned how I can use and change the tooltip in my visualizations in Power BI Desktop. So far I have used them with the default settings. From now on my charts could be much prettier when I change or add some details even other visualization. What is tooltip and what is for?…Read More Tooltip in Power BI Desktop.
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
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.
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