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
Sunday, June 28, 2015
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)
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
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
Wednesday, February 4, 2015
SQLSaturday #405 - Buenos Aires 2015 - May 22
Finally Argentina will host the first local #SQLSaturday event so we are really excited. Here is the registration page for the ones who wants to attend
https://www.sqlsaturday.com/405/eventhome.aspx
It will be on May 22 at Microsoft Argentina (Bouchard 710 4° Piso, Ciudad Autónoma de Buenos Aires, Buenos Aires, 1053, Argentina)
These are the tweeter info you need to know
#sqlsatBuenosAires
SAVE THE DATE !!
See you there
https://www.sqlsaturday.com/405/eventhome.aspx
It will be on May 22 at Microsoft Argentina (Bouchard 710 4° Piso, Ciudad Autónoma de Buenos Aires, Buenos Aires, 1053, Argentina)
These are the tweeter info you need to know
#sqlsatBuenosAires
SAVE THE DATE !!
See you there
Subscribe to:
Posts (Atom)