Database Articles

About: JShah

Full Name

J Shah

Website

http://sqldbpool.wordpress.com

Details

I have 5 years of experience in database technologies. Responsibilities 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

Posts by JShah:

• November 10, 2009 Msg 7391, Level 16, State 2, Line 23 – Error while running Linked Server

• November 6, 2009 Script – Generate DBCC ShrinkFile for each datbase files

• November 3, 2009 Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection.

• November 2, 2009 DBCC PAGE

• October 16, 2009 Shrink Log File

• October 13, 2009 An error has occurred while establishing a connection to the server

• October 9, 2009 What are the features we can enable using Surface Area Configuration Tool?

• October 8, 2009 SQL Server Security Interview Questions

• October 8, 2009 How to change Min/Max Memory in SQL Server?

• October 7, 2009 SQL Server 2008 Active-Passive/Active-Active Cluster Installation

Older Posts »