Recertify with Microsoft Virtual Academy
Posted: May 2, 2015 Filed under: Microsoft Certification | Tags: Microsoft Certification Leave a commenthttps://www.microsoft.com/learning/en-us/recertification-virtual-academy.aspx
Recertify with Microsoft Virtual Academy
Born to Learn Updates including 2nd Shot, Updated Certification Roadmap and MCP Book Discounts
Posted: February 11, 2015 Filed under: Microsoft Certification, Microsoft SQL Server Leave a commentThere is a new Microsoft certification roadmap
MCP Book Discounts
Second Shot is back
https://www.microsoft.com/learning/en-us/second-shot.aspx
Dissecting Score Reports: What Does It All Mean? Part 1
Posted: April 12, 2014 Filed under: Microsoft Certification, Microsoft SQL Server Leave a comment
Dissecting Score Reports: What Does It All Mean? Part 1
Free Microsoft Server Virtualization Exam!
Posted: December 27, 2013 Filed under: Microsoft Certification, Microsoft Windows Server, Virtualization | Tags: Microsoft Certification, Microsoft Windows, Virtualization Leave a commentFree Microsoft Server Virtualization Exam!
SQL Server 2008 Exam Retirements
Posted: December 27, 2013 Filed under: Microsoft Certification, Microsoft SQL Server | Tags: Microsoft Certification, Microsoft SQL Server Leave a commentThe 2008 MCITP DBA/Developer Exam retirement date have been extended to July 31, 2014 to match the BI exam.
I do wonder if that was related to me asking about the BI Retirement date!
Dec 2013 update on Microsoft SQL Server Certification
Posted: December 10, 2013 Filed under: Microsoft Certification, Microsoft SQL Server, Microsoft SQL Server 2014 Leave a commentDec 2013 update on Microsoft SQL Server Certification – http://borntolearn.mslearn.net/btl/b/weblog/archive/2013/12/04/dec-2013-update-on-developer-and-sql-certifications.aspx#fbid=rB_vto02BcD
In March 2014, recertification options for maintaining the MCSE credentials will be made available – cool!
Help Create Exam Content and get Exam Credit!
Posted: October 17, 2013 Filed under: Microsoft Certification, Microsoft SQL Server | Tags: Certification, Microsoft SQL Server Leave a commentHelp Create Exam Content and get Exam Credit!
Help Create Exam Content and get Exam Credit!
Microsoft Certification second shot is back for 2013!
Posted: September 1, 2013 Filed under: Microsoft Certification, Microsoft SQL Server | Tags: Certification, Microsoft Leave a commentMIcrosoft Certification second shot is back for 2013 – http://www.microsoft.com/learning/en-us/second-shot.aspx
MCM SQL Server 2008 reading list
Posted: September 1, 2013 Filed under: General DBA Skills, Microsoft Certification, Microsoft SQL Server | Tags: Microsoft Certified Professional, Microsoft SQL Server Leave a commentPlanning and Design
Infrastructure Planning and Design – http://www.microsoft.com/en-us/download/details.aspx?id=732
On-disk structures including new in 2008
On Disk Structures – http://www.sqlskills.com/blogs/paul/category/on-disk-structures/
FileStream – http://www.sqlskills.com/blogs/paul/category/filestream/
Spatial Indexes – http://www.sqlskills.com/blogs/paul/sql-server-2008-spatial-indexes/
Sparse Columns – http://www.sqlskills.com/blogs/paul/category/sparse-columns/
Data Compression – http://blogs.msdn.com/b/sqlserverstorageengine/archive/tags/data+compression/default.aspx
Data Compression : Strategy,Capacity Planning and Best Practices – http://sqlcat.com/sqlcat/b/whitepapers/archive/2009/05/29/data-compression-strategy-capacity-planning-and-best-practices.aspx
Data file maintenance, database snapshots and tempdb
Shrink – http://www.sqlskills.com/BLOGS/PAUL/category/Shrink.aspx
Database Snapshots – http://www.sqlskills.com/BLOGS/PAUL/category/Database-Snapshots.aspx
Database Maintenance – http://www.sqlskills.com/BLOGS/PAUL/category/Database-Maintenance.aspx
Working with Tempdb in SQL Server 2005 – http://technet.microsoft.com/en-us/library/cc966545.aspx
Physical Database Storage Design – http://technet.microsoft.com/en-us/library/cc966414.aspx
Logging, recovery and log file maintanence
Transaction Logging – http://www.sqlskills.com/BLOGS/PAUL/category/Transaction-Log.aspx
Index internals and fragmentation
Fragmentation – http://www.sqlskills.com/BLOGS/PAUL/category/Fragmentation.aspx
Indexes from every angle – http://www.sqlskills.com/BLOGS/PAUL/category/Indexes-From-Every-Angle.aspx
Online indexing options in SQL Server 2005 – http://technet.microsoft.com/en-us/library/cc966402.aspx
Performance And Tuning Optimization
Query tuning through effective indexing strategies – http://www.sqlskills.com/BLOGS/KIMBERLY/category/Indexes.aspx
Microsoft SQL Server Advanced Skills
Posted: September 1, 2013 Filed under: General DBA Skills, Microsoft Certification, Microsoft SQL Server | Tags: Microsoft Certified Professional, Microsoft SQL Server Leave a commentHaving said that Microsoft Master Certifications are retired, this is an interesting page – http://www.brentozar.com/sql-mcm/
Day 3 mentions some interesting skills –
On-disk structure knowledge
Index tuning knowledge
C#/VB knowledge
Stored procedure knowledge
XML parsing knowledge
Backup & recovery knowledge