[EN/ES] ¿24 Horas PASS en Español? MAÑANA!

LOGO__24hofSQLPASS_ESPeditionEste evento del 24 Horas de PASS en Español consta de 24 sesiones en los días 1 y 2 de Diciembre en los cuales tendremos a MVPs, Lideres de Comunidades y otros expertos en la Plataforma de Datos de Microsoft exponiendo diversos temas sobre estas tecnologías y las recientes tendencias en el manejo de datos y analíticos.

Los temas estarán divididos en las siguientes categorías:

  • Application & Database Development
  • BI Information Delivery
  • BI Platform Architecture, Development & Administration
  • Cloud Application Development & Deployment
  • Enterprise Database Administration & Deployment

######      ######      ######

I speak Spanish a little bit. Week ago (on Saturday 21st) in Madrid at SQL Saturday No 459 I presented my session using Spanish language version of my environment (Windows and SQL Servers). I was not brave enough, and I don’t have enough experience to deliver session in Spanish, but level of this knowlegde is good enough to attend el evento en Español. Twenty four sessions, two days, several interesting topics and many great speakers.

Application & Database Development
Como Leer Planes de Ejecución | Enrique Catala Bañuls
Descubriendo el corazón de la optimización “Estadísticas más que un concepto”
| Ahias Portillo
Optimizando SQL Server 2014 para MS Dynamics AX 2012 R3 (ERP) | Juan Rafael
Procesando XML de Estructuras Complejas con SSIS | Carlos Andres Ulate Hernandez

BI Information Delivery
Analizando patrones con SQL, Excel, Azure ML, R y más
| Ana Maria Bisbe York
Aplicaciones de BI móvil para Microsoft SQL Server | John Alexander Bulla Torres
Cuadros de Mando: El todo es más que la suma de las partes | Salvador Ramos
Deep Dive PowerBI 2.0 | Juan Alvarado
Escenarios de análisis de datos con los Power: Pivot, View & Query. También con Power BI y Datazen. | Guillermo Taylor
PowerBI Personalizado con D3JS | John Bocachica

BI Platform Architecture, Development & Administration
Administración de Soluciones de Power BI | Guillermo Caicedo
Automatizando la generación de Datawarehouses a través de metadatos. | Miguel Egea
Machine Learning | Alan Koo
Mejores Prácticas de DataWarehouse con SQL Server | Eduardo Castro
SSIS 2016: Nuevo y mejorado | Jose L. Rivera

Cloud Application Development & Deployment
Planeando e Implementando Servicios de Datos con Microsoft Azure. | Adrian Miranda
Planificación y Preparación Para Actualizar a SQL Database v12 | German Cayo
VMs de Alto Rendimiento para SQL Server en AWS y Azure | Warner Chavez

Enterprise Database Administration & Deployment
AlwaysOn en SQL Server 2016 | Andrei Garzon
Mejores Prácticas para SQL-Server en Ambientes Virtualizados | Carlos Rojas Vargas
Migrando a SQL Server 2016 | Jesus Gil Velasco
SQL Server 2016 – Stretch Databases | Kenneth Urena
SQL Server Disaster Recovery Plan con Azure | Enrique Puig
Tecnicas Avanzadas de Monitoreo | Javier Villegas

Full details about sessions are available here: http://www.sqlpass.org/24hours/2015/spanish/Sesiones.aspx

Registration for free 24 hours training is available here: http://www.sqlpass.org/24hours/2015/spanish/Registro.aspx

[EN/PT] Bem-vindo ao mundo de 24 Horas de PASS!

Bem-vindo ao mundo de 24 Horas de PASS!

LOGO__24hofSQLPASS_PORedition24 horas de formação gratuita em SQL Server – Distribuída por 2 dias. Nos dias 18 e 19 de Novembro de 2015 realiza-se a terceira edição do “24 Horas de PASS” completamente em Português! Com ínicio às 13:00 (Brasil) / 15:00 (Portugal), cada dia irá contar com 12 horas seguidas de apresentações sobre funcionalidades e técnicas de SQL Server com especial atenção para a última versão – o SQL Server 2014 .

24 Horas de PASS é um evento online e gratuito, onde pode aprender com os melhores especialistas em SQL Server do mundo Lusófono, onde o Português é a lingua Oficial. Mais de 20 especialistas em SQL Server do Brasil e de Portugal vão fazer apresentações técnicas focadas nos seguintes temas:

  • Application & Database Development
  • BI Information Delivery
  • BI Platform Architecture, Development & Administration
  • Enterprise Database Administration & Deployment
  • Professional Development

Temos uma extensa lista de “speakers especialistas”, incluindo MVPs, MCMs e PFE’s (Premier Field Engineer) da Microsoft. Organizado pelas comunidades da PASS no Brasil e em Portugal este evento conta com o melhor que há de SQL Server de ambos lados de Atlântico.

#####     #####     #####

Of course – I don’t speak Portuguese – so, previous part I get from event site. Switching to English: in the Middle of next Week will be very important for all SQL Server Folks who speak, understand even only leard Portuguese language. Another big and fantastic event – 24 Hour of PASS will begin on 18th November. Twenty Four sessions focused for SQL Server technology just administrators, consultants, architects, developers. List of the sessions and speakers are really impressive:

Wednesday, November 18, 2015
10 Dicas para Escrever Codigos T-SQL Melhores
| Rodrigo Crespi
Segredos da ABIN e do SIS – Apps Seguras Com Acesso Multi-Camada | André Melancia
SQL Azure Database | Vitor Faria Tomaz
SQL Bad Practice | Marcus Bittencourt
Understanding & Solving Columnstore Problems | Niko Neugebauer
Ciclo de vida de uma query | Tiago Balabuch
Entendendo o Transaction Log | Luiz Mercante
HandsOn – SQL Server AlwaysOn Availability Groups | Edvaldo Castro
Query Store no SQL Server 2016
| Andre Batista

Thursday, November 19, 2015
Powershell – Passar de scripts simples a funções avançadas | Cláudio Silva
Datazen – Arquitetura e Desenvolvimento
| Thiago Henrique Hernandes Zavaschi
Alta disponibilidade com Azure SQL Database
| Marcos Freccia
Azure VM’s with SQL Server – Notes from the field
| Pedro Simoes, Vitor Pombeiro
Advanced SQL Server Execution Plans | Fabiano Neves Amorim
Alta disponibilidade sem cluster | Armando Lacerda
Boas Práticas de Desempenho e Disaster Recovery no SQL Database
| Marcondes Alexandre
Extended Events: Receitas de sucesso para troubleshooting
| Dennes Torres De Oliveira
Hekaton v.2 e ColumnStore Index v.3 – Nova Geração de DBAs
| Luan Moreno Medeiros Maciel
Ocultando dados com SQL Server 2016
| Ivan Campos
Query optimization and analysis in SQL Server 2016
| Pedro Lopes
Resource Governor for SQL Server 2014 in Action! | Etienne Lopes

Friday, November 20, 2015
Filegroups – ótimas práticas
| Marcelo Adade
Validacao de Dados Automatizada na Datawarehouse
| Daniel De sousa
AlwaysOn e realmente poderoso? truques de uso | Reinaldo Kibel

 

Full details about sessions are available here: http://www.sqlpass.org/24hours/2015/portuguese/Sessions.aspx 

Registration for free 24 hours training is available here: http://www.sqlpass.org/24hours/2015/portuguese/Registration.aspx

[EN] SQL Server 2012 Training Kits – first pack is ready

SQL Server 2012. New Server. New Knowledge. New Experience.
New Books. Three new Exams. Three New Training Kits.
1960 pages. UnCounted Sleepless Nights…

I’m talking about new Training Kits for SQL Server 2012. See details below:

EXAM 70-461

If You are newbie, fan, administrator (accidental or exceptional), architect, analyst, programmer, consultant or professional. It does no matter. First exam for both training and certification path is about T-SQL Querying. Basic information about this book (from publisher site): Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD—featuring multiple, customizable testing options. Maximize your performance on the exam by learning how to: Create database objects / Work with data / Modify data / Troubleshoot and optimize queries. 

BOOKLET__TrainingKitExam70-461_Querying_MicrosoftSQLServer2012Publishing info:
Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
By: Itzik Ben-Gan, Dejan Sarka, Ron Talmage
Publisher:Microsoft Press Formats:
Print  Safari Books Online
Print: October 2012 (est.)
Pages: 720 (est.)
Print ISBN:978-0-7356-6605-4 | ISBN 10:0-7356-6605-9

EXAM 70-462

If You will go to DBA way the next step is Administration. The next exam too. What you can find inside this book (from publisher site): Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. Maximize your performance on the exam by mastering the skills and experience measured by these objectives: Install and configure SQL Server / Maintain instances and databases / Optimize and troubleshoot SQL Server / Manage data / Implement security / Implement high availability

BOOKLET__TrainingKitExam70-462_AdministeringMicrosoftSQLServer2012DatabasesPublishing Info:
Training Kit Exam 70-462: Administering Microsoft® SQL Server® 2012 Databases
By: Orin Thomas, Peter Ward, BoB Taylor
Publisher: Microsoft Press
Formats: Print  Safari Books Online
Print: July 2012 (est.)
Pages: 640 (est.)
Print ISBN:978-0-7356-6607-8 | ISBN 10:0-7356-6607-5

EXAM 70-463

If you are warehouse oriented, next step after querying is working with Data Warehouse. And this subject is the third part of the beginning of this series. Just look inside (as a previous from publisher site): Work at your own pace through a series of lessons and practical exercises, and then assess your skills with online practice tests—featuring multiple, customizable testing options. Maximize your performance on the exam by learning how to: Design and implement a data warehouse / Develop and enhance SQL Server Integration Services packages / Manage and maintain SQL Server Integration Services packages / Build data quality solutions / Implement custom code in SQL Server Integration Services packages

BOOKLET__TrainingKitExam70-463_ImplementingaDataWarehousewithMicrosoftSQLServer2012Publishing Info:
Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft® SQL Server® 2012

By: Dejan Sarka, Matija Lah, Grega Jerkic
Publisher: Microsoft Press
Formats: Print  Safari Books Online
Print: September 2012 (est.)
Pages: 600 (est.)
Print ISBN:978-0-7356-6609-2 | ISBN 10:0-7356-6609-1

 

GO TO THE SHOP… WAIT!

Before You going to buy, try to recalculate this order. For me – best idea is buying all three books. And I’ve two choice now: Amazon or O’Reilly, price are different:

The package at Amazon: 70-461 + 70-462 + 70-463 >> 114,51  (shipping free)
The package at O’Reilly: 70-461 + 70-462 + 70-463 >> 209,97 (shipping free)

Are You ready for order? Just do it!