Contact Me (Consulting)

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.

8) 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)


Responses

  1. Please leave your comments here

  2. I am waiting for your feedback :)

  3. 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,

  4. 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)

  5. Can you take corporate training in our company?

  6. Yes I am taking corporate training, online production support

  7. 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.

  8. 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)

  9. 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

  10. 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.

  11. I want to learn SQL server. Where should I start? Can I ge tthe installation CD?

    • Yes. You can call me or email me.

  12. Hello webmaster
    I would like to share with you a link to your site
    write me here preonrelt@mail.ru

  13. 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

  14. sir can you tell me more about Linking Servers or remote servers through IP configuration with remote servers


Leave a response

Your response: