Ozzie.eu

Ozzie.eu

Love to code although it bugs me.

27 Jun 2022

Better Powershell SQL comand exection using Dbatools

Recently I chose to develop a quick batch solution, for working with SQL Server databases, using Powershell and the Invoke-SqlCmd cmdlet. I was faced with unexpected errors. After quick workaround on the code, I was able to get things done. However, recently I got to redo the batch resulting on a more performant solution. The key to this was the Invoke-DbaQuery Cmdlet.
20 Jun 2022

Powershell Error on Invoke-Sqlcmd? Ditch the pipe operator.

As you might have read, I'm a fan of GTD. Having to develop a quick batch solution for some data copying between different SQL Server databases, I chose to use Powershell scripting and the Invoke-SqlCmd cmdlet. However I was faced with unexpected errors for something as trivial as an export/import job.
07 Dec 2021

Preferred Programming Language Versus Getting Things Done

Now and then you’ll face some important task that needs to be done on the spot, with no delays. Usually single-shot operations. For that, the key performance indicator is GTD.
25 Oct 2021

Python script to unfollow inactive friends on Twitter

Twitter is great to learn the news of your chosen interests, but sometimes your get stuck with an increasing amount of inactive friends who haven't updated their status in ages.
07 Sep 2021

EF Core Update Model on Database First Project

Developing a project using .NET Core and Entity Framework, using an existing database, does not come with a Model update wizard. But still, it doesn't have to be a daunting task.