Spread the loveRestoring a SQL Database Backup Using SQL Server Management Studio A SQL database backup is an essential safeguard against data loss or corruption in your SQL database. Having a backup ...

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

Some of these modules use what is called the SQL Management Object (SMO) which allows you to load some assemblies to be able to connect to a SQL server and then explore the server and its database and ...

Using Synonyms [!INCLUDE SQL Server ASDB, ASDBMI, ASDW] A synonym is an alternative name for a schema-scoped object. In SMO, synonyms are represented by the ...

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance Synapse Analytics FabricSQLDB] In [!INCLUDEssNoVersion] Management Objects (SMO), tables are represented by the ...

The wizard can be found by right clicking the database they want to copy in SQL Server Management Studio and selecting Tasks and then Copy Database from the menu. Before-and-After Upgrade Checklist ...

Here are a few of my favourite secrets to make life easier in SSMS for SQL Server 2012. Multiplicity The Object Explorer Details pane doesn’t show up by default, but you’ll definitely want to ...

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

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