When the database CHECKDB task gets completed .This does is a frequent question asked my Team Leads/Managers or else any one. Buy UN fortunately SQL Server Management Studio does not help us n o this. No Worries we from SQL Server 2005 and above we have DMV to help us out. use master go SELECT […]
Please register for Junior SQL Server DBA What to do & What not to do on Sep 13, 2014 2:00 PM IST at: https://attendee.gotowebinar.com/register/1233616123437806338 This webminar is usefull to the Junior DBA. Best Practices to follow SQL Server Optimal Settings. Database Optimal Settings Monitoring SQL Server Performace Activity Monitor Perfmon Change log how to do […]
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).