Export data from SQL Server to an Excel file


Sometimes you need to export data from SQL Server tables, views or the result of any T-SQL query into excel file, reason could be anything such as MIS team need Sales data in excel file…

 274 total views,  17 views today

Read More...

Difference between clustered index and non clustered index


SQL Server indexes are used by queries to find data values quickly in tables and views. Basically it speed up the queries performance. You can also relate a SQL Server Indexes with any text book…

 572 total views,  6 views today

Read More...

SET STATISTICS IO


SQL STATISTICS IO is a set statement , when it is enabled it causes SQL Server to display information about the amount of disk activity generated by T- SQL statement. SYTANX SET STATISTICS IO {…

 161 total views

Read More...

How to insert the result of a stored procedure into table


Sometimes, you want to store the result of a stored procedure into table or temp table instead of returning the output. Storing output of stored procedure into table enables more option for you, such as…

 733 total views,  5 views today

Read More...

Dynamic Data Masking in SQL Server


Dynamic data masking also known as DDM is a security feature in SQL Server which helps you to prevent the access of unauthorize users to sensitive data in the database. It was introduced in SQL…

 557 total views,  33 views today

Read More...

View Collation Information in SQL Server


Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data. You can easily find SQL collation at the server, database and column level using SQL Server System Catalog views, or…

 310 total views,  1 views today

Read More...

DROP IF EXISTS


SQL Server 2016 has released an optional IF EXISTS clause with DROP statement that can be used as DROP IF EXISTS. DROP IF EXITS verify if an object exists then drops an existing object and…

 340 total views,  1 views today

Read More...

Script table in SQL Server


You can script a table from database using a SQL Server Management Studio. SQL Server Management allows you to script out tables from database using a Script table as option. This option can be used…

 73 total views,  1 views today

Read More...

Generate Database Scripts With Data in SQL Server


You can generate a database scripts including the schema and the data by using the Generate Scripts option available in SQL Server Management Studio (SSMS), which generates a scripts for selected database. When you perform…

 337 total views,  3 views today

Read More...

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. This function is limited only to a specific table or…

 158 total views,  3 views today

Read More...

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 runs a scan directly on database, and follows base of…

 187 total views,  4 views today

Read More...

SQL ROLLBACK Transactions


SQL ROLLBACK transaction statement rolls back an explicit or implicit transaction to the beginning of the transaction. If savepoint is specified then it rolls back the transaction to a savepoint within the transaction. Basically, it…

 1,358 total views,  7 views today

Read More...

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 a column data also decrypt the data. SQL Server encrypts data…

 460 total views,  4 views today

Read More...

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 can not be used to extract JSON object or JSON…

 299 total views,  1 views today

Read More...

SQL JSON_QUERY Function


SQL JSON_QUERY is a JSON function which extracts an object or an array from a JSON string. JSON_QUERY function introduced in SQL Server 2016. You can not extract a scalar value using JSON_QUERY function. It…

 294 total views,  1 views today

Read More...

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 in SQL Server 2016. Once it is enabled, It applies…

 510 total views,  2 views today

Read More...

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 2016. JSON_MODIFY function returns the updated JSON string. Using JSON_MODIFY…

 201 total views,  6 views today

Read More...