2007-07-18
2,936 reads
SMO
SQL Server Management Objects
In this column, I discuss how SMO can be used to examine a database’s objects and to perform a variety of administrative tasks.
2007-06-18
2,930 reads
Alert-based Transaction Log Backups using SMO
Allen White provides an SMO script for automating database log backups, using either native backup or Red Gate's SQL Backup tool.
2007-05-07
2,426 reads
PowerSMO at work part 2
Dan Sullivan continues his exploration of the versatile PowerSMO tool with coverage of how to control logins, monitor server activity and create standalone administrative scripts.
2007-04-02
2,261 reads
Backing Up a Database with SMO
In SQL Server 2005, the management object framework changed substantially from the DMO framework in prior verisons. Now we have SMO, RMO, and other .NET assemblies that can be used to manage SQL Server. New author Brandie Tarvin brings us a short look at how SMO can be used to perform one of those critical tasks in SQL Server.
2008-03-05 (first published: 2007-03-13)
6,741 reads
SMO Basics
SQL Server guru Andy Warren has been working with all aspects of SQL Server for many years and is slowly upgrading his skills to SQL Server 2005. Here he takes a look at SMO basics, which is the replacement for DMO.
2006-06-28
10,429 reads
Script Database Objects with SMO
One of the big changes with SQL Server 2005 is the evolution of SQL-DMO to the new SMO managed code assemblies. Author Raj Vasant brings us quite a bit of code to show how this can be used to script your objects.
2006-04-04
16,576 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers