T-SQL Tuesday 173 - Has AI Helped You with Your SQL Server Job
This month the #TSQL2SDAY invitation comes from Pinal Dave who asked us to write about the AI helping at our jobs.
Posts by Year
2024
T-SQL Tuesday 173 - Has AI Helped You with Your SQL Server Job
T-SQL Tuesday 171 - Describe the Most Recent Issue You Closed
This month the #TSQL2SDAY invitation comes from Brent Ozar who asked us to write about the last ticket we closed.
2023
T-SQL Tuesday 163 - What is the best piece of Career Advice you ever received
This month the #TSQL2SDAY invitation comes from Gethyn Ellis who asks us to write about the best piece of Career Advice we ever received.
The SQLBits 2023 experience
In March 2023 we visited Newport, Wales to attend our third in-person SQLBits. Here is how it was for us.
T-SQL Tuesday 159 - New Year’s Resolutions - Magda
This month the #TSQL2SDAY invitation comes from Deepthi Goguri who asks us to write about our favorite new feature in SQL Server 2022 or in Azure and New Yea...
T-SQL Tuesday 159 - What’s Your Favorite New Feature? - Magda
This month the #TSQL2SDAY invitation comes from Deepthi Goguri who asks us to write about our favorite new feature in SQL Server 2022 or in Azure and New Yea...
2022
T-SQL Tuesday 150 - My first technical job
This month the #TSQL2SDAY invitation comes from Kenneth Fisher who asks us to write about our first technical job.
The SQLBits 2022 experience
Earlier this month our family attended the SQLBits in-person in London. Here is how it was for us.
T-SQL Tuesday 148 - Advice on Running a User Group
This month the #TSQL2SDAY invitation comes from Rie Merritt who asks us to write about various aspects of running a user group.
2021
Festive Tech Calendar - Arm your Bicep with D(i)SC
Watch a video where I am showing how to make your life easier while building new environments.
T-SQL Tuesday 143 - Short code examples
This month the #TSQL2SDAY invitation comes from John McCormack who asks us to write about our handy short scripts.
T-SQL Tuesday 138 - Managing Technology Changes
This month the #TSQL2SDAY invitation comes from Andy Leonard who asks us to write about ch-ch-ch-ch-changes and how we deal with them.
T-SQL Tuesday 137 - Using Jupyter Notebooks
This month the #TSQL2SDAY invitation comes from Steve Jones who asks us to write about Jupyter notebooks.
T-SQL Tuesday 136 - sql_variant to the rescue
This month the #TSQL2SDAY invitation comes from Brent Ozar who wants us to write about our favourite (or least favourite) types.
T-SQL Tuesday 135 - The outstanding tools of the trade that make your job awesome – write-up
Read responses to the February 2021 edition of T-SQL Tuesday.
T-SQL Tuesday 135 - The outstanding tools of the trade that make your job awesome
Without tools, most of the work would be much harder to do or could not be done at all.
T-SQL Tuesday 134 - give me a break
This month the #TSQL2SDAY invitation comes from James McGillivray who asks us to take a break.
2020
How to Excel with PowerShell (ImportExcel) - Table of contents
Table of contents for the How to Excel with PowerShell series.
T-SQL Tuesday 133 - What (Else) Have You Learned from Presenting?
This month the #TSQL2SDAY invitation comes from Lisa Bohm who asks us about technical things we have learned from writing or giving the presentation.
T-SQL Tuesday 132 - How Are You Coping with Pandemic?
This month the #TSQL2SDAY invitation comes from Taiob Ali who asks about the ways to handle the challenging 2020.
LET function in EXCEL 365
Microsoft Excel 365 gives us a new function – LET(). The LET function assigns names to calculation results. This allows storing intermediate calculations, va...
T-SQL Tuesday 131 - Data Analogies, or Explain Databases Like I’m Five!
This month the #TSQL2SDAY invitation comes from Rob Volk who asks about the analogies we use to explain data concepts.
T-SQL Tuesday 131 - Data Analogies, or Explain Databases Like I’m Five! – Magda
This month the #TSQL2SDAY invitation comes from Rob Volk who asks about the analogies we use to explain data concepts. Magda writes about SQL JOINs.
Instalowanie narzędzi społeczności z pomocą dbatools
Skorzystaj z pracy i doświadczenia innych
Install community tools with dbatools
Take advantage of others’ work and experience
Saving Outlook attachments with PowerShell
Save attachments from hundreds of emails received via Microsoft Outlook using PowerShell.
D like Duplicate.
I found the CTRL+D shortcut key as an interesting feature in many programs. It can duplicate without using copy and paste. But not always. It is also D like ...
Power Query installation.
While I was preparing to work in the new (for me) Microsoft Office 365, I learned that Excel 365 already has the “built-in” Power Query add-in.
dbatools.io = command-line SQL Server Management Studio - Keys, certificates
This post is part of the series showing practical usage examples. The main post covering links to all posts can be found here: dbatools.io = command-line S...
Microsoft Excel functionality – Data import from PDF – very useful tool.
Many times happened to me when I received a PDF file with a table that I had to “type” into the program manually. This option allows you in an easy way to ge...
dbatools.io = command-line SQL Server Management Studio - Start/Stop
This post is part of the series showing practical usage examples. The main post covering links to all posts can be found here: dbatools.io = command-line S...
T-SQL Tuesday 130 - Automate Your Stress Away - Magda
This month the #TSQL2SDAY invitation comes from Elizabeth Noble who asks about improving things at work.
dbatools.io = SQL Server Management Studio jako wiersz poleceń - Połącz, Zapytaj, Zapisz
Ten wpis jest częścią serii ukazującej praktyczne przykłady użycia modułu. Główny wpis zawierający odnośniki do pozostałych wpisów serii można znaleźć tuta...
dbatools.io = SQL Server Management Studio jako wiersz poleceń
Używam dbatools.io w codziennej pracy. Ten niesamowity zestaw narzędzi pomógł mi niezmiernie. Spotkałem także sporo osób, któe miały pewne zastrzeżenia lub n...
dbatools.io = SQL Server Management Studio jako wiersz poleceń - spis treści
Spis treści dla serii dbatools.io = SQL Server Management Studio jako wiersz poleceń.
dbatools.io = command-line SQL Server Management Studio
I am using dbatools.io in day-to-day work. That amazing set of tools helped me a lot. I have also met people who have some reservations or do not know where ...
dbatools.io = command-line SQL Server Management Studio - Table of contents
Table of contents for the dbatools.io = command-line SQL Server Management Studio series.
dbatools.io – how to contribute?
Take advantage of others’ work and experience
2019
Data:Scotland – Multi-server agent jobs administration with happy faces and pigeons
Following the Data:Scotland conference I have uploaded my presentation to GitHub as well as official Data:Scotland repository.
Data:Scotland – Thank you!
Earlier this month I had a pleasure to attend the third edition of Data:Scotland - the data platform conference that takes place in Glasgow, Scotland. In thi...