Open up new reporting options for your SQL Server with these PowerShell tips.

Let me explain. Traditionally, SQL Distributed Management Objects (DMO) and SMO have been complicated enough to code that many DBAs stayed away from them.

As part of the SQL Server Management Objects (SMO), DBAs have access to the wonderful world of policies. From here, we can assess the condition of our server configurations and create policies to ...

IntelliSense in SQL Server 2008 works largely as it does in VS, providing you with a list of objects and methods as you type code. The second-most-coveted new feature in Management Studio is T-SQL ...

The SQL Server Management Objects (SMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer SQL Server objects and services.

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.

But not everyone has VB skills, and writing SMO (SQL Server Management Objects) is neither easy nor intuitive. PowerShell allows you to script a database in just 21 characters of code and schedule ...

The mssql extension for Visual Studio Code, used to support SQL Server connections and T-SQL editing, has been updated with IntelliCode functionality and a new Object Explorer, among other new ...

Figure 2. The same query as executed in SQL Server Management Studio. (Click image to view larger version.) Obviously, SSMS offers some features that PowerShell doesn't, such as the handy Object ...