Showing posts with label MicroSoft SQL Server. Show all posts
Showing posts with label MicroSoft SQL Server. Show all posts
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...
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:
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...
Wednesday, 20 January 2016

Error accessing Oracle Database Objects via Linked Server in SQL Server (The OLE DB provider "OracleOLEDB.Oracle" for linked server reported an error. Access denied.)

›
In one of the project we are working these days, there was a requirement to fetch some details, directly from the Oracle Database via VIEWS...
Wednesday, 25 November 2015

Analyzing SQL Server Error Logs / Agent Logs using T-SQL

›
Even though you design our SQL Scripts with the best methods using best practices, or configure the SQL Server to perform correctly and in ...
Sunday, 22 November 2015

Enabling Instant File Initialization in SQL Server

›
Technorati Tags: MicroSoft SQL Server Every time the SQL data file or log file expands, it fills the newly allocated (expanded) space with ...