Deep Dive into AI and a Sea of Data

I cannot deny my background as a database administrator. Initially, when I started delving into neural networks, I tried to understand how they possibly function. The first thing I stumbled upon was where the heck is the data stored? In the clouds? Under a secret stone at a British boarding school? After all this has […]

A closer look

Once in a while, you stumble upon a nice feature of SQL Server that you knew existed, but never really explored. Despite it being in SQL Server since 2005. Let’s do this today with one of the most powerful features in Transact-SQL (T-SQL) ROW_NUMBER(). This function is designed to “assign a unique sequential integer to […]

𝐌𝐚𝐬𝐭𝐞𝐫𝐢𝐧𝐠 𝐭𝐡𝐞 𝐌𝐨𝐦𝐞𝐧𝐭

𝐓𝐢𝐦𝐞 𝐓𝐫𝐚𝐜𝐤𝐢𝐧𝐠 𝐢𝐧 𝐒𝐐𝐋, 𝐏𝐨𝐰𝐞𝐫𝐒𝐡𝐞𝐥𝐥, 𝐚𝐧𝐝 𝐂# Time is a cornerstone of programming and database management. Whether it’s for logging, timestamping, or scheduling, accurately capturing the essence of now is indispensable. Let’s dive into the simplest ways to grab the current timestamp in SQL, #PowerShell, and #csharp, along with tips for formatting dates and times […]

AI. Getting to know the new kid on the block

This blog post aims to offer a top-level overview of (generative) AI. Starting from its inception, touching on how it operates, and most importantly, how to get the most out of it. It was inspired by the excellent video “Generative AI in a Nutshell” by Henrik Kniberg. For those who appreciate an excellent overview of […]

From Source to Consumer: Data Refinery with PowerShell

Powershell Developed by Microsoft, is an automation and configuration management framework comprising a command-line shell and scripting language. It’s designed for system administration, allowing the management of both local and remote systems with ease. At its core, the PowerShell pipeline is a fundamental feature, where the source cmdlet generates objects that are passed to the […]