[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] SQL Server 2012 SP2 Cumulative Update #9 is available!

Week ago SQL Server Release Services Team released new update package for SQL Server 2012.

This update (VSTS BUG: 5285719 | 321185) introduces a new global property that exposes the latest CU number that is currently installed on the SQL Server. After you install this update, you can obtain the CU number information by executing either of the following queries:

          SELECT @@VERSION

Additionally, this update also adds the CU number information to the first line of the SQL Server error log.

In this Cumulative Update No 9 {build no 11.0.5641.0) for SQL Server 2012 with Service Pack 2, Microsoft fixed twelve issues:

VSTS BUG: 5725383 | 3102243
FIX: The version and the version flag properties of a subscription view can’t be updated correctly in MDS 2012
Master Data Services (MDS)

VSTS BUG: 5514346 | 3103293
FIX: Error 17066 occurs during the encryption operation when you use TDE in SQL Server 2012
SQL service

VSTS BUG: 5835424 | 3103472
FIX: The SQL Server service performs more I/O operations on the mirror server than on the principal server
High Availability

VSTS BUG: 5689513 | 3103644
SQLTables function and sp_tables stored procedure don’t require SELECT permission any longer on user tables and views
SQL security

VSTS BUG: 5686787 | 3101120
FIX: SQL Server stops responding when you back up the certificate that is used to encrypt the database encryption key in SQL Server 2012
SQL service

VSTS BUG: 5641871 | 3103016
FIX: SSRS stops responding when you try to export a report to a .pdf document in SQL Server 2012
Reporting Services

VSTS BUG: 4272469 | 2682488
FIX: Backup operation fails in a SQL Server database after you enable change tracking
SQL service

VSTS BUG: 4812002 | 3082877
FIX: No error is prompted when a connection is ended in sqlcmd
SQL service

VSTS BUG: 5646993 | 3097636
FIX: Performance decrease when an application that has connection pooling frequently connects or disconnects in SQL Server
SQL service

VSTS BUG: 5699533 | 3051145
FIX: SQL Server may shut down when you use Service Broker in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5544328 | 3097970
FIX: Sp_describe_undeclared_parameters returns incorrect result when the undeclared parameter targets a decimal column
SQL service

VSTS BUG: 5687797 | 2835348
Update improves the Service Broker when you send messages to remote servers in SQL Server 2012 and SQL Server 2014
SQL service


This update could be applied for:

  • Microsoft SQL Server 2012 Service Pack 2


Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 9

You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP: step1: Install the service pack on the passive node / step2: Install the service pack on the active node (This step requests servicerestart).

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package.


[EN] New Book on the shelf. From James Bond.

BOOK__TheEnterpriseCloudByJamesBondFew days ago I got a present. The new book about Cloud Architecture. This book has been written by Bond. James Bond. But of course James Bond know everything about SPECTRE but have no experience with Cloud. The real James Bond is a Chief Technology Officer at Hewlett-Packard (Las Vegas, Nevada, USA) with a lot of experience with The Cloud. I found very good opinions about this book: 4,8/5 stars at O’Reilly and 4,7/5 stars at Amazon. As we can read on last page:

Despite the buzz surrounding the cloud computing, only a small percentage of organizations have actually deployed this new style of IT—so far. If you’re planning your long-term cloud strategy, this practical book provides insider knowledge and actionable real-world lessons regarding planning, design, operations, security, and application transformation. This book teaches business and technology managers how to transition their organization’s traditional IT to cloud computing. Rather than yet another book trying to sell or convince readers on the benefits of clouds, this book provides guidance, lessons learned, and best practices on how to design, deploy, operate, and secure an enterprise cloud based on real-world experience.

Author James Bond provides useful guidance and best-practice checklists based on his field experience with real customers and cloud providers. You’ll view cloud services from the perspective of a consumer and as an owner/operator of an enterprise private or hybrid cloud, and learn valuable lessons from successful and less-than-successful organization use-case scenarios. This is the information every CIO needs in order to make the business and technical decisions to finally execute on their journey to cloud computing.

  • Get updated trends and definitions in cloud computing, deployment models, and for building or buying cloud services
  • Discover challenges in cloud operations and management not foreseen by early adopters
  • Use real-world lessons to plan and build an enterprise private or hybrid cloud
  • Learn how to assess, port, and migrate legacy applications to the cloud
  • Identify security threats and vulnerabilities unique to the cloud
  • Employ a cloud management system for your enterprise (private or multi-provider hybrid) cloud ecosystem
  • Understand the challenges for becoming an IT service broker leveraging the power of the cloud

And of course few words about author – James Bond:

James Bond is a Chief Technologist for the HPCloud business unit.  He provides cloudbusiness strategy and technical guidance, solution architecture, and transitionplanning to Fortune 100 and Government customers in North America.  Bond’s role is to educate customers andindustry on the transition from legacy enterprise IT to private, hybrid andbrokering cloud environments.  He is acloud keynote presenter at numerous customer and industry conferences acrossthe U.S.

With more than 25 years experience in public andprivate sectors, Bond was an early pioneer in the design and deployment of Infrastructure,Software, and Platform as a Service offerings—long before the term cloudcomputing was coined.  His background indata centers, LAN/WAN systems design, software development, and ISP/ASPmanagement were precursors to his current focus on cloud computing.  Bond is well known on the industry and withinHP as an expert resource of real-world cloud design and deployment experiencehaving successfully deployed cloud environments for some of the largest U.S.Government customers.

Before joining HP, Bond was a Vice Presidentwith Apptix, a leading commercial Software as a Service provider, where hearchitected and managed some of the largest SaaS deployments in the UnitedStates.  Past industry experienceincludes Chief Technology Officer for IceWEB, Vice President of SteelCloud, andpositions with Electronic Data Systems, Computer Sciences Corporation, andComputer Data Systems.

Bond holds a Bachelor’s degree in ComputerScience from the University of Maryland. He authors numerous technical white papers and is finalizing his firstbook—on cloud computing.  He is avolunteer Emergency Medical Technician (EMT) in his spare time and currentlyresides in Las Vegas, Nevada.

I will start to read this book soon, and I hope to give five start after reading.

And here are links for:

  • O’Reilly bookstore page
  • Amazon bookstore page
  • Author’s LinkedIn profile

Post Scriptum:

Only one bad feeling about this book. And it is for O’Reilly: this book – even brand new doesn’t smell. And because I love Smells of The New Book – I’m really dissapointed…