About Blog
This Blog is a place where I share my own personal thoughts, notes, opinions and experiences with databases. I believe we together learn the new things by sharing knowledge. I hope you all will enjoy reading this blog. If you do have any question please let me know, I will try my best to answer you.
About Author : Jugal Shah
I have 14 plus years experience as Solution Architect, DBA, Developer in SQL Server, MySQL, PostgreSQL, AWS Redshift, AWS Aurora, MariaDB, AWS RDS and cloud technologies.I love to share knowledge. Knowledge sharing is the best way to learn anything. I love to do programming whenever get a time. I have good knowledge in VB 6.0, .Net and Power Shell.
AWS Redshift and SQL Server I am subject matter expert.
Contact Me
Email Me:
jugal.shah@sqldbpool.com
My Certifications
Most Valuable Professional – SQL Server Award
Super excited to share that I have been recognized as Most Valuable Professional (MVP) by Microsoft for the consecutive four times and want share the award picture
MSSQLTips.com Trendsetter award 2013
Super excited to share that I have been recognized as Trendsetter by MSSQLTips.com for completing 25 articles
Dear sir
i am very much happy and like to see your certifications in you blog spot . i also want to do MS SQL Server 2005 Administration certification can you guide me for that
thanks
swaraj
Could you please guide me on MySQL Certification?
Yes Sure
Great feat!! 🙂
Congratulations!!
“The uncertainties of the present always give way to the enchanted possibilities of the future. You are destined for greatness. Enjoy your journey”
hello sir…
I want to be a sql dba i have knowledge of t-sql stored procedures etc. but i have no any environment where i could make practise of these things and become a successful dba
now a days i m in practise web developer with asp.net and c# sql server 2005 bt i want to be sql dba …
please Suggest me…
You can implement the virutal machines on your machine, do all the practice…
great Achivement
Hello sir,Awesom awards u got…
i also want to be DBA bcoz i m interested in database…
I m now in final year IT engg (2011-2012)from mumbai university..
so plz suggest me what kind of knowledge is necessary4 dat…
my email-id is:makkolhe12@gmail.com
plz sir…….help me…..
Hi sir,
Great position you are, and i also be like you, please gude and help me.
srihari22187@gmail.com-This is my mail iD.
Pls……
Thanks SriHari.. Let me know what information you are looking for?
Hi Shah,
I have eight years experience in windows system administration, now i plan to change my profile as SQL DBA, whats your opinion and from what version i need to start, currently what is the most used version between customer.
There is no specific version, most of the client use 2005 and 2008
Hi Shah jee,
It is very good and helpful material to everyboy related to database.Sir,
can you send me the related book’s name which are useful to become a DBA.
Thanks
DEV DUTT
9899489304
Emailid——devjnv2007@gmail.com
HI
Hello sir,i am shayna student of btech i want to get certified in oracle ocp bt rite now i want training in oracle.can i get training in oracle within 1 month ?
You have check for the institutes near by your location.
hello sir,i m rajashri can u tell me which is the latest version of sql server 2005 or 2008.i m doing rdbms course from compufield institute at warden road mumbai there is a scope for institutions course. plz guide me this is my email id
thank u.
it is SQL Server 2012
Hello Jugal, Im from Canada but completly Non-IT background. I started my little step by doing a course in Software Testing and got certified from ISTQB. I want to become DBA or atleast i think that..!!! I need a mentor who could guide me through the path. Would you like to be my Mentor..?? Please guide me through the path of DBA..!!
Thanks
DR
write your queries, i will guide you.
Hi Sir
can please suggests good books ,to get guidence while practicing below tasks as you mentioned in your PPT.
-performance and tuning
-Backup and restore
-Maintenance plan
-HA Setup
-DBCC
-Bloking/Deadlock
-capacity planning
-SQL profiler
-DTA
-SQL Configuration
-Best practice
-security setup
-Database Design
Hi Jugal Shah
I am having 3 years in sql sever DBA in on one organization for my environment we have to configure power shell script for below mentioned things:
Please configure powershell scripting and email notification for monitoring below.
1. SQL Server services running in PROD instances
2. Mirroring status on these instances.
3. Backup status on all instances.
Note :output should be in html format.and email notification.
can you help on this please.
Sure, I can guide you for that.
I got some tips from your blog. Thanks for it and will take help in future.
welcome Deepak
Hi Sir,
I interested learn sql DBA. Can you tell me any once online training center .
I would recommend to start with SQL DBA videos on youtube.
HI JUGAL ,
CAN U PLEASE TELL ME ABOUT JOB FAILURE ISSUES\
FOR EXAMPLE JOB WAS INVOKED BY USER
JOB WAS INVOKED BY SCHEDULE LIKE KIND OF ISSUES CAN U PLEASE INFORMATION ABOUT IT WILL BE HELPFUL TO ME…
Sir, I am working on MIS with Excel and MySQL .. My hobby is to work on data.. So please suggest me for DBA. I have done 6 months traing in .net as well but still not using.
Kindly suggest..
Regards,
Shiv
Sir, I am working with MIS excel and MYsql. My hobby is to work on data.
and knowledge of C# as well . is it possible to go in DBA field. pls suggest .
Rgards,
Shiv
Yes, start with the DBA roles and responsibilities.
Thank you ..so much for sharing your deep knowledge about dba…its very helpfull…for technical people…@@@
Hi Sir,
Just now i dont my course SQL DBA 2012.. But in My Class Teacher teach me Full Theory Knowlege .. So i want particle knowledge SQL DBA 2012. So how can i improve this Knowlege .
Sachinbhosale041@gmail.com
Thanku you for sharing knowledge.
hi sir, I want to SQL DBA, i have knowledge about SQL Basics .but don’t know how to start study? please suggest