Saturday, July 27, 2013

[SQL 2012] Upgrading certification from mcts sql2008 to sql mcsa 2012

[SQL 2012] Upgrading certification from mcts sql2008 to sql mcsa 2012

Upgrading certification from mcts sql2008 to sql mcsa 2012

Posted: 26 Jul 2013 11:45 PM PDT

HiI am thinking about upgrading me mcts in sql2008 (exam 70-432) to the new mcsa 2012 path. The 2 exams needed are 70-457 and 70-458 but microsoft don't seem to have any study material.The other option is to take the 3 exams 70-461, 70-462, and 70-463 but i prefer to do the upgrade if possible (saving myself £99.00) in the process !As there are no books available for the upgrade,would i need to read all 3 of these books (461,462,463, quering sql2012, administering 2012, and datawarehouse 2012 respectively ) ?I'm presuming this would give me all the required knowledge to then sit the upgrade exams ?Any advice on study material for these upgrade exams would be appreciated.Thanks

how to filter just numbers from varchar value?

Posted: 26 Jul 2013 10:40 PM PDT

when i try to execute the below query it throws an error "Conversion failed when converting the varchar value '1131-' to data type int."SELECT dbo.fn_int_only('11AB31-A') but SELECT dbo.fn_int_only('11AB31') this query returns a proper result like 1131is there any other ways to filter only INT values? or how do i overcome this error?

Service account password change on always on availability group

Posted: 26 Jul 2013 03:46 PM PDT

I am new to the always on availability group concept. I am looking for the steps to change the SQL Service account password in always on availability group environment without service interruption (I am ok with the service interruption due to failover). We are using the same Service account (domain account) in both the instances. Due to some password policies we need to change the passwords of this domain accounts in every quarter. Availability mode of the availability group is synchronous commit mode and automatic failover is enabled. When I started the activity synchronization state was "Synchronized" and failover readiness was "No data loss". First I changed the password of the domain account from windows security and then in secondary node configuration manager I changed the service account password and restarted the SQL service. After the SQL service restart on secondary node synchronization state changed to "not Synchronized" and failover readiness to "data loss". (I suspect this is because of database cross connectivity is not established due to the password change). As the failover readiness is "data loss" I forced to stop the SQL service on primary node without failing over to secondary node and to do the password change on primary node service account, thus by causing some service interruption. Please help me on this and please let me know the steps to do the password change without service interruption./ or is it mandatory to have service interruption during the service account password change in always on.

BOL 2012

Posted: 26 Jul 2013 08:20 AM PDT

What's everyone's thoughts on Books Online for SQL 2012?I find it more of a hassle to install - separate download & install rather than a simple checkbox during the SQL install - and as well as slower & not as easy to use as earlier versions.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog