IDENT_CURRENT Function
The IDENT_CURRENT function returns the last IDENTITY value generated for any specific table or view on an identity column in any session and any scope.… Read More »IDENT_CURRENT Function
SQL Vulnerability Assessment
SQL Vulnerability Assessment (VA) is an easy to use tool that you can use to identify, track, and remediate potential database vulnerabilities. The VA service… Read More »SQL Vulnerability Assessment
SQL ROLLBACK Transactions
SQL ROLLBACK transaction statement rolls back an explicit or implicit transaction to the beginning of the transaction. If a savepoint is specified, it rolls back… Read More »SQL ROLLBACK Transactions
Column Level Encryption Decryption using Symmetric Keys
SQL Server allows several options to protect sensitive data, and one of them is specifying a column level encryption. Using this option you can encrypt… Read More »Column Level Encryption Decryption using Symmetric Keys
How to Read SQL Server error logs using the xp_readerrorlog
Xp_readerrorlog is a SQL Server extend stored procedure allows you read the contents of the SQL Server error log files. It allows you to read… Read More »How to Read SQL Server error logs using the xp_readerrorlog
SQL QUOTENAME Function
SQL QUOTENAME function is a string function which returns a Unicode string with the delimiters added to make the input string a valid SQL Server… Read More »SQL QUOTENAME Function
SQL JSON_VALUE Function
JSON_VALUE is a JSON function which is used to extracts scalar value from JSON string. It returns a single text value of type nvarchar. It… Read More »SQL JSON_VALUE Function
Row Level Security in SQL Server
Row-Level Security enables you to use group membership or execution context to control access to rows in a database table. Row level security feature introduced… Read More »Row Level Security in SQL Server
SQL JSON_MODIFY Function
The JSON_MODIFY is a JSON functions that allows you to update the value of a property in a JSON string. It introduced in SQL Server… Read More »SQL JSON_MODIFY Function
SQL Correlated Subquery
A correlated subquery is a subquery that uses the values of the outer query and it is evaluated for each row processed by the outer… Read More »SQL Correlated Subquery
SQL sp_helptext
SQL sp_helptext is a SQL Server System stored procedure that displays the the definition of any SQL Server objects. You can see the definition of… Read More »SQL sp_helptext
SQL Over Clause
SQL OVER clause allows the use of aggregation without using a group by clause. OVER clause aggregate rows across groups of another field using the… Read More »SQL Over Clause
SQL Server @@Servicename
SQL @@servicename is SQL Server configuration function which returns the name of the registry key under which SQL Server is running. This function does not… Read More »SQL Server @@Servicename
SQL Server sp_procoption startup procedures
The sp_procoption is a SQL Server system stored procedure allows us to Set or clear a stored procedure for automatic execution when an instance of… Read More »SQL Server sp_procoption startup procedures
SQL ROUND Function
The SQL ROUND function is a SQL Mathematical Function which is used to round a number to a specified length or precision. It returns a… Read More »SQL ROUND Function
SQL NOT NULL Constraint
SQL NOT NULL Constraint is used to prevent inserting NULL values into the specified column. When value for any specific column is not provided while… Read More »SQL NOT NULL Constraint
SQL Server sp_executesql
The sp_executesql is a SQL Server built-in sytem stored procedure that enables to execute of the dynamically constructed SQL statements or batches. The following are advantages… Read More »SQL Server sp_executesql
SQL Server Change Data Capture
SQL Server Change Data Capture also know as CDC, was introduced in SQL Server 2008 version. It is used to capture the changes made to… Read More »SQL Server Change Data Capture
SQL change column collation to case sensitive
How to change the Collation of table column to Case insensitive or Case sensitive? Lets prepare a sample table called DumpData, and insert few records… Read More »SQL change column collation to case sensitive