Hi Folks If you want to trace out who have alter the user roles in the SQL Server.here is the simplest way. Open SQL Server management studio and execute the below query select * from sys.traces Copy the output of sys.traces and replace it in the query path of below query SELECT TextData,StartTime,NTUserName,ApplicationName FROM fn_trace_gettable(‘C:Program […]
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 […]
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 […]
SQL Server 2005 Enterprise edition introduced audit feature from SQL Server 2005 and later on all versions of SQL Server(2008,2008 R2,2012).
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 . […]