Showing posts with label CodeProject. Show all posts
Showing posts with label CodeProject. Show all posts
Thursday, 4 November 2021

Full Backup Vs. Differential Backup Vs. Log Backup

›
When it comes to backing up SQL Server databases, it's critical to know what backup types are there and what you should choose. In order...
Monday, 1 November 2021

Removing Invalid Logins (Both Server and Database Principals) from SQL Server

›
Have you ever come across a situation where you need to remove SQL Logins of users which have already left the organisation and not valid ...
Sunday, 31 October 2021

Attaching SQL Database with FILESTREAM data

›
 Have you ever come across a situation where you need to attach a database using existing files (mdf, ldf & file stream data), but you...

SQL Server Transaction Log file behaviour in Full Recovery Mode

›
In a previous blog post, I have explained different types of recovery models in SQL Server databases. During the explanations, I have state...
Saturday, 30 October 2021

Recovery Models in SQL Server Databases

›
 "Recovery Model" determines how long the data is to be kept in the transaction logs. It also allows what sort of backups and re...
Friday, 10 May 2019

Strange behavior on JSON_VALUE when table contains blank and non-blank values (JSON text is not properly formatted. Unexpected character '.' is found at position 0.)

›
Few days back we had a requirement to search whether a certain value exists in one of the table fields where the values are stored as JSON ...
6 comments:
Monday, 10 September 2018

Applying database principal through out the server (for all databases) for a particular user

›
Ever come across a requirement which you required to give db_datareader access to a specific user across all the databases on a particular S...
Friday, 6 July 2018

Replacing sp_depends with sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities

›
sp_depends have been one of the most used system stored procedures in SQL Server. Infact many of us still use that even though Microsoft had...
Wednesday, 30 May 2018

Computed columns in SQL Server

›
Computed columns are type of columns which the values are derived based on one or more other columns. Hence the data type on the computed c...
Tuesday, 20 March 2018

Data Encryption in SQL Server using T-SQL Functions (ENCRYPTBYPASSPHRASE, DECRYPTBYPASSPHRASE & HASHBYTES)

›
Decade ago data was just an entity which helped business to operate smoothly. By then data was considered as some sort of business related i...
1 comment:
Saturday, 10 March 2018

Strange behaviour converting NVARCHAR(MAX) to BINARY

›
Few days back I was writing a CLR function to be used for hashing string values. The only option was the CLR functions since T-SQL doesn’t h...
1 comment:
Sunday, 3 December 2017

Behaviour of IDENTITY Columns and SEQUENCES with TRANSACTIONS

›
Few days back, I was caught in a discussion with couple of my colleagues, regarding a problem they are facing with an IDENTITY column. The i...
Tuesday, 18 October 2016

Always Encrypted feature in SQL Server 2016

›
With the introduction of SQL Server 2016 in June (Official Final Release), Microsoft had introduced few, new and very useful features in to ...
1 comment: