How We Ended up with Git

Git is used by many teams for version control. In this article, Dino Esposito takes a look back at the history of source control and how git became the popular tool it is today.

Creating and Using Inline Table-Valued Functions

Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000.

iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.

Improve Power BI Performance with Horizontal Filtering

In this third part of this Power BI optimization series we look at how horizontal filtering and other changes can improve overall performance

Experimenting with PostgreSQL in a Container

Learn how to get started using a container to run PostgreSQL, or really any other RDBMS, including a gotcha to watch out for.

SQL Server High CPU Query Use Monitoring with PowerShell

In this part of the PowerShell monitoring tips we look at how to capture the top queries that are consuming the most CPU from all monitored instances.

Application down after SQL Service logon account change

I was working on one of my clients server recently. This was during a normal maintenance monthly activity to reboot the database server every first weekend. I rebooted the machine, and as per the defined steps, I checked the SQL services after the reboot to ensure they were up. I verified all SQL Services and […]

Hidden treasures of SQL Prompt

You are invited to discover features of SQL Prompt that you may not even know exist. We will will walk you through the treasure map of SQL Prompt and show you where all the great features are buried.

The Social Impact of Artificial Intelligence and Data Privacy Issues

Like any technology, AI can be used for evil instead of good. Shree Das explains several examples and what should be done to prevent the misuse of data.

Azure Database for MySQL

In this article we take a look at setting up and configuring MySQL to run on Azure along with some performance metrics for this database platform running on Azure.

Configure Replication Between an On-premises SQL Server and AWS RDS

In this article, we will review how to migrate the data from on-premises SQL Server to AWS RDS for SQL Server using transactional replication. There are several ways to migrate data from on-premises SQL Server to AWS RDS for SQL Server and transactional replication is one among them. Configuring transactional replication between the on-premises SQL Server […]