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

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.

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.

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

2. SQL Server Management Studio If we are talking about database management tools, the best choice is SQL Server Management Studio. It combines a powerful set of user-friendly graphical tools and ...

Microsoft this month pushed out 133 patches for a broad swatch of software and apps and plugged a zero-day flaw in SQL Server.

Joey on SQL Server Why Activity Monitor May Be Hurting Your SQL Server's Performance As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some ...

When SQL Server Management Studio is already open, the easiest way to open SQL Profiler is to click on the Tools dropdown menu. Then select "SQL Server Profiler" from the menu.

You can use one of two options to insert CSV files: "Bulk Insert," a command that works from the SQL Server Management Studio, or "bcp utility," which you run from a Windows command line prompt.

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.