Dynamic data masking (DDM) limits sensitive data exposure by masking it to non-privileged users. It can be used to greatly simplify the design and coding of security in your application. Permission You do not need any special permission to create a table with a dynamic data mask, only the standard CREATE TABLE and ALTER on schema permissions. Adding, replacing, …
Using Database Mail, your database applications can send e-mail messages to users. The messages can contain query results, and can also include files from any resource on your network. Database Mail has two configuration objects: The database configuration objects provide a way for you to configure the settings that Database mail should use when sending …
Here i am trying to find missing indexes on foreign key relation tables. Other References:
Returns the ASCII code value Converts an integer ASCII code A to a character Search character Replace Character PATINDEX (‘%pattern%’ , ‘A’) STUFF (‘A’, S, L, ‘B’) SOUNDEX DIFFERENCE (‘A’, ‘B’) of soundex LEN Returns length of ‘A’, excluding trailing blanks SUBSTRING –Returns L characters of ‘A’ starting at SSUBSTRING(‘HELLOW’,2,1) = ‘E’SUBSTRING(‘HELLOW’,5,10) = ‘OW’SUBSTRING(‘HELLOW’,10,1) = …
SQL Server provides two features that track changes to data in a database: change data capture and change tracking. These features enable applications to determine the DML changes (insert, update, and delete operations) that were made to user tables in a database. Change Data Capture configuration settings ● maxtrans* — The maximum number of transactions to process in …
Track data changes using CDC in SQL Server Enterprise edition Read More »
SQL Server 2016 introduced support for temporal tables (also known as system-versioned temporal tables) as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time. Temporal is a database feature …
dm_db_log_space_usage, databases
