2 Days Parallel Data Warehouse-APS Seminar

Having problems scaling your data warehouse? Considering your options? There is another way! Learn all about Parallel Data Warehouse (PDW/APS), HP´s and Microsoft’s scale out data warehouse appliance. In this intensive two day seminar you’ll get both the theoretical knowledge and the practical advice needed to bring “parallelism, all the time, every time” to your data warehouse.What you will learn?
· Important Massively Parallel Processing (MPP) scale out concepts
· Core PDW/APS functionality
· Design patterns for implementing PDW/APS solutions
· Practical advice and considerations when migrating to PDW/APS
· PDW/APS integration with Hadoop

Who Should Attend the PDW/APS Seminar

Architects, Designers, and Senior DBA’s involved in Very Large Databases and their associated challenges will find this course has concepts that will bring fresh thinking and great value to their organisations. It is a must for anyone planning on implementing PDW/APS in the near future. James has been involved in most PDW rollouts globally, and brings excellent lessons learnt from the field to his presentation style. See below for his background.

Course Detail
· Scale Out Concepts
· Appliance Architecture
· Introducing the PDW/APS Region
· Table & Database Design
· Querying with PDW/APS
· Data Loading Patterns
· Migrating to PDW/APS
· Managing the Appliance
· Introducing the Hadoop Region
· Integrating with Hadoop using PDW/APS & Polybase
· Reference case from Sweden.

Where and When

Location Start
HP Stockholm, Sweden Oct. 7 2014 Oct. 8 2014
Gustav III:s boulevard 36, Frösunda Port, Solna 09:00 17:00


You must register to reserve a seat, availability is limited and subject to HP/Microsoft approval. Please send your registration request and provide following information to sten@hp.com


Invoice address:
Cost center/reference or “inköpsnummer”
Street / box
Postal number

– The cost for this 2 day training is Sek 4500 per person and will be invoiced before the event.
– Latest registration date is Aug 22 2014
– This cost will be discounted on a PDW/APS deal within 30 days after the training.
– Registration is not automatic and will be confirmed based on qualification and time of registration.

Sessions are presented in English

Hewlett Packard/Microsoft reserves the right to cancel this course in the event that HP/Microsoft determines, in its sole discretion, there is insufficient registrants in the course. HP/Microsoft will not be liable for any other costs, damages or claims arising from the cancellation.

SQL Server 2014 landar den 1:a april

Idag annonserades att SQL 2014 har gått till RTM (Released to Manufacturing) och kommer att finnas tillgänglig den 1:a april.

Några av de nya funktionerna i SQL Server 2014 innefattar:

  • In-Memory Online Transaction Processing (OLTP): Tidigare känd som project “Hekaton”. Detta är den nya in-memory funktionaliteten för OLTP som är inbyggt i SQL Server 2014 och ger upp till 30x prestandaökning.
  • In-Memory Columnstore (DW): Denna funktionalitet introducerades I SQL Server 2012 och är nu uppdaterbar för att möjliggöra read and write till ett datalager samtidigt som man erhåller ultrasnabba query-hastigheter och högre kompressionsgrader.
  • Nya hybrid-scenarios tillsammans med Windows Azure: Denna funktionalitet inkluderar bl a backup till Windows Azure samt möjligheten att sätta upp en Windows Azure Virtual Machine som en Always On Secondary vilket ger ett mycket kostnadseffektivt disaster-recovery lösning med snabb återställningstid.
  • SQL Server 2014 tillgänglig idag som Windows Azure Virtual Machine: Kunder och partner kan få databaslösningar med den senaste memory-teknologin tillgänglig på ett per minuter.

Läs mer på Microsoft’s blogpost här

Vi kommer att gå igenom en del av funktionerna på TGI SQL Friday, se schema här

På Microsoft’s officiella hemsida finns mer information och testversion för nedladdning, se länk här