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!
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
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
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?
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?
1… 2… 3… testing. It’s another T-SQL Tuesday and my first post in the series. Thanks to Jess Pomfret (b|t) for bringing this topic up. There are many hacks that helped me in life (either personal or professional), but I wanted to share my biggest ‘hack’ so far. It is #SQLFamily. The group of…Read More T-SQL Tuesday #123: Life hacks to make your day easier