Sunday, May 24, 2015

SQL Saturday Buenos Aires

Hoy 22 de Mayo lo recordaremos en parte porque se realizo el primer SQL Saturday en Buenos Aires. En las oficias de Microsoft Argentina.

La mas grande comunidad de DBA, Developers y BI SQL PASS ha dado el primer paso en nuestro pais.

Gracias a los organizadores Mariano Kovo y Lucas Fernandez , A los Sponsors Microsoft, Precision IT, Trigger DB y Dell software


Dejo algunas fotos del evento


Mi charla sobre "SQL Monitoring"





Junto a los organizadores y speakers



Estos son los temas de los que estuvimos hablando durante mi presentacion


§Visualizando la actividad de la instancia
§Deadlocks y errores de SQL utilizando Extended Events
§SQL Performance Dashboard
§Missing Indexes desde el query plan

§Performance Point – Sistema de Captura , Análisis y Alertas


En los próximos días estaré posteado la presentación y los scripts

Friday, May 15, 2015

SQL Server 2014 Service Pack 1 "Re-released"

After few weeks of the "release and revoke" of SQL Server 2014 SP1 , we have a new version available for download. Test it carefully this time.

The original version raised an error if the instance had a SSIS catalog 

Symptoms

Assume that you have a SQL Server instance that has the SSISDB catalog enabled in Microsoft SQL Server 2014. When you try to upgrade to SQL Server Service Pack 1 (SP1) build number 12.0.4050.0, you receive the following error messages:

Error: 912, Severity: 21, State: 2.

Script level upgrade for database 'master' failed because upgrade step 'SSIS_hotfix_install.sql' encountered error 3602, state 251, severity 25. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous error log entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.


Error: 3417, Severity: 21, State: 3.

Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online. SQL Server shutdown has been initiated




Here is the installation procedure if you already installed the SP 1 build 12.0.4050.0
  1. Use Add or Remove Programs in Control Panel to uninstall version 12.0.4050.0 of SQL Server 2014 SP1 (KB3018269).
  2. Install SQL Server 2014 SP1 version 12.0.4100.1 (version 12.0.4100.1).

Error 912 or 3417 when you install SQL Server 2014 SP1 (build 12.0.4050.0)


SQL Server 2014 Service Pack 1 release information




Text-to-speech function is limited to 100 characters

Thursday, May 7, 2015

Speaker at SQLSaturday #405 - Buenos Aires

Hello Everyone

I'd like to announce that I'll be speaking at the first SQLSaturday at Buenos Aires. I'll be talking about different techniques to monitor SQL Server performance. I am so excited because this is my first time as a speaker. 

This event will be held May 22 2015 at Bouchard 710 4° Piso, Microsoft Argentina, Ciudad Autónoma de Buenos Aires, Buenos Aires, 1053, Argentina. 

If you are not registered yet you should do it using below link

http://www.sqlsaturday.com/405/eventhome.aspx


Hola a Todos

Quiero anunciarles que voy a estar dando una charla en el primer SQLSaturday que se llevará a cabo en Buenos Aires. Voy a estar hablando sobre diferentes técnicas para monitorear la performance de SQL Server. Estoy muy entusiasmado porque es mi primera vez como orador.

El evento se realizara el 22 de Mayo de 2015 en Microsoft Argentina, Bouchard 710 4° Piso,  Ciudad Autónoma de Buenos Aires, Buenos Aires, 1053, Argentina. 

Si aún no están registrados, háganlo utilizando el siguiente link