Microsoft SQL Server Management Studio 18, which can be used to manage any SQL infrastructure, has been released and is now generally available to users with a long list of updates and improvements.

SQL Server Management Studio (SSMS) is the principal interface for working with Microsoft SQL Server. However, many subtleties of this powerful tool evade even the most seasoned professionals ...

Figure 6. We have really just dipped our toe into the water that is using SMO with PowerShell to explore and report on various portions of SQL server and its database and tables. We can also do things ...

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 ...

Ok, I'm having this wierd issue where I'm editing a row in the SQL manager, doing some text entry and I hit Shift and then Space (the reason being that if I am typing along and about to type a ...

Just like the first option, Beekeeper Studio is a free, open-source, cross-platform, SQL editor and database manager. It supports various databases such as MySQL, SQLite, SQL Server, and PostgreSQL.

(Microsoft did add backup encryption to all editions of SQL Server in 2014.) The other security feature added to the Standard Edition was key management for managing encryption keys.

Migrating SQL server farms to the cloud offers long-term benefits, including optimized costs, flexibility, enhanced security and simplified management.

Each SQL Server virtual machine (VM) is assigned a static private and public IP address, ensuring stable connectivity for internal cluster communication and remote management.

Microsoft’s July 2025 Patch Tuesday fixes 137 vulnerabilities, including critical flaws in SQL Server, Netlogon, Office, and the .NET Framework.