SqlShare.com Logo
 
Skip Navigation Links
Home
Channels
Classes
About Us
Login / Register
Subscribe to the All channels feed  Goto the SqlShare.com blog
Channels > SQL > SMO

Video List Video List
Shrinking the Transaction Log with SMO
Date Published: September 10, 2008
Author: Tim Mitchell
Rating: 4.03
Description: This videos shows you how to shrink the transaction log of a database using SMO.

Using the Tables Collection in SMO
Date Published: September 10, 2008
Author: Tim Mitchell
Rating: 4.17
Description: SQL SMO is a way to access almost every part of SQL Server using an object interface that's perfect for a programmer (or a DBA that can write a little code!). Tim Mitchell provides a short introduction to the Tables collection, which provides an easy way to iterate through all of the tables in a database. Note that he as many other SMO videos if you're just starting out, you may want to watch them all.

Retrieve Table and Indexes Sizes in SMO
Date Published: September 10, 2008
Author: Tim Mitchell
Rating: 3.83
Description: SQL SMO man Tim Mitchell demonstrates how to retrieve the size of your tables and indexes and then write the output in HTML. This assumes you have a basic understanding of SMO, if you're new to SMO visit Tim's profile for a complete list of his SMO videos.

Try Catch Blocks and Return Values within SMO
Date Published: September 10, 2008
Author: Tim Mitchell
Rating: 4.00
Description: Even trivial applications should be prepared to handle error conditions cleanly. This video goes over using Try Catch Blocks and return values using .NET and SMO, a nice advance over the old on error GOTO method from the VB6 days.

Update SQL Permissions using SMO
Date Published: September 10, 2008
Author: Tim Mitchell
Rating: 4.24
Description: It's surprisingly easy to set permissions in an object based way using SQL Management Objects (SMO). Tim Mitchell shows you how to use the ObjectPermissionSet to hold the permissions and then apply them to a specified object. If you're new to SMO check out Tim's other videos to learn SMO from the beginning!

Backing Up Your Database With SMO
Date Published: September 09, 2008
Author: Tim Mitchell
Rating: 3.92
Description: This video shows you how to backup your database using SMO.

Capture Schema Changes with SMO
Date Published: September 09, 2008
Author: Tim Mitchell
Rating: 4.08
Description: This video show you how to collect schema changes made to your database using SMO

Collections Explained
Date Published: September 09, 2008
Author: Tim Mitchell
Rating: 4.19
Description: This video introduces collections in .NET.

Conditional SQL Server Backups with SMO
Date Published: September 09, 2008
Author: Tim Mitchell
Rating: 4.35
Description: This video shows you how to do conditional backups in SQL Server using SMO. Tim has a bunch of other videos on SMO to help you get started if you're new to it!

Connecting to a SQL Server Database with SMO
Date Published: September 09, 2008
Author: Tim Mitchell
Rating: 3.88
Description: This video shows you how to use SMO to connect to a sql server database.


   Next -->
Tags


Most Watched Videos in Selection Most Watched Videos in Selection
Collections Explained

Creating SQL Server Jobs with SMO

Creating an SMO Dashboard - Part 1

Enumerate SQL Server Databases using SMO

Try Catch Blocks and Return Values within SMO



Sponsored Ads
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions