Tag Archives: 2008 R2

Top 30 SQL Server DBA Interview Questions

Top 30 SQL Server DBA Interview Questions SQL THE ONE There are total 185 questions are answered under SQL Server DBA category in the book “SQL THE ONE”. In this chapter we can see questions and answers on DBCC, Common, … Continue reading

Posted in Interview Q&A, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , | Leave a comment

Top 40 SQL Server Performance Tuning Interview Questions

Top 40 SQL Server Performance Tuning Interview Questions SQL THE ONE There are total 254 questions are answered under SQL Server Performance Tuning category in the book “SQL THE ONE”. In this chapter we can see questions and answers on … Continue reading

Posted in Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , , , , , , , , | 5 Comments

Deploying SSIS package using Deployment Manifest with screenshots

Creating SSIS Deployment Manifest Deploying SSIS package using Deployment Manifest with screenshots To demonstrate SSIS package deployment manifest with screenshots I have created a test package on dummy source and destination databases. The package ETL data between source and destination … Continue reading

Posted in MSBI, SQL Server DBA, SSIS | Tagged , , , , , , , , , | 9 Comments