Author Archives: Devendra Singh

About Devendra Singh

A guy with self learning capability , Analytical Ability , Exploring in nature , Just looking for ways for spreading happiness among everyone. Little aggressive some time. Just want peace everywhere in this world.

Logs for review on windows server


We can check the logs of windows server using powershell command Command : get-eventlog -logname System -EntryType Error

Aside | Posted on | Leave a comment

Remote Administration from Powershell


We are managing 22 servers and we need to have lot of data analysis and every time we have to login on the server and apply some of the methods to understand the data and draw some results for business. … Continue reading

Aside | Posted on | Leave a comment

Exporting directory Listing to excel Sheet : Powershell


We need to move some of the files which are coming as bank statements from bottomline to accounting system and some times we need be aware about the duplicate of files. In this post we just want to use powershell … Continue reading

Aside | Posted on | Leave a comment

Daily Technical Activities


We are just trying to go with full speed for learning in the month of June so that we can see the technical capacity with ourself . Today i thought to create the list of activities that we are doing … Continue reading

Aside | Posted on | Leave a comment

SQL Server Profiler 101


Description SQL Server  Profiler is a powerful tool that allows you to capture and analyse events, such as the execution of a stored procedure, occurring within SQL Server. This information can be used to identify and troubleshoot many SQL Server-related problems. basics … Continue reading

Aside | Posted on | Leave a comment

Audit sensitive data to see who did what, when, where, and how ?


We need to have information about whats going on our SQL server and What is being changed ? When it was changed ? Where its changed ? How its changed ? These all questions need to be explored to understand … Continue reading

Aside | Posted on | Leave a comment

Using the SQL Server Profiler


These SQL Server Profiler event classes can be used to help you find out if SQL Server is running as efficiently as it can. They include: Execution Warnings: For very busy servers, it is possible that a query may have … Continue reading

Aside | Posted on | Leave a comment