Informix Request for Enhancement

Posted: September 12, 2013 | Author: | Filed under: DB2 LUW, Informix 12 | Tags: , | Leave a comment

 

IBM Informix Request For Enhancement site.

https://www.ibm.com/developerworks/rfe

Microsoft Certification second shot is back for 2013!

Posted: September 1, 2013 | Author: | Filed under: Microsoft Certification, Microsoft SQL Server | Tags: , | Leave a comment

MIcrosoft 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 | Author: | Filed under: General DBA Skills, Microsoft Certification, Microsoft SQL Server | Tags: , | Leave a comment

Planning 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

Advertisement

Microsoft SQL Server Advanced Skills

Posted: September 1, 2013 | Author: | Filed under: General DBA Skills, Microsoft Certification, Microsoft SQL Server | Tags: , | Leave a comment

Having 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

Microsoft Master Certification reported retiring in October

Posted: September 1, 2013 | Author: | Filed under: Microsoft Certification, Microsoft SQL Server | Tags: , | Leave a comment

So we are hearing that Microsoft has cancelled the Master and Architect levels of certification!  http://blogs.technet.com/b/neiljohn/archive/2013/08/31/retiring-the-microsoft-master-certifications-and-training.aspx

Whilst the wikipedia site does indicate the MCM is going – http://blogs.technet.com/b/neiljohn/archive/2013/08/31/retiring-the-microsoft-master-certifications-and-training.aspx

with technet also going this seems to indicate the Microsoft want to run everything themselves..