Referencing an Object by Using a Collection in Visual C# This code example shows how to set a column property by using the xref:Microsoft.SqlServer.Management.Smo.TableViewTableTypeBase.Columns%2A, ...

Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc. - MicrosoftDocs/sql-docs ...

This really opens up the door on what you can do with SQL using PowerShell such as reporting on the state of your backups to viewing the size of the databases and tables. You can even take it further ...

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

Conclusion Restoring a SQL database backup using SQL Server Management Studio is a straightforward process that allows you to recover lost or corrupted data. By following the steps outlined in this ...

Get tips for updating to Microsoft SQL Server 2014, including using SLQ's Copy Database Wizard and a checklist with key tasks to complete during your migration plan.

Scott Stephens creates a package that allows you to clone most database objects with dynamic SQL.

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

Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from various sources to single or multiple locations in Microsoft SQL Server 2000.