To Reproduce Set up Metabase v55+ In SQL server create a login and a db user with different names (sample included below) Add DB connection to Metabase Notice the conneciton will save but sync never ...

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

In this lab we're going to install and set up a SQL Server Database inside of the Windows Virtual Machine. We're also going to Disable the Windows VM's Internal Firewall. Finally we'll Remote Desktop ...

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server.

Untangle SQL Server connection strings Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools.