DBA Scrolls - SQL Stories from the Trenches

In this blog post, we will explore a useful PowerShell script that allows you to execute TSQL queries and send the results via email. The script is versatile and can work with any type of TSQL query. It also provides op…

In today's blog post, we'll explore how to automate the population of UK holiday data into a SQL Server database using PowerShell. We'll walk through the code and discuss how it retrieves holiday information…

PowerShell is a powerful scripting language that can be used to automate tasks in Microsoft SQL Server. In this blog, we will discuss how to connect to a SQL Server instance from PowerShell. Step 1: Install SQL Server Po…