Data Warehouse Physical Architecture Options

Custom Data Warehouse Architecture
Scale not defined
Custom design
  
Fast Track Reference Architecture
Scale between 4 and 80TB
Rapid Deployment and Use reference configurations optimized for data warehousing.
http://www.microsoft.com/sqlserver/en/us/solutions-technologies/data-warehousing/fast-track.aspx

HP Business Data Warehouse Appliance
Optimised for up to 5TB
Highly tuned solution that integrates hardware and software.
http://www.microsoft.com/sqlserver/en/us/solutions-technologies/appliances/hp-bdw.aspx

Parallel Data Warehouse
Scale to 100s of terabytes
Parallel processing (MPP) architecture to gain scalable performance, flexibility, and hardware choices with the most comprehensive data warehouse solution available.
http://www.microsoft.com/sqlserver/en/us/solutions-technologies/data-warehousing/pdw.aspx

SQL Server 2012 Databix

Enriched SQL-Flavoured cereal to nourish you and your customers

With three new ingredients to fortify customers and partners!

Cloud Based Learning Routes for SQL Server 2012

The volume of free training available for SQL Server in the cloud is continually increasing. The best sites I have found are below.

TechNet Virtual Labs: SQL Server 2012 Virtual Labs
http://technet.microsoft.com/en-us/virtuallabs/hh859575
This allows you to evaluate and test Microsoft's products and technologies with a series of hands-on labs that you can complete in 90 minutes or less.

Microsoft Virtual Academy
http://www.microsoftvirtualacademy.com/Home.aspx
This is a training portal where you can learn at your own pace, focusing on Microsoft technologies, gain points and get recognition. There are tracks in SQL Server, SQL Azure, Clustering, Business Intelligence etc.

SQL Server 2008 Microsoft Certified Master (MCM) Readiness Videos
http://technet.microsoft.com/en-us/sqlserver/ff977043
These videos are for those wanting to pursue SQL Server 2008 Microsoft Certified Master certification. Each module establishes the level of depth and breadth required to achieve this certification with deep dive subject matter included. These are good watch even if you are not thinking of taking the MCM exams.

SQL Server Best Practices
http://technet.microsoft.com/en-us/sqlserver/bb671430
Technical White Papers provide real-world guidelines, expert tips, and guidance for SQL Server.

EBooks
http://www.red-gate.com/community/books/
Free PDF downloads of ebooks specializing in database and programming technologies.

SQLBits
http://www.sqlbits.com/
Excellant community conference videos of recorded sessions which are available to watch on demand. 

24 Hours of PASS
http://www.sqlpass.org/24hours/spring2012/
The 24 Hours of PASS event is a virtual stage of SQL Server experts with in-depth sessions on the hottest SQL Server topics over 24 consecutive (and free!) technical webcasts.

SQL Server 2012 Certifications

The article 'Move Your Career to the Cloud with the Microsoft Certified Solutions Expert certification' sets out details of the new certification.
http://blogs.technet.com/b/nraja/archive/2012/04/12/move-your-career-to-the-cloud-with-the-microsoft-certified-solutions-expert-certification.aspx

This new set of SQL Server certifications aims to provide a broader and deeper set of technology skills. The new certification is across technology solutions based on cutting-edge technologies for both On-premise or in the cloud solutions. The certification details are

Microsoft Certified Solutions Associate (MCSA)
http://www.microsoft.com/learning/en/us/certification/cert-sql-server-MCSA.aspx
Exam 461 Querying Microsoft SQL Server 2012
Exam 462 Administering a Microsoft SQL Server 2012 Database
Exam 463 Implementing Data Warehouses with Microsoft SQL Server 2012

• To transition your certification
• Exam 457 Part 1
• Exam 458 Part 2

Microsoft Certified Solutions Expert (MCSE) Data Platform
http://www.microsoft.com/learning/en/us/certification/cert-sql-server-data-platform.aspx?WT.mc_id=v3_MSL_social_MCSEDP

Exam 464 Developing Microsoft SQL Server 2012 Databases
Exam 465 Designing Database Solutions for SQL Server 2012

• To transition your certification
• MCITP: Database Administrator 2008
• Exam 457 Part 1
• Exam 458 Part 2
• Exam 459 Transition your MCITP: Database Administrator 2008 to MCSE: Data Platform

MCSE: Business Intelligence
Further details of this route are here:-
http://www.microsoft.com/learning/en/us/certification/cert-sql-server-business-intelligence.aspx

SQLBits X - UK SQL Server 2012 Technical Launch Event

SQLBits X,  the official UK SQL Server 2012 Technical Launch Event was held from 29th - 31st March 2012 and took place at the Novotel London West, London.

This was another amazing event with plenty of chance to absorb the vast array of technical offerings from all areas of Database Management, Development and Business Intelligence.  It was a privilege to be a helper at such an event.

The event consisted of the Training Day, Conference Day and Community Day on Saturday. In the evening there was a chance to network with the largest attendance of any SQLBits.

The SQLBits keynotes were delivered by Quentin Clark , the Corporate Vice President of Microsoft SQL Server Database Systems Group and Conor Cunningham, Principal Software Architect at Microsoft. Quentin Clark showcased the vast set of new tools and new features of SQL Server 2012 to help deal with the data explosion and migration to cloud services. Conor Cunningham demonstrated the sheer speed of the new ColumnStore index and its benefits to the Data Warehouse.  A great plus for the conference was the presence of the SQLCAT team and international speakers.

The takeaway from the conference is that there is a change in how and what needs to be managed and where the future lies for database services.   

SQL Server 2012 Virtual Launch

SQL Server 2012 Virtual Launch Event today March 7, 2012 starting at 8:00AM Pacific (-8:00 GMT), 4PM in the UK.

The keynotes from Microsoft Executives:

Ted Kummert, Corporate Vice President, Business Platform Division
Quentin Clark, Corporate Vice President, Database Systems Group.

The launch video without login 
http://istreampl-push.wm.llnwd.net/istreampl_push

The Launch Event Agenda sqlserverlaunch.com/WW/Agenda

There are over 30 sessions to learn about the new capabilities of SQL Server 2012 at your own pace.

Management of Database Systems

Discussions held at the Avon Information Management group meeting on 1 February.

My current working research questions were discussed.

To what extent are best practices and procedures utilised by the database community?
Is their adoption affected by the complex interactions that are an integral part of the management of Database Systems? 
Can the use of holistic methodologies contribute to improvement and innovation?


The Database System
The 4 main components in the system:- 

• Technical Conponents
• Cultural factors
• Paradigms
• Application Centric

Technical Layers 
The current technical system discussed broken down into sections including:-

• Architecture
• Access and Control
• Maintenance
• Resiliance and Conservation
• Data Artifacts
• Change
• Forecasting

Cultural Factors
Items relating to cultural  arena:-

• Ethics and Governance
• Companies perception vs DBA’s
• Organizational management structure
• Customer requirements
• Financial and IT progression
• Proactive vs Reactive
• Database community
• Vendor  vs Supplier  vs Competitors
• Change Managers vs Developers vs Service Managers
• Attitudes and beliefs of DBAs
• Market place changes from local to global
• Environmental considerations
• Government, Legal and Political issues
• Business Owner, Changes to the business model, Risk

Paradigms
A few major methodologies that are in use today:-

• Service Management
• Data Management
• Problem Management
• Forensic Management
• Agile Management
• Information Lifecycle Management
• Database as a Service

Additional paradigms to consider:-

• Service Orientated Architecture
• Capability Maturity Model

Application Centric
Taking the viewpoint that the application is at the centre of everything:-

• Structured vs Unstructured vs Semi Structured
• Transient vs Transactional vs Historical
• Big Data vs Scalability, Sharding
• Scale out vs Scale up
• Quality of Data
• Cloud vs On Premise
• Data Sets for Public consumption
• Database Engine changes vs Virtualization