Author Archives: uday arumilli

Upgrading SQL Server Questions and Answers

Q&A Upgrading SQL Server Questions and Answers         1. Can you upgrade SQL Server 2008 SP2 Standard Edition to 2008 R2 Developer Edition? Ans: You can’t change the version of the installed instance as far as I … Continue reading

Posted in High Availability, SQL Server DBA | Tagged , , , , , , , | 16 Comments

Installing SQL Server Interview Questions

Q&A Installing SQL Server Interview Questions and Answers Installing SQL Server Interview Questions and Answers Here are listing out few question and answers on installing sql server, lets go through these questions. 1. What are the components installed with the … Continue reading

Posted in SQL Server DBA | Tagged , , , , , | 1 Comment

Using variables in SSIS – Simple example

Using variables in SSIS – Simple example Working with variables in SSIS: A simple demonstration Before building the ETL package we need create a sales history table: CREATE TABLE Product_Sales_History( SaleID BIGINT NOT NULL UNIQUE, ProductID VARCHAR(50) NOT NULL, Total … Continue reading

Posted in MSBI, SSIS | Tagged , , , , , | Leave a comment