tag:blogger.com,1999:blog-8626342930813851562024-03-05T04:36:00.739-03:00Javier Villegas - SQL Server DBA - Microsoft MVP Data Platform - MCTS / MCPThis is my blog in where I'll share all my DBA experience and sql scripts.
Este es mi blog donde comparto toda mi experiencia como DBA y algunos scripts.Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.comBlogger68125tag:blogger.com,1999:blog-862634293081385156.post-26304644551891361842021-06-18T16:01:00.003-03:002021-06-18T16:01:57.277-03:00 Query Store Hints Preview en Azure SQL<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="ES-AR" style="color: black; font-family: "Arial",sans-serif; mso-ansi-language: ES-AR; mso-fareast-font-family: "Times New Roman";">A principios de junio de este año
Microsoft lanzo Query Store Hints como Public Preview en Azure SQL (Azure SQL
Database y Managed Instance) </span><span lang="ES-AR" style="font-family: "Arial",sans-serif; mso-ansi-language: ES-AR; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="ES-AR" style="color: black; font-family: "Arial",sans-serif; mso-ansi-language: ES-AR; mso-fareast-font-family: "Times New Roman";">Esta nueva funcionalidad agrega una nueva característica
super interesante a Query Store.</span><span style="font-family: Arial, sans-serif;"> </span></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="ES-AR" style="color: black; font-family: "Arial",sans-serif; mso-ansi-language: ES-AR; mso-fareast-font-family: "Times New Roman";">Ya conocemos que Query Store se encarga de
almacenar los planes de ejecución así como las estadísticas de runtime (tiempo
de ejecución, uso de CPU, lectura , escritura , etc) para todos los procesos en
una base de datos de usuario.</span><span lang="ES-AR" style="font-family: Arial, sans-serif;"><o:p> </o:p></span><span style="font-family: Arial, sans-serif;"> </span></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span lang="ES-AR" style="color: black; font-family: "Arial",sans-serif; mso-ansi-language: ES-AR; mso-fareast-font-family: "Times New Roman";">Sabemos que muchas veces SQL Server no elige
el mejor plan de ejecución, por lo que en algunas ocasiones vemos alguna regresión
en la ejecución de nuestros procesos.<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span style="font-family: Arial, sans-serif;">En estos casos, si tenemos acceso al código podemos
cambiar el comportamiento de dicho proceso modificando el código y agregando
una </span><a href="https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-query?view=sql-server-ver15?WT.mc_id=DP-MVP-5002080" style="font-family: Arial, sans-serif;">QUERY
HINT</a><span style="font-family: Arial, sans-serif;"> . En muchos casos no tenemos la posibilidad de modificar el código por
lo que no podríamos cambiar dicho comportamiento.</span><span style="font-family: Arial, sans-serif;"> </span></p>
<p class="MsoNormal"><span lang="ES-AR" style="font-family: "Arial",sans-serif; mso-ansi-language: ES-AR;">Con Query Store Hints ahora podemos identificar el
query en el que detectamos la regresión para luego asignar en forma externa
unos o varios hints, por lo que podremos cambiar el comportamiento de los
procesos problemáticos sin tener que modificar el código.</span><span style="font-family: Arial, sans-serif;"> </span></p>
<p class="MsoNormal"><span lang="ES-AR" style="font-family: "Arial",sans-serif; mso-ansi-language: ES-AR;">Los invito a ver este <a style="mso-comment-date: 20210618T1559; mso-comment-reference: JV_1;">video donde explico todos los detalles y
muestro algunos ejemplos de esta nueva </a>funcionalidad.</span></p><p class="MsoNormal"><span lang="ES-AR" style="font-family: "Arial",sans-serif; mso-ansi-language: ES-AR;"><br /></span></p><p class="MsoNormal"></p><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="372" src="https://www.youtube.com/embed/50w9oXjW-_k" width="447" youtube-src-id="50w9oXjW-_k"></iframe></div><br /><span lang="ES-AR" style="font-family: "Arial",sans-serif; mso-ansi-language: ES-AR;"><br /></span><p></p>Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com3tag:blogger.com,1999:blog-862634293081385156.post-7554874320615419272020-09-24T23:58:00.005-03:002020-09-25T00:00:16.431-03:00Exam DP-300 Administering Relational Databases on Microsoft Azure – Study Guide<p class="MsoNormal" style="background: white; line-height: 22.5pt; margin-bottom: 7.5pt; vertical-align: top;"><b><span face="Arial, sans-serif" style="color: #333333; font-size: 18pt; text-transform: uppercase;">AZURE DP-300 STUDY GUIDE<o:p></o:p></span></b></p><p class="MsoNormal" style="line-height: 19.5pt; margin-bottom: 2.25pt;"><b><span face="Arial, sans-serif" style="color: #333333; font-size: 18pt; text-transform: uppercase;">ADMINISTERING RELATIONAL DATABASES ON MICROSOFT AZURE</span></b></p><p class="MsoNormal" style="background: white; line-height: 22.5pt; margin-bottom: 7.5pt; mso-outline-level: 1; vertical-align: top;"><span face="Arial, sans-serif" style="color: #333333;">If you are interested in getting
the new Microsoft role-based certification “</span><b style="color: #333333; font-family: Arial, sans-serif;">Azure Database Administrator
Associate</b><span face="Arial, sans-serif" style="color: #333333;">” you only have to take the exam (DP-300. </span><b style="color: #333333; font-family: Arial, sans-serif;">Administering Relational
Databases on Microsoft Azure</b><span face="Arial, sans-serif" style="color: #333333;">) so I’ve prepared a study guide that includes all
the areas and topics that will be evaluated as well as links to the official documentation
and learning portal.</span></p><p class="MsoNormal" style="background: white; line-height: 22.5pt; margin-bottom: 7.5pt; mso-outline-level: 1; vertical-align: top;"><o:p></o:p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvgmvjQOWNphT8itI98OpwWS_5CWlq7idpnkpdAIqg17D9WWbTqNdAKjHjdlEjhQTo8dI-AVEsrp9bUWJw3ERlqfNP1rLyKVpYGz1mOJE7pv3v784xxhSKAJB63cE-YTLYgZIx4Bn-tS5a/s231/Azure+Database+Admin+Cert.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="223" data-original-width="231" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvgmvjQOWNphT8itI98OpwWS_5CWlq7idpnkpdAIqg17D9WWbTqNdAKjHjdlEjhQTo8dI-AVEsrp9bUWJw3ERlqfNP1rLyKVpYGz1mOJE7pv3v784xxhSKAJB63cE-YTLYgZIx4Bn-tS5a/s0/Azure+Database+Admin+Cert.jpg" /></a></div><br /><p></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><b><u><span face=""Arial",sans-serif" style="border: 1pt none windowtext; color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Plan and Implement Data Platform Resources
(15-20%)</span></u></b></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";">
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Deploy resources by using manual methods</span></b><br />
• Deploy database offerings on selected platforms<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-paas-vs-sql-server-iaas?WT.mc_id=DP-MVP-5002080" target="_blank"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-paas-vs-sql-server-iaas</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure customized deployment templates<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-resource-manager-samples?tabs=single-database?WT.mc_id=DP-MVP-5002080" target="_blank"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-resource-manager-samples?tabs=single-database</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Apply patches and updates for hybrid and IaaS deployment<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-resource-manager-samples?tabs=single-database&WT.mc_id=DP-MVP-5002080" target="_blank"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-automated-patching</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Recommend an appropriate database offering based on specific
requirements</span></b><br />
<br />
• Evaluate requirements for the deployment<br />
• Evaluate the functional benefits/impact of possible database offerings<br />
• Evaluate the scalability of the possible database offering<br />
• Evaluate the HA/DR of the possible database offering<br />
• Evaluate the security aspects of the possible database offering<br />
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Configure resources for scale and performance</span></b><br />
<br />
• Configure Azure SQL database/elastic pools for scale and performance<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool-manage?WT.mc_id=DP-MVP-5002080" target="_blank"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool-manage</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure Azure SQL managed instances for scale and performance<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure SQL Server in Azure VMs for scale and performance<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Calculate resource requirements<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sharepoint/administration/storage-and-sql-server-capacity-planning-and-configuration?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sharepoint/administration/storage-and-sql-server-capacity-planning-and-configuration</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Evaluate database partitioning techniques, such as database sharding<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/architecture/best-practices/data-partitioning?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/architecture/best-practices/data-partitioning</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br style="mso-special-character: line-break;" />
<!--[if !supportLineBreakNewLine]--><br style="mso-special-character: line-break;" />
<!--[endif]--><b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;"><o:p></o:p></span></b></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><b><span face=""Arial",sans-serif" style="border: 1pt none windowtext; color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Evaluate a strategy for moving to Azure</span></b><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
• Evaluate requirements for the migration<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/dma/dma-assesssqlonprem?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/dma/dma-assesssqlonprem?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Evaluate offline or online migration strategies<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Evaluate requirements for the upgrade<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-version-15?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-version-15?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br style="mso-special-character: line-break;" />
<!--[if !supportLineBreakNewLine]--><br style="mso-special-character: line-break;" />
<!--[endif]--><o:p></o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";">• Evaluate offline or online upgrade
strategies<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-application-rolling-upgrade?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-application-rolling-upgrade</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br style="mso-special-character: line-break;" />
<!--[if !supportLineBreakNewLine]--><br style="mso-special-character: line-break;" />
<!--[endif]--><b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;"><o:p></o:p></span></b></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><b><span face=""Arial",sans-serif" style="border: 1pt none windowtext; color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Implement a migration or upgrade strategy
for moving to Azure</span></b><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
• Implement an online migration strategy<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://datamigration.microsoft.com/scenario/sql-to-azuresqldb?step=1&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://datamigration.microsoft.com/scenario/sql-to-azuresqldb?step=1</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Implement an offline migration strategy<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• implement an online upgrade strategy<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-application-rolling-upgrade?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-application-rolling-upgrade</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Implement an offline upgrade strategy<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
<b><u><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Implement a Secure Environment (15-20%)</span></u></b><br />
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Configure database authentication by using platform and database
tools</span></b><br />
<br />
• Configure Azure AD authentication<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure?tabs=azure-powershell&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure?tabs=azure-powershell</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Create users from Azure AD identities<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure security principals<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/security/securing-sql-server?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/security/securing-sql-server?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Configure database authorization by using platform and database
tools</span></b><br />
<br />
• Configure database and object-level permissions using graphical tools<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/security/permissions-database-engine?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/security/permissions-database-engine?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Apply principle of least privilege for all securables<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/authorization-and-permissions-in-sql-server?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/authorization-and-permissions-in-sql-server</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Implement security for data at rest</span></b><br />
<br />
• Implement Transparent Data Encryption (TDE)<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Implement object-level encryption<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/encrypt-a-column-of-data?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/encrypt-a-column-of-data?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Implement Dynamic Data Masking<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Implement Azure Key Vault and disk encryption for Azure VMs<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/virtual-machines/windows/disk-encryption-key-vault?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/virtual-machines/windows/disk-encryption-key-vault</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br style="mso-special-character: line-break;" />
<!--[if !supportLineBreakNewLine]--><br style="mso-special-character: line-break;" />
<!--[endif]--><b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;"><o:p></o:p></span></b></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><b><span face=""Arial",sans-serif" style="border: 1pt none windowtext; color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><b><span face=""Arial",sans-serif" style="border: 1pt none windowtext; color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Implement security for data in transit</span></b><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
• Configure SQL DB and database-level firewall rules<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configure?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configure</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Implement Always Encrypted<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure Azure Data Gateway<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-gateway?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-gateway</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Implement compliance controls for sensitive data</span></b><br />
<br />
• Apply a data classification strategy<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/security/sql-data-discovery-and-classification?view=sql-server-ver15&tabs=t-sql&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/security/sql-data-discovery-and-classification?view=sql-server-ver15&tabs=t-sql</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure server and database audits<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/create-a-server-audit-and-database-audit-specification?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/create-a-server-audit-and-database-audit-specification?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Implement data change tracking<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/track-data-changes-sql-server?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/track-data-changes-sql-server?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Perform vulnerability assessment<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/security/sql-vulnerability-assessment?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/security/sql-vulnerability-assessment?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
<b><u><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Monitor and Optimize Operational Resources (15-20%)</span></u></b><br />
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Monitor activity and performance</span></b><br />
<br />
• Prepare an operational performance baseline<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/establish-a-performance-baseline?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/performance/establish-a-performance-baseline?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Determine sources for performance metrics<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Interpret performance metrics<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/performance-monitoring-and-tuning-tools?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/performance/performance-monitoring-and-tuning-tools?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Assess database performance by using Azure SQL Database Intelligent<br />
Performance<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-query-performance?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-query-performance</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure and monitor activity and performance at the infrastructure, server,
service, and database levels<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/query-profiling-infrastructure?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/performance/query-profiling-infrastructure?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<b><u><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Implement performance-related maintenance tasks</span></u></b><br />
<br />
• Implement index maintenance tasks<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/maintenance-plans/rebuild-index-task-maintenance-plan?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/maintenance-plans/rebuild-index-task-maintenance-plan?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Implement statistics maintenance tasks<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/maintenance-plans/update-statistics-task-maintenance-plan?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/maintenance-plans/update-statistics-task-maintenance-plan?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure database auto-tuning<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automatic-tuning-enable?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automatic-tuning-enable</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Automate database maintenance tasks<br />
– Azure SQL agent jobs, Azure automation, SQL server agent jobs<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/maintenance-plans/use-the-maintenance-plan-wizard?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/maintenance-plans/use-the-maintenance-plan-wizard?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Manage storage capacity<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Identify performance-related issues</span></b><br />
<br />
• Configure Query Store to collect performance data<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Identify sessions that cause blocking<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://support.microsoft.com/en-gb/help/224453/inf-understanding-and-resolving-sql-server-blocking-problems"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://support.microsoft.com/en-gb/help/224453/inf-understanding-and-resolving-sql-server-blocking-problems</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Sssess growth/fragmentation of databases and logs<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Assess performance-related database configuration parameters<br />
– including AutoClose, AutoShrink, AutoGrowth<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://support.microsoft.com/en-gb/help/315512/considerations-for-the-autogrow-and-autoshrink-settings-in-sql-server"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://support.microsoft.com/en-gb/help/315512/considerations-for-the-autogrow-and-autoshrink-settings-in-sql-server</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Configure resources for optimal performance</span></b><br />
<br />
• Configure storage and infrastructure resources<br />
– Optimize IOPS, throughput, and latency<br />
– Optimize Tempdb performance<br />
– Optimize data and log files for performance<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-server-storage-configuration?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-server-storage-configuration</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure server and service account settings for performance<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://support.microsoft.com/en-gb/help/319942/how-to-determine-proper-sql-server-configuration-settings"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://support.microsoft.com/en-gb/help/319942/how-to-determine-proper-sql-server-configuration-settings</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure Resource Governor for performance<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><b><span face=""Arial",sans-serif" style="border: 1pt none windowtext; color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Configure a user database for optimal
performance</span></b><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Implement database-scoped configuration<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-scoped-configuration-transact-sql?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-scoped-configuration-transact-sql?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure compute resources for scaling<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-single-database-scale?WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-single-database-scale</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure Intelligent Query Processing (IQP)<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/intelligent-query-processing?view=sql-server-ver15&WT.mc_id=DP-MVP-5002080"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/performance/intelligent-query-processing?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<b><u><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Optimize Query Performance (5-10%)</span></u></b><u><o:p></o:p></u></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Review query plans</span></b><br />
• Determine the appropriate type of execution plan<br />
– Live Query Statistics, Actual Execution Plan, Estimated Execution Plan,
Showplan<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/execution-plans?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/performance/execution-plans?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Identify problem areas in execution plans<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/analyze-an-actual-execution-plan?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/performance/analyze-an-actual-execution-plan?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Extract query plans from the Query Store<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Evaluate performance improvements</span></b><br />
• Determine the appropriate Dynamic Management Views (DMVs) to gather query
performance information<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Identify performance issues using DMVs<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Identify and implement index changes for queries<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-index-design-guide?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-index-design-guide?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Recommend query construct modifications based on resource usage<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/upgrade-dbcompat-using-qta?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/performance/upgrade-dbcompat-using-qta?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Assess the use of hints for query performance<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-query?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-query?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><b><span face=""Arial",sans-serif" style="border: 1pt none windowtext; color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><b><span face=""Arial",sans-serif" style="border: 1pt none windowtext; color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Review database table and index design</span></b><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Identify data quality issues with duplication of data<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/data-quality-services/introduction-to-data-quality-services?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/data-quality-services/introduction-to-data-quality-services?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Identify normal form of database<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Assess index design for performance<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-index-design-guide?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-index-design-guide?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Validate data types defined for columns<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://www.mssqltips.com/sqlservertip/4799/validate-integer-and-decimal-values-in-sql-server/"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://www.mssqltips.com/sqlservertip/4799/validate-integer-and-decimal-values-in-sql-server/</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Recommend table and index storage including filegroups<br />
• Evaluate table partitioning strategy<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-files-and-filegroups?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-files-and-filegroups?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Evaluate the use of compression for tables and indexes<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/enable-compression-on-a-table-or-index?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/enable-compression-on-a-table-or-index?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<b><u><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Perform Automation of Tasks (10-15%)</span></u></b><u><o:p></o:p></u></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Create scheduled tasks</span></b><br />
• Manage schedules for regular maintenance jobs<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/ssms/agent/schedule-a-job?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/ssms/agent/schedule-a-job?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure multi-server automation<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/ssms/agent/automated-administration-across-an-enterprise?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/ssms/agent/automated-administration-across-an-enterprise?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure notifications for task success/failure/non-completion<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/ssms/agent/notify-an-operator-of-job-status?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/ssms/agent/notify-an-operator-of-job-status?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Evaluate and implement an alert and notification strategy</span></b><br />
• Create event notifications based on metrics<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-insights-alerts-portal"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-insights-alerts-portal</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
• Create event notifications for Azure resources<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/service-broker/event-notifications?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/service-broker/event-notifications?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
• Create alerts for server configuration changes<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-alert-transact-sql?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-alert-transact-sql?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Create tasks that respond to event notifications<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/service-broker/event-notifications?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/service-broker/event-notifications?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Manage and automate tasks in Azure</span></b><br />
• Perform automated deployment methods for resources<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/devops/pipelines/targets/azure-sqldb?view=azure-devops&tabs=yaml"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/devops/pipelines/targets/azure-sqldb?view=azure-devops&tabs=yaml</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Automate Backups<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automated-backups?tabs=single-database"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automated-backups?tabs=single-database</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Automate performance tuning and patching<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automatic-tuning"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automatic-tuning</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Implement policies by using automated evaluation modes<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/policy-based-management/administer-servers-by-using-policy-based-management?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/policy-based-management/administer-servers-by-using-policy-based-management?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><b><span face=""Arial",sans-serif" style="border: 1pt none windowtext; color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><b><span face=""Arial",sans-serif" style="border: 1pt none windowtext; color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><b><span face=""Arial",sans-serif" style="border: 1pt none windowtext; color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><b><u><span face=""Arial",sans-serif" style="border: 1pt none windowtext; color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Plan and Implement a High Availability and
Disaster Recovery (HADR)<br />
Environment (15-20%)</span></u></b><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Recommend an HADR strategy for a data platform solution</span></b><br />
• Recommend HADR strategy based on RPO/RTO requirements<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-business-continuity"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-business-continuity</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Evaluate HADR for hybrid deployments<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-high-availability-dr"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-high-availability-dr</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Evaluate Azure-specific HADR solutions<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-high-availability"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-high-availability</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Identify resources for HADR solutions<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://www.sqlskills.com/blogs/erin/sql-server-hadr-features/"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://www.sqlskills.com/blogs/erin/sql-server-hadr-features/</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Test an HADR strategy by using platform, OS and database tools</span></b><br />
• Test HA by using failover<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/perform-a-planned-manual-failover-of-an-availability-group-sql-server?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/perform-a-planned-manual-failover-of-an-availability-group-sql-server?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Test DR by using failover or restore<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-disaster-recovery"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-disaster-recovery</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
Perform backup and restore a database by using database tools<br />
• Perform a database backup with options<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver15#TsqlProcedure"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver15#TsqlProcedure</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Perform a database restore with options<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Perform a database restore to a point in time<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-sql-server-database-to-a-point-in-time-full-recovery-model?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-sql-server-database-to-a-point-in-time-full-recovery-model?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure long-term backup retention<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-long-term-retention"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-long-term-retention</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br style="mso-special-character: line-break;" />
<!--[if !supportLineBreakNewLine]--><br style="mso-special-character: line-break;" />
<!--[endif]--><b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;"><o:p></o:p></span></b></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><b><span face=""Arial",sans-serif" style="border: 1pt none windowtext; color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><b><span face=""Arial",sans-serif" style="border: 1pt none windowtext; color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">Configure DR by using platform and
database tools</span></b><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure replication<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/replication/tutorial-preparing-the-server-for-replication?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/replication/tutorial-preparing-the-server-for-replication?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure Azure Site Recovery for a database offering<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-sql"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-sql</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Configure HA using platform, OS and database tools</span></b><br />
• Create an Availability Group<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/create-availability-group-transact-sql?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/t-sql/statements/create-availability-group-transact-sql?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Integrate a database into an Availability Group<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-group-add-a-database?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-group-add-a-database?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure quorum options for a Windows Server Failover Cluster<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/wsfc-quorum-modes-and-voting-configuration-sql-server?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/wsfc-quorum-modes-and-voting-configuration-sql-server?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure an Availability Group listener<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/create-or-configure-an-availability-group-listener-sql-server?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/create-or-configure-an-availability-group-listener-sql-server?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0in; vertical-align: top;"><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<b><u><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Perform Administration by Using T-SQL (10-15%)</span></u></b><br />
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Examine system health</span></b><br />
• Evaluate database health using DMVs<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs#monitoring-query-performance"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs#monitoring-query-performance</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Evaluate server health using DMVs<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Perform database consistency checks by using DBCC<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Monitor database configuration by using T-SQL</span></b><br />
• Assess proper database autogrowth configuration<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://www.red-gate.com/simple-talk/sql/database-administration/sql-server-database-growth-and-autogrowth-settings/"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://www.red-gate.com/simple-talk/sql/database-administration/sql-server-database-growth-and-autogrowth-settings/</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Report on database free space<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/databases/display-data-and-log-space-information-for-a-database?view=sql-server-ver15#TsqlProcedure"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/databases/display-data-and-log-space-information-for-a-database?view=sql-server-ver15#TsqlProcedure</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Review database configuration options<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/databases/change-the-configuration-settings-for-a-database?view=sql-server-ver15#TsqlProcedure"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/databases/change-the-configuration-settings-for-a-database?view=sql-server-ver15#TsqlProcedure</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Perform backup and restore a database by using T-SQL</span></b><br />
• Prepare databases for AlwaysOn Availability Groups<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/manually-prepare-a-secondary-database-for-an-availability-group-sql-server?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/manually-prepare-a-secondary-database-for-an-availability-group-sql-server?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Perform transaction log backup<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-a-transaction-log-sql-server?view=sql-server-ver15#using-transact-sql"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-a-transaction-log-sql-server?view=sql-server-ver15#using-transact-sql</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Perform restore of user databases<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Perform database backups with options<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Manage authentication by using T-SQL</span></b><br />
• Manage certificates<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-certificate-transact-sql?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-certificate-transact-sql?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Manage security principals<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/principals-database-engine?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/principals-database-engine?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
<br />
<br />
<b><span style="border: 1pt none windowtext; mso-border-alt: none windowtext 0in; padding: 0in;">Manage authorization by using T-SQL</span></b><br />
• Configure permissions for users to access database objects<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/grant-a-permission-to-a-principal?view=sql-server-ver15"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/grant-a-permission-to-a-principal?view=sql-server-ver15</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><br />
• Configure permissions by using custom roles<br />
</span><span lang="ES-AR" style="color: black; mso-color-alt: windowtext;"><a href="https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-an-application-role?view=sql-server-ver15#TsqlProcedure"><span face=""Arial",sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; mso-ansi-language: EN-US; mso-border-alt: none windowtext 0in; mso-fareast-font-family: "Times New Roman"; padding: 0in;">https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-an-application-role?view=sql-server-ver15#TsqlProcedure</span></a></span><span face=""Arial",sans-serif" style="color: #333333; font-size: 10.5pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<p class="MsoNormal"><span face=""Arial",sans-serif" style="mso-ansi-language: EN-US;"><o:p> </o:p></span></p><span face="Arial, sans-serif" style="color: #333333; font-size: 10.5pt;">SQL Server Workshops check out </span><span lang="ES-AR"><a href="https://microsoft.github.io/sqlworkshops/" target="_blank"><span face="Arial, sans-serif" lang="EN-US" style="border: 1pt none windowtext; color: #1e73be; font-size: 10.5pt; padding: 0in;">https://microsoft.github.io/sqlworkshops/</span></a></span><p></p>Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com13tag:blogger.com,1999:blog-862634293081385156.post-85375907797211223902020-06-15T19:39:00.001-03:002020-06-15T19:40:53.108-03:00Full schedule of all my upcoming sessions during June 2020<font face="arial" size="5">Sharing the schedule of all my sessions during June 2020 </font><div><font face="arial" size="5">Each entry has a link to the registration site<br /></font><div><font face="arial" size="5"><br /></font></div><div><div><font face="arial" size="5">Saturday 20 – SQL Saturday Caxias do Sul Virtual 2020 - <a href="https://www.sqlsaturday.com/968/registernow.aspx" target="_blank">Monitoring & Troubleshooting SQL Server using Free community Tools (Spanish/Portuguese) </a></font></div><div><font face="arial" size="5"><br /></font></div><div><font face="arial" size="5">Wednesday 23 – <a href="https://www.powerbidays.com/virtualevent/argentina-power-bi-days-2020-06-23/" target="_blank">Argentina Power BI Days - Power BI use cases (Spanish) </a></font></div><div><font face="arial" size="5"><br /></font></div><div><font face="arial" size="5">Wednesday 24 - PASS Marathon: Azure Data Services Spanish Edition - <a href="https://www.pass.org/marathon/2020/azure-spanish/Registro.aspx" target="_blank">La Evolución de SQL Server como Servicio - Azure SQL Database Managed Instance (Spanish) </a></font></div><div><font face="arial" size="5"><br /></font></div><div><font face="arial" size="5">Thursday 25 - Tampa SQL User Groups - <a href="https://www.meetup.com/Tampa-SQL-User-Groups/events/zxmknrybcjbhc/" target="_blank">New features in SQL Server 2019 (English) </a></font></div></div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYQWn-4oSRDQhPyh6LGokNZy2umbpBIRn2pFzvlknqMcPvEqc_mHS27MtI4Z3ENj7W9RYUFF07PfWkRmU4wsjiMcq6q3LyizTDe0FHDCNqFRAO6ILc5rNh4TWy9O_JCoyqWjzEw55cyY4a/s1778/June2020.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="944" data-original-width="1778" height="266" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYQWn-4oSRDQhPyh6LGokNZy2umbpBIRn2pFzvlknqMcPvEqc_mHS27MtI4Z3ENj7W9RYUFF07PfWkRmU4wsjiMcq6q3LyizTDe0FHDCNqFRAO6ILc5rNh4TWy9O_JCoyqWjzEw55cyY4a/w500-h266/June2020.jpg" width="500" /></a></div><div><br /></div></div>Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com1tag:blogger.com,1999:blog-862634293081385156.post-42082565671371268972019-02-21T10:27:00.000-03:002019-02-21T10:27:28.696-03:00Preconference Migrating to modern SQL Server versions<br />
<span style="background-color: white; font-family: Arial, Helvetica, sans-serif;">
<span style="font-family: Arial, Helvetica, sans-serif;">SQL Saturday Chile is around the corner , April 13th 2019. I'll be delivering a pre-conference (Friday 12th) named "<b>Migrating our old SQL Server to the modern platform</b>" where we will cover all the necessary steps to accomplish a successful migration from either an old SQL Server 2005 or 2008 to the Modern Data Platform, like different options in Azure or new SQL Server versions on premises.</span></span><br />
<span style="background-color: white; font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Arial, Helvetica, sans-serif;">Also two main sessions on Saturday named "</span><span style="color: #293338;"><b>SQL Server in Docker Containers</b>" and "</span><span style="color: #293338;"><b>Query Performance Insights - What's New ?</b>"</span></span><br />
<span style="background-color: white; font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
</span><br />
<span style="background-color: white; font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Arial, Helvetica, sans-serif;">See you there !!</span></span><br />
<br />
<span style="background-color: white; font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span>
<span style="background-color: white; font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Arial, Helvetica, sans-serif;">SQL Saturday Chile esta llegando, El 13 de Abril de 2019 estare dando una pre-conferencia (Viernes 12) llamada </span></span><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;">"</span><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;"><b>Migrating our old SQL Server to the modern platform</b>" donde veremos como realizar una migracion en forma exitosa desde una version vieja de SQL Server 2005 o 2008 hacia versiones mas modernas como las diferentes opciones en Azure o nuevas versiones de SQL on premises</span><br />
<span style="background-color: white; font-family: Arial, Helvetica, sans-serif;">Tambien dos sesiones principales durante el Sabado llamadas </span><br />
<span style="background-color: white; font-family: Arial, Helvetica, sans-serif;"></span><br />
<span style="background-color: white; font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: whitesmoke;">"</span></span><span style="color: #293338;"><b>SQL Server in Docker Containers</b>" y "</span><span style="color: #293338;"><b>Query Performance Insights - What's New ?</b>"</span></span><br />
<div>
<span style="background-color: white; font-family: Arial, Helvetica, sans-serif;"><span style="color: #293338;"><br /></span></span></div>
<span style="font-family: Arial, Helvetica, sans-serif;">Los espero !!!</span><br />
<br />
<a href="https://www.sqlsaturday.com/836/EventHome.aspx" style="font-family: Arial, Helvetica, sans-serif; white-space: pre-wrap;">https://www.sqlsaturday.com/836/EventHome.aspx</a><br />
<div style="border: none; box-sizing: border-box; font-stretch: inherit; line-height: 1.8; margin: inherit; overflow-wrap: normal; overflow: auto; padding: 0px; vertical-align: baseline; word-break: normal;">
<span style="font-family: arial, helvetica, sans-serif;"><span style="white-space: pre-wrap;"><br /></span></span></div>
<br />Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com5tag:blogger.com,1999:blog-862634293081385156.post-25117766041776627752018-03-07T12:52:00.001-03:002018-03-07T13:00:41.762-03:00GroupBy and DataPlatformGeeks conferences <span style="font-family: "arial" , "helvetica" , sans-serif;">During march I'll be delivering my presentation (in english) about SQL Server 2017 called "Community-Driven Enhancements" in two of the most prestigious online events. Registration is open and is free !!</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: Arial, Helvetica, sans-serif;"><b><a href="https://www.groupby.org/" target="_blank">GroupBy</a></b></span></span><br />
<span style="background-color: white; font-family: Arial, Helvetica, sans-serif;">Friday, 16</span><sup style="background-color: white; box-sizing: border-box; font-family: Arial, Helvetica, sans-serif;">th</sup><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;"> March 2018 (</span><span class="aBn" data-term="goog_1534308854" style="background-color: white; box-sizing: border-box; font-family: Arial, Helvetica, sans-serif;"><span class="aQJ" style="box-sizing: border-box;">11:00 AM – 12:00 PM EST</span></span><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;">)</span><span style="font-family: Arial, Helvetica, sans-serif;"><br /><a href="http://www.dataplatformgeeks.com/events/" target="_blank"><br /></a></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b><a href="http://www.dataplatformgeeks.com/events/" target="_blank">DataPlatformGeeks</a></b></span><br /><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;">Monday, 19</span><sup style="background-color: white; box-sizing: border-box; font-family: Arial, Helvetica, sans-serif;">th</sup><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;"> March 2018 (</span><span class="aBn" data-term="goog_1534308854" style="background-color: white; box-sizing: border-box; font-family: Arial, Helvetica, sans-serif;"><span class="aQJ" style="box-sizing: border-box;">3:00 PM – 4:00 PM IST</span></span><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;">)</span><br />
<br />
<br />
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">Durante el mes de marzo estaré dando mi presentación (en ingles) sobre SQL Server 2017 llamada" Mejoras impulsadas por la comunidad" es dos de los mas prestigiosos eventos online.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">La resitración esta abierta y es gratuita !!</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhcXB2xsqNEiXYXIK0B1UCDTaZwr0OPSdZfe6Wx-Adrkc_4unShSOw3Dk3BZk9HAXgg9XgZXYkor0bZX9JxoPEX4-xG1ugKcjGXLWnB2QE0E0ffzP7FsfnmnLV3mr0OTU_Bblm7bqoJBtAs/s1600/Group_By_Conference_Logo.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="355" data-original-width="1199" height="94" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhcXB2xsqNEiXYXIK0B1UCDTaZwr0OPSdZfe6Wx-Adrkc_4unShSOw3Dk3BZk9HAXgg9XgZXYkor0bZX9JxoPEX4-xG1ugKcjGXLWnB2QE0E0ffzP7FsfnmnLV3mr0OTU_Bblm7bqoJBtAs/s320/Group_By_Conference_Logo.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQUW9YMHxepOR0DvOnbmEUwr5uNn6QwIE1eokpasm0BkinkiIeTocMNS4eUTofx_VvStPgFACM8idVSzOV7eBUH0Fb9mNopkPeHtEQ9U-GGSZwVsLlOaBHkF6dma_dZvYJ3smTLDM5aBWG/s1600/DataPlatformGeeks.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="400" data-original-width="400" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQUW9YMHxepOR0DvOnbmEUwr5uNn6QwIE1eokpasm0BkinkiIeTocMNS4eUTofx_VvStPgFACM8idVSzOV7eBUH0Fb9mNopkPeHtEQ9U-GGSZwVsLlOaBHkF6dma_dZvYJ3smTLDM5aBWG/s200/DataPlatformGeeks.jpeg" width="200" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com2tag:blogger.com,1999:blog-862634293081385156.post-89355023587735755832018-02-26T12:38:00.002-03:002018-02-26T12:38:59.743-03:0024 Horas de PASS es Español - Edición 2018<span style="font-family: Arial, Helvetica, sans-serif;">Aquí comparto la charla relacionada con SQL Server 2017 presentada durante el evento 24 Horas de PASS (24HOP) en Español</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/T_RjD6-jYyA/0.jpg" src="https://www.youtube.com/embed/T_RjD6-jYyA?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Este es el link del canal de Youtube del PASS Global Spanish donde podrán encontrar los videos de todas las sesiones </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://www.youtube.com/channel/UCAu7CcpdHszjxMwx8uwvU-A">https://www.youtube.com/channel/UCAu7CcpdHszjxMwx8uwvU-A</a></span>Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com1tag:blogger.com,1999:blog-862634293081385156.post-76002404592485524272018-02-26T12:32:00.000-03:002018-02-26T12:32:34.434-03:00SQL Server 2017 en Netconf AR y UY 2017<span style="font-family: Arial, Helvetica, sans-serif;">Aquí comparto todo lo relacionado con las charlas y entrevistas durante las conferencia NetConf de Argentina y Uruguay que se han desarrollo durante 2017</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">NetConf AR</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Charla</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/u501dKuL86s/0.jpg" src="https://www.youtube.com/embed/u501dKuL86s?feature=player_embedded" frameborder="0" allowfullscreen></iframe></span></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Entrevista</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/ttVBv96vovg/0.jpg" src="https://www.youtube.com/embed/ttVBv96vovg?feature=player_embedded" frameborder="0" allowfullscreen></iframe></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<span style="font-family: Arial, Helvetica, sans-serif;">NetConf UY</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Charla</span><br />
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/e2o4fQxwMqA/0.jpg" src="https://www.youtube.com/embed/e2o4fQxwMqA?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">Entrevista</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div style="text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/UTgnBrPWElY/0.jpg" src="https://www.youtube.com/embed/UTgnBrPWElY?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<br />Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com0tag:blogger.com,1999:blog-862634293081385156.post-91663339061544829882017-11-16T14:39:00.000-03:002017-11-16T14:39:31.195-03:00PASS Summit 2017 - Speaker Idol<span style="font-family: Arial, Helvetica, sans-serif;">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. </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPsAnB3vGLOxaAn7TlHfXIC2k9QtThYkFKL55KRljATyZHxtJCjePIDg5y_4ww0hGH23_Jli_NDiod5blEgV1MTFCIljg_xwVfpPqRLwE3EmS4ODtECTVb4Or8TkdB1rQPcXH05qc5Gy6w/s1600/IMG_6469%25281%2529.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPsAnB3vGLOxaAn7TlHfXIC2k9QtThYkFKL55KRljATyZHxtJCjePIDg5y_4ww0hGH23_Jli_NDiod5blEgV1MTFCIljg_xwVfpPqRLwE3EmS4ODtECTVb4Or8TkdB1rQPcXH05qc5Gy6w/s320/IMG_6469%25281%2529.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyGBZWm9R1xuT_-0byJHAblOn1lq8ZEZRu7yxAVceDawdfCukbtCTzzL7jXcEVcZyk9EtI6FfqJnLRyvPwkJFSkfJJu6hf7tPX1NWQCRli45A-mFTlNaN7q2DNslhuIsSLQMAG88-K06nI/s1600/IMG_6465.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyGBZWm9R1xuT_-0byJHAblOn1lq8ZEZRu7yxAVceDawdfCukbtCTzzL7jXcEVcZyk9EtI6FfqJnLRyvPwkJFSkfJJu6hf7tPX1NWQCRli45A-mFTlNaN7q2DNslhuIsSLQMAG88-K06nI/s320/IMG_6465.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgf07OAAktrs-sSVrPnfVw8NyZNg72zaLPJGkVBqE2WYDa1-Al6NZioUlfKe7FjDhtPbvsl5tzsXygGlWvVb3RWp9q6trFIAOCblNACBB_kP91KCgTZTY9LO3ONxur3m9xle9p2UiY9Ms3p/s1600/IMG_6437.HEIC" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1600" data-original-width="1200" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgf07OAAktrs-sSVrPnfVw8NyZNg72zaLPJGkVBqE2WYDa1-Al6NZioUlfKe7FjDhtPbvsl5tzsXygGlWvVb3RWp9q6trFIAOCblNACBB_kP91KCgTZTY9LO3ONxur3m9xle9p2UiY9Ms3p/s320/IMG_6437.HEIC" width="240" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;">Mi participación en el Speaker Idol</span></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHzdX047_-5gZCA2SUy0Sao_d5nln2Ah9c35NoQPVRGNwEMFwjgf-IDkyo30MQlbvoIR5hFV6Dt1gs_4JfqKOlGJxTvg8YsUt29XCd5tHUu_CerRqMu6ucXFr0hzvMZDww392Yh8ep2WwI/s1600/IMG_6588.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="960" data-original-width="1280" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHzdX047_-5gZCA2SUy0Sao_d5nln2Ah9c35NoQPVRGNwEMFwjgf-IDkyo30MQlbvoIR5hFV6Dt1gs_4JfqKOlGJxTvg8YsUt29XCd5tHUu_CerRqMu6ucXFr0hzvMZDww392Yh8ep2WwI/s320/IMG_6588.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_Jwshj1JVsUufdIEy_jqorcLgKElIq6_MxJjN_s2awpq47ULx8FuiqXlFhLbFWUH00GZ_AOk0ILZYgsgG-EMlzqPRRiQeAj7pK58aA8QKlQKZFBTFK3hLOzhoeZ0esXy97rRTPJTUyykz/s1600/IMG_6586.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="960" data-original-width="1280" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_Jwshj1JVsUufdIEy_jqorcLgKElIq6_MxJjN_s2awpq47ULx8FuiqXlFhLbFWUH00GZ_AOk0ILZYgsgG-EMlzqPRRiQeAj7pK58aA8QKlQKZFBTFK3hLOzhoeZ0esXy97rRTPJTUyykz/s320/IMG_6586.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJVJBnCnca95KwbadyQD_brUZjIl6BpSmSENMd5P_McdPBLDHncPxmX3_MNWQaQ_MgtVa6p3cHlQE5AZZI5A8XCIzIGjdK_F68bBiQQ6XG_Glv13_557albgMkjJVdD756aFAvW0_1P6Fj/s1600/IMG_2636.HEIC" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJVJBnCnca95KwbadyQD_brUZjIl6BpSmSENMd5P_McdPBLDHncPxmX3_MNWQaQ_MgtVa6p3cHlQE5AZZI5A8XCIzIGjdK_F68bBiQQ6XG_Glv13_557albgMkjJVdD756aFAvW0_1P6Fj/s320/IMG_2636.HEIC" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNvAc0D66Yhyphenhyphend3WAB2M1y9kI-oa6gJfpvi63P-PrVuiIzZ4JotThzLWULHCJtL0g5eLigqKBOwLl70F7nbFUmPtBsyNmMNBF_9ab6uvTfC8QznfsW3Lj_LzMiuMbE4je1uE2AGS5Gc6vpk/s1600/IMG_0002.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="720" data-original-width="960" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNvAc0D66Yhyphenhyphend3WAB2M1y9kI-oa6gJfpvi63P-PrVuiIzZ4JotThzLWULHCJtL0g5eLigqKBOwLl70F7nbFUmPtBsyNmMNBF_9ab6uvTfC8QznfsW3Lj_LzMiuMbE4je1uE2AGS5Gc6vpk/s320/IMG_0002.JPG" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.dcac.co/syndication/your-pass-summit-2017-speaker-idol-contestants-are">https://www.dcac.co/syndication/your-pass-summit-2017-speaker-idol-contestants-are</a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;">Anuncio de PASS Summit 2018</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizGqvi0Yy7bklMQMkX8vFPi20bKaA69C42Kk1Mgpsu75QuBSy2KJec502AISfwWbnzHvcmoy5x2ZGThPfcQ0Gz05lqFDFduOQ3008PQPCr6LXV7tM55RObOXeFmaj-NfgiL10cJexaaVyK/s1600/IMG_6551%25281%2529.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizGqvi0Yy7bklMQMkX8vFPi20bKaA69C42Kk1Mgpsu75QuBSy2KJec502AISfwWbnzHvcmoy5x2ZGThPfcQ0Gz05lqFDFduOQ3008PQPCr6LXV7tM55RObOXeFmaj-NfgiL10cJexaaVyK/s320/IMG_6551%25281%2529.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;">Keynote día 1</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwxpMvDiKccCDI6nTdMF8cgu5GGmpbRYrOA4SoZPgneXEZh-GZB-MrWaFM8HH0w2UC1Jf4gmZmdvcd1rGIKyrgeM99JJ-SqG4_z8wNVvP8aB2ee2LZ2I5jgI-99U1DeVcfhq43GxJiSjdT/s1600/IMG_6498.HEIC" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwxpMvDiKccCDI6nTdMF8cgu5GGmpbRYrOA4SoZPgneXEZh-GZB-MrWaFM8HH0w2UC1Jf4gmZmdvcd1rGIKyrgeM99JJ-SqG4_z8wNVvP8aB2ee2LZ2I5jgI-99U1DeVcfhq43GxJiSjdT/s320/IMG_6498.HEIC" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwdE2-fUv2UlG3Lbjno4_fkRC8ANQd9UhgKV3bexfoNV2h3hvLV9vU_5ni6sJUvf8KFlxRiq4A1wy1TBtiSt8W48cay7JdNFdlyneF5Y2WJV8O9YryIEQPyszOGkab_yPVdchkzuWGAx2L/s1600/IMG_6502%25281%2529.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwdE2-fUv2UlG3Lbjno4_fkRC8ANQd9UhgKV3bexfoNV2h3hvLV9vU_5ni6sJUvf8KFlxRiq4A1wy1TBtiSt8W48cay7JdNFdlyneF5Y2WJV8O9YryIEQPyszOGkab_yPVdchkzuWGAx2L/s320/IMG_6502%25281%2529.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgapVbVFYqSXD-XsanuWjZUbatHWWAWx-r44ye-va0f1NFcNU3502mYASSGjZdmC3VNuNS5KGPz32ZEa7V7ZszkIOaU7rdrd4AHaiFUuHJaKLg-VblZw4Gyyb4LEEUlXjXyomP9K77MjiFs/s1600/IMG_6503.HEIC" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgapVbVFYqSXD-XsanuWjZUbatHWWAWx-r44ye-va0f1NFcNU3502mYASSGjZdmC3VNuNS5KGPz32ZEa7V7ZszkIOaU7rdrd4AHaiFUuHJaKLg-VblZw4Gyyb4LEEUlXjXyomP9K77MjiFs/s320/IMG_6503.HEIC" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEit-Pfre5CoxFzCzug4w-eHUkPe-9OPw05C0X7vF8aBCXaPJREsdA3L0xb60GCcW44j2uhOS1sdWIlOQ0uiiKTr3q692V4vD13OEHYz_1vCc_I1cX24_84Q5TanRIhGtHP1T2q-F0A_JY5c/s1600/IMG_6504.HEIC" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEit-Pfre5CoxFzCzug4w-eHUkPe-9OPw05C0X7vF8aBCXaPJREsdA3L0xb60GCcW44j2uhOS1sdWIlOQ0uiiKTr3q692V4vD13OEHYz_1vCc_I1cX24_84Q5TanRIhGtHP1T2q-F0A_JY5c/s320/IMG_6504.HEIC" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6H47NXjDkS6Yr32J0FqyQ6SiZvMmoeBNhewcYhWIWHAd9YiOBCjI0GVQRzIraQ-3wlMYT4oi9tVAvqPs3zHnNEygh30sy4iIoRMFbFX4uD_zybI5xULdtdd_B3qIjSW85jdJ02SpQHPyF/s1600/IMG_6507%25281%2529.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6H47NXjDkS6Yr32J0FqyQ6SiZvMmoeBNhewcYhWIWHAd9YiOBCjI0GVQRzIraQ-3wlMYT4oi9tVAvqPs3zHnNEygh30sy4iIoRMFbFX4uD_zybI5xULdtdd_B3qIjSW85jdJ02SpQHPyF/s320/IMG_6507%25281%2529.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;">Keynote día</span><span style="font-family: Arial, Helvetica, sans-serif;"> 2</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmhBwoDmXm6ov0vAT9SppQeHQ-oae7QsJwnDRiEhOfpfdGeEbgjHzTPwxKSawDFNhVhh4KYiLJkuo9r68r6XyO5wui8Ni5ugxI4NNaAPe7mxeDPx5dpTH-3zZ_wVRqxvrth1NP8_ncI64r/s1600/IMG_6560.HEIC" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmhBwoDmXm6ov0vAT9SppQeHQ-oae7QsJwnDRiEhOfpfdGeEbgjHzTPwxKSawDFNhVhh4KYiLJkuo9r68r6XyO5wui8Ni5ugxI4NNaAPe7mxeDPx5dpTH-3zZ_wVRqxvrth1NP8_ncI64r/s320/IMG_6560.HEIC" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_v7CUkHom38BdSeE2A4Kjzj8GV8W0VPsmKWhFxwxQrQg8Bv2waNI2LP1mpsCwQSNFFd0BYdTtLFH3hQyrR1BM0wQqbhcfR63sgUJ-IDW3wFy4X8xDKgZnNZSB4XOdBllgWul8DofQlRZJ/s1600/IMG_6559.HEIC" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_v7CUkHom38BdSeE2A4Kjzj8GV8W0VPsmKWhFxwxQrQg8Bv2waNI2LP1mpsCwQSNFFd0BYdTtLFH3hQyrR1BM0wQqbhcfR63sgUJ-IDW3wFy4X8xDKgZnNZSB4XOdBllgWul8DofQlRZJ/s320/IMG_6559.HEIC" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg62cpFFadBuAR3j4heHNRkUStvC1jwvKtGEB6gVjQb0TVS4fhDvZcLaODXATUt6PfhuVBPPgjmGirUqH9LqnM0hJ3fXxYKhY40wamnJhnKuFxTao-LWveOIdH5swh2tWokv_5D9z9xvIlm/s1600/IMG_6553%25281%2529.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg62cpFFadBuAR3j4heHNRkUStvC1jwvKtGEB6gVjQb0TVS4fhDvZcLaODXATUt6PfhuVBPPgjmGirUqH9LqnM0hJ3fXxYKhY40wamnJhnKuFxTao-LWveOIdH5swh2tWokv_5D9z9xvIlm/s320/IMG_6553%25281%2529.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com1tag:blogger.com,1999:blog-862634293081385156.post-68201717012939484962017-10-30T14:49:00.001-03:002017-10-30T14:49:17.985-03:00NetConf AR<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Durante el mes de Julio de 2017 se realizo la primer edición de la conferencia NetConf AR</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><a href="http://www.netconf.com.ar/">http://www.netconf.com.ar</a></span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">En donde estuve presente junto a mi colega y amigo Maximiliano Accotto hablando acerca de SQL Server 2017.</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Aquí el link de la charla y de la entrevista post evento</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/u501dKuL86s/0.jpg" src="https://www.youtube.com/embed/u501dKuL86s?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /><iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/ttVBv96vovg/0.jpg" src="https://www.youtube.com/embed/ttVBv96vovg?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com1tag:blogger.com,1999:blog-862634293081385156.post-53211989420367028342017-08-03T15:25:00.001-03:002017-08-03T15:25:55.770-03:00Video Tutorial - Instalando SQL Server 2017 sobre Ubuntu Linux en Azure<span style="font-family: "arial" , "helvetica" , sans-serif;">En este tutorial vemos como hacer una instalación de SQL Server 2017 sobre Ubuntu Linux en Azure</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">El primer paso es crear la VM de Ubuntu Linux en Azure</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/lIOWc5Vm6hQ/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/lIOWc5Vm6hQ?feature=player_embedded" width="320"></iframe></div>
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">Luego realizamos de instalación de SQL Server 2017 RC1</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/4HmuSEgWmQU/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/4HmuSEgWmQU?feature=player_embedded" width="320"></iframe></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Próximamente presentare como configurar SQL Server 2017 sobre Linux integrando un Active Directory de Windows Server para así poder utilizar Windows Authentication en SQL Server </span>Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com0tag:blogger.com,1999:blog-862634293081385156.post-54583484454986036722017-07-03T10:49:00.002-03:002017-07-03T10:49:44.497-03:00Webinar "SQL Server 2017 Community-driven Enhancements" PASS DBA Virtual Group<div style="background-color: white; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 22px; font-stretch: normal; font-weight: normal; line-height: normal; margin: 0.75em 0px 0px; position: relative;">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: 13.2px;">On July 28th 2017 I have presented the webinar "SQL Server 2017 Community Driven Enhancements" for PASS DBA Virtual Group</span></div>
<div class="post-body entry-content" id="post-body-8498179819387869935" itemprop="articleBody" style="background-color: white; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; line-height: 1.4; position: relative; width: 546px;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="post-body entry-content" id="post-body-8498179819387869935" itemprop="articleBody" style="background-color: white; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; line-height: 1.4; position: relative; width: 546px;">
<span style="font-family: Arial, Helvetica, sans-serif;">These are te topics I have covered</span></div>
<div class="post-body entry-content" id="post-body-8498179819387869935" itemprop="articleBody" style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; line-height: 1.4; position: relative; width: 546px;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="post-body entry-content" id="post-body-8498179819387869935" itemprop="articleBody" style="background-color: white; line-height: 1.4; position: relative; width: 546px;">
<div style="color: #666666; direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: Arial;">•</span><span style="color: #595959; font-family: "Segoe UI";">Introduction</span></div>
<div style="color: #666666; direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: Arial;">•</span><span style="color: #595959; font-family: "Segoe UI";">Smart </span><span style="color: #595959; font-family: "Segoe UI";">Differential</span><span style="color: #595959; font-family: "Segoe UI";"> </span><span style="color: #595959; font-family: "Segoe UI";">Backup</span></div>
<div style="color: #666666; direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: Arial;">•</span><span style="color: #595959; font-family: "Segoe UI";">Smart </span><span style="color: #595959; font-family: "Segoe UI";">Transaction</span><span style="color: #595959; font-family: "Segoe UI";"> Log </span><span style="color: #595959; font-family: "Segoe UI";">Backup</span></div>
<div style="color: #666666; direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: Arial;">•</span><span style="color: #595959; font-family: "Segoe UI";">SELECT INTO …. ON </span><span style="color: #595959; font-family: "Segoe UI";">Filegroup</span></div>
<div style="color: #666666; direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: Arial;">•</span><span style="color: #595959; font-family: "Segoe UI";">Tempdb</span><span style="color: #595959; font-family: "Segoe UI";"> </span><span style="color: #595959; font-family: "Segoe UI";">Setup</span><span style="color: #595959; font-family: "Segoe UI";"> </span><span style="color: #595959; font-family: "Segoe UI";">improvements</span></div>
<div style="color: #666666; direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: Arial;">•</span><span style="color: #595959; font-family: "Segoe UI";">Tempdb</span><span style="color: #595959; font-family: "Segoe UI";"> </span><span style="color: #595959; font-family: "Segoe UI";">monitoring</span><span style="color: #595959; font-family: "Segoe UI";"> and </span><span style="color: #595959; font-family: "Segoe UI";">planning</span></div>
<div style="color: #666666; direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: Arial;">•</span><span style="color: #595959; font-family: "Segoe UI";">Transaction</span><span style="color: #595959; font-family: "Segoe UI";"> log </span><span style="color: #595959; font-family: "Segoe UI";">monitoring</span><span style="color: #595959; font-family: "Segoe UI";"> and </span><span style="color: #595959; font-family: "Segoe UI";">diagnostics</span></div>
<div style="color: #666666; direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: Arial;">•</span><span style="color: #595959; font-family: "Segoe UI";">Improved</span><span style="color: #595959; font-family: "Segoe UI";"> </span><span style="color: #595959; font-family: "Segoe UI";">backup</span><span style="color: #595959; font-family: "Segoe UI";"> performance </span><span style="color: #595959; font-family: "Segoe UI";">for</span><span style="color: #595959; font-family: "Segoe UI";"> </span><span style="color: #595959; font-family: "Segoe UI";">small</span><span style="color: #595959; font-family: "Segoe UI";"> </span><span style="color: #595959; font-family: "Segoe UI";">databases</span><span style="color: #595959; font-family: "Segoe UI";"> </span><span style="color: #595959; font-family: "Segoe UI";">on</span><span style="color: #595959; font-family: "Segoe UI";"> </span><span style="color: #595959; font-family: "Segoe UI";">high-end</span><span style="color: #595959; font-family: "Segoe UI";"> servers</span></div>
<div style="color: #666666; direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: Arial;">•</span><span style="color: #595959; font-family: "Segoe UI";">Processor</span><span style="color: #595959; font-family: "Segoe UI";"> </span><span style="color: #595959; font-family: "Segoe UI";">information</span><span style="color: #595959; font-family: "Segoe UI";"> in </span><span style="color: #595959; font-family: "Segoe UI";"><b>sys.dm_os_sys_info</b></span></div>
<div style="color: #666666; direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: Arial;">•</span><span style="color: #595959; font-family: "Segoe UI";">Capturing</span><span style="color: #595959; font-family: "Segoe UI";"> </span><span style="color: #595959; font-family: "Segoe UI";">Query</span><span style="color: #595959; font-family: "Segoe UI";"> Store </span><span style="color: #595959; font-family: "Segoe UI";">runtime</span><span style="color: #595959; font-family: "Segoe UI";"> </span><span style="color: #595959; font-family: "Segoe UI";">statistics</span><span style="color: #595959; font-family: "Segoe UI";"> in DBCC CLONEDATABASE</span></div>
<div style="color: #666666; direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: Arial;">•</span><span style="color: #595959; font-family: "Segoe UI";">Resumable</span><span style="color: #595959; font-family: "Segoe UI";"> Online </span><span style="color: #595959; font-family: "Segoe UI";">Index</span><span style="color: #595959; font-family: "Segoe UI";"> </span><span style="color: #595959; font-family: "Segoe UI";">Rebuild</span></div>
<div style="color: #666666; direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: Arial; text-indent: -0.38in;">•</span><span style="color: #595959; font-family: "Segoe UI"; text-indent: -0.38in;">Automatic plan correction</span></div>
<div style="color: #666666; direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #595959; font-family: "Segoe UI"; text-indent: -0.38in;"><br /></span></div>
<div style="direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="font-family: "Segoe UI"; text-indent: -0.38in;">Here is a link to the slides and demos</span></div>
<div style="direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="font-family: "Segoe UI"; text-indent: -0.38in;"><br /></span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="font-size: 13.2px; text-indent: -0.38in;"><span style="font-family: Segoe UI;"><a href="http://dba.pass.org/?EventID=8486">http://dba.pass.org/?EventID=8486</a></span></span></div>
<div style="direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="font-family: "Segoe UI"; text-indent: -0.38in;"><br /></span></div>
<div style="direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="font-family: "Segoe UI"; text-indent: -0.38in;">Here is the recording</span></div>
<div style="direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="font-family: "Segoe UI"; text-indent: -0.38in;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/iMaJE7SonD8/0.jpg" src="https://www.youtube.com/embed/iMaJE7SonD8?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div style="direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="font-family: "Segoe UI"; text-indent: -0.38in;"><br /></span></div>
<div style="direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="font-family: "Segoe UI"; text-indent: -0.38in;">Please send me your feedback</span></div>
<div style="direction: ltr; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<br /></div>
</div>
Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com0tag:blogger.com,1999:blog-862634293081385156.post-84981798193878699352017-06-14T16:21:00.002-03:002017-07-28T16:59:32.450-03:00Charla "SQL Server 2017 Mejoras impulsadas por la comunidad" en PASS Global Spanish virtual group<span style="font-family: "arial" , "helvetica" , sans-serif;">El día 14 de Junio de 2017 he dado la charla "SQL Server 2017 Mejoras impulsadas por la comunidad" en <a href="http://globalspanish.pass.org/" target="_blank">PASS Global Spanish virtual group</a> </span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Voy a estar dando la misma charla en Ingles el día 28 de Junio a las 12 (EDT) en <a href="http://dba.pass.org/" target="_blank">PASS DBA Virtual Group </a></span><br />
<br />
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">Estos son algunos de los puntos de los que hemos hablado</span><br />
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: "arial";">•</span><span style="color: #595959; font-family: "segoe ui";">Introduction</span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: "arial"; mso-color-index: 6; mso-special-format: bullet;">•</span><span style="color: #595959; font-family: "segoe ui";">Smart
</span><span style="color: #595959; font-family: "segoe ui";">Differential</span><span style="color: #595959; font-family: "segoe ui";">
</span><span style="color: #595959; font-family: "segoe ui";">Backup</span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: "arial"; mso-color-index: 6; mso-special-format: bullet;">•</span><span style="color: #595959; font-family: "segoe ui";">Smart
</span><span style="color: #595959; font-family: "segoe ui";">Transaction</span><span style="color: #595959; font-family: "segoe ui";">
Log </span><span style="color: #595959; font-family: "segoe ui";">Backup</span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: "arial"; mso-color-index: 6; mso-special-format: bullet;">•</span><span style="color: #595959; font-family: "segoe ui";">SELECT
INTO …. ON </span><span style="color: #595959; font-family: "segoe ui";">Filegroup</span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: "arial"; mso-color-index: 6; mso-special-format: bullet;">•</span><span style="color: #595959; font-family: "segoe ui";">Tempdb</span><span style="color: #595959; font-family: "segoe ui";">
</span><span style="color: #595959; font-family: "segoe ui";">Setup</span><span style="color: #595959; font-family: "segoe ui";">
</span><span style="color: #595959; font-family: "segoe ui";">improvements</span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: "arial"; mso-color-index: 6; mso-special-format: bullet;">•</span><span style="color: #595959; font-family: "segoe ui";">Tempdb</span><span style="color: #595959; font-family: "segoe ui";">
</span><span style="color: #595959; font-family: "segoe ui";">monitoring</span><span style="color: #595959; font-family: "segoe ui";">
and </span><span style="color: #595959; font-family: "segoe ui";">planning</span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: "arial"; mso-color-index: 6; mso-special-format: bullet;">•</span><span style="color: #595959; font-family: "segoe ui";">Transaction</span><span style="color: #595959; font-family: "segoe ui";">
log </span><span style="color: #595959; font-family: "segoe ui";">monitoring</span><span style="color: #595959; font-family: "segoe ui";">
and </span><span style="color: #595959; font-family: "segoe ui";">diagnostics</span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: "arial"; mso-color-index: 6; mso-special-format: bullet;">•</span><span style="color: #595959; font-family: "segoe ui";">Improved</span><span style="color: #595959; font-family: "segoe ui";">
</span><span style="color: #595959; font-family: "segoe ui";">backup</span><span style="color: #595959; font-family: "segoe ui";">
performance </span><span style="color: #595959; font-family: "segoe ui";">for</span><span style="color: #595959; font-family: "segoe ui";"> </span><span style="color: #595959; font-family: "segoe ui";">small</span><span style="color: #595959; font-family: "segoe ui";">
</span><span style="color: #595959; font-family: "segoe ui";">databases</span><span style="color: #595959; font-family: "segoe ui";">
</span><span style="color: #595959; font-family: "segoe ui";">on</span><span style="color: #595959; font-family: "segoe ui";">
</span><span style="color: #595959; font-family: "segoe ui";">high-end</span><span style="color: #595959; font-family: "segoe ui";">
servers</span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: "arial"; mso-color-index: 6; mso-special-format: bullet;">•</span><span style="color: #595959; font-family: "segoe ui";">Processor</span><span style="color: #595959; font-family: "segoe ui";">
</span><span style="color: #595959; font-family: "segoe ui";">information</span><span style="color: #595959; font-family: "segoe ui";">
in </span><span style="color: #595959; font-family: "segoe ui";"><b>sys.dm_os_sys_info</b></span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: "arial"; mso-color-index: 6; mso-special-format: bullet;">•</span><span style="color: #595959; font-family: "segoe ui";">Capturing</span><span style="color: #595959; font-family: "segoe ui";">
</span><span style="color: #595959; font-family: "segoe ui";">Query</span><span style="color: #595959; font-family: "segoe ui";">
Store </span><span style="color: #595959; font-family: "segoe ui";">runtime</span><span style="color: #595959; font-family: "segoe ui";">
</span><span style="color: #595959; font-family: "segoe ui";">statistics</span><span style="color: #595959; font-family: "segoe ui";">
in DBCC CLONEDATABASE</span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: "arial"; mso-color-index: 6; mso-special-format: bullet;">•</span><span style="color: #595959; font-family: "segoe ui";">Resumable</span><span style="color: #595959; font-family: "segoe ui";">
Online </span><span style="color: #595959; font-family: "segoe ui";">Index</span><span style="color: #595959; font-family: "segoe ui";">
</span><span style="color: #595959; font-family: "segoe ui";">Rebuild</span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #499211; font-family: "arial"; text-indent: -0.38in;">•</span><span style="color: #595959; font-family: "segoe ui"; text-indent: -0.38in;">Automatic
plan correction</span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #595959; font-family: "segoe ui";"><br /></span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="font-family: "segoe ui";"><a href="https://www.slideshare.net/JavierVillegas17/sql-server-2017-mejoras-impulsadas-por-la-comunidad" target="_blank">link a Slideshare</a></span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #595959; font-family: "segoe ui";"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.slideshare.net/JavierVillegas17/sql-server-2017-mejoras-impulsadas-por-la-comunidad" target="_blank"><img border="0" data-original-height="733" data-original-width="1303" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnjqSS1bjghXSysE9Mtsm7RgWXViS774a9dahm4eSqADJJhvD2C5omgrkzXUt3t2qDvdLSevKeM_4ZlneyA0aQCzdScU5XG3ISkHg0vaYOB01nwGKdwrwUtGENjwnx9p1FKGWjiHkxThyphenhypheno/s400/1.jpg" width="400" /></a></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #595959; font-family: "segoe ui";"><span id="goog_1761612243"></span><a href="https://www.blogger.com/"></a><span id="goog_1761612244"></span><br /></span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="font-family: "segoe ui";"><a href="https://1drv.ms/u/s!AooNqQercqgfhJwqFniZPUjsVxPNdg" target="_blank">link a los scripts utilizados en la demo</a></span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="color: #595959; font-family: "segoe ui";"><br /></span></div>
<div style="direction: ltr; margin-bottom: 0pt; margin-left: 0.38in; margin-top: 4.8pt; text-indent: -0.38in; unicode-bidi: embed; vertical-align: baseline;">
<span style="font-family: "segoe ui";">Esta es la grabación</span><br />
<span style="font-family: "segoe ui";"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/CIb0ESy53Lc/0.jpg" src="https://www.youtube.com/embed/CIb0ESy53Lc?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<span style="font-family: "segoe ui";"><br /></span>
<span style="font-family: "segoe ui";"><br /></span>
<span style="font-family: "segoe ui";"><br /></span></div>
Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com0tag:blogger.com,1999:blog-862634293081385156.post-27000237152679076642017-05-22T16:13:00.000-03:002017-05-22T16:13:02.795-03:00Bienvenido SQL Server 2017<span style="font-family: Arial, Helvetica, sans-serif;">El Miércoles 19 de Abril durante el evento Data Amp, Microsoft anuncio el nombre definitivo de la próxima versión de SQL Server.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Bienvenido SQL Server 2017</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVH51bA7awAvQCMa-tGa7Td88eKxW6JpJh3qot6rC_TNFfcfdElB8dKx4KfOT9RGEyhq2IBzr6HF2fcen7b1lK0yCwNRw7L2peyLXVoW309dprKTK0HM2CFsyX2vpoW3S6z9g-WO0bFjou/s1600/Image-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="223" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVH51bA7awAvQCMa-tGa7Td88eKxW6JpJh3qot6rC_TNFfcfdElB8dKx4KfOT9RGEyhq2IBzr6HF2fcen7b1lK0yCwNRw7L2peyLXVoW309dprKTK0HM2CFsyX2vpoW3S6z9g-WO0bFjou/s400/Image-1.png" width="400" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">La versión CTP 2.1 esta disponible para descargar</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<a href="https://www.microsoft.com/en-us/sql-server/sql-server-2017"><span style="font-family: Arial, Helvetica, sans-serif;">https://www.microsoft.com/en-us/sql-server/sql-server-2017</span></a><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Una de las características mas importantes de esta versión en que corre tanto en Windows como en varias distribuciones de Linux , así como también en Docker.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Graph Database, Phyton y Adaptative Query Procesing son algunas de las funcionalidades mas importantes.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Los mantengo informados !!</span>Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com0tag:blogger.com,1999:blog-862634293081385156.post-41917503649032002062017-04-25T15:17:00.000-03:002017-04-25T15:17:10.179-03:00Charla "Query Store al rescate" en PASS Global Spanish<h3 class="post-title entry-title" itemprop="name" style="background-color: #fefdfa; color: #d52a33; font-family: Georgia, Utopia, "Palatino Linotype", Palatino, serif; font-size: 22px; font-stretch: normal; font-weight: normal; line-height: normal; margin: 0px; position: relative;">
<span style="color: #333333; font-family: "helvetica neue", arial, helvetica, sans-serif; font-size: 13px; line-height: 18.2px;">Nuevamente muchas gracias </span><span style="background-color: white; color: #333333; font-family: "helvetica neue", arial, helvetica, sans-serif; font-size: 13px; line-height: 50px; white-space: nowrap;"><a href="https://twitter.com/SpanishPASSVC" style="color: #7d181e; text-decoration-line: none;" target="_blank">@SpanishPASSVC</a> por permitirme presentar una vez mas mi charla</span></h3>
<div class="post-body entry-content" id="post-body-7447842954416285453" itemprop="articleBody" style="background-color: #fefdfa; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 14.52px; line-height: 1.4; position: relative; width: 586px;">
<span style="color: #333333; font-family: "helvetica neue", arial, helvetica, sans-serif;"><span style="font-size: 13px; line-height: 50px; white-space: nowrap;">"<b>Query Store al rescate</b>"</span></span><br /><span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">Scripts de las demo - <a href="https://1drv.ms/f/s!AooNqQercqgfhIk2Wj1maQ5ZRQVv6g" target="_blank">descargar</a></span></div>
<div class="post-body entry-content" id="post-body-7447842954416285453" itemprop="articleBody" style="background-color: #fefdfa; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 14.52px; line-height: 1.4; position: relative; width: 586px;">
<br /></div>
<div class="post-body entry-content" id="post-body-7447842954416285453" itemprop="articleBody" style="background-color: #fefdfa; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 14.52px; line-height: 1.4; position: relative; width: 586px;">
<span style="color: #333333; font-family: arial, helvetica, sans-serif; font-size: 13px;">Les dejo los link a los slides. </span></div>
<div class="post-body entry-content" id="post-body-7447842954416285453" itemprop="articleBody" style="background-color: #fefdfa; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 14.52px; line-height: 1.4; position: relative; width: 586px;">
<span style="color: #333333; font-family: arial, helvetica, sans-serif; font-size: 13px;"><br /></span></div>
<div class="post-body entry-content" id="post-body-7447842954416285453" itemprop="articleBody" style="background-color: #fefdfa; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 14.52px; line-height: 1.4; position: relative; width: 586px;">
<span style="color: #333333; font-family: arial, helvetica, sans-serif; font-size: 13px;"><a href="https://www.slideshare.net/JavierVillegas17/query-store-al-rescate-pass-spanish" target="_blank">https://www.slideshare.net/JavierVillegas17/query-store-al-rescate-pass-spanish</a></span></div>
<div class="post-body entry-content" id="post-body-7447842954416285453" itemprop="articleBody" style="background-color: #fefdfa; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 14.52px; line-height: 1.4; position: relative; width: 586px;">
<span style="color: #333333; font-family: arial, helvetica, sans-serif; font-size: 13px;"><br /></span></div>
<div class="post-body entry-content" id="post-body-7447842954416285453" itemprop="articleBody" style="background-color: #fefdfa; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 14.52px; line-height: 1.4; position: relative; width: 586px;">
<span style="color: #333333; font-family: arial, helvetica, sans-serif; font-size: 13px;"><br /></span></div>
<div class="post-body entry-content" id="post-body-7447842954416285453" itemprop="articleBody" style="background-color: #fefdfa; line-height: 1.4; position: relative; width: 586px;">
<span style="background-color: transparent; font-size: 13px;"><span style="color: #333333; font-family: arial, helvetica, sans-serif;">Aquí</span></span><span style="color: #333333; font-family: arial, helvetica, sans-serif;"><span style="font-size: 13px;"> esta la grabación subida a Youtube</span></span></div>
<div class="post-body entry-content" id="post-body-7447842954416285453" itemprop="articleBody" style="background-color: #fefdfa; line-height: 1.4; position: relative; width: 586px;">
<span style="color: #333333; font-family: arial, helvetica, sans-serif;"><span style="font-size: 13px;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/U7zNz0FbnkI/0.jpg" src="https://www.youtube.com/embed/U7zNz0FbnkI?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div class="post-body entry-content" id="post-body-7447842954416285453" itemprop="articleBody" style="background-color: #fefdfa; line-height: 1.4; position: relative; width: 586px;">
<span style="color: #333333; font-family: arial, helvetica, sans-serif;"><span style="font-size: 13px;"><br /></span></span></div>
Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com1tag:blogger.com,1999:blog-862634293081385156.post-20412847225317724602017-04-01T23:53:00.001-03:002017-04-01T23:53:33.240-03:00SQL Saturday Santiago, Chile 2017Hoy tuve la oportunidad de participar como orador de dos charlas en el evento SQL Saturday Santiago, Chile 2017 organizado por el capitulo local de PASS Chile.<br />
<br />
Este fue un event presencial, gratuito en donde participaron mas de 150 personas interesadas en las diferentes propuestas de Data Platform de Microsoft<br />
<br />
Dejo link a la charlas donde podran descargar los slides y los scripts con las demos realizadas<br />
<br />
<h4 style="background-color: white; border: 0px; box-sizing: border-box; color: #565656; font-family: "Source Sans Pro", sans-serif; font-size: 18px; font-stretch: inherit; font-variant-numeric: inherit; font-weight: 500; line-height: 1.1; margin: 10px 0px; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: 700; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Nuevas Caracteristicas de SQL Server 2016 para DBAs</span></h4>
<a href="http://www.sqlsaturday.com/606/Sessions/Details.aspx?sid=59685">http://www.sqlsaturday.com/606/Sessions/Details.aspx?sid=59685</a><br />
<br />
<br />
<h4 style="background-color: white; border: 0px; box-sizing: border-box; color: #565656; font-family: "Source Sans Pro", sans-serif; font-size: 18px; font-stretch: inherit; font-variant-numeric: inherit; font-weight: 500; line-height: 1.1; margin: 10px 0px; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: 700; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">Recomendaciones para Entornos de SQL Server Productivo</span></h4>
<div>
<a href="http://www.sqlsaturday.com/606/Sessions/Details.aspx?sid=61029">http://www.sqlsaturday.com/606/Sessions/Details.aspx?sid=61029</a></div>
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEheGrtlg_CXdGHxbFL21Ienn-Pv7z20uXkpM591vurcOyTF-oDDZSmBaDJ56HxpUfz0cq-mfnpMW4Xu4U35a_PDuUq8Vm1lvcSQDSw6IjUqCRH8TFVdbQIlNhYfaPm-AWwHikez5xZkmw9O/s1600/IMG_2541.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEheGrtlg_CXdGHxbFL21Ienn-Pv7z20uXkpM591vurcOyTF-oDDZSmBaDJ56HxpUfz0cq-mfnpMW4Xu4U35a_PDuUq8Vm1lvcSQDSw6IjUqCRH8TFVdbQIlNhYfaPm-AWwHikez5xZkmw9O/s320/IMG_2541.JPG" width="320" /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCK5Oh2ViC8Lp8hFR3JmgVjOjcGjhKKeGKeWoQ83BujQNS09mmJuq44ExRS6bL9Sf6MSMze8nO9yOOjccTeMBqheuvCFRwpHqzfQk6C7-QG13Xl6DB91vfu9GowmZTYadCexnG01WBNPSY/s1600/IMG_2543.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCK5Oh2ViC8Lp8hFR3JmgVjOjcGjhKKeGKeWoQ83BujQNS09mmJuq44ExRS6bL9Sf6MSMze8nO9yOOjccTeMBqheuvCFRwpHqzfQk6C7-QG13Xl6DB91vfu9GowmZTYadCexnG01WBNPSY/s320/IMG_2543.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmP7Mzm7bdrqDH8WQIeqeUBr6miJKYzqc4Z9vO9O5_3ag0B6FtMD1TYMI9TYR39NB8bHyrAXYu8uzFbZQ-dbpqEl-qekHhegyz40UkEz1DOSObMkXM3JcgFmlVrQOZ7SRb6D76DxorMMc7/s1600/IMG_2547.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmP7Mzm7bdrqDH8WQIeqeUBr6miJKYzqc4Z9vO9O5_3ag0B6FtMD1TYMI9TYR39NB8bHyrAXYu8uzFbZQ-dbpqEl-qekHhegyz40UkEz1DOSObMkXM3JcgFmlVrQOZ7SRb6D76DxorMMc7/s320/IMG_2547.JPG" width="240" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDNHgOdDvOt2FBpcWhtoUouRCV8zZ0fGHYxks7Bj5ln8uraXnSnQkgsMzvM2D1AfPlWwjkcrtfNS66GiPUQLIXYoj2B859rh4q9IqxjC7i7OFww9EmOpB45MqZHKFyoSVVnPj3TEoagEGK/s1600/IMG_2539.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDNHgOdDvOt2FBpcWhtoUouRCV8zZ0fGHYxks7Bj5ln8uraXnSnQkgsMzvM2D1AfPlWwjkcrtfNS66GiPUQLIXYoj2B859rh4q9IqxjC7i7OFww9EmOpB45MqZHKFyoSVVnPj3TEoagEGK/s320/IMG_2539.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrjW0zVQ6vpbtNBtWmEF0pIVmGlF63qrVyVIYqQRMbaXaeaNakNFpIn4Rd_dxFzOE-pLvgqe4aEfjsuAgVmhHC6yiUd_sE8YYJQoyBrRT4eWIEtDG0WEksD3Vud5xvWUjvpKwkKpPv3N_f/s1600/IMG_2552.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrjW0zVQ6vpbtNBtWmEF0pIVmGlF63qrVyVIYqQRMbaXaeaNakNFpIn4Rd_dxFzOE-pLvgqe4aEfjsuAgVmhHC6yiUd_sE8YYJQoyBrRT4eWIEtDG0WEksD3Vud5xvWUjvpKwkKpPv3N_f/s320/IMG_2552.JPG" width="192" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXbuLkJuYMYIH9xP99gP7gn3wYWkwwgrgD7ShvcxT8x-8gNiHqMuzvRKoQbONDiVpo0TFVTGUuSfk9O9AWirZ85F-eX-eYjoa1Vhz5xWcr3Ua6MbTvahBSN6vpUJQSEAw4pQ2H0GO-7Eyw/s1600/IMG_2554.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXbuLkJuYMYIH9xP99gP7gn3wYWkwwgrgD7ShvcxT8x-8gNiHqMuzvRKoQbONDiVpo0TFVTGUuSfk9O9AWirZ85F-eX-eYjoa1Vhz5xWcr3Ua6MbTvahBSN6vpUJQSEAw4pQ2H0GO-7Eyw/s320/IMG_2554.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6yosuqXHsirUTZmw8BegVxJgnIFQ-Bm8DmknjyLPteWARcTIEpEfnObD6Gbn_Agkwd95W8n8A6gnEmK-Oo3vDB0VNEE8MbseOAtbC0qmde1QA0zXNzw4Na1K5bZXniDG7FM9dWpcGdk3i/s1600/IMG_2557.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6yosuqXHsirUTZmw8BegVxJgnIFQ-Bm8DmknjyLPteWARcTIEpEfnObD6Gbn_Agkwd95W8n8A6gnEmK-Oo3vDB0VNEE8MbseOAtbC0qmde1QA0zXNzw4Na1K5bZXniDG7FM9dWpcGdk3i/s320/IMG_2557.JPG" width="192" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguf-4Jjlxldp7AI5kacj8G6tXc0-0H0ZqVgVx50X0fHPf_4Jj4eYxZrMBz2E2ADl1kCJgI7FoJ7_IwgiZHcUywVqNWH0WJ8DbI5wDXPvtZzq3YTtoVQQh7cAmOfKBXUpq0a1wDEgN8_NVu/s1600/IMG_2577.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguf-4Jjlxldp7AI5kacj8G6tXc0-0H0ZqVgVx50X0fHPf_4Jj4eYxZrMBz2E2ADl1kCJgI7FoJ7_IwgiZHcUywVqNWH0WJ8DbI5wDXPvtZzq3YTtoVQQh7cAmOfKBXUpq0a1wDEgN8_NVu/s320/IMG_2577.JPG" width="320" /></a></div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYHV4DP7h_TlY1YMa3SHNIPmni9HrqY3tKUB1H6vJ_ao3_6e97sm2_B6mErp27ZbNWkNKj5lAdw9Nt_2FTz_3EWFtDX_znpTb3gZwd_tyqD_ROzcFu3VMke1Yf11pyZh6DV_eYMdToFKi7/s1600/IMG_2542.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYHV4DP7h_TlY1YMa3SHNIPmni9HrqY3tKUB1H6vJ_ao3_6e97sm2_B6mErp27ZbNWkNKj5lAdw9Nt_2FTz_3EWFtDX_znpTb3gZwd_tyqD_ROzcFu3VMke1Yf11pyZh6DV_eYMdToFKi7/s320/IMG_2542.JPG" width="320" /></a></div>
<br />Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com0tag:blogger.com,1999:blog-862634293081385156.post-68863015634286129982017-03-02T15:22:00.000-03:002017-03-02T15:22:49.985-03:00Podcast SQL Data Partners<span style="font-family: Arial, Helvetica, sans-serif;">Quiero compartir con ustedes el link con la grabación de la entrevista que realizamos con los amigos de <a href="http://sqldatapartners.com/" target="_blank">SQL Data Partners</a>, <span style="background-color: white;">Carlos Chacon y Steve Stedman</span></span><span style="background-color: white; color: #666666; font-family: "Open Sans", Arial, sans-serif; font-size: 18px;"> </span><br />
<br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif;">En este episodio hacemos un recorrido por algunas de las experiencias (no tan buenas) relacionadas con upgrades a </span><span style="font-family: Arial, Helvetica, sans-serif;">SQL Server 2016 </span><span style="font-family: Arial, Helvetica, sans-serif;">así</span><span style="font-family: Arial, Helvetica, sans-serif;"> como por algunas de las New Features. Finalmente respondí las preguntas relacionadas con #SQLFamily </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Espero que les sea útil y les guste!</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Se los recomiendo</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<h1 class="entry-title" style="background: rgb(255, 255, 255); border: 0px; box-sizing: border-box; color: #333333; font-family: "Open Sans", Arial, sans-serif; font-size: 32px; font-weight: 500; line-height: 1em; margin: 0px; outline: 0px; padding: 0px 0px 10px; vertical-align: baseline;">
<a href="http://sqldatapartners.com/2017/01/25/speedbumps/" target="_blank">Episode 85: Speedbumps Upgrading to 2016</a></h1>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://sqldatapartners.com/2017/01/25/speedbumps/" target="_blank"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJ89YN6xnZdVVsOqk3wO2Pbgtr2HRjtRHdpvxqhB8CjD2xRxEvMKOTo-rVQ1YmWybhmTd_X0idzK6q_-DqcEwlKjlxAjL3gXbwOx1UjBzcjAGMcOIxpN67Cf0H3bOSzFu3HN1ADKXoa3-j/s320/YoutubeThumbnail.png" width="320" /></a><span id="goog_1438810826"></span><span id="goog_1438810827"></span><a href="https://www.blogger.com/"></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<br />
<span style="font-family: "Calibri",sans-serif; font-size: 11.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"><a href="http://sqldatapartners.com/2017/01/25/speedbumps/">http://sqldatapartners.com/2017/01/25/speedbumps/</a></span><br />
<br />
<br />
<br />Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com0tag:blogger.com,1999:blog-862634293081385156.post-4203127602617369392017-02-02T10:06:00.001-03:002017-02-02T10:06:25.144-03:00SQL Saturday 606 - Chile<span style="font-family: Arial, Helvetica, sans-serif;">Hola amigos</span><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">El día sábado 1 de Abril de 2017 se estará realizando el evento de la comunidad PASS . <b>SQL Saturday #606 en Santiago de Chile</b> a realizarse en </span><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><b>Duoc Antonio Varas</b> (A</span></span><span style="font-family: Arial, Helvetica, sans-serif;">ntonio Varas 666, Providencia , Santiago, Región Metropolitana)</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Habra speakers de toda Latinoamerica, Expertos de Microsoft, Expertos en SQL Server y Microsoft MVPs.</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">El evento es totalmente gratuito y se verán temas como los siguientes</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<br />
<ul style="background-color: white; border: 0px; box-sizing: border-box; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; list-style: square outside; margin: 0px 0px 10px 18px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Arial, Helvetica, sans-serif;">Administración de SQL Server </span></li>
</ul>
<ul style="background-color: white; border: 0px; box-sizing: border-box; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; list-style: square outside; margin: 0px 0px 10px 18px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Arial, Helvetica, sans-serif;">Bases de datos en Microsoft Azure</span></li>
</ul>
<ul style="background-color: white; border: 0px; box-sizing: border-box; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; list-style: square outside; margin: 0px 0px 10px 18px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Arial, Helvetica, sans-serif;">Data Warehouse en Microsoft Azure</span></li>
</ul>
<ul style="background-color: white; border: 0px; box-sizing: border-box; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; list-style: square outside; margin: 0px 0px 10px 18px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Arial, Helvetica, sans-serif;">Inteligencia de Negocios</span></li>
</ul>
<ul style="background-color: white; border: 0px; box-sizing: border-box; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; list-style: square outside; margin: 0px 0px 10px 18px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Arial, Helvetica, sans-serif;">Integration Services</span></li>
</ul>
<ul style="background-color: white; border: 0px; box-sizing: border-box; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; list-style: square outside; margin: 0px 0px 10px 18px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Arial, Helvetica, sans-serif;">Analysis Services</span></li>
</ul>
<ul style="background-color: white; border: 0px; box-sizing: border-box; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; list-style: square outside; margin: 0px 0px 10px 18px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Arial, Helvetica, sans-serif;">Power BI</span></li>
</ul>
<ul style="background-color: white; border: 0px; box-sizing: border-box; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; list-style: square outside; margin: 0px 0px 10px 18px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Arial, Helvetica, sans-serif;">Azure Machine Learning</span></li>
</ul>
<ul style="background-color: white; border: 0px; box-sizing: border-box; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; list-style: square outside; margin: 0px 0px 10px 18px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Arial, Helvetica, sans-serif;">Azure Data Lake y U-SQL</span></li>
</ul>
<ul style="background-color: white; border: 0px; box-sizing: border-box; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; list-style: square outside; margin: 0px 0px 10px 18px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Arial, Helvetica, sans-serif;">Analytics sobre Spark y HDInsight</span></li>
</ul>
<br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<span style="font-family: Arial, Helvetica, sans-serif;">Ya esta abierta la inscripción en el siguiente link</span><br />
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.sqlsaturday.com/606/eventhome.aspx">http://www.sqlsaturday.com/606/eventhome.aspx</a></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">Yo estaré dando dos charlas relacionadas con SQL Server</span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<ul style="background-color: white; border: 0px; box-sizing: border-box; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; list-style: square outside; margin: 0px 0px 10px 18px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><div style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-variant-numeric: inherit; font-weight: 500; line-height: 1.1; margin: 10px 0px; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: 700; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Arial, Helvetica, sans-serif;">Recomendaciones para Entornos de SQL Server Productivo</span></span></div>
</li>
</ul>
</div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.sqlsaturday.com/606/Sessions/Details.aspx?sid=61029">http://www.sqlsaturday.com/606/Sessions/Details.aspx?sid=61029</a></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<ul style="background-color: white; border: 0px; box-sizing: border-box; font-stretch: inherit; font-variant-numeric: inherit; line-height: inherit; list-style: square outside; margin: 0px 0px 10px 18px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><h4 style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-variant-numeric: inherit; font-weight: 500; line-height: 1.1; margin: 10px 0px; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; box-sizing: border-box; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: 700; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Arial, Helvetica, sans-serif;">Nuevas Caracteristicas de SQL Server 2016 para DBAs</span></span></h4>
</li>
</ul>
</div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.sqlsaturday.com/606/Sessions/Details.aspx?sid=59685">http://www.sqlsaturday.com/606/Sessions/Details.aspx?sid=59685</a></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">Los espero !!</span></div>
<div>
<br /></div>
Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com0tag:blogger.com,1999:blog-862634293081385156.post-47167764300218729192017-01-12T12:32:00.000-03:002017-01-12T12:32:33.988-03:00Microsoft SQL Server fue nombrado "Software del año"<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Según lo publicado por la revista <a href="http://www.wired.com/" target="_blank">WIRED</a>, Microsoft SQL Server fue nombrado "Software del año" dado que su popularidad creció mas rápido que otros motores de base de datos durante el año 2016</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">les dejo el link al articulo completo de WIRED</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<a href="https://www.wired.com/2017/01/microsofts-old-school-database-surprise-software-hit-year/" target="_blank"><span style="font-family: Arial, Helvetica, sans-serif;">https://www.wired.com/2017/01/microsofts-old-school-database-surprise-software-hit-year/</span></a><br />
<a href="https://www.wired.com/2017/01/microsofts-old-school-database-surprise-software-hit-year/" target="_blank"><br /></a>
<a href="https://www.wired.com/2017/01/microsofts-old-school-database-surprise-software-hit-year/" target="_blank"><br /></a>
<div class="separator" style="clear: both; text-align: center;">
<span style="margin-left: 1em; margin-right: 1em;"><a href="https://www.wired.com/2017/01/microsofts-old-school-database-surprise-software-hit-year/" target="_blank"><img alt="https://www.wired.com/2017/01/microsofts-old-school-database-surprise-software-hit-year/" border="0" height="159" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtNkN9qEFuzYxx-Rj07Tcw72vLuxrdzbiZS5C8lXQbTmok8F0IUEmmaWuc_J2MzDTg4kHpR-J0OUTGu_jrJRrtfL_irmorZPIC94_DlUzqCUthxIM2ydV987YucUDVGPh3k1yUFDNbpw3C/s320/GettyImages-497452707-f.jpg" width="320" /></a></span></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com1tag:blogger.com,1999:blog-862634293081385156.post-515615098470234072016-12-11T21:26:00.000-03:002016-12-11T21:26:52.242-03:00Charla "Nuevas Caracteristicas de SQL Server 2016 para DBAs" 24 Horas de PASS en Español<span style="font-family: "arial" , "helvetica" , sans-serif;">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)</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">les dejo el link al video de mi charla llamada "Nuevas Caracteristicas de SQL Server 2016 para DBAs"</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/GfHuV6FGH7I/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/GfHuV6FGH7I?feature=player_embedded" width="320"></iframe></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com0tag:blogger.com,1999:blog-862634293081385156.post-29376611806049344112016-11-30T15:24:00.001-03:002016-11-30T15:26:40.120-03:0024 Horas de PASS en Español - 6 y 7 de Diciembre 2016<div class="" data-block="true" data-editor="83oqe" data-offset-key="1q1hv-0-0" style="background-color: white; color: #1d2129; font-family: Helvetica, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;">
<div class="_1mf _1mj" data-offset-key="1q1hv-0-0" style="direction: ltr; font-family: inherit; position: relative;">
<span data-offset-key="1q1hv-0-0" style="font-family: inherit;">24 Horas de PASS en Español </span><span class="_5u8n" data-offset-key="1q1hv-1-0" spellcheck="false" style="background-color: rgba(88 , 144 , 255 , 0.14902); border-bottom: 1px solid rgba(88 , 144 , 255 , 0.298039); font-family: inherit;"><span data-offset-key="1q1hv-1-0" style="font-family: inherit;"><span data-text="true" style="font-family: inherit;">#24HOP</span></span></span><span data-offset-key="1q1hv-2-0" style="font-family: inherit;"> - Diciembre 6 y 7 </span></div>
<div class="_1mf _1mj" data-offset-key="1q1hv-0-0" style="direction: ltr; font-family: inherit; position: relative;">
<span data-offset-key="1q1hv-2-0" style="font-family: inherit;">Evento gratuito para la comunidad hispana de @sqlserver </span><span class="_5u8n" data-offset-key="1q1hv-3-0" spellcheck="false" style="background-color: rgba(88 , 144 , 255 , 0.14902); border-bottom: 1px solid rgba(88 , 144 , 255 , 0.298039); font-family: inherit;"><span data-offset-key="1q1hv-3-0" style="font-family: inherit;"><span data-text="true" style="font-family: inherit;">#dataplatform</span></span></span><span data-offset-key="1q1hv-4-0" style="font-family: inherit;"> @sqlpass #PowerBI</span></div>
<div class="_1mf _1mj" data-offset-key="1q1hv-0-0" style="direction: ltr; font-family: inherit; position: relative;">
<span data-offset-key="1q1hv-4-0" style="font-family: inherit;"><a href="http://www.sqlpass.org/24hours/2016/spanish/Inicio.aspx">http://www.sqlpass.org/24hours/2016/spanish/Inicio.aspx</a></span></div>
</div>
<div class="" data-block="true" data-editor="83oqe" data-offset-key="fk8hh-0-0" style="background-color: white; color: #1d2129; font-family: Helvetica, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;">
<div class="_1mf _1mj" data-offset-key="fk8hh-0-0" style="direction: ltr; font-family: inherit; position: relative;">
<span data-offset-key="fk8hh-0-0" style="font-family: inherit;"><br data-text="true" /></span></div>
</div>
<div class="" data-block="true" data-editor="83oqe" data-offset-key="2lhlk-0-0" style="background-color: white; color: #1d2129; font-family: Helvetica, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;">
<div class="_1mf _1mj" data-offset-key="2lhlk-0-0" style="direction: ltr; font-family: inherit; position: relative;">
<span data-offset-key="2lhlk-0-0" style="font-family: inherit;">Mi charla es "<b>Nuevas Características de SQL Server 2016 para DBAs</b>" </span></div>
<div class="_1mf _1mj" data-offset-key="2lhlk-0-0" style="direction: ltr; font-family: inherit; position: relative;">
<span data-offset-key="2lhlk-0-0" style="font-family: inherit;"><a href="http://www.sqlpass.org/24hours/2016/spanish/sesiones/Details.aspx?sid=56739">http://www.sqlpass.org/24hours/2016/spanish/sesiones/Details.aspx?sid=56739</a></span></div>
</div>
<div class="" data-block="true" data-editor="83oqe" data-offset-key="86hsj-0-0" style="background-color: white; color: #1d2129; font-family: Helvetica, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;">
<div class="_1mf _1mj" data-offset-key="86hsj-0-0" style="direction: ltr; font-family: inherit; position: relative;">
<span data-offset-key="86hsj-0-0" style="font-family: inherit;"><br data-text="true" /></span></div>
</div>
<div class="" data-block="true" data-editor="83oqe" data-offset-key="289bs-0-0" style="background-color: white; color: #1d2129; font-family: Helvetica, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;">
<div class="_1mf _1mj" data-offset-key="289bs-0-0" style="direction: ltr; font-family: inherit; position: relative;">
<span data-offset-key="289bs-0-0" style="font-family: inherit;">Los espero !!!</span></div>
</div>
Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com2tag:blogger.com,1999:blog-862634293081385156.post-41361244111566554862016-10-28T02:53:00.000-03:002016-10-28T02:53:37.908-03:00PASS Summit 2016 - Dia 2<span style="font-family: Arial, Helvetica, sans-serif;">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)</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvHkDomga5RKv-gyca3b1pNWdToh2W38FomBVqcciZcNEyrhoagjNRw3A-S_qE_YeVzCblrSuDjYnoPzwKbhFi7xkzR-m88Kj7P8kNOccNZ2BILiG2jzkCXgY45vLBchOHnwmN_uNQms1d/s1600/IMG_0329.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvHkDomga5RKv-gyca3b1pNWdToh2W38FomBVqcciZcNEyrhoagjNRw3A-S_qE_YeVzCblrSuDjYnoPzwKbhFi7xkzR-m88Kj7P8kNOccNZ2BILiG2jzkCXgY45vLBchOHnwmN_uNQms1d/s320/IMG_0329.JPG" width="320" /></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Tambien no informaron las fechas del evento para el próximo año ( 31 de Octubre al 3 de Noviembre de 2017)</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6IIvamq4YBOk8CZTovuE-n9OnHUnZXIJCyieQkmHdeGxwaHcni4dfn64olHgdXS6-cK-JPtgvq0rtgqjHiC0_3nXpP9HSF4bHT7LuXWVog1fl4P9_2NqDbh21ZIIpdvMeP5j2gNpFoqWo/s1600/IMG_0331.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6IIvamq4YBOk8CZTovuE-n9OnHUnZXIJCyieQkmHdeGxwaHcni4dfn64olHgdXS6-cK-JPtgvq0rtgqjHiC0_3nXpP9HSF4bHT7LuXWVog1fl4P9_2NqDbh21ZIIpdvMeP5j2gNpFoqWo/s320/IMG_0331.JPG" width="320" /></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Estos fueron los resultados de la encuesta a los miembros de PASS acerca del significado de esta comunidad de profesionales</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEheniOjCImLCIPp-Ud4096JRFSAG1Ohch4zm8MH-r38kv36fzXTNyNd0IfgmPYUhpkScq0PDKPhoWo5hlWMXb7JfXXOjmTmg5nbJRpUBjUv-nYF0w1no5SbdRPw_MqTCWo_I-K4yqRX7jJ2/s1600/IMG_0328.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEheniOjCImLCIPp-Ud4096JRFSAG1Ohch4zm8MH-r38kv36fzXTNyNd0IfgmPYUhpkScq0PDKPhoWo5hlWMXb7JfXXOjmTmg5nbJRpUBjUv-nYF0w1no5SbdRPw_MqTCWo_I-K4yqRX7jJ2/s320/IMG_0328.JPG" width="320" /></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Durante el Keynote del día 2 el Dr. David DeWitt nos habló sobre DW en la nube</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvomXmxhyphenhyphenYAFnM1fNbvgoEfvAk_CYrasEMd1aHETFPvCdDr414LtrS_832OfOyhkgRmripOaf3x-6UYPGD_u-8m7Vcl6ifZF8NVky_HP3Z51mRRH_RsDIXm1rJBOn6wsg_cJvb3r1I85G2/s1600/IMG_0333.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvomXmxhyphenhyphenYAFnM1fNbvgoEfvAk_CYrasEMd1aHETFPvCdDr414LtrS_832OfOyhkgRmripOaf3x-6UYPGD_u-8m7Vcl6ifZF8NVky_HP3Z51mRRH_RsDIXm1rJBOn6wsg_cJvb3r1I85G2/s320/IMG_0333.JPG" width="320" /></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Una de mis sesiones fue relacionada a SQL en Linux. donde confirmaron que estará disponible para mediados del 2017</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh37AmMym3FYrmofcuLhMayBv1uOkPn9yrm3xBIjXPIf8fPEmW76EXgOJd1HGDjAP0s2CdSJVOJF7OKTe-qSNtKst7G3cLEoTIdz7SDr76SahHQYaI73PevBQq6Wex3oaCv2nZSdUtiI2rO/s1600/IMG_0337.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh37AmMym3FYrmofcuLhMayBv1uOkPn9yrm3xBIjXPIf8fPEmW76EXgOJd1HGDjAP0s2CdSJVOJF7OKTe-qSNtKst7G3cLEoTIdz7SDr76SahHQYaI73PevBQq6Wex3oaCv2nZSdUtiI2rO/s320/IMG_0337.JPG" width="320" /></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com0tag:blogger.com,1999:blog-862634293081385156.post-25344728988093853342016-10-27T03:01:00.002-03:002016-10-27T03:01:42.590-03:00PASS Summit 2016 - Dia 1<span style="font-family: Arial, Helvetica, sans-serif;">Desde el 26 hasta el 28 de Octubre de 2016 se esta desarrollando el PASS Summit en Seattle, WA. </span><div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbcdiljkp4Z_gxdzJSk-WkP-uKcDi7TWmIiD6zN0mJurEu1QcBSMyHVo1dLZp2NNF5cQEnxVDa7-HIhWP-CuUXz8JIrC_kkisxpof2CyIcg4JwADBPNBbZq7gJg8xxfw9CD-tju1xUNKKz/s1600/CvoDqgpUEAIsMmZ.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="258" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbcdiljkp4Z_gxdzJSk-WkP-uKcDi7TWmIiD6zN0mJurEu1QcBSMyHVo1dLZp2NNF5cQEnxVDa7-HIhWP-CuUXz8JIrC_kkisxpof2CyIcg4JwADBPNBbZq7gJg8xxfw9CD-tju1xUNKKz/s320/CvoDqgpUEAIsMmZ.jpg" width="320" /></a></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">PASS es la conferencia anual de profesionales de SQL Server y BI. El evento congrega una gran cantidad de miembros de la comunidad PASS.</span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">Este es mi PASS numero 7 y el 1ero como Microsoft MVP Data Platform.</span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">En los siguientes POST voy a transmitirles las novedades mas importantes</span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">Bienvenidos</span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqKcC-aGmpYK1rwTv4VvVdKwrXnm1mqZ4TOlbTEqb2xPFRHvHTDZFwfeSHNTv7dAKPKzgLDQCWa8CLYapuy-kbN0bOiTiqxkqV3pNW8n7ilmpPx0cQtVgM4UFLWEEE30MO3tMoswB6eHPn/s1600/IMG_0238.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqKcC-aGmpYK1rwTv4VvVdKwrXnm1mqZ4TOlbTEqb2xPFRHvHTDZFwfeSHNTv7dAKPKzgLDQCWa8CLYapuy-kbN0bOiTiqxkqV3pNW8n7ilmpPx0cQtVgM4UFLWEEE30MO3tMoswB6eHPn/s400/IMG_0238.JPG" width="300" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOMQ1A3HPwwrKr20ziURmYFJILVpbETPVEURLxtyI31mXB7qnfgZm1uCekbN05hg0TFgpqEraUeTiuKY9hA2FJVdYTi3JtuIqWqd8_S-9e2SWvp2Xq4rVI0g9-PIxD8HORYIlT1uVUIWW_/s1600/IMG_0322.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOMQ1A3HPwwrKr20ziURmYFJILVpbETPVEURLxtyI31mXB7qnfgZm1uCekbN05hg0TFgpqEraUeTiuKY9hA2FJVdYTi3JtuIqWqd8_S-9e2SWvp2Xq4rVI0g9-PIxD8HORYIlT1uVUIWW_/s320/IMG_0322.JPG" width="240" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;">Keynote Dia 1</span></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkBLyax_koPL_XBTG4Ew52nfIn0FH5AUeMyyFLRr0Pvb01VZhgezO-zdYvOABJaXx2fc0foKnymxFp5Oel6jeFMNx7AKWnRUJwELNZqTHbOX56qW45Vnm_XAi0FZ6pvfhxIxbQISZvM87s/s1600/IMG_0276.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkBLyax_koPL_XBTG4Ew52nfIn0FH5AUeMyyFLRr0Pvb01VZhgezO-zdYvOABJaXx2fc0foKnymxFp5Oel6jeFMNx7AKWnRUJwELNZqTHbOX56qW45Vnm_XAi0FZ6pvfhxIxbQISZvM87s/s320/IMG_0276.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6-lx5vUTk4puzYez82CT6pURDJKa-iU6NlavqMFrlw3l9LdL_oHt_xPl2lU4Qi3Pih25ZOtz5_L6C5wESd5zT7nLL5IlW6MWaRAfeeJFIAy9MLYLUix9zfiJwbSrRH8_dz2tIYf-chmt3/s1600/IMG_0273.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6-lx5vUTk4puzYez82CT6pURDJKa-iU6NlavqMFrlw3l9LdL_oHt_xPl2lU4Qi3Pih25ZOtz5_L6C5wESd5zT7nLL5IlW6MWaRAfeeJFIAy9MLYLUix9zfiJwbSrRH8_dz2tIYf-chmt3/s320/IMG_0273.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisW_iu61s5zChdS-RBU3ys-qIjsCkaarf_XBdy5oPfJgKo_EyUYZX48YGaG_6vGehwbFVXrCz22ijlDJcoj7HRjduTrytoJsfdcre1pWtYsubNxKGPf1xfgRcLpRQ2ZMywP_FqRVoBuenZ/s1600/IMG_0277.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisW_iu61s5zChdS-RBU3ys-qIjsCkaarf_XBdy5oPfJgKo_EyUYZX48YGaG_6vGehwbFVXrCz22ijlDJcoj7HRjduTrytoJsfdcre1pWtYsubNxKGPf1xfgRcLpRQ2ZMywP_FqRVoBuenZ/s320/IMG_0277.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSi2mXIhPH95azwawh3C5OR7onVXWD-PuNvxDAAUwi8Vs_yPQFHldH5yp994yG5EGg9v9QP0t2xWdNgrqVpJnZDQAZ_LeF7h6iL2nNcOfYub8EWYTneuy0nBspESHq_7yiw2h2cTnh12zF/s1600/IMG_0272.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSi2mXIhPH95azwawh3C5OR7onVXWD-PuNvxDAAUwi8Vs_yPQFHldH5yp994yG5EGg9v9QP0t2xWdNgrqVpJnZDQAZ_LeF7h6iL2nNcOfYub8EWYTneuy0nBspESHq_7yiw2h2cTnh12zF/s320/IMG_0272.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFKEQfRzgCAk1LGDpOBSAT-mH2wSqitNhDJNjZDpWSwBKjhzFOU9SPxN0eZXOW6hWDoZlZD01kC36qJMx-YgTi12Flzy3uswXJPZUYiGit46M22lThBOd9b8kwmgdwRByjh7E5PPpMGyTk/s1600/IMG_0280.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFKEQfRzgCAk1LGDpOBSAT-mH2wSqitNhDJNjZDpWSwBKjhzFOU9SPxN0eZXOW6hWDoZlZD01kC36qJMx-YgTi12Flzy3uswXJPZUYiGit46M22lThBOd9b8kwmgdwRByjh7E5PPpMGyTk/s320/IMG_0280.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0TyuKL-quTMbTgPxm6OUHuuPYyNWR949wIam2R9kMyCwb2rq5gvp4WIRVNeOgCyTFaZlh72f5qrnTdMIa6brgOat68w8PyrybC9RHMhmjD3dLHSS0ukX6lwFcjBbEMWfayXUiPTkLddvy/s1600/IMG_0287.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0TyuKL-quTMbTgPxm6OUHuuPYyNWR949wIam2R9kMyCwb2rq5gvp4WIRVNeOgCyTFaZlh72f5qrnTdMIa6brgOat68w8PyrybC9RHMhmjD3dLHSS0ukX6lwFcjBbEMWfayXUiPTkLddvy/s320/IMG_0287.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiINI-yYL9zL-Y9ubMViACSYNUECKScsqUEWRr5LflT9KYAxPi2ex8H5oK1PDYIlfTUyGWSA4GNh9iSKTFoXBTvm_nbjICvEj9P6ar1rEEr4g5zxq0jGPxMkEReSK3l9tp0M-Bov56ULq35/s1600/IMG_0285.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiINI-yYL9zL-Y9ubMViACSYNUECKScsqUEWRr5LflT9KYAxPi2ex8H5oK1PDYIlfTUyGWSA4GNh9iSKTFoXBTvm_nbjICvEj9P6ar1rEEr4g5zxq0jGPxMkEReSK3l9tp0M-Bov56ULq35/s320/IMG_0285.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlv-bQhrqcaivj1W_gz78kbBv9Dy8_8kDrMLzx0MWlBLyBeI6wcDGHZpuUCljjRWriiQYPwrDcuusniBwHZTEHzd0yqCvEO4W9_qRje1ZbZHZS-vvqxmIj9iaM8HX2-JQ4c1jJYWjAxXoy/s1600/IMG_0294.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlv-bQhrqcaivj1W_gz78kbBv9Dy8_8kDrMLzx0MWlBLyBeI6wcDGHZpuUCljjRWriiQYPwrDcuusniBwHZTEHzd0yqCvEO4W9_qRje1ZbZHZS-vvqxmIj9iaM8HX2-JQ4c1jJYWjAxXoy/s320/IMG_0294.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiWV9L3LoMgIAYjdGGydN-uP5vUKDIrtUgghrlaH1U0vrRtIKSBgfoQljAN8rmvUw7HSJKf9nQ8RzY5bza2zxVaAFT_ooTIEHSGw3papZgjQLxGnTH-m5wHY6iKXtHa87CqUOeaeNv413J/s1600/IMG_0297.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiWV9L3LoMgIAYjdGGydN-uP5vUKDIrtUgghrlaH1U0vrRtIKSBgfoQljAN8rmvUw7HSJKf9nQ8RzY5bza2zxVaAFT_ooTIEHSGw3papZgjQLxGnTH-m5wHY6iKXtHa87CqUOeaeNv413J/s320/IMG_0297.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhe-Y21JtzreJ_xLfZW_pYnR_l2FPe8lq8DIQ7VNFH2pcswX-zbHjUGxkMX6Fle5V4i1w8WCjyFGTobl0u9xNX7KRaHeWnzSbQdstfLo-mewkSULNVtnLCCsn6RTA60sPsx6gvalv1FPk9Y/s1600/IMG_0298.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhe-Y21JtzreJ_xLfZW_pYnR_l2FPe8lq8DIQ7VNFH2pcswX-zbHjUGxkMX6Fle5V4i1w8WCjyFGTobl0u9xNX7KRaHeWnzSbQdstfLo-mewkSULNVtnLCCsn6RTA60sPsx6gvalv1FPk9Y/s320/IMG_0298.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxGneOm0WqyTemBOVqdWQ7ph8g2yWODRPrtN-P3KHhq-VvgBqNuyi89RHsRuylPkO66BcQudV87QLFPQDnFPAs_hnuJne5qq_cenhBKgj8_kVopHF9QIm1-Q1vzF-nWuwLS7zpw8UhOT49/s1600/IMG_0310.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxGneOm0WqyTemBOVqdWQ7ph8g2yWODRPrtN-P3KHhq-VvgBqNuyi89RHsRuylPkO66BcQudV87QLFPQDnFPAs_hnuJne5qq_cenhBKgj8_kVopHF9QIm1-Q1vzF-nWuwLS7zpw8UhOT49/s320/IMG_0310.JPG" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">Los 5 anuncios mas importantes </span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://t.co/vwCxMP8xoL" target="_blank">https://t.co/vwCxMP8xoL</a></span></div>
<div>
<br /></div>
<div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">1. Public Preview of Azure Analysis Services</span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">2. SQL Server 2016 DW Fast Track Reference Architecture, 145TB</span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">3. Data Migration Assistant and Database Experimentation Assistant</span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">4. Azure SQL Data Warehouse Expanded Free Trial</span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">5. Cognitive Toolkit (formerly known as CNTK)</span></div>
</div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://t.co/vwCxMP8xoL" target="_blank"><br /></a></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://t.co/vwCxMP8xoL" target="_blank"><br /></a></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com0tag:blogger.com,1999:blog-862634293081385156.post-5312836035559786182016-06-23T15:00:00.001-03:002016-06-23T15:00:43.212-03:00SQL 2016 Features - Poster<br />
<span style="font-family: Arial, Helvetica, sans-serif;">Aquí les dejo el poster con todos los features del nuevo SQL Server 2016</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Es siempre una muy buena fuente de consulta</span><br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8SNjaunACZRqOjohXRVf6q4P7gYGsSVA_YHkobeyCgsWGjNrqxMd7nLmZAs288ewefukAZpqmBdZ_NRWuBegDZH_hj9LBTm5YTNXj52qef_tj5lucnBLQeaPUqfsR-UaryZeQBdGGmi8C/s1600/Microsoft+SQL+Server+2016+Infographic.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="265" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8SNjaunACZRqOjohXRVf6q4P7gYGsSVA_YHkobeyCgsWGjNrqxMd7nLmZAs288ewefukAZpqmBdZ_NRWuBegDZH_hj9LBTm5YTNXj52qef_tj5lucnBLQeaPUqfsR-UaryZeQBdGGmi8C/s400/Microsoft+SQL+Server+2016+Infographic.jpg" width="400" /></a></div>
<br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif;">Download</span><br />
<a href="https://1drv.ms/b/s!AooNqQercqgfg4onaqENsZKPPMEtKw" target="_blank">Microsoft SQL 2016 Infographic</a>Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com1tag:blogger.com,1999:blog-862634293081385156.post-76790407857504145542016-06-06T10:30:00.003-03:002016-06-06T10:31:33.905-03:00Version actualizada de SP_DBA_CurrentlyExec<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Acá les dejo una versión actualizada de SP_DBA_CurrentlyExec</span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<a href="https://onedrive.live.com/redir?resid=1FA872AB07A90D8A!49568&authkey=!ABwpIFtS7ZyHwb8&ithint=folder%2csql"><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: x-small;">https://onedrive.live.com/redir?resid=1FA872AB07A90D8A!49568&authkey=!ABwpIFtS7ZyHwb8&ithint=folder%2csql</span></a><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Estos son algunos ejemplos de uso así como también el Change Log</span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Change Log</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">-- v4.1 . 2013-08-23</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">-- v4.2 . 2014-04-23 - Now is a SP</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">-- v4.3 . 2014-04-25 - Automatically Include Blocking Reports, Open Trans and Server Info</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">-- v4.31. 2014-05-14 - Fix Elap_Time = 23:59:59</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">-- v4.32. 2014-05-27 - Fix OpenTran</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">-- v4.4. 2014-06-10 - Elap_Time includes Days. Default Sort is Elap_Time / Start_Time</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">-- v4.41. 2014-06-22 - Minor Fixes</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">-- v4.42. 2014-07-28 - Fix Transaction log usage on named instances</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">-- v4.43. 2014-08-04 - Add "Rollback" Status</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">-- v4.5 . 2015-10-25 - Add Object schema and databases.state=0 // Filters</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">-- v4.6 . 2016-04-15 - Add MultiServer and Blocks</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">-- v4.7 . 2016-04-19 - Identify Blocking Transactions</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">-- v4.8 . 2016-06-06 - Excel output</span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Examples</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">--[dbo].[SP_DBA_CurrentlyExec]</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">--[dbo].[SP_DBA_CurrentlyExec] @Filter_Name='object_name',@Filter_value ='SP_BL'</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">--[dbo].[SP_DBA_CurrentlyExec] @Filter_Name='Host_name',@Filter_value ='NJUMTS'</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">--[dbo].[SP_DBA_CurrentlyExec] @Filter_Name='Login_Name',@Filter_value ='MyLogin'</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">--[dbo].[SP_DBA_CurrentlyExec] @Filter_Name='SPID',@Filter_value ='371'</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">--[dbo].[SP_DBA_CurrentlyExec] @MultiServer=1</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"></span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">--[dbo].[SP_DBA_CurrentlyExec] @Blocks=1</span><br />
<span style="color: purple; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">--[dbo].[SP_DBA_CurrentlyExec] @excel=1</span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Pronto estará disponible una serie de videos explicativos en YouTube como información adicional</span><br />
<br />Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com5tag:blogger.com,1999:blog-862634293081385156.post-74276752581222120922016-05-31T11:59:00.000-03:002016-05-31T11:59:06.086-03:00Bug critico en SQL 2014 SP1 CU6 - No funciona el hint NOLOCK<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Microsoft ha anunciado a travez de su <a href="https://blogs.msdn.microsoft.com/sqlreleaseservices/" target="_blank">Microsoft Release Serives Blog</a> que si su servidor SQL tiene instalado la primer versión de SQL 2014 SP1 CU6 (12.0.4449.0) y</span><span style="font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif;"> se ejecuta un SELECT utilizando el hint NOLOCK y la query se ejecuta en paralelo puede bloquear otras queries.</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Esto en un bug muy critico para las personas que utilizan NOLOCK (como por ejemplo yo..)</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Microsoft ha retirado el SQL 2014 SP1 CU6 original que había publicado inicialmente y hoy 31/5/2016 lo ha re-publicado con ente problema ya solucionado.</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Como darnos cuenta si tenemos el CU6 que no funciona bien?</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif;">select @@version</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Si la versión instalada es la <span style="background-color: #f2f2f2; font-size: 15px; line-height: 20px;">12.0.4449.0</span> significa que hemos instalado la versión con el bug. Microsoft recomienda desinstalarla e instalar la nueva <span style="background-color: #f2f2f2; font-size: 15px; line-height: 20px;">12.0.4457.0</span> lo antes posible</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Mas info</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><a href="https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-6-for-sql-server-2014-sp1/">https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-6-for-sql-server-2014-sp1/</a></span><br />
<br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif;">Nueva versión</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://support.microsoft.com/en-us/kb/3167392">https://support.microsoft.com/en-us/kb/3167392</a></span>Javier Villegashttp://www.blogger.com/profile/05304689260580191971noreply@blogger.com0