PASS Summit 2017 - Speaker Idol

Se desarrolló una nueva edición del mayor evento de la comunidad de Data Platform. el PASS Summit 2017 en Seattle, WA. Este año tuve la oportunidad de participar por primera vez en el Speaker Idol. 

Mi participación en el Speaker Idol

https://www.dcac.co/syndication/your-pass-summit-2017-speaker-idol-contestants-are

Anuncio de PASS Summit 2018

Keynote día 1

Keynote día 2

Charla "SQL Server 2017 Mejoras impulsadas por la comunidad" en PASS Global Spanish virtual group

El día 14 de Junio de 2017 he dado la charla "SQL Server 2017 Mejoras impulsadas por la comunidad" en PASS Global Spanish virtual group 

Voy a estar dando la misma charla en Ingles el día 28 de Junio a las 12 (EDT) en PASS DBA Virtual Group 


Estos son algunos de los puntos de los que hemos hablado

•Introduction

•Smart Differential Backup

•Smart Transaction Log Backup

•SELECT INTO …. ON Filegroup

•Tempdb Setup improvements

•Tempdb monitoring and planning

•Transaction log monitoring and diagnostics

•Improved backup performance for small databases on high-end servers

•Processor information in sys.dm_os_sys_info

•Capturing Query Store runtime statistics in DBCC CLONEDATABASE

•Resumable Online Index Rebuild

•Automatic plan correction

link a Slideshare

link a los scripts utilizados en la demo

Esta es la grabación

Podcast SQL Data Partners

Quiero compartir con ustedes el link con la grabación de la entrevista que realizamos con los amigos de SQL Data Partners,  Carlos Chacon y Steve Stedman 


En este episodio hacemos un recorrido por algunas de las experiencias (no tan buenas) relacionadas con upgrades a SQL Server 2016 así como por algunas de las New Features. Finalmente respondí las preguntas relacionadas con #SQLFamily 

Espero que les sea útil y les guste!

Se los recomiendo

Episode 85: Speedbumps Upgrading to 2016

http://sqldatapartners.com/2017/01/25/speedbumps/

Charla "Nuevas Caracteristicas de SQL Server 2016 para DBAs" 24 Horas de PASS en Español

Los dias 6 y 7 de Diciembre de 2016 se realizo el evento online anual para la comunidad de habla hispana de profesionales de Data Platform (SQL Server, BI, etc)

les dejo el link al video de mi charla llamada "Nuevas Caracteristicas de SQL Server 2016 para DBAs"

PASS Summit 2016 - Dia 2

Continuando con el evento PASS Summit 2016 en su segundo día,se presento el nuevo "branding" the PASS. ( Así como también el nuevo site que estará disponible a principios del 2017)

Tambien no informaron las fechas del evento para el próximo año ( 31 de Octubre al 3 de Noviembre de 2017)

Estos fueron los resultados de la encuesta a los miembros de PASS acerca del significado de esta comunidad de profesionales

Durante el Keynote del día 2 el Dr. David DeWitt nos habló sobre DW en la nube

Una de mis sesiones fue relacionada a SQL en Linux. donde confirmaron que estará disponible para mediados del 2017

PASS Summit 2016 - Dia 1

Desde el 26 hasta el 28 de Octubre de 2016 se esta desarrollando el PASS Summit en Seattle, WA. 

PASS es la conferencia anual de profesionales de SQL Server y BI. El evento congrega una gran cantidad de miembros de la comunidad PASS.

Este es mi PASS numero 7 y el 1ero como Microsoft MVP Data Platform.

En los siguientes POST voy a transmitirles las novedades mas importantes

Bienvenidos

Keynote Dia 1

Los 5 anuncios mas importantes 

https://t.co/vwCxMP8xoL

1. Public Preview of Azure Analysis Services

2. SQL Server 2016 DW Fast Track Reference Architecture, 145TB

3. Data Migration Assistant and Database Experimentation Assistant

4. Azure SQL Data Warehouse Expanded Free Trial

5. Cognitive Toolkit (formerly known as CNTK)

Version actualizada de SP_DBA_CurrentlyExec

Acá les dejo una versión actualizada de SP_DBA_CurrentlyExec


https://onedrive.live.com/redir?resid=1FA872AB07A90D8A!49568&authkey=!ABwpIFtS7ZyHwb8&ithint=folder%2csql


Estos son algunos ejemplos de uso así como también el Change Log

Change Log
-- v4.1 . 2013-08-23
-- v4.2 . 2014-04-23 - Now is a SP
-- v4.3 . 2014-04-25 - Automatically Include Blocking Reports, Open Trans and Server Info
-- v4.31. 2014-05-14 - Fix Elap_Time = 23:59:59
-- v4.32. 2014-05-27 - Fix OpenTran
-- v4.4.  2014-06-10 - Elap_Time includes Days. Default Sort is Elap_Time / Start_Time
-- v4.41. 2014-06-22 - Minor Fixes
-- v4.42. 2014-07-28 - Fix Transaction log usage on named instances
-- v4.43. 2014-08-04 - Add "Rollback" Status
-- v4.5 . 2015-10-25 - Add Object schema and databases.state=0 // Filters
-- v4.6 . 2016-04-15 - Add MultiServer and Blocks
-- v4.7 . 2016-04-19 - Identify Blocking Transactions
-- v4.8 . 2016-06-06 - Excel output

Examples
--[dbo].[SP_DBA_CurrentlyExec]
--[dbo].[SP_DBA_CurrentlyExec] @Filter_Name='object_name',@Filter_value ='SP_BL'
--[dbo].[SP_DBA_CurrentlyExec] @Filter_Name='Host_name',@Filter_value ='NJUMTS'
--[dbo].[SP_DBA_CurrentlyExec] @Filter_Name='Login_Name',@Filter_value ='MyLogin'
--[dbo].[SP_DBA_CurrentlyExec] @Filter_Name='SPID',@Filter_value ='371'
--[dbo].[SP_DBA_CurrentlyExec] @MultiServer=1

--[dbo].[SP_DBA_CurrentlyExec] @Blocks=1
--[dbo].[SP_DBA_CurrentlyExec] @excel=1

Pronto estará disponible una serie de videos explicativos en YouTube como información adicional

Charla "Analizando la performance del subsistema de I/O" en PASS Global Spanish

Muchas gracias @SpanishPASSVC por permitirme presentar mi charla

"Analizando la performance del subsistema de I/O"
Scripts de las demo - descargar


Les dejo los link a los slides. 

http://www.slideshare.net/SpanishPASSVC/analizando-la-performance-del-subsistema-de-io?qid=55e467c3-c8c2-413b-8853-9f32d3606028&v=&b=&from_search=1

SQL Server 2016 Release Candidate (RC0)

What's New in SQL Server 2016 Release Candidate (RC0)

Updated: March 3, 2016

Applies To: SQL Server 2016 Preview

This topic summarizes the new features in the current monthly build of SQL Server 2016 Release Candidate (RC0). The topic also contains links to more detailed component level what's new information for the current month and previous monthly builds.

Download

https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016

 For the current release notes, see SQL Server 2016 Release Notes.

Database Engine - new this month

Support for UTF-8 – bcp Utility, BULK INSERT, and OPENROWSET now support the UTF-8 code page. For more information, see those topics andCreate a Format File (SQL Server).

New string functions – STRING_SPLIT (Transact-SQL) and STRING_ESCAPE (Transact-SQL) are added.

New JSON_MODIFY function. The built-in support for JSON also now includes the JSON_MODIFY (Transact-SQL) function. Use theJSON_MODIFY function to update the value of a property in a JSON string and return the updated JSON string.

New or improved in Stretch Database

• New preview version on Azure. A preview of a new version of Stretch Database on Azure that supports one petabyte of data is now available. To register for preview access, go to SQL Server Stretch Database preview.
• Azure Active Directory authentication. The option to use a federated service account for SQL Server to communicate with the remote Azure SQL Database server when certain conditions are true no longer requires a trace flag. For more info, see Enable Stretch Database for a database.

Parallel scan of nonclustered indexes on MEMORY_OPTIMIZED tables: Now all indexes on MEMORY_OPTIMIZED tables support parallel scan. This speeds the performance of analytical queries that scan large sets of data.

For more detailed what's new information and information on previous months, see What's New in Database Engine.

New values for the model database and default values for new databases (which are based on model). The initial size of the data and log files is now 8 MB. The default auto-growth of data and log files is now 64MB.

Autogrow options: Trace flag 1117 is replaced by the AUTOGROW_SINGLE_FILE and AUTOGROW_ALL_FILES option of ALTER DATABASE, and trace flag 1117 has no affect. For more information, see ALTER DATABASE File and Filegroup Options (Transact-SQL) and the new is_autogrow_all_files column of sys.filegroups (Transact-SQL).

Allocation of mixed extents: Trace flag 1118 is replaced with the SET MIXED_PAGE_ALLOCATION option of ALTER DATABASE, and trace flag 1118 has no affect. For more information, see ALTER DATABASE SET Options (Transact-SQL), and the new is_mixed_page_allocation_on column ofsys.databases (Transact-SQL).

SQL Server Management Tools: SQL Server Management Tools is no longer installed from the main feature tree; for details see Install SQL Server Management Tools.

For more detailed what's new information and information on previous months, see What's New in Database Engine.

Analysis Services - new this month

PowerShell for Tabular models at 1200 compatibility level

RC0 completes the PowerShell enhancements for Tabular models created at the SQL Server 2016 version. You can use all of the applicable cmdlets, plus two new cmdlets specific to Tabular mode: Invoke-ProcessASDatabase and Invoke-ProcessTable.

SSIS Tasks for Tabular models at 1200 compatibility level

SSIS tasks and destinations against a SQL Server 2016 tabular model use tabular object representations instead of multidimensional. For example, in the latest SSDT, when you select objects to process, the Processing Task will automatically detect it is a Tabular model and show Tabular objects instead of measuregroups and dimensions.

Microsoft.AnalysisServices.Tabular namespace for Tabular 1200 programmability in AMO

Analysis Services Management objects is updated to include a new Tabular namespace for managing a Tabular instance of SQL Server 2016 Analysis Services (at compatibility level 1200), as well as provide the data definition language for creating or modifying Tabular models programmatically. Visit Microsoft.AnalysisServices.Tabular to read up on the API.

Display folders for Tabular models at 1200 compatibility level

Defined in SQL Server Data Tools and rendered in client applications like Excel or Power BI Desktop, display folders help you organize large numbers of measures into individual folders, adding a visual hierarchy that is easier for report users to navigate.

Integration Services - new this month

SSIS Designer creates and maintains packages for SQL Server 2016, 2014, or 2012. You can now use SSIS Designer in SQL Server Data Tools (SSDT) for Visual Studio 2015 to create and maintain packages that target SQL Server 2016, SQL Server 2014, or SQL Server 2012. In the property pages for an Integration Services project, on the General tab of Configuration Properties, select the TargetServerVersion property and choose SQL Server 2016, SQL Server 2014, or SQL Server 2012. To get SSDT, see Download Latest SQL Server Data Tools.

Support for server-wide default logging level. In SQL Server Server Properties, under the Server logging level property, you can now select a default server-wide logging level. You can pick from one of the built-in logging levels - basic, none, verbose, performance, or runtime lineage - or you can pick an existing customized logging level. The selected logging level applies to all packages deployed to the SSIS Catalog. It also applies by default to a SQL Agent job step that runs an SSIS package.

HDFS File Destination now supports ORC file format. The HDFS File Destination now supports the ORC file format in addition to Text and Avro. (The HDFS File Source supports only Text and Avro.) For more info about this component, see HDFS File Destination.

For more detailed what's new information and information on previous months, see What's New in Integration Services.

Master Data Services - new this month

Derived Hierarchy Management Experience Improved

The derived hierarchy management experience in MDS has been improved. For more information about this feature, see Create a Derived Hierarchy (Master Data Services).

For more detailed what's information on previous months, see What's New in Master Data Services (MDS).

Reporting Services - new this month

For more detailed what's new information and information on previous months, see What's New in Reporting Services (SSRS).

SQL Server R Services

For more detailed what's new information and information on previous months, see What's New in SQL Server R Services.

Did this Article Help You? We’re Listening

What information are you looking for, and did you find it? We’re listening to your feedback to improve the content. Please submit your comments to sqlfeedback@microsoft.com

More information about SQL Server 2016

For more information about SQL Server 2016 Release Candidate (RC0), or to download the SQL Server 2016 Release Candidate (RC0) data sheet, see SQL Server 2016 Preview.

https://msdn.microsoft.com/en-us/library/bb500435.aspx

"SQL Advanced Monitoring" Session for PASS DBA Virtual Chapter

On February 24th 2016 I have presented my session "SQL Advanced Monitoring" for PASS DBA Virtual Chapter.

Here you can find the recording

Here can access to the slides and the scripts

http://dba.sqlpass.org/Home.aspx?EventID=4661



Hope you find it useful
--Javier

Charla SQL Monitoring en PASS Global Spanish

Muchas Gracias @SpanishPASSVC por permitirme presentar mi charla acerca de "SQL Monitoring"

Les dejo los link a la grabacion y a los slides

Aca les dejamos la presentación del dia de hoy por Javier Villegas. http://t.co/qO7xu4AeIM

— PASS Global Spanish (@SpanishPASSVC) September 16, 2015

24 Hours of PASS: Summit 2015 Preview

Se llevara a cabo el 17 de Septiembre de 2015 empezando a las 12:00 UTC con una duración de 24 horas. Presentando 24 webcasts , este evento ofrece una visión del contenido sin igual que ofrece PASS Summit 2015, que se llevara a cabo desde 27 al 30 de Octubre en Seattle, WA

http://www.sqlpass.org/24hours/2015/summitpreview/About.aspx

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

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

@Ale_Cabanchik @CarlosLChacon @adrianfz10 @maxiaccotto

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

Detect languageAfrikaansAlbanianArabicArmenianAzerbaijaniBasqueBengaliBelarusianBulgarianCatalanChinese (Simp)Chinese (Trad)CroatianCzechDanishDutchEnglishEsperantoEstonianFilipinoFinnishFrenchGalicianGeorgianGermanGreekGujaratiHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKannadaKoreanLaoLatinLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTamilTeluguThaiTurkishUkrainianUrduVietnameseWelshYiddish

AfrikaansAlbanianArabicArmenianAzerbaijaniBasqueBengaliBelarusianBulgarianCatalanChinese (Simp)Chinese (Trad)CroatianCzechDanishDutchEnglishEsperantoEstonianFilipinoFinnishFrenchGalicianGeorgianGermanGreekGujaratiHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKannadaKoreanLaoLatinLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTamilTeluguThaiTurkishUkrainianUrduVietnameseWelshYiddish

Text-to-speech function is limited to 100 characters

Options : History : Help : Feedback