[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] Visual Studio 2013 Update 1 is available

If you are follower of Somasegar’s Blog {LINK} You know: First Update for Visual Studio 2013 is available from today. S. Somasegar is the corporate vice president of the Developer Division at Microsoft {PROFILE}. In this update Visual Studio Team solve thirty three bugs, which have been found and known since released date of Visual Studio 2013. Here is the short list and quantity for each category:

LOGO__VisualStudio2013Team Foundation Server [1]
Debugger [3]
Directed Graph Markup Language [1]
Graphics Debugger [2]
Web Tools [7]
Visual C++ [5]
IntelliTrace [1]
Cloud Platform [1]
Visual Studio Test [6]
XAML Tools [2]
XAML Designer [1]
Release Management for Visual Studio 2013 [3]

This update could be applied to (without restart):

  • Release Management Client for Visual Studio 2013
  • Release Management for Visual Studio 2013
  • Release Management Server for Team Foundation Server 2013
  • Microsoft Visual Studio Ultimate 2013
  • Microsoft Visual Studio Professional 2013
  • Microsoft Visual Studio Premium 2013
  • Microsoft Visual Studio Express 2013 for Web
  • Microsoft Visual Studio Express 2013 for Windows
  • Microsoft Visual Studio Express 2013 for Windows Desktop

and support those languages versions: Chinese (Simplified), Chinese (Traditional), Czech, English, French, German, Italian, Japanese, Korean, Russian, Polish, Portuguese, (Brazil), Spanish, Turkish.

More informations about this update You will find at special site: Description of Visual Studio 2013 Update 1. If You want install this update You can choose one of two ways:

  1. online installation from Web Installer file (1,1 MB) – you will need internet connection on dev machine {LINK HERE}
  2. offline installation from ISO installation disk – you will need only 245 MB for mounting ISO file {LINK HERE}

This update will be available as automatic update from Visual Studio 2013 in next few weeks.

Enjoy!