Wednesday, 4 May 2022

Avoiding NULL or blank values when reading Excel containing mix data types using SSIS

›
 Have you encountered the issue of getting null values or blank values when data is read using an SSIS package and exported to a text file? ...
Sunday, 21 November 2021

Missing SQL Server Configuration Manager (SSCM) from the Start Menu

›
 Have you encountered an issue where the SQL Server Configuration Manager console is not available among the other SQL Server-related start ...
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...