PowerShell offers a lightweight and efficient solution for backing up SQL Server Express databases on local workstations without the need for full system backups.

Microsoft announced on Oct. 30 that it expanded SQL Server passive use rights for organizations licensing SQL Server with Software Assurance (SA) coverage.

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.

During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...