Scott Stephens creates a package that allows you to clone most database objects with dynamic SQL.

SQL Server database corruption is troublesome for DBAs, particularly if the situation arrives suddenly and there is no backup. This situation can lead to prolonged downtime and permanent data loss in ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part ...

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 ...

If you have accidently deleted data from database tables in MS SQL Server, you can restore the deleted data (tables) using Log Sequence Number (LSN). But for this, you need the transaction backup file ...

Learn about SQLCLR, writing database objects in managed code, and configuring SQL Server to use code located within .NET assemblies.

The heart of any relational database management system is the system catalog that documents the database objects and system settings being used. The system catalog offers a wealth of information about ...

SQL development is evolving fast, and Microsoft.Build.Sql is leading the charge. This next-generation SDK brings flexible project structures, better source control integration, automated build-time ...

.NET 6 adds the ability for ADO.NET database drivers to support efficient command batching using native protocols.