Feel Free to consult your Database Servers (MSSQL and MySQL)
Email ID: jshah143@gmail.com
My database group
* Group name: sqldbpool
* Group home page: http://groups.google.co.in/group/sqldbpool
* Group email address: sqldbpool@googlegroups.com
Experience Summary
1) Database design.
2) Installation of MS-SQL Server, Managing Multiple instances on one server.
3) Managing multiple servers with different configurations.
4) Database Engine, MS-SQL server SSIS, MS-SQL server Full-Text Search.
5) Managing Memory for Large Databases, Linking Servers, Configuring SQL Mail, Database Mail and SQL Server Agent Mail.
6) Configuring High Availability Database Mirroring, Log Shipping, Replication.
7) Backup and Restore of the databases, backup on tape and restore form tape and Disaster Recovery.
Security considerations for MS-SQL server, (SQL injections).
9) Automating Administrative Tasks.
10) Migration of the older versions to 2005.
11) Monitoring and Tuning for Performance.
12) Patch management for development, staging and Production databases.
13) Production Server Alert setup (Disk, Memory, Processor etc) using performance and monitor tool.
14) Database archiving task.
15) Writing stored procedures, functions and triggers.
16) MySQL Clustering setup on Linux Machine using Linux-HA Service and DRBD (Distributed Replicated Block Device).
17) Database Report design using Microsoft Reporting Service, Crystal Reports and BIRT (open source).
18) Capacity planning exercises to properly identify required hardware, software, database configuration/architecture necessary to support application need.
19) Data Modeling, schema design and review.
20) Tuning and debugging high performance, high availability databases.
21) Reviewing and applying database schema changes.
22) Creating a large number of replicas.
23) Replication setup in MySQL.
24) XML handling using MSSQL Server 2000/2005
Organization level activities
25) Imparted the SQL Server, MySQL and Crystal report trainings
26) An active member of the database manager pool. (Solve DB related issue of the different projects)
Please leave your comments here
I am waiting for your feedback
I need help with Transfer Data from a specific table to Excel from my database. I use SQL Server 2005
Do I need a script or is it easy to Using SQL Server Data Transformation Services.
Where do I find that tool, SQL Server Data Transformation Services (DTS)
Thanks & Regards,
I sometimes use Excel to extract data. This will be choppy but you
should be able to figure it out or at least search the web for more
detailed instructions for your specific need.
1- Create a button in excel.
2- Rename the button and caption if you like (I renamed the button to
‘UpdateData’).
3- Double-click the button so the vb editor opens.
4- Edit the Sub it creates for you to call another sub you will make
later:
My code looks like this (notice the sub has the name I used):
Private Sub UpdateData_Click()
UpdateTririgaData_Click
End Sub
5- In the Microsoft Visual Basic editor look at the left pane, the
viewer to the left should have a Modules section, right click and create
a new module.
6- In the module paste something like this (notice there are two subs):
Public Sub UpdateTririgaData_Click()
Sheets(“raw”).Select
Rows(“2:10000″).Select
Selection.ClearContents
ImportTririgaProjectData
End Sub
Private Sub ImportTririgaProjectData()
‘ Get the start and end times
Dim startdate As String
Dim enddate As String
startdate = Worksheets(“Pivot”).Range(“B1″).Value
enddate = Worksheets(“Pivot”).Range(“B2″).Value
‘ Create a connection object.
Dim cnTridata As ADODB.Connection
Set cnTridata = New ADODB.Connection
‘ Provide the connection string.
Dim strConn As String
‘Use the SQL Server OLE DB Provider.
strConn = “PROVIDER=SQLOLEDB;”
‘Connect to the Pubs database on the local server.
strConn = strConn & “DATA SOURCE=;”
strConn = strConn & “INITIAL CATALOG=;”
strConn = strConn & “User ID=;”
strConn = strConn & “Password=;”
‘Use an integrated login.
’strConn = strConn & ” INTEGRATED SECURITY=sspi;”
‘Now open the connection.
cnTridata.Open strConn
‘ Create a recordset object.
Dim rsTridata As ADODB.Recordset
Set rsTridata = New ADODB.Recordset
With rsTridata
‘ Assign the Connection object.
.ActiveConnection = cnTridata
‘ Extract the required records.
.Open ” select t2.OrganizationName, t7.Priority, t7.WorkId,
t7.Description, t1.PlannedEndDateTime, t1.ActualEndDateTime ” _
& “, t7.Status ” _
& ” from T_WORKTASK t1 left outer join T_ORGANIZATIONCONTAINER
t2 on t1.AssignedToSysKey2=t2.spec_id left outer join V_WORKCONTAINER
t7 on t1.AssociatedToSysKey2=t7.spec_id ” _
& ” where t1.SYS_OBJECTID > 0 ” _
& ” and t1.PlannedEndDateTime/1000 >= datediff(second,
‘01/01/1970′, ‘” & startdate & “‘) ” _
& ” and t1.PlannedEndDateTime/1000 0 ” _
& ” order by upper(t2.OrganizationName) ,upper(t7.Priority)
,upper(t7.WorkId) ”
‘& “, cast(DATEADD(s,cast(t1.ActualEndDateTime/1000 as
int),’01/01/1970′) as DateTime) as ActualEndDate ” _
‘ Copy the records into cell A1 on Sheet1.
Worksheets(“raw”).Range(“A2″).CopyFromRecordset rsTridata
‘ Tidy up
.Close
End With
cnTridata.Close
Set rsTridata = Nothing
Set cnTridata = Nothing
End Sub
7- You will have to change ” PROVIDER=SQLOLEDB;” if you are connecting
to Oracle. You will have to update all the connection information. You
will have to change any worksheet references that I have to worksheets
that you have.
8- Additionally, before you test your new button you will have to make
sure you have added the correct driver into your vb editor. To do this
click Tools->References
8a- I have ensured that ‘Microsoft ActiveX Data Objects 2.8 Library’ was
checked.
9- Now go back to your new button and click it, ensure that your not in
‘Design Mode’ (the icon with a ruler, pencil and 45′ drafting square in
it – you may have to added it to your menu bar first)
Can you take corporate training in our company?
Yes I am taking corporate training, online production support
hi,
i am working on VB.Net stored procedure i mean VB.Net 2005 SQL project. in that i need to wrote a stored procedure using VB code and finally need to deploy the created SP in SQL server. a different SP gets created in the SQL server.
now my query is when i am writing complex SP’s such as when i need to pass the output from one SP to other SP as input, how can i store these values since i require these oputput values for further comparisons with other SP’s as well. what kind of collection can be created which can handle the values permanently.
I need help with Transfer Data from a specific table to Excel from my database. I use SQL Server 2005
Do I need a script or is it easy to Using SQL Server Data Transformation Services.
—————————————————————————–
You have to use SSIS which is in SQL Server BI tool
Where do I find that tool, SQL Server Data Transformation Services (DTS)
Pls help me?
How To Make dynamic Cross Tab Query in SQL Server 2005
Hi Dinesh,
You can use SP_ExecuteSQL or Execute clause, store the dynamic query in string and using Execute or SP_ExecuteSQL you can execute them
hello sir
i have read many articles regarding clustered index and non clustered index.but i am unable to figure out the difference in real practical scenario.when we should choose clustered or nonclustred for a column.whats the real difference as far as performace is concerned.please help me
You have only 1 clustered inedex and 249 non-clustered index. Clustered Index arranges the physical order of the data as per the sorting order. Both tree are using the B-Tree Structure. The main diffrence is in their leaf level node. In Clustered index leaf level node stores the data pages, so it can search more fast than the other indexes. while non-clustered index in its leaf level stored the row addres or the clustered index address to locate the row. so clustered index can search more faster than the non-clustered index.
I want to learn SQL server. Where should I start? Can I ge tthe installation CD?
Yes. You can call me or email me.
Hello webmaster
I would like to share with you a link to your site
write me here preonrelt@mail.ru
Hello Sir,
I want to learn SQL 2000, 2005.
Let me guide, from where I have to start.
Which books are good?
Best ways to crack interviews, types of questions they ask.
Any types of enterprise demos, we have to perform in real time environment.
At last, different ways to get job after learning sql dba.
I will really appreciate if you gonna help me in the described matter.
Thanks & Regards,
Dhaval Patel
sir can you tell me more about Linking Servers or remote servers through IP configuration with remote servers