Hi All Think you have to install sql server server pack to all the SQL Server in a Server. and Attended installation takes much time and human interferance, here is a simple idea solution for it .Install SQL Server Latest Service Packs from Command Prompt. its the easiest method to implement. Before proceding please take […]
SQL Server Upgradation is done in 2 ways Attended Installation/Upgrade Un Attended Installation/Upgrade (Silent Installation) Attended Installation/Upgrade is a basic method of installation . in which we interact with the GUI Screens in SQL Server Un Attended Installation/Upgrade (Silent Installation) is which sql server is upgraded from the command Prompt.
In my old blog i wrote how to import data from xml files. In this blog i am going to import data from xml files using SSIS(SQL Server Integration Services) Step 1 Open SQL Server Bussiness intelligence studio and create a new SSIS Package Step 2 Click on new ssis package insert dataflow task as […]
tablediff.exe is a Microsoft Internal tool in SQL Server 2008. this is used to check a quick comparison between 2 table in 2 different instanced.tablediff.exe can do a comparison search on row level ,common level and schema level, this command is located in the C:Program FilesMicrosoft SQL Server100COM path, syntax of tablediff.exe is as below […]
Migrating the users is the main time consuming task basically this can be acheived the 3 ways 1) Generate the user scripts 2) sp_revlogin 3) Using SSIS to migrate the users Generate the user scripts this is the basic method to migrating the user and it is very simple to implement,to implement this when you […]
you can use systeminfo command to command prompt .check the image below if you see System Manufacturer name as VMware, Inc.then it is a Virtual Machine You can even use SQL Server to confirm that SQL Server is runing on Physical or Virtual Machine ,just run the below query in the SSMS DECLARE @Result TABLE […]
SQL Server 2005 Enterprise edition introduced audit feature from SQL Server 2005 and later on all versions of SQL Server(2008,2008 R2,2012).
if there is a requirement of moving a backup manually from one place to other,then you can use backup with media password policy,check the image attached
Once the database mirroring is configured it is very important to monitor the performance of SQL Server and ldf size of the mirroring configured databases.network utilization of the Principle and Mirrored Server,you might get a question how many databases can be configured for log shipping, as per my experience 10 is the max value . […]