martes, 31 de mayo de 2011

Webcast TechNet: Descubriendo Microsoft Atlanta - SQL supervisión de la configuración de Cloud

En esta sesión se estaré presentando Cloud Service Microsoft Codename Atlanta, discutiremos cómo este servicio le permitirá monitorear SQL Server desde la nube. Después de asistir a este Webcast, conocerá la posición de Atlanta, entenderá las capacidades clave que tiene.

 

Registro en https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032475873&Culture=es-AR

 

 

Saludos,

 

Ing. Eduardo Castro Martinez

http://tiny.cc/comwindows

http://comunidadwindows.org

lunes, 30 de mayo de 2011

Webcast MSDN: Mejores Prácticas en implementación PROS con SQL Server

Los invito al Webcast sobre Mejores Prácticas en implementación PROS con SQL Server que estaré impartiendo el 30 de Mayo a las 2pm –6GMT. Pueden registrarse en la siguiente dirección https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032477023&Culture=es-AR

 

Id. de evento: 1032477023

Moderador(es): Eduardo Castro

Idiomas: Español.

Productos: Microsoft SQL Server, Microsoft SQL Server 2008 R2.

Público: Generalista de IT.

Únase a nosotros en este Webcast en donde compartiremos las mejores prácticas para implementar PROS Pricing Suite application de software de Microsoft SQL Server la gestión de los datos de 2008. Hablaremos en detalle sobre el rendimiento, alta disponibilidad y escalabilidad de Pricing Suite application en Windows Server 2008 R2 del sistema operativo y SQL Server 2008, utilizando las implementaciones de los clientes como ejemplos prácticos.

 

Saludos,

 

Ing Eduardo Castro Martinez

Microsoft SQL Server MVP

http://tiny.cc/comwindows

martes, 24 de mayo de 2011

Sesiones sobre SQL Server en TechEd 2011

Les comparto la lista de Sesiones de SQL Server creada por SQLDenis, las sesiones están grabadas y su puede ver por demanda.

Microsoft SQL Server Code-Named "Denali" AlwaysOn Series,Part 1: Introducing the Next Generation High Availability Solution
Santosh Balasubramanian Database & Business Intelligence 300 - Advanced DBI302 Day 1 May 16, 2011 from 1:15PM to 2:30PM
In this session we talk about the new high availability solution that is being introduced in SQL Server code-named "Denali". The session provides an overview of AlwaysOn and introduces the key new features and capabilities that will help businesses achieve the high availability SLA for mission…

Building Scalable Database Solutions Using Microsoft SQL Azure Database Federations
Cihan Biyikoglu Database & Business Intelligence 400 - Expert DBI403 Day 1 May 16, 2011 from 3:00PM to 4:15PM

SQL Azure provides an information platform that you can easily provision,configure and use to power your cloud applications. In this session we explore the patterns and practices that help you develop and deploy applications that can exploit the full power of the elastic,highly available,and…

Using Knowledge to Cleanse Data with Data Quality Services
Elad Ziklik Database & Business Intelligence 200 - Intermediate DBI207 Day 1 May 16, 2011 from 3:00PM to 4:15PM

SQL Server Data Quality Services (DQS) is a Knowledge-Driven Data Quality product aimed at the data stewards and IT professionals who seek to improve the quality of their business data. In this session,we describe the concept and main principles behind Data Quality Services from Microsoft,and demo…

Top 10 Reasons to Upgrade to Microsoft SQL Server 2008/R2 Reporting Services
Teo Lachev Database & Business Intelligence 200 - Intermediate DBI205 Day 1 May 16, 2011 from 3:00PM to 4:15PM

Rich in demos,this session presents top reasons to upgrade to Microsoft SQL Server 2008 and SQL Server 2008 R2 versions of Reporting Services. Use this information to convince your boss that it's time to upgrade and remove past limitations. If you already use these versions,you might discover…

The T-SQL Cookbook: What's Cool in Microsoft SQL Server 2008 R2 and New in SQL Server Code-Named "Denali"
Tobias Ternstrom Database & Business Intelligence 300 - Advanced DBI318 Day 1 May 16, 2011 from 3:00PM to 4:15PM

In this session we walk through the new T-SQL-related features that are being delivered in the next version of SQL Server. We show off some cool demos as well as describe the use-cases that these language extensions enable.

Microsoft SQL Server Beyond Relational Landscape: Current and Future
Michael Rys Database & Business Intelligence 300 - Advanced DBI316 Day 1 May 16, 2011 from 4:45PM to 6:00PM

Many database applications today need to manage not only tabular relational data,but documents,images,objects such as spatial objects etc. In fact,80% or more of the data produced and stored are so-called unstructured documents and are often not stored in the database,but often need to be managed in…

Getting Started with Cloud Business Intelligence
Pej Javaheri, Tharun Tharian Database & Business Intelligence 200 - Intermediate DBI210 Day 1 May 16, 2011 from 4:45PM to 6:00PM

The cloud has many possibilities and advantages for your Business Intelligence deployments,enhancing and even simplifying your on-premises environments. In this demo-packed session,we go over the capabilities available to you in Windows Azure to help you deploy,execute and enhance your Business…

Creating Self-Service Analytic BI Applications with Microsoft SharePoint 2010
Peter Myers Database & Business Intelligence, Office & SharePoint 200 - Intermediate OSP205 Day 1 May 16, 2011 from 4:45PM to 6:00PM

SharePoint 2010 is the premier BI portal solution. In this session learn how business users can be empowered to create self-service analytic applications by harnessing the power of SharePoint. Topics cover an introduction to the Chart and Status List Web Parts and the three SharePoint service…

Automating Database Migration to Microsoft SQL Server
Welly Lee Database & Business Intelligence 300 - Advanced DBI307 Day 1 May 16, 2011 from 4:45PM to 6:00PM

Does your organization have Oracle,Sybase,MySQL or Access databases that you like to migrate to SQL Server or SQL Azure? Do you know that Microsoft offers a free tool to automate database migration? In this demo-heavy session,we examine how SQL Server Migration Assistant (SSMA) migrates other…

Can Your BI Solution Scale?
Teo Lachev Database & Business Intelligence 300 - Advanced DBI330 Day 1 May 16, 2011 from 4:45PM to 6:00PM

Your Business Intelligence solution is ready for prime-time but will it perform well? Join this session to learn techniques for testing the performance and scalability of Microsoft SQL Server Reporting Services (SSRS) and Microsoft SQL Server Analysis Services (SSAS).

A Lap around Microsoft Business Intelligence
Pej Javaheri, Herain Oberoi Database & Business Intelligence 200 - Intermediate DBI209 Day 1 May 16, 2011 from 1:15PM to 2:30PM

Familiar with the database functionality of Microsoft SQL Server or the collaboration functionality of Microsoft SharePoint,but have not had the chance to explore the broad and integrated Business Intelligence capabilities offered by across these products and Microsoft Excel? This session provides…

Managing Master Data with MDS and Microsoft Excel
John McAllister Database & Business Intelligence 200 - Intermediate DBI204 Day 2 May 17, 2011 from 8:30AM to 9:45AM

Master Data Services (MDS) was released in Microsoft SQL Server 2008 R2 and enables organizations to do a better job of managing key data assets. In the next release of SQL Server,it will be even easier to manage data by using Excel as the user interface. In this session we cover the basics of MDS…

What's New in Microsoft SQL Server Code-Named "Denali" for SQL Server Analysis Services and PowerPivot
T.K. Anand, Ashvini Sharma Database & Business Intelligence 200 - Intermediate DBI206 Day 2 May 17, 2011 from 10:15AM to 11:30AM

In Microsoft SQL Server 2008 R2,we introduced PowerPivot which is a self-service Business Intelligence experience that enables information workers to build,share and collaborate on their personal and team BI applications within the familiar environment of Excel and SharePoint. In SQL Server…

Abundantly "Crescent": Demos Galore
Sean Boon, Carolyn Chau, Sabrena McBride Database & Business Intelligence 200 - Intermediate DBI208 Day 2 May 17, 2011 from 3:15PM to 4:30PM

What is Microsoft project code-named "Crescent" really capable of? How can it address the needs of your business? This session covers a variety of demonstrations against REAL DATA,across various industry verticals,to enable you to see what's possible when deploying this new technology. If you like…

What’s New in Microsoft SQL Server Code-Named “Denali” for Reporting Services
Carolyn Chau Database & Business Intelligence 200 - Intermediate DBI211 Day 2 May 17, 2011 from 1:30PM to 2:45PM

Microsoft SQL Server code-named “Denali” introduces many new features and enhancements for both IT professionals and business users. This session provides an end-to-end introduction and demonstrations of all the new capabilities specific to Reporting Services including SharePoint…

Microsoft StreamInsight: Introduction to Complex Event Processing with SQL Server 2008 R2 StreamInsight
Torsten Grabs Database & Business Intelligence 300 - Advanced DBI303 Day 2 May 17, 2011 from 5:00PM to 6:15PM

Microsoft SQL Server 2008 R2 introduces StreamInsight,a comprehensive platform for building event-driven applications. While typical relational database applications are query-driven,event-driven applications are characterized by continuously arriving new data,continuous processing of the incoming…

What's New in Manageability for Microsoft SQL Server Code-Named "Denali"
Denny Cherry Database & Business Intelligence 300 - Advanced DBI304 Day 2 May 17, 2011 from 1:30PM to 2:45PM

Microsoft SQL Server "Denali" has many new features and enhancements. With a focus on manageability,this session tours new features including Contained Databases,Distributed Replay Utility,User Defined Roles,SQL Management Studio enhancements,and PowerShell. The session is demo-intensive and…

High Availability and Disaster Recovery Customer Panel: Architectures and Lessons Learned
Thomas Grohser, Prem Mehra, Sanjay Mishra, Ayad Shammout, David Smith, Michael Steineke Database & Business Intelligence 300 - Advanced DBI309 Day 2 May 17, 2011 from 3:15PM to 4:30PM

This session covers real-life customer deployment scenarios to achieve high availability (99.99+) and disaster recovery (regional and distant),lessons learned,and associated best practices. The content is not merely coverage of available functions and features of Microsoft SQL Server,but based on…

Columnstore Indexes Unveiled
Eric Hanson Database & Business Intelligence 300 - Advanced DBI312 Day 2 May 17, 2011 from 8:30AM to 9:45AM

This talk describes a new data warehouse SQL query acceleration feature in Microsoft SQL Server code-named "Denali" based on a new type of index called the columnstore. This new index,combined with enhanced query processing features,improves data warehouse query performance by hundreds to thousands…

Microsoft SQL Azure Advanced Administration: Backup,Restore and Database Management Strategies for Cloud Databases
David Robinson Database & Business Intelligence 300 - Advanced DBI313 Day 2 May 17, 2011 from 5:00PM to 6:15PM

The cornerstone of any enterprise application is the ability to backup and restore data. In this session we focus on the various options available to application developers and administrators of SQL Azure applications for archiving and recovering database data. We look at the various scenarios in…

Using Cloud (Microsoft SQL Azure) and PowerPivot to Deliver Data and Self-Service BI at Microsoft
Harinarayan Paramasivan, Diana Putnam, Sanjay Soni Database & Business Intelligence 300 - Advanced DBI323 Day 2 May 17, 2011 from 1:30PM to 2:45PM

See a live demo of how Microsoft IT is distributing terabytes of data from the Enterprise Data Warehouse to various business and IT groups at Microsoft using SQL Azure cloud and on-premise platform. Learn about Data Services Layer (DSL) which is a distribution platform that provides a single…

Killer Real-World PowerPivot Examples
Grant Paisley, Daniel Yu Database & Business Intelligence 300 - Advanced DBI329 Day 2 May 17, 2011 from 5:00PM to 6:15PM

This session is jam packed with amazing PowerPivot report examples. This is *the* session to attend if you want to get the most out of PowerPivot visualizations. Essentially we look at multiple PowerPivot reports from different clients (Education,Retail,Banking,Airline) and show a variety of…

All Up Data Warehouse: From SMP to Parallel Data Warehouse
Dandy Weyn Database & Business Intelligence 300 - Advanced DBI332 Day 2 May 17, 2011 from 10:15AM to 11:30AM

Microsoft Data Warehousing brings you a solid offering that provides the right data warehousing solution for customer needs and workloads. In this session,learn about Reference Architectures using Fast Track Data Warehouse 3.0 and appliance-based implementations including Microsoft SQL Server…

Advanced Business Intelligence Solutions Using Microsoft Excel + Excel Services
Kevin Fan, Manpratap Suri Database & Business Intelligence 300 - Advanced DBI335 Day 2 May 17, 2011 from 10:15AM to 11:30AM

Learn how you can utilize the power of Excel and Excel Services BI features to easily create a compelling BI solution using the tools you already know.

Performance Tuning and Optimization in Microsoft SQL Server 2008 R2 and SQL Server Code-Named "Denali"
Adam Machanic, Mike Wachal Database & Business Intelligence 400 - Expert DBI402 Day 2 May 17, 2011 from 3:15PM to 4:30PM

Understanding when to search for performance problems and how to tune your queries to correct them is one of the most persistent questions that face DBAs. Join Adam and Mike to explore a methodology for discovering and improving performance problems. Along the way you'll see examples that take…

Best Practices for Building Tier 1 Enterprise Business Intelligence Solutions with Microsoft SQL Server Analysis Services
Adam Jorgensen Database & Business Intelligence 400 - Expert DBI407 Day 2 May 17, 2011 from 8:30AM to 9:45AM

The purpose of this session is to highlight issues,best practices and lessons learned from a select group of SQL Server Enterprise customers. Some example of the customer projects we cover in this session: AdCenter and their 6TB SSAS environment: two 3TB OLAP cubes,XBox Live and their planned…

BI Power Hour
Pej Javaheri, Carolyn Chau, Manpratap Suri, Allan Folting, Matt Masson, Julie Strauss Database & Business Intelligence 200 - Intermediate DBI201 Day 3 May 18, 2011 from 5:00PM to 6:15PM

The legacy continues. The Microsoft Business Intelligence team is excited to once again present the BI PowerHour. In this entertaining session,we dazzle you with new demonstrations that expose the lighter side of Business Intelligence exposing the flexibility and power of the Microsoft BI Platform.…

Introducing the Next Generation Design Tools for Microsoft SQL Server Analysis Services
Julie Strauss Database & Business Intelligence 200 - Intermediate DBI203 Day 3 May 18, 2011 from 10:15AM to 11:30AM

Microsoft SQL Server code-named “Denali” brings the simplicity and power of the PowerPivot technologies to corporate BI,and at the same time drives forward the PowerPivot self-service capabilities that we introduced in SQL Server 2008 R2. We give you a tour of building corporate BI Semantic Models…

Microsoft SQL Server Reference Architecture and Appliances
D. Britton Johnston, Bernardo Zamora Database & Business Intelligence 300 - Advanced DBI301 Day 3 May 18, 2011 from 5:00PM to 6:15PM

Learn what are the current and future SQL Server Appliances and References Architectures that allow customers to deploy OLTP,DW,BI and Database consolidation solutions in a very short time,with all the components configured and optimized. These appliances include all the Hardware,Software and…

Fast Track Data Warehouse Version 3.0 New Features and Best Practices
Michael Bassett, Anjan Das, Jim Hautala Database & Business Intelligence 300 - Advanced DBI308 Day 3 May 18, 2011 from 1:30PM to 2:45PM

This session depicts some of the new features and architecture changes present in version 3.0 of SQL Server Fast Track Data Warehousing. Best practices derived from HP's extensive joint testing with Microsoft during the development of its current Fast Track reference architectures are also detailed.

Microsoft SQL Azure Performance Considerations and Troubleshooting
Henry Zhang Database & Business Intelligence 300 - Advanced DBI314 Day 3 May 18, 2011 from 1:30PM to 2:45PM

Become an expert on SQL Azure by learning how to best utilize the cloud database platform to your advantage. We show you the unique performance considerations to keep in mind when architecting your SQL Azure application. Learn the inside tips and tricks to quickly identify performance…

Microsoft SQL Server in Virtualization and Private Cloud
Guy Bowerman, Darmadi Komo Database & Business Intelligence 300 - Advanced DBI315 Day 3 May 18, 2011 from 10:15AM to 11:30AM

Come and learn how SQL Server fits into your company's strategy on virtualization and private cloud. We talk talk about SQL Server feautures that are relevant in virtualization and private cloud deployment,why Hyper-V is better for SQL Server virtualization,the upcoming HP Database Consolidation…

What’s New in Microsoft SQL Server Code-Named “Denali” for SQL Server Integration Services
Matt Masson Database & Business Intelligence 300 - Advanced DBI317 Day 3 May 18, 2011 from 3:15PM to 4:30PM

This session shows off the new features of Microsoft SQL Server Integration Services in SQL Server code-named “Denali”. Using customer scenarios,we demonstrate the migration process and highlight the benefits of the new SSIS server architecture. We cover the many improvements made to increase…

Upsizing and Modernizing with the Microsoft BI Stack and Fast Track Data Warehouse
Kevin Cornett, Ilan Wajsman Database & Business Intelligence 300 - Advanced DBI320 Day 3 May 18, 2011 from 8:30AM to 9:45AM

In 2010,Stein Mart deployed a Microsoft SQL Server Fast Track Data Warehouse and launched an aggressive effort to become an information-based culture leveraging the Microsoft Business Intelligence stack. This session provides a detailed description of the infrastructure as it existed before and…

End-to-End PerformancePoint Services
Peter Myers Database & Business Intelligence 300 - Advanced DBI325 Day 3 May 18, 2011 from 3:15PM to 4:30PM

PerformancePoint Services 2010 (PPS) is the next generation performance management application from Microsoft. It delivers a design environment targeted at power users for creating and deploying sophisticated Key Performance Indicator (KPI),scorecard,report and dashboard definitions. The session…

Integrating Microsoft SQL Server Reporting Services with Microsoft SharePoint Technologies
Prash Shirolkar Database & Business Intelligence 300 - Advanced DBI328 Day 3 May 18, 2011 from 1:30PM to 2:45PM

Deep dive into how and why to integrate SQL Server code-named “Denali” Reporting Services (SSRS) with SharePoint 2010,including an overview of the new claims-aware shared service architecture,IT experience,performance enhancements,and end user functionality.

Microsoft SQL Server Analysis Services Design Challenges
Peter Myers Database & Business Intelligence 300 - Advanced DBI331 Day 3 May 18, 2011 from 8:30AM to 9:45AM

Microsoft SQL Server Analysis Services allows developers to produces cubes which,when designed well,can deliver intuitive,feature-rich and highly-performant data models. In many ways they are a key component to delivering Business Intelligence within the enterprise. To be clear,this session…

Let’s Get Visual: The Art of Report Design
Paul Turley Database & Business Intelligence 300 - Advanced DBI334 Day 3 May 18, 2011 from 3:15PM to 4:30PM

Do your users have the same old,mundane table reports they’ve been using for decades? Stop living in the past and make your reports pop. Learn to use design patterns,best practices and visuals that pack more usable information into fewer,more usable reports. Use Reporting Services and other…

Innovative Storage and Data Management Strategies to Power Your Microsoft Enterprise Applications
Alex Jauch, Robert Quimbey Database & Business Intelligence 300 - Advanced DBI336 Day 3 May 18, 2011 from 1:30PM to 2:45PM

In this session,hear about innovative storage and data management strategies that are being used by leading organizations around the world to build highly efficient,flexible and reliable IT infrastructure to support their business-critical enterprise software including Microsoft Exchange…

Microsoft SQL Server Code-Named "Denali" AlwaysOn Series,Part 2: Building a Mission-Critical High Availability Solution Using AlwaysOn
Justin Erickson Database & Business Intelligence 400 - Expert DBI404 Day 3 May 18, 2011 from 8:30AM to 9:45AM

In this session we walk you through the steps to deploy a high availability solution using AlwaysOn. This is a demo-heavy presentation and the experts from the product development team walk you through a high availability solution architecture and deployment,explain key architectural concepts and…

lunes, 16 de mayo de 2011

Datawarehouse SQL Server Startup Option -E

Cuando se tienen Datawarehouse con SQL Server de gran tamaño la opción de inicio –E puede ser útil para aumentar el desempeño ya que para cargas de trabajo de tipo DW aumenta la cantidad de extends que son asignados a cada archivo de un filegroup, se aplica en los escenarios en los cuales se tiene una cantidad limitada de usuarios cuyas consultas generan scans de datos, NO debe ser activado en ningún otro tipo de aplicación ya que afecta considerablemente el desempeño, además únicamente es soportada en la versión de 64 bits de SQL Server.

Este parámetro es utilizado en el TPC-H Performance Test disponible en http://www.tpc.org/results/FDR/tpch/HP_DL380G6_100GB_090409_2P_2.93GHzQC_FDR.pdf el TPC-H es una prueba estándar para medir el desempeño de sistemas de soporte de decisiones “This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.”

Deben evaluar si este parámetro aplica para sus escenarios de Datawarehouse.

Saludos,

Ing. Eduardo Castro Martinez

Microsoft SQL Server MVP

http://tiny.cc/comwindows

Note: Cross posted from Eduardo Castro SQL ServerMVP.

Permalink

Datawarehouse SQL Server Startup Option -E

Cuando se tienen Datawarehouse con SQL Server de gran tamaño la opción de inicio –E puede ser útil para aumentar el desempeño ya que para cargas de trabajo de tipo DW aumenta la cantidad de extends que son asignados a cada archivo de un filegroup, se aplica en los escenarios en los cuales se tiene una cantidad limitada de usuarios cuyas consultas generan scans de datos, NO debe ser activado en ningún otro tipo de aplicación ya que afecta considerablemente el desempeño, además únicamente es soportada en la versión de 64 bits de SQL Server.

Este parámetro es utilizado en el TPC-H Performance Test disponible en http://www.tpc.org/results/FDR/tpch/HP_DL380G6_100GB_090409_2P_2.93GHzQC_FDR.pdf el TPC-H es una prueba estándar para medir el desempeño de sistemas de soporte de decisiones “This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.”

Deben evaluar si este parámetro aplica para sus escenarios de Datawarehouse.

Saludos,

Ing. Eduardo Castro Martinez

Microsoft SQL Server MVP

http://tiny.cc/comwindows

Note: Cross posted from Eduardo Castro SQL ServerMVP.

Permalink

Datawarehouse SQL Server Startup Option -E

Cuando se tienen Datawarehouse con SQL Server de gran tamaño la opción de inicio –E puede ser útil para aumentar el desempeño ya que para cargas de trabajo de tipo DW aumenta la cantidad de extends que son asignados a cada archivo de un filegroup, se aplica en los escenarios en los cuales se tiene una cantidad limitada de usuarios cuyas consultas generan scans de datos, NO debe ser activado en ningún otro tipo de aplicación ya que afecta considerablemente el desempeño, además únicamente es soportada en la versión de 64 bits de SQL Server.

Este parámetro es utilizado en el TPC-H Performance Test disponible en http://www.tpc.org/results/FDR/tpch/HP_DL380G6_100GB_090409_2P_2.93GHzQC_FDR.pdf el TPC-H es una prueba estándar para medir el desempeño de sistemas de soporte de decisiones “This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.”

Deben evaluar si este parámetro aplica para sus escenarios de Datawarehouse.

Saludos,

Ing. Eduardo Castro Martinez

Microsoft SQL Server MVP

http://tiny.cc/comwindows

Note: Cross posted from Eduardo Castro SQL ServerMVP.

Permalink

Datawarehouse SQL Server Startup Option -E

Cuando se tienen Datawarehouse con SQL Server de gran tamaño la opción de inicio –E puede ser útil para aumentar el desempeño ya que para cargas de trabajo de tipo DW aumenta la cantidad de extends que son asignados a cada archivo de un filegroup, se aplica en los escenarios en los cuales se tiene una cantidad limitada de usuarios cuyas consultas generan scans de datos, NO debe ser activado en ningún otro tipo de aplicación ya que afecta considerablemente el desempeño, además únicamente es soportada en la versión de 64 bits de SQL Server.

Este parámetro es utilizado en el TPC-H Performance Test disponible en http://www.tpc.org/results/FDR/tpch/HP_DL380G6_100GB_090409_2P_2.93GHzQC_FDR.pdf el TPC-H es una prueba estándar para medir el desempeño de sistemas de soporte de decisiones “This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.”

Deben evaluar si este parámetro aplica para sus escenarios de Datawarehouse.

Saludos,

Ing. Eduardo Castro Martinez

Microsoft SQL Server MVP

http://tiny.cc/comwindows

Note: Cross posted from Eduardo Castro SQL ServerMVP.

Permalink

Datawarehouse SQL Server Startup Option -E

Cuando se tienen Datawarehouse con SQL Server de gran tamaño la opción de inicio –E puede ser útil para aumentar el desempeño ya que para cargas de trabajo de tipo DW aumenta la cantidad de extends que son asignados a cada archivo de un filegroup, se aplica en los escenarios en los cuales se tiene una cantidad limitada de usuarios cuyas consultas generan scans de datos, NO debe ser activado en ningún otro tipo de aplicación ya que afecta considerablemente el desempeño, además únicamente es soportada en la versión de 64 bits de SQL Server.

Este parámetro es utilizado en el TPC-H Performance Test disponible en http://www.tpc.org/results/FDR/tpch/HP_DL380G6_100GB_090409_2P_2.93GHzQC_FDR.pdf el TPC-H es una prueba estándar para medir el desempeño de sistemas de soporte de decisiones “This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.”

Deben evaluar si este parámetro aplica para sus escenarios de Datawarehouse.

Saludos,

Ing. Eduardo Castro Martinez

Microsoft SQL Server MVP

http://tiny.cc/comwindows

Note: Cross posted from Eduardo Castro SQL ServerMVP.

Permalink

lunes, 9 de mayo de 2011

Limpiar el LOG en SQL Server sin guardarlo

En versiones anteriores de SQL Server se contaba con el estatuto TRUNCATE_ONLY para limpiar el LOG sin guardarlo, sin embargo esta función fue deprecada en versiones nuevas de SQL Server. Por lo tanto si deseamos “limpiar ” LOG de SQL Server y no nos interesa su contenido podemos ejecutar los siguientes comandos:

 

-- Hacer backup sin guardarlo en archivo

BACKUP LOG [nombreBD] TO DISK='NULL'

- - Reducir el tamaño de los archivos de log


dbcc shrinkfile ('TLOGFILENAME', tamano) – donde tamano es la cantidad de MB que deseamos que quede el archivo

Eduardo Castro Martínez

http://ecastrom.blogspot.com

http://comunidadwindows.org

http://tiny.cc/comwindows

viernes, 6 de mayo de 2011

Sync Framework, SQL Server y SQL Azure

Les comparto la presentación del Webcast MSDN que impartí sobre Sync Framework y SQL Server http://slidesha.re/ieHjpU

 

image

 

Saludos,

Eduardo Castro Martinez

http://comunidadwindows.org

http://ecastrom.blogspot.com

Cluster de SQL Server con el Microsoft iSCSI Software Target

Microsoft ha liberado de forma gratuita el Microsoft iSCSI Software Target , de esta forma ahora ahora se pueden realizar escenarios de clúster de SQL Server sin necesidad de contar con una SAN, el software lo pueden descargar desde esta dirección http://www.microsoft.com/downloads/en/confirmation.aspx?FamilyID=45105d7f-8c6c-4666-a305-c8189062a0d0 este blog post http://blogs.technet.com/b/josebda/archive/2009/01/31/step-by-step-using-the-microsoft-iscsi-software-target-with-hyper-v-standalone-full-vhd.aspx muestra cómo configurar un ambiente con Hyperv.

 

Saludos,

 

Eduardo Castro Martinez

http://comunidadwindows.org

http://ecastrom.blogspot.com