Books
Translate This Blog
-
Recent Posts
Top Posts
- Querying UDP Ports with PowerShell
- Changing Ownership of File or Folder Using PowerShell
- Using PowerShell Parameter Validation to Make Your Day Easier
- Quick Hits: Finding Exception Types with PowerShell
- Avoiding System.Object[] (or Similar Output) when using Export-Csv
- Sharing Variables and Live Objects Between PowerShell Runspaces
- Speedy Ping using PowerShell
- Use PowerShell to remove local profiles
- Building a TCP Server Using PowerShell
- PowerShell and WPF: Writing Data to a UI From a Different Runspace
Archives
Categories
- .net
- api
- array
- background jobs
- binary
- book
- c#
- clock
- codeplex
- com object
- convert
- CTP
- database
- deep dive
- excel
- Favorites
- function
- groups
- guest blog
- hash table
- Internet Explorer
- ise
- mcpmag
- module
- MVP
- network
- news
- parameter
- patches
- performance
- pinvoke
- podcast
- port
- PoshChat
- poshpaig
- PoshRSJob
- poshwsus
- powercli
- powerscripting
- Powershell
- printers
- quickhits
- reflection
- regex
- registry
- Regular Expressions
- report
- resolution
- runspace
- runspaces
- scripting games 2012
- scripting games 2013
- scripting guy
- scripts
- SMO
- Speaker
- speaking
- SQL
- tcp
- tips
- tsql
- updates
- user group
- V3
- V4
- v5
- weather
- widget
- win32API
- winter scriting games 2014
- wmi
- word
- WPF
- wsus
- xaml
Tag Archives: SMO
Restore a SQL Database Using SQL Server Management Objects (SMO) and PowerShell
At some point in your career with SQL, there may come a time to perform a restore of the database (and maybe transaction logs depending on your situation). Given that we covered how to back up a SQL database, we … Continue reading
Backup a SQL Database Using SQL Server Management Objects (SMO) and PowerShell
In my next article on my SQL and PowerShell series, I will talk about using the SQL Server Management Objects (SMO) to back up a SQL database. If you recall in my previous article on SQL Databases, you saw how … Continue reading
Exploring SQL Databases Using SQL Server Management Objects (SMO) and PowerShell
Continuing with my little SQL and PowerShell series, I am going to talk about how you can use PowerShell to explore SQL databases using SMO. As shown in the previous articles, I will make my initial connection to a SQL … Continue reading
Exploring SQL Server Using SQL Server Management Objects (SMO) and PowerShell
Continuing on from my previous article where I showed you how to make an initial connection to a SQL server using SMO, this article aims to dive deeper into the Microsoft.SqlServer.Management.Smo.Server object to view the configuration and available methods of … Continue reading
Connecting to a SQL Server Using SQL Server Management Objects (SMO) and PowerShell
In a previous article, I showed you how to find all of the SQL servers and instances using a function that queries the registry. Moving on from this, I will now show how you can connect to a SQL server … Continue reading