Beginning SQL Server SMO

preview_player
Показать описание
Recently I was invited to talk about beginning SMO on the SQL Undercover podcast. So I put together a tutorial to teach SMO in PowerShell from the very beginning.

This isn't a PowerShell tutorial; it's an SMO tutorial. So if you need to know how to use SMO to manage SQL Server, here's a 2hr beginning.
  1. Jen and Sean McCown - MinionWare
  2. Microsoft SQL Server (Software)
  3. Database (Software Genre)
  4. Database Administrator (Job Title)
  5. SMO
  6. Powershell
Рекомендации по теме
Beginning SQL Server 2:04:11

Beginning SQL Server SMO

Loading SQL Server 0:01:52

Loading SQL Server Management Object SMO

SQL Undercover TV 1:50:28

SQL Undercover TV - Powershell and the SQL Management Objects (SMO)

Powershell SQL Client 0:05:59

Powershell SQL Client SMO

How to Fix 0:01:05

How to Fix SQL Cannot Connect Error in SQL Server Management Studio

Connecting to SQL 0:09:40

Connecting to SQL Server using SSMS Part 1

Installing SQL Server 0:04:36

Installing SQL Server Management Object SMO

Powershell reading data 0:13:05

Powershell reading data from SQL Server via cmdlet or SMO

SQL : SQL 0:01:33

SQL : SQL Server: Why do use SMO?

C# : Inconsistent 0:01:23

C# : Inconsistent default constraints from SQL Server Management Objects (SMO)

Databases: SQL Server 0:02:01

Databases: SQL Server SMO Method 'Discover()'

001 Connecting to 0:09:40

001 Connecting to SQL Server using SSMS

SSMS Failing To 0:03:55

SSMS Failing To Connect To SQL Server

Cannot find type 0:03:24

Cannot find type [microsoft.sqlserver.management.smo.server]

Script Database Tables 0:00:32

Script Database Tables using SQL Server Management Objects

Create SQL User 0:01:18

Create SQL User in SQL Server 2022 Database using SSMS

How to load 0:01:35

How to load data using Microsoft.SqlServer.Management.Smo in C#?

[ How to 0:02:52

[ How to FIX ✅ ] Microsoft SQL Server Error 18456 Login Failed for User

How To Study 0:09:41

How To Study SQL Server - Connecting to SQL Server using SSMS Part 1

01 SSMS Object 0:25:29

01 SSMS Object Explorer

ForEach SQL Server 0:05:59

ForEach SQL Server Management Objects (SMO) Task SSIS

Connecting to SQL 0:09:41

Connecting to SQL Server using SSMS Part 1

Undercover TV - 2:27:57

Undercover TV - Sean McCown Joins Us For a session on Beginning Powershell SMO

15- SQL Server 0:25:27

15- SQL Server Management Object SMO Create DB , table Part 2

Комментарии
Автор

Awesome demonstration of SMO in Powershell. I would love to get some of your time to discuss your experiences with SMO. It is nice t finally find someone else dealing with SMO in their world. Great work, Thank You for all you efforts.

artintheraw
Автор

Thank you for this video, I did not finish to watch it ( for the moment, ...), but it was enought to find THE best way to encrypt stored procedures and functions.
Works only with local instance, but the job is done !

victorineweber