Aquí encontraran el podcast que grabamos con Carlos Chacon de SQL Data Partners durante el SQL Saturday de Buenos Aires donde hablamos sobre de Extended Events.
Muchas gracias Carlos por la buena onda!!
Espero que lo disfruten
http://sqldatapartners.com/2015/08/05/podcast-episode-02-extended-events/
Thursday, August 6, 2015
SQL 2016 CTP 2.2 y Upgrade Advisor beta disponible para descargar
Recientemente Microsoft liberó una nueva versión publica para la comunidad (CTP) de SQL Server 2016. en este caso la versión 2.2. La cual fue publicada, retirada y re- publicada esta semana.
http://blogs.technet.com/b/dataplatforminsider/archive/2015/07/28/sql-server-2016-community-technology-preview-2-2-is-available.aspx
Asimismo podemos encontrar la primera version preliminar del SQL Server Upgrade Advisor 2016
http://blogs.technet.com/b/dataplatforminsider/archive/2015/07/28/sql-server-2016-community-technology-preview-2-2-is-available.aspx
Asimismo podemos encontrar la primera version preliminar del SQL Server Upgrade Advisor 2016
Sunday, June 28, 2015
SQL Server 2016 lanza un nuevo modelo de rápidas versiones preliminares con CTP 2.1
Muy buenas noticias !! Desde ahora veremos disponibles versiones preliminares de SQL 2016 mucho mas rápido. Ya esta disponible las versión CTP 2.1
http://blogs.technet.com/b/dataplatforminsider/archive/2015/06/24/sql-server-2016-launches-new-rapid-preview-model-with-ctp-2-1.aspx
http://blogs.technet.com/b/dataplatforminsider/archive/2015/06/24/sql-server-2016-launches-new-rapid-preview-model-with-ctp-2-1.aspx
SQL Server Management Studio (SSMS) ya tiene su propia actualizacion por separado
Desde ahora SSMS contara con su propio upgrade path por lo que veremos actualizaciones mas seguidas y separadas de SQL Server.
Actualmente se encuentra disponible las versión Preview de Junio 2015
Download SQL Server Management Studio June 2015 preview
Links relacionados
http://sqlmag.com/sql-server-2016/sql-server-management-studio-now-has-its-own-upgrade-path
https://msdn.microsoft.com/en-us/library/mt238290.aspx
Actualmente se encuentra disponible las versión Preview de Junio 2015
Download SQL Server Management Studio June 2015 preview
Links relacionados
http://sqlmag.com/sql-server-2016/sql-server-management-studio-now-has-its-own-upgrade-path
https://msdn.microsoft.com/en-us/library/mt238290.aspx
Thursday, June 4, 2015
SQL Saturday Buenos Aires - Presentación y Demos
Aquí podrán descargar la presentación PowerPoint y los scripts utilizados en la demo de mi charla llamada "SQL Monitoring" durante el SQL Saturday Buenos Aires
http://1drv.ms/1FwJHgq
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
Estos son los temas de los que estuvimos hablando durante mi presentacion
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
§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
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
- Use Add or Remove Programs in Control Panel to uninstall version 12.0.4050.0 of SQL Server 2014 SP1 (KB3018269).
- 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)
Subscribe to:
Posts (Atom)