Vadrevu - SQL Server DBA - Hyderabad, Andhra Pradesh, India

Naresh Vadrevu

Hyderabad, Andhra Pradesh, India


SQL Server DBA


The Data Base Administrator (DBA) is responsible for providing technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies, and providing Information Technology with a long-term perspective on the relationship of database technology to the business opportunities facing the company. It is extremely important to the company that on-line processing database systems offer the highest reliability and performance possible. The DBA is challenged to work with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives. Trains and develops technical support and applications staff to better utilize on-line processing databases environment. Provides and designs tools to assist in the management of the database and transaction processing environment.Works to provide a working model of our transaction processing environment for capacity assessment and planning.

Work History

Programmer Analyst


April 2011 - April 2011

Programmer Analyst
- ASP.NET developer
- Website portal developer (AJAX, JQUERY, CSS, DHTML, XML and JS)
- Windows and Web based applications
- HTML5 based applications
- Applications complaint to both web and mobile channels.
- Consuming and providing Webservices
- Integration with other components

Programmer Analyst

wilshire software technologies

From April 2010

Jr. Software Engineer

MV Data Systems

November 2009 - April 2011

Jr. Software Engineer
-Product Based Applications
-Windows based Applications using VB.NET and SQL SERVER 2008
-Installations and Debugging on Client side environment

Programmer Analyst

Wilshire Software Technologies

Analyst Programmer

Wilshire Software Technologies


Delete a File from a Folder in using C#, VB.NET

To implement this functionality we need to write the following code like as shown below

string FileName ="test.txt";
string Path = "E:\\" + FileName;
FileInfo file = new FileInfo(Path);
if (file.Exists)
If you want to see it in complete example check below code

<html xmlns="">
<head runat="server">
<title>how to delete a file from a folder in using c#</title>
<form id="form1" runat="server">
<td><b>Enter File Name to Delete:</b></td>
<td><asp:TextBox ID="txtName" runat="server" /></td>
<tr><td></td><td><asp:Button ID="btnDelete" runat="server" Text="Delete File" /> </td></tr>
<tr><td colspan="2"><asp:Label ID="lblResult" runat="server"/></td></tr>
Now open code behind file and add following namespaces

C# Code

using System;
using System.Drawing;
using System.IO;
After that write the following code in code behind

protected void btnDelete_Click(object sender, EventArgs e)
string filename =txtName.Text;
string path = "E:\\" + filename;
FileInfo file = new FileInfo(path);
if (file.Exists)
lblResult.Text = filename + " file deleted successfully";
lblResult.ForeColor = Color.Green;
lblResult.Text = filename + " file not exists in filepath";
lblResult.ForeColor = Color.Red;

Imports System.Drawing
Imports System.IO
Partial Class Default2
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)

End Sub
Protected Sub btnDelete_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim filename As String = txtName.Text
Dim path As String = "E:\" & filename
Dim file As New FileInfo(path)
If file.Exists Then
lblResult.Text = filename & " file deleted successfully"
lblResult.ForeColor = Color.Green
lblResult.Text = filename & " file not exists in filepath"
lblResult.ForeColor = Color.Red
End If
End Sub
End Class

How to Get Multiple Tables From Stored Procedure - MS SQL, ASP .NET

Lets say you have a stored procedure that makes multiple select statements to return multiple sets of data. And you like to get them on your Asp .Net code. Take this stored procedure for example:
-- =============================================
-- Author: Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[TestSproc]



Select top 10 * from MyTable1
Select top 10 * from MyTable2


On your Asp .Net you can code like this to retrieve multiple tables from the stored procedure. This code is in C#.

DataTable table1=new DataTable();
DataTable table2=new DataTable();

string connectionString="------------------"; //set the connectionString
System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectionStri ng);

System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand();
command.Connection = connection;
command.CommandText = "TestSproc";
command.CommandType = CommandType.StoredProcedure;
//set sproc params

SqlDataAdapter adapter = new SqlDataAdapter(command);
DataSet dataSet = new DataSet();
if (dataSet.Tables.Count > 0)
table1 = dataSet.Tables[0];
if (dataSet.Tables.Count > 1)
table2 = dataSet.Tables[1];


SQL Server DBA - Retrieving SQL Server Fixed Server Roles for Disaster Recovery

There is and it revolves around the system stored procedure sp_helpsrvrolemember. If we look at the entry for this system stored procedure in the online version of Books Online, we can get the output format, which gives us what we need to create a temporary table to hold our results. This leads to our CREATE TABLE statement (with a SET NOCOUNT ON to supress row count numbers coming back, because we don't need them):

CREATE TABLE #ServerRoleMembers (
ServerRole sysname,
MemberName sysname,

We can use an INSERT statement along with a stored procedure execution, and that's what we'll do with sp_helpsrvrolemember. So if we want to cover all known fixed server roles, here's what we do:

INSERT INTO #ServerRoleMembers (ServerRole, MemberName, MemberSID)
EXEC sp_helpsrvrolemember;

If you specify sp_helpsrvrolemember without a parameter, it will return back the role memberships for all the fixed server roles. This is typically what we want. If that's not the case and you only want specific roles covered, you'll need to list each one individually, meaning a separate insert statement like so:

INSERT INTO #ServerRoleMembers (ServerRole, MemberName, MemberSID)
EXEC sp_helpsrvrolemember '<server role>';

And then we just need to write a SELECT query that builds our T-SQL to re-create the role memberships at a later time (and then drop the temporary table):

SELECT 'EXEC sp_addsrvrolemember @loginame = ''' + MemberName + ''',
@rolename = ''' + ServerRole + ''';'
FROM #ServerRoleMembers;

DROP TABLE #ServerRoleMembers;

All of this should be run as a single batch script and the output should be saved off to a file which will be backed up. This will ensure we have a runnable script for future recovery.

Now if you're wondering about why the choice of sp_helpsrvrolemember, it's simple: it runs across all supported versions of SQL Server without a version check. We could use catalog views and the like, but since sp_helpsrvrolemember is still fully supported, we can use it to create a very simple solution.

Qualifications & Certifications

Computer Sciece & Engineering

Dr. Paul Raj Engineering College


Dr. Paul Raj Enginnering College

Dr. Paul Raj Engg college, JNTU HYDERABAD

Dr. Paulraj Engineering College


St. Thomas University

Skillpages has been acquired by! is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more

Are you sure that you want to leave?