Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics
Learn how to get started working with SMO and PowerShell.
2024-01-20 (first published: 2016-05-11)
13,851 reads
Laerte Junior
Stairway to Server Management Objects (SMO) Level 2: Connections and Creating Server Inventories
Learn how to get started working with SMO and PowerShell.
2024-01-20 (first published: 2016-07-13)
5,022 reads
Stairway to Server Management Objects (SMO) Level 3: The Database Class
Learn how to get started working with SMO and PowerShell.
2024-01-20 (first published: 2017-02-01)
6,827 reads
Stairway to Server Management Objects (SMO) Level 4: Scripting and Copying Small Databases
In the fourth level of this series, we will examine how you can use the scripting classes to create the code to manage your SQL Server instances and databases.
2024-01-20 (first published: 2023-12-13)
1,862 reads
Stairway to Server Management Objects (SMO) Level 5: Moving to the SQLServer Module
In this level you will learn about the SQLServer PowerShell module that ships with modern versions of SSMS.
2024-01-20 (first published: 2024-01-17)
1,613 reads
Blogs
What’s New at AWS re:Invent 2025 – Day 1 Highlights
Day 1 is an absolute thrill at re:Invent! I normally dedicate this dynamic day...
Running SQL Server on KubeVirt – Getting Started
With all the changes that have happened with VMware since the Broadcom acquisition I...
Why is shrinking IT budgets a good thing?
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers