Prototyping is my favorite part of programming. I like building new stuff and getting things working. It’s no surprise, then, that I am a big fan of MongoDB and NoSQL in general. Don’t get me wrong: I ...

If you have installed a previous version using the zip file then delete the installed SSMS Schema Folders folder before continuing. Run the .vsix file to start the VSIX Installer. It will detect which ...

Following on from my post two weeks ago about how to get the details of Power BI operations seen in the Capacity Metrics App using the OperationId column on the Timepoint Detail page, I thought it was ...

In this post, we will see how to install PostgreSQL on your Windows client computer and how you can connect and use it. PostgreSQL, commonly called Postgres, is an open-source relational database ...

SQL, the Structured Query Language, remains one of the most widely used programming languages, coming in fourth in Stack Overflow’s research for 2023. Just over half (51.52%) of professional ...

We are excited to announce that you can now directly call SQL Server stored procedures in Power Fx. You no longer need to call a Power Automate Flow to use a stored procedure. This feature is in ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...