sqlfamily

Last month of the year brings a great topic proposed by Lisa Bohm (blog|twitter). Lisa asks about technical things we have learned from writing or giving the presentation. While ago I have written a post about saving Outlook attachments with PowerShell and that that was actually the thing I learned from the topic I want…

Read More T-SQL Tuesday #133: What (Else) Have You Learned from Presenting?

This month Taiob Ali (blog|twitter) asks the community about the ways to handle the challenging 2020. See the #132 #tsql2sday invitation. Here is my story. Background Just before the virus outbreak, I have changed the job (the main reason was to spend more time with the family and work from home more often). The change…

Read More T-SQL Tuesday #132: How Are You Coping with Pandemic?

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!

T-SQL-Tuesday T-SQL-Tuesday

This month Elizabeth Noble (blog|twitter) hosts the #TSQL2SDAY event (see the invitation) and would like to know how did you make your life easier by automating thing. Paper age There was this place I just started and wanted to request a day off. I asked people around how to do this, what system do we…

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

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

Post thumbnail

Last time I have joined the T-SQL Tuesday was about life hacks, and this month thanks to Kenneth Fisher’s (blog|twitter) invitation I will show you something I have used recently. While ago I had to draw some diagrams. At that time I did not have MS Visio available. Additionally, I wanted to use something I…

Read More T-SQL Tuesday #127: Non SQL Tips and tricks

Blind date: PowerShell & dbatools Blind date: PowerShell & dbatools

Last month I have demonstrated how to contribute to the dbatools.io without touching PowerShell editor. This time let’s see how to do some PowerShell, shall we? So exciting! However, you might find here why some stuff did not work quite well, as I found the hard way. You’ve been warned. Invite dbatools for dinner (or…

Read More dbatools.io ā€“ blind-date: why don’t I see my changes?

dbatools.io ā€“ how to contribute? dbatools.io ā€“ how to contribute?

What dbatools.io is? That’s what you can find on their website. dbatools is a free PowerShell module with over 500 SQL Server best practice, administration, development and migration commands included. Currently, other components of SQL Server such as SSIS, SSRS and SSAS are not supported, but they are part of the overall goal. The high…

Read More dbatools.io ā€“ how to contribute?