Microsoft Excel 365 gives us a new function – LET(). It is not available for every Microsoft 365 subscriber though. A few weeks ago my Excel did not have this function, but now I can work with it. I did a few examples when I was learning this feature and want to share them with…Read More LET function in EXCEL 365
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.