With SQL Server 2005 many things have been changed. In earlier versions in order to make it work, SQL Mail relied on having a MAPI mail client installed like Outlook. This has changed with SQL Server ...

This feature applies to SQL Server 2022 and later on Azure Virtual Machines and Arc enabled SQL Server. Guest users with Microsoft Entra B2B collaboration are users that have accounts in an external ...

The CLR assembly in this project can only be deployed to a SQL Server with CLR enabled, and support for UNSAFE permission set. If you have SSDT, you can open the SQL server project and publish it to ...

Database auditing is the activity of monitoring and recording configured database actions from database users and nondatabase users, to ensure the security of the databases. An administrator can ...

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...

A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine’s system databases. Tim Chapman discusses these system databases. A fundamental skill for DBAs is to have ...