Tag: SQL (Page 6/7)

#PSTip Changing SQL database AutoShrink property using SMO and PowerShell

Note: This tip requires PowerShell 2.0 or above. In today’s tip, we will see how we can use SQL SMO…

Read More

#PSTip Restoring a SQL Database using SMO

Note: This tip requires PowerShell 2.0 or above. In a couple of earlier tips on using SMO, we looked at…

Read More

#PSTip Backing up SQL transaction log using SMO

Note: This tip requires PowerShell 2.0 or above. In an earlier tip, we looked at how we can use SQL…

Read More

#PSTip Backing up a SQL database using SMO

Note: This tip requires PowerShell 2.0 or above. In today’s tip, we shall see how we can use SQL Management…

Read More

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

Note: This tip requires PowerShell 2.0 or above. When automating SQL server database creation in PowerShell, we may want to…

Read More

#PSTip Change SQL Server MaxServerMemory configuration using SMO

Note: This tip requires PowerShell 2.0 or above. As database administrators, we might want to configure SQL MaxServerMemory setting to…

Read More