Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

Obtain information about database objects and the database as a whole. Gives information about the roles and users of an application. You can use the str () function to operate on a character or ...

This article, “ SQL Server Management Objects: Finally ready for prime time,” was originally published at InfoWorld.com. Read more of Sean McCown’s Database Underground blog and follow the ...

A business object written with an SQL pass-through has the database server do more record processing. With a pass-through, the server does the subtotals and sends fewer records back to the object.

We have responsibility across the spectrum, from low-level drivers up through the big GUI tools: SMO [SQL Server Management Objects], DacFX [Data-Tier Application Framework], SQL PowerShell, SSDT ...

Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc. - MicrosoftDocs/sql-docs ...

Now, let's take a look at another technology in SQL Server: Policy-Based Management. As part of the SQL Server Management Objects (SMO), DBAs have access to the wonderful world of policies.

Fixed an issue that was causing SQL Server Management Studio to crash when an object is dragged from object explorer to the editor. You can review the feedback on this issue to learn more. Fixed an ...

This code example shows how to create an e-mail account in SMO. Database Mail is represented by the <xref:Microsoft.SqlServer.Management.Smo.Mail.SqlMail> object and referenced by the ...