Daniel Silva's blog
DevOps Engineer
The first time I’ve heard about dbatools was on its early stages and, although it seemed really interesting, I didn’t know anything about PowerShell, nor I had to work with SQL professionally. Moreover, to me it looked like it was “focused” on helping DBAs (maybe hence its name?). Even though I’ve never contributed to the project, I’ve always kept an eye on it.
Why do I need it now? Some context 🔗I usually have to analyse logs in order to perform some C#/SQL troubleshooting/debugging/performance tuning. The approach that I usually take is to use Excel and import the log file as a table, so that I can filter, highlight and so on.
PSConfEU is the “Europe’s largest PowerShell-themed annual conference!”. It covers a lot of different topics and brings professionals from all over the world.
“In 2020, we’ll have 350 delegate seats again and 40 international speakers”
It has talks about DSC, PowerShell internals, Azure, DevOps, IoT and many other areas.
This conference is simply amazing and I’m really happy to announce that I will be speaking! Last year was my first time attending and speaking at a conference outside my country, and PSConfEU was the one. I couldn’t ask for a better experience. Let me share my experience with you, specially if you are a newcomer.
I use a Mac as my development machine. As you might or might not now, SQL Server is not available for macOS. Instead, you need to use docker and have a container to hold your instance. The whole Docker world is new to me, and every day I’m learning more and more things about it.
Recently I was testing my backup/restore procedure and I had this weird error:
MODIFY FILE encountered operating system error 31(A device attached to the system is not functioning.) while attempting to expand the physical file '/var/opt/mssql/data/myDatabase.mdf'.