I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 ...

Don’t get me wrong — I use PowerShell all the time and I’m at ... Sean McCown is a Certified Master in SQL Server and a SQL Server MVP with 20 years of experience in databases.

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

There are lots of ways to create MSSQL databases via PowerShell. We could invoke a T-SQL query using the CREATE DATABASE term, we could write some code to use the [Create() method with SMO] or ...

One way to figure out if your computer can reach a SQL database and that your credentials work to connect to it is by using a PowerShell script. You'll first need to get the SqlServer PowerShell ...