Tracy Boggiano's SQL Server  Blog Rotating Header Image

January, 2014:

Exam 70-458 – Objective 4 – Design and implement a data warehouse

Design and implement dimensions Design shared/conformed dimensions Conformed dimensions have same meaning to each fact table ( Determine whether you need support for slowly changing dimensions ( If old values must be retained then you need this Determine attributes ( Design hierarchies ( Determine whether you need star or snowflake schema ( Star schema Table […]

Exam 70-458 – Objective 3 – Implement high availability

Implement AlwaysOn Implement a mirroring solution using AlwaysOn Availability modes ( Asynchronous-commit mode Synchronous-commit mode Steps to perform Create mirroring endpoint ( Enable AlwaysON ( Create an availability group ( ALTER AVAILABILITY GROUP GroupA ADD DATABASE DB Create an availability group listener ( Add a secondary replica ( ALTER DATABASE db SET HADR AVAILABILITY GROUP […]

Exam 70-458 – Objective 2 – Implement Security

Manage logins and server roles Configure server security ( Secure the SQL Server using Windows Account/SQL Server accounts, server roles Server-Level Roles ( Create log in accounts ( Manage access to the server, SQL Server instance, and databases Database Roles ( Create and maintain user-defined server roles ( Manage certificate logins CREATE LOGIN Example D […]

Exam 70-458 – Objective 1 – Manage Data

Configure and maintain a backup strategy Manage different backup models, including point in time recovery Recovery models ( FULL SIMPLE – No point in time recovery BULK-LOGGED – Can recover to last backup, no point in time recovery Should take transaction log backup before and after Protect customer data even if backup media is lost […]

Exam 70-458 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 Study Resources

I passed the 70-457 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 today.  Next I will be attempting the 70-458, as I study I’ll put my notes and links to relevant materials here.  I hope to take and pass the exam by the end of March 2014. I’ll add links […]