Month: January 2014

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

This entry is part 4 of 8 in the series Exam 70-458

This entry is part 4 of 8 in the series Exam 70-458  Design and implement dimensions Design shared/conformed dimensions Conformed dimensions have same meaning to each fact table (http://www.jamesserra.com/archive/2011/11/conformed-dimensions/) Determine whether you need support for slowly changing dimensions (http://msdn.microsoft.com/en-us/library/ms141715.aspx) If old values must be retained then you need this Determine attributes (http://msdn.microsoft.com/en-us/library/ms174760.aspx) Design hierarchies (http://msdn.microsoft.com/en-us/library/ms174935.aspx) …

Read More “Exam 70-458 – Objective 4 – Design and implement a data warehouse”

Exam 70-458 – Objective 3 – Implement high availability

This entry is part 3 of 8 in the series Exam 70-458

This entry is part 3 of 8 in the series Exam 70-458  Implement AlwaysOn Implement a mirroring solution using AlwaysOn Availability modes (http://technet.microsoft.com/en-us/library/ff877931.aspx) Asynchronous-commit mode Synchronous-commit mode Steps to perform Create mirroring endpoint (http://technet.microsoft.com/en-us/library/ff878259.aspx) Enable AlwaysON (http://technet.microsoft.com/en-us/library/ff878259.aspx) Create an availability group (http://technet.microsoft.com/en-us/library/ff878307.aspx) ALTER AVAILABILITY GROUP GroupA ADD DATABASE DB Create an availability group listener (http://msdn.microsoft.com/en-us/library/hh213080.aspx) …

Read More “Exam 70-458 – Objective 3 – Implement high availability”

Exam 70-458 – Objective 2 – Implement Security

This entry is part 2 of 8 in the series Exam 70-458

This entry is part 2 of 8 in the series Exam 70-458  Manage logins and server roles Configure server security (http://msdn.microsoft.com/en-us/library/bb283235.aspx) Secure the SQL Server using Windows Account/SQL Server accounts, server roles Server-Level Roles (http://msdn.microsoft.com/en-us/library/ms188659.aspx) Create log in accounts (http://msdn.microsoft.com/en-us/library/aa337562.aspx) Manage access to the server, SQL Server instance, and databases Database Roles (http://msdn.microsoft.com/en-us/library/ms189121.aspx) Create and …

Read More “Exam 70-458 – Objective 2 – Implement Security”

Exam 70-458 – Objective 1 – Manage Data

This entry is part 1 of 8 in the series Exam 70-458

This entry is part 1 of 8 in the series Exam 70-458  Configure and maintain a backup strategy Manage different backup models, including point in time recovery Recovery models (http://technet.microsoft.com/en-us/library/ms189275.aspx) FULL SIMPLE – No point in time recovery BULK-LOGGED – Can recover to last backup, no point in time recovery Should take transaction log backup …

Read More “Exam 70-458 – Objective 1 – Manage Data”

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 …

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