Author: Magda

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

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.

Post thumbnail

Many times happened to me when I received a PDF file with a table that I had to “type” into the program manually. Fortunately, the data didn’t have too many lines 10-20 at most, so it wasn’t time-consuming, but it was frustrating and it could cost a mistake. I wish I knew that before.This option…

Read More Microsoft Excel functionality – Data import from PDF – very useful tool.

Hi, I am Magda and this is my first blog post. I have seen #TSQL2SDAY invitation from Elizabeth Noble (blog|twitter) for September and thought I would give it a try. I am going to tell you about my adventures in improving things at work. Intro As a non-technical worker, I can’t do changes on my…

Read More T-SQL Tuesday #130: Automate Your Stress Away – Magda