SQLScientist.com

Pages

Home
About Me
Contact Us
Portfolio
SQL Server Interview Questions

No posts. Show all posts

Home

Subscribe to: Posts (Atom)

About Me

Asif Ghanchi

View my complete profile

Popular Posts

SQL Server Scenario Based Interview Question

1. There’s a table with below data Write a query which will give below output. Query: declare @input as table ( ...
Auto Maintain Archive, Purge & Purge on Source Table in SQL Server

We are developing many application where we are auditing, archiving and purging data also for many tables. Most of the application will us...
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.

This is most well known error when we are trying to access excel from SQL Server. To fix this issue, we need to follow below steps. In...
Setup Kerberos Authentication for SQL Server

Below are steps to configure Kerberos Authentication for SQL Server. 1) Open Active Directory 2) Go to the properties of Server where ...
Get column header list from Excel using Open XML SDK 2.5

There are many applications which are using to insert, update and delete data in database using Excel file. In this type of requirement, we...
Auto Audit Column Wise Change Data Capture (CDC)

Change data capture is used to audit insert, update, and delete activity for table in SQL Server table. You can go through below link to und...
Different ways to execute/store SSIS packages

Before going ahead, we should be aware about how many ways we can store SSIS packages File system SQL Server (Integration Service) SQ...
Error Logging and Alerts in SQL Server

Error Logging is main part of our database application. I am trying to share some sample code which I am using in my daily life. We need t...
Unzip all *.zip files from folder including child folders

I am writing this blog for one on my colleague Ashish Gupta who wants to do this task for his Production Deployment repeatedly. We had requ...
Could not update the metadata that indicates database is enabled for Change Data Capture.

Today, I came across below error when I was trying to enable CDC for database. I used below query to enable CDC on database. Query: Use ...