gitmelyk / dbhelper

The detailed explanation could be found on Red Gate SimpleTalk's link 'Programming SQL Server with SQL Server Management Objects Framework' https://www.red-gate.com/simple-talk/dotnet/c-programming/programming-sql-server-sql-server-management-objects-framework/

✅ DBHelper

SMO library which has, as a result, a DLL. In the library, you can find a lot of methods to work with SQL Server database.

Method description	Method signature
To ensure a backup certificate exists	EnsureBackupCertificateExists(ServerConnection,Ilog,ref string,string)
To create a backup certificate	CreateBackupCertificate(ServerConnection,ILog,string,string,ref string, bool)
To take a copy only backup	BackupDatabase(ServerConnection,ILog,ref string, bool)
To perform database check	CheckDb(ServerConnection, ILog , ref string )
To put database in user access mode	PutDbInUserMode(ServerConnection, DatabaseUserAccess ,bool, ILog, ref string)
To kill all user process for particular database	KillAllProcessesForOneDatabase(ServerConnection, ref string)
To determine the log size	DetermineLogSize(ServerConnection,ref string)
To set database in particular recovery mode	SetRecoveryMode(ServerConnection,RecoveryModel,bool, ILog , ref string)
To restore the database	RestoreDatabase(ServerConnection, ILog, ref string)
To shrink the database log	ShrinkLog(ServerConnection,int,ILog,ref string)
To determine is the database online	IsTheDataBaseOnLine(ServerConnection, ILog, ref string)

✅ IOHeLper

SQLCLR project which has, as a result, a DLL that should be published on the database server.

Method description	Method signature
Can I perform backup?	CanIPerformABackup(ServerConnection, ILog , ref string, DiskSizeUnit )
To delete old backup files	DeleteBackupFiles(ServerConnection, ILog, ref string)
To determine number and size	DetermineNumberOfBackupFiles(ServerConnection, ILog, ref int, ref Int64,ref string)

✅ Tester

A console application that could be useful to make some tests.

✅ SmoIntroduction

Class Name	Class Description
CreateGraph	Shows how to create NODE & EDGE tables
CreateMOTable	Shows how to create the memory optimized tables
CreatePartitionScheme	Shows how to create the partition scheme and the partition function
CreateStoredProc	Shows how to create the stored procedure
CreateSysVerTempTables	Shows how to create system-versioned ( temporal ) tables
CreateTable	Shows how to create traditional - disk based tables
ExtProperties	Shows how to manipulate with extended properties
ExtendedEvents	Shows how to manipulate with extended events ( create session, add targets, add events )
ListAllUserDefinedDataTypes	Shows how to get and recreate all user-defined data type in a database
RebuildIndexes	Shows how to rebuild indexes and update statistics
ServerConfiguration	Shows how to get the server configuration
ServerEvents	Shows how to subsribe to server events
SetDefaultInitField	Shows how to reduce the amount of T-SQL needed for object initialisation
TDE	Shows how to encrypt the database