My Blog’s status 2013, thanks to all visitors

Hi
I am very glad to see the growth of my blog, I am posting this after so many days as a new post , and I am very thak full for all the visiters and commenters. I got Aprox 15000 visiters til date, this a big achivements for a blogger.

SQL server database Mirroring Error

One time when I am dealing with Mirroring with SQL server 2008 database, on my students stand alone desktop we encounter the Error:
The server network address “TCP://SQLServer:5022″ cannot be reached or does not exist.
Check the network address name and that the ports for the local and remote endpoints are operational.
(Microsoft SQL Server, Error: 1418)
We tried very hard but unable to short out the Error.
One day I get one mail from SQLAuthority.com as I’m a subscriber of mail. In that mail I got the solution. The link is as:
http://blog.sqlauthority.com/2010/03/18/sql-server-mirroring-configured-without-domain-the-server-network-address-tcpsqlservername5023-can-not-be-reached-or-does-not-exist/#comment-201918
And my recommendation for readers, please see this also.
http://blog.sqlauthority.com/2010/01/11/the-server-network-address-tcpsqlserver5023-can-not-be-reached-or-does-not-exist-check-the-network-address-name-and-that-the-ports-for-the-local-and-remote-endpoints-are-operational-microso/

Finding out how much memory SQL Server is utilizing?

Many time for a new DBA  hard to find how much My Server utilising memory? Here is explained a number of ways to find the memory utilized by SQL server.

By Using Performance monitor:

 Go to Start–>Run and type perfmon . You will find the following screen where you can see the total memory used(the pages/sec) by your box.

By Using DMV:
You can Query to sys.dm_os_memory_clerks DMV to find out Memory utilization by SQL server. To see how see the following link.

http://www.sqlservercentral.com/Forums/Topic1188221-391-1.aspx

By using SQL Reports:

Right Click on SQL Server–>reports–>Standard Reports–> Memory Consumption

See the Following image.

My blog is growing…

Today is 24 sep. my blog’s foundation day, This article is written in response of my blog’s foundation day, on 24th September 2010 I was started this blog, which is dedicated to Beginner SQL DBA and other who are interested to know about. As on 15 September 2011 I have 1,824 visitors.

My blog is growing…

I am very glad, by seeing the growth of my technical blog http://mumbaisqldba.wordpress.com/ and I am very thank full of my visitors and comment writers.

References Coming from:

Most references are coming from Google and others…

Microsoft certification path on SQL server:

Technology Specialist (TS):

Microsoft provide MCTS certificate after passing any one Exam of 70-432 for DBA or 70-433 for developer and 70-448 For BI. Here I am giving a rot map which is broadcasted by Microsoft itself on their website. To download the PDF Click here.

More: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab2

IT Professional certification (Pro):

Exam 70-450 : Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008.

Exam 70-451 : Designing Database Solutions and Data Access Using Microsoft SQL Server 2008.

Exam 70-452 : Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

Visit for more: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab3

Advance:

MCM:

Exam 88-970: SQL Server 2008 Microsoft Certified Master: Knowledge Exam. And

Exam 88-971: SQL Server 2008 Microsoft Certified Master: Lab Exam

More: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab5

MCA:

Successfully pass the MCA Board Exam conducted by Microsoft and industry experts.

More: http://www.microsoft.com/learning/en/us/certification/architect.aspx

SQL server 2008 course fees in mumbai

I experienced that many guys are search the training fee of SQL server DBA, so I like to give a note on the DBA training fee which may applicable in Mumbai and other city in India.

The training institutions charges the fee as per there course module. And some time it’s varying institute to institute. Here I’m giving approximate fee on the basis of courses and training facility of institution.

 On the Base of Microsoft certification:

          If any one looking for SQL server certification’s training fee, it will be Rs. 7000 to 12000 for only one exam module, i.e. exam 70-432, exam 70-450, which is mostly excluding exam fee. The exam fee mostly charged Rs. 2250 to Rs.2500 extra.

On the Base of Institute’s certification:

            Some time training institute provides a certificate of completion of SQL Server DBA course or after exam held by institution. That is all up to institution may charges Rs. 10000 to 25000 depends upon the course material deleing by them and facility provided.

Note: This is recommended to candidate that he/she must ask clearly about all aspect of training like fee includes study material or other facility or not, and qualified trainer is available or not etc. The above detail is only my opinion reader please use there transparency while select training institution.

DBA certification on SQL server in Mumbai:

DBA certification on SQL server in Mumbai:

 

I like to teach SQL server 2008(DBA) Certification Exam 70-432, after passing this single exam you will tagged as MCTS (Microsoft Certified Technology Specialist). Which is I have passed with an 83%. I offer private tuition for interested students/ professionals with a competitive fee in industry.

            The training institutions ask a sound fee but most of them unable to deliver the knowledge and expertise for passing the exam and also to work with technology.

 

I am having approx 10 years of professional experience in IT field, see about me and my certifications

 

If any one interested to be an SQL server DBA, at there time and place (any where in Mumbai Only), just contact me on ali_tailor@yahoo.com

Cell no. +91 9619492911(Ali)