SQL

#PSTip Backing up a SQL database using SMO

Ravikanth C
1 Min To Read
12 Apr, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. In today’s tip, we shall see how we can use SQL Management Objects (SMO) in PowerShell to perform a SQL database backup.

#PSTip List all fixed disk drives visible to SQL Server instance

Ravikanth C
1 Min To Read
03 Apr, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. When automating SQL server database creation in PowerShell, we may want to give the end user an option to select from a list of available fixed disk drives and let the user select the drive that should …

#PSTip Change SQL Server MaxServerMemory configuration using SMO

Ravikanth C
1 Min To Read
03 Apr, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. As database administrators, we might want to configure SQL MaxServerMemory setting to ensure the SQL service does not occupy all available physical memory.

#PSTip Identifying SQL system objects using SMO

Ravikanth C
1 Min To Read
28 Mar, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. A SQL Server instance, by default, deploys a few system databases such as Temp DB, MSDB, Master, and Model DB.

#PSTip Generate T-SQL script to clone database tables using SMO

Ravikanth C
1 Min To Read
27 Mar, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. In an earlier tip, we looked at how we can use SMO in PowerShell to generate T-SQL scripts for cloning databases.

#PSTip Generate T-SQL script for cloning a SQL database

Ravikanth C
1 Min To Read
19 Mar, 2013
- Tips and tricks
- SQL

Note: This tip requires PowerShell 2.0 or above. As database administrator, you may want to create a database on development or test servers with similar settings as on the production server.

Showing items from SQL