viernes, 28 de mayo de 2010

viernes, 21 de mayo de 2010

Introduction to SQL Server Stream Insight

In this presentation we review the basics about SQL Server Stream Insight.

 

Regards,

 

 

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Note: Cross posted from Eduardo Castro.

Permalink

Webcast MSDN: "¡Petabytes para Peanuts! Tiene Sentido Datos Fuera de "Ambiente""

Este el webcast impartido el 21 mayo sobre SQL Server Stream Insight

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

 

Idiomas:
Español.

Productos:
Windows Azure.

Audiencia(s):
Programador/desarrollador de programas.

Duración:
60 Minutos

Información general del Evento

Hoy en día, la llave para tener éxito con datos ya no es sobre cómo puede pagar para adquirir, almacenar y procesar datos en forma efectiva. Esa es la parte económica y fácil. El reto ahora es desarrollar formas para utilizar mejor datos que su competencia para que pueda tener sentido todos los datos que tiene. Aprenda cómo el procesamiento algorítmico, a una escala modesta y extrema, esta cambiando completamente la forma en cómo creamos sistemas de información. Escuche cómo Microsoft está tratando como este cambio y utiliza estos conceptos emergentes en sus servicios en línea. También vea ejemplos de cómo parte de esta tecnología está comenzando a aparecer en la corriente de productos de Microsoft.

 

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Note: Cross posted from Eduardo Castro.

Permalink

jueves, 20 de mayo de 2010

SQL Server 2008 R2 Training Kit

If you want to start working with the new features in SQL Server 2008 R2, you need to download the SQL Server 2008 R2 Update for Developers Training Kit, is avaiable at http://www.microsoft.com/downloads/details.aspx?familyid=FFFAAD6A-0153-4D41-B289-A3ED1D637C0D&displaylang=en

The training kit offers the following benefits:

  • Learn how to build applications that exploit the unique features and capabilities of SQL Server 2008 and SQL Server 2008 R2.
  • Provides a comprehensive set of videos, presentations, demos and hands-on labs
  • Contains new content for developers who are new to SQL Server.
  • Contains new content for SQL Server 2008 R2.
  • Contains all of the existing content from the SQL Server 2008 Developer Training Kit.
  • Easy to download and install.

 

Contents
The training kit includes the following content:

  • Presentations (22)
    • SQL Server 2008 R2 Update for Developers Overview Part I - SQL Server 2008 Review
    • SQL Server 2008 R2 Update for Developers Overview Part II - Introducing SQL Server 2008 R2
    • SQL Server 2008: Filestream
    • SQL Server 2008: Spatial
    • SQL Server 2008: T-SQL
    • SQL Server 2008: Date and Time Types
    • SQL Server 2008: SQLCLR
    • SQL Server 2008: Reporting Services
    • SQL Server 2008 R2: Introducing Application and Multi-Server Management with SQL Server 2008 R2 and Visual Studio 2010
    • SQL Server 2008 R2: Working with Data Tier Application Projects in Visual Studio 2010
    • SQL Server 2008 R2: Managing Change in Data Tier Application Projects with Visual Studio 2010 and SQL Server 2008 R2
    • SQL Server 2008 R2: Introducing SQL Server 2008 R2 StreamInsight
    • SQL Server 2008 R2: Querying Events in SQL Server 2008 R2 StreamInsight
    • SQL Server 2008 R2: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters
    • SQL Server 2008 R2: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine
    • SQL Server 2008 R2: What's New in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Developing Reports with the New Features of SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Working with Shared Components in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Working with ATOM Data Feeds in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Embedded Reporting in Applications with SQL Server 2008 R2 Reporting Services and Visual Studio 2010
    • SQL Server 2008 R2: Developing with the Microsoft Chart Controls in Visual Studio 2010
  • Demos (29)
    • SQL Server 2008: AdventureWorks Racing All-Up Demo
    • SQL Server 2008: Spatial Demo
    • SQL Server 2008: Spatial Types
    • SQL Server 2008: Introduction to Filestream
    • SQL Server 2008: SQL CLR Nullable Types
    • SQL Server 2008: Programming with Filestream
    • SQL Server 2008: Reporting Services Web Application Integration
    • SQL Server 2008: T-SQL Date and Time Support
    • SQL Server 2008: T-SQL Table-Valued Parameters
    • SQL Server 2008: T-SQL Row Constructors
    • SQL Server 2008: T-SQL Grouping Sets
    • SQL Server 2008: T-SQL Merge
    • SQL Server 2008 R2: Creating a Utility Control Point
    • SQL Server 2008 R2: Enrolling a Managed Instance
    • SQL Server 2008 R2: Creating Data-Tier Applications
    • SQL Server 2008 R2: Data-Tier Application Deployment
    • SQL Server 2008 R2: Managing Change in Data Tier Application Projects in Visual Studio 2010
    • SQL Server 2008 R2: Introducing SQL Server 2008 R2 StreamInsight
    • SQL Server 2008 R2: Querying Events in SQL Server 2008 R2 StreamInsight
    • SQL Server 2008 R2: Advanced SQL Server 2008 R2 StreamInsight Event Queries
    • SQL Server 2008 R2: Working with SQL Server 2008 R2 StreamInsight CTI Events and Advance Time Settings
    • SQL Server 2008 R2: Creating a SQL Server 2008 R2 StreamInsight Input Adpater
    • SQL Server 2008 R2: Choosing a SQL Server 2008 R2 StreamInsight Development Model
    • SQL Server 2008 R2: Using the SQL Server 2008 R2 StreamInsight Event Flow Debugger
    • SQL Server 2008 R2: Using the New Report Design Features in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Using Shared Component Libraries in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Using SQL Server 2008 R2 Reporting Services Report Feeds
    • SQL Server 2008 R2: Using the Visual Studio 2010 Report Viewer Control
  • Hands-on Labs (18)
    • SQL Server 2008: How to build your first Web Application with SQL Server and ASP.NET
    • SQL Server 2008: Using Spatial Data in TSQL
    • SQL Server 2008: Using Spatial Data in Managed Code
    • SQL Server 2008: Using SQL CLR in SQL Server 2008
    • SQL Server 2008 R2: Introduction to PowerPivot
    • SQL Server 2008 R2: Introduction to Reporting Services Improvements
    • SQL Server 2008 R2: Introduction to StreamInsight and Complex Event Processing
    • SQL Server 2008 R2: Introduction to Data-tier Applications
    • SQL Server 2008 R2: Creating and Deploying a Data-Tier Application
    • SQL Server 2008 R2: Managing Change in Data-Tier Application Projects in Visual Studio 2010
    • SQL Server 2008 R2: Querying Events in SQL Server 2008 R2 StreamInsight using LINQ
    • SQL Server 2008 R2: Working with the SQL Server 2008 R2 StreamInsight Samples
    • SQL Server 2008 R2: Working with the SQL Server 2008 R2 StreamInsight Event Flow Debugger
    • SQL Server 2008 R2: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Developing and Consuming Report Libraries in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Working with ATOM Data Feeds in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Embedded Reporting in Applications with SQL Server 2008 R2 Reporting Services and Visual Studio 2010
    • SQL Server 2008 R2: Developing with the Microsoft Chart Controls
  • Videos (35)
    • SQL Server 2008 R2 Update for Developers Overview Part I - SQL Server 2008 Review
    • SQL Server 2008 R2 Update for Developers Overview Part II - Introducing SQL Server 2008 R2
    • Introducing SQL Server 2008 R2 StreamInsight
    • Demo: Real Time Analytics with SQL Server 2008 R2 StreamInsight
    • Introducing SQL Server 2008 R2 Application and Multi-Server Management
    • Introducing SQL Server 2008 R2 Reporting Services
    • Introduction To SQL Server 2008 R2 StreamInsight and Complex Event Processing
    • Introducing PowerPivot for Excel 2010 and SharePoint 2010
    • Presentation: Introducing Application and Multi-Server Management with SQL Server 2008 R2 and Visual Studio 2010
    • Demo: Creating a Utility Control Point
    • Demo: Enrolling a Managed Instance
    • Presentation: Working with Data Tier Application Projects in Visual Studio 2010
    • Demo: Creating Data-Tier Applications
    • Demo: Data-Tier Application Deployment
    • Presentation: Managing Change in Data Tier Application Projects with Visual Studio 2010 and SQL Server 2008 R2 (Part I)
    • Presentation: Managing Change in Data Tier Application Projects with Visual Studio 2010 and SQL Server 2008 R2 (Part II)
    • Demo: Managing Change in Data Tier Application Projects in Visual Studio 2010
    • Presentation: Introducing SQL Server 2008 R2 StreamInsight (Part I)
    • Presentation: Introducing SQL Server 2008 R2 StreamInsight (Part II)
    • Demo: Introducing SQL Server 2008 R2 StreamInsight
    • Presentation: Querying Events in SQL Server 2008 R2 StreamInsight (Part I)
    • Presentation: Querying Events in SQL Server 2008 R2 StreamInsight (Part II)
    • Demo: Querying SQL Server 2008 R2 StreamInsight Using LINQ
    • Presentation: Querying Events in SQL Server 2008 R2 StreamInsight (Part III)
    • Demo: Advanced SQL Server 2008 R2 StreamInsight Event Queries
    • Presentation: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters (Part I)
    • Presentation: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters (Part II)
    • Demo: Working with SQL Server 2008 R2 StreamInsight CTI Events and Advance Time Settings
    • Presentation: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters (Part III)
    • Demo: Creating a SQL Server 2008 R2 StreamInsight Input Adapter
    • Presentation: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine (Part I)
    • Presentation: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine (Part II)
    • Demo: Choosing a SQL Server 2008 R2 StreamInsight Development Model
    • Presentation: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine (Part III)
    • Demo: Using the SQL Server 2008 R2 StreamInsight Event Flow Debugger
    • resentation: What's New in SQL Server 2008 R2 Reporting Services
    • Presentation: Developing Reports with the New Features of SQL Server 2008 R2 Reporting Services
    • Demo: Using the New Report Design Features in SQL Server 2008 R2 Reporting Services
    • Presentation: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
    • Demo: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
    • Presentation: Working with Shared Components in SQL Server 2008 R2 Reporting Services
    • Demo: Using Shared Component Libraries in SQL Server 2008 R2 Reporting Services
    • Presentation: Working with ATOM Data Feeds in SQL Server 2008 R2 Reporting Services
    • Demo: Using SQL Server 2008 R2 Reporting Services Report Feeds
    • Presentation: Embedded Reporting in Applications with SQL Server 2008 R2 Reporting Services and Visual Studio 2010
    • Demo: Using the Visual Studio 2010 Report Viewer Control
    • Presentation: Developing with the Microsoft Chart Controls in Visual Studio 2010

 

Regards,

Ing. Eduardo Castro, SQL Server MVP

Note: Cross posted from Eduardo Castro.

Permalink

miércoles, 12 de mayo de 2010

Access SQL Server with WCF Kerberos and allow double hop impersonation

If you need to access SQL Server from a WCF Service using kerberos (in order to pass credentials and enable impersonation), first you need to configure SQL Server to run with an Domain Account, set the SQL Computer and the user account to be trusted for delegation in the Active Directory, and you must run the setspn commands:

 

setspn –a MSSQLServer/machinename Domain\ServiceUserName

setspn –a MSSQLServer/machinenameFQDN Domain\ServiceUserName

setspn –a MSSQLServer/machinename:1433 Domain\ServiceUserName

setspn –a MSSQLServer/machinenameFQDN:1433 Domain\ServiceUserName

 

A sample code of the WCF Service can be as follows:

 

 public class MyWCFService: ServiceBase

    {

        private ServiceHost serviceHost = null;

 

        protected override void OnStart(string[] args)

        {

            if (serviceHost != null)

            {

                serviceHost.Close();

            }

 

            serviceHost = new ServiceHost(typeof(MyWCFService));

 

            serviceHost.Open();

        }

 

        protected override void OnStop()

        {

            if (serviceHost != null)

            {

                serviceHost.Close();

                serviceHost = null;

            }

        }

      }

 

The application configuration file can be as follows:

 

<system.serviceModel>

    <bindings>

      <netTcpBinding>

        <binding name="tcpBinding" />

      </netTcpBinding>

    </bindings>

    <services>

      <service behaviorConfiguration="MyServiceBehaviorWCF" name="MyWCFService">

        <endpoint address="mex" binding="mexTcpBinding" bindingConfiguration="" />

        <endpoint binding="netTcpBinding" bindingConfiguration="tcpBinding"

          name="Tcp" contract="IMyWCFService" />

        <host>

          <baseAddresses>

               <add baseAddress="net.tcp://machineA.domain.local:9000/MyWCFService" />

          </baseAddresses>

        </host>

      </service>

    </services>

    <behaviors>

      <serviceBehaviors>

        <behavior name="MyServiceBehaviorWCF">

          <serviceMetadata httpGetEnabled="true" />

        </behavior>

      </serviceBehaviors>

    </behaviors>

  </system.serviceModel>

 

When you install the Windows Service that host the WCF you need to set the account under which it runs for example Domain\WCFAccount.

The WCF client configuration needs to be configured as follows, pay attention to the identity section, because you need to specify the SPN if you want to use kerberos:

 

<bindings>

   <netTcpBinding>

    <binding name="tcpBinding" />

   </netTcpBinding>

  </bindings>

            <client>

   <endpoint address="net.tcp://machineA.domain.local:9000/service" binding="netTcpBinding"

    bindingConfiguration="tcpBinding" contract="IMyWCFService"

    name="IMyWCFService">

     <identity>

       <servicePrincipalName value="MyWCFService/machineA.domain.local"/>

     </identity>

   </endpoint>

 

How do I configure the servicePrincipalName for my service? You need to use the Windows Service Name (MyWCFService)

  1. Add Domain\WCFAccount to the Active Directory
  2. Add the SPN for the WCF hosting service for the machine where you are running the service:
  3. Setspn –a MyWCFService/machineA.domain.local:9000 Domain\WCFAccount
  4. Setspn –a MyWCFService/machineA:9000 Domain\WCFAccount
  5. Mark the account Domain\WCFAccount  as trusted for delegation
  6. Start the Windows Service.

 

Regards,

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/




Note: Cross posted from Eduardo Castro.

Permalink

Bases de datos SQL Azure Bajo el Toldo

En este video vemos la arquitectura de SQL Azure y el funcionamiento interno de su infraestructura de aprovisionamiento y manejo de seguridad.

 

SQL Azure Bajo el toldo from Eduardo Castro on Vimeo.

 

Saludos,

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/




Note: Cross posted from Eduardo Castro.

Permalink

martes, 11 de mayo de 2010

Introduccion a SQL Azure Bases de datos en la nube

En este video vemos una introducción a las bases de datos en la nube con SQL Azure.

 

Introduccion a SQL Azure Bases de datos en la nube from Eduardo Castro on Vimeo.

 

 

Saludos,

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/




Note: Cross posted from Eduardo Castro.

Permalink

SQL Azure Database Under the Hood

In this presentation we review the SQL Azure architecture, provisioning process and security fundamentals.

 

Regards,

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/




Note: Cross posted from Eduardo Castro.

Permalink

Webcast MSDN: "SQL Azure Database: Bajo el Toldo"

Estaré impartiendo este webcast sobre SQL Azure: bases de datos en la nube.

http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032443830&Culture=es-AR

 

Idiomas:
Español.

Productos:
Windows Azure.

Audiencia(s):
Programador/desarrollador de programas.

Duración:
60 Minutos

Fecha de Inicio:

miércoles, 12 de mayo de 2010 12:00 a.m. Bogotá

Información general del Evento

SQL Azure Database es un servicio de base de datos relacional altamente disponible y seguro que ofrece a los clientes una interfaz de provisión libre de fricción mientras mantiene un modelo de programación compatible con SQL Server. Esta sesión se enfocará en la tecnologías subyacentes de SQL Azure para que pueda entender cómo aprovechar mejor la bases de datos SQL Azure.

 

Saludos,

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/



Note: Cross posted from Eduardo Castro.

Permalink

lunes, 10 de mayo de 2010

Podcast sobre Instalación de SQL Server 2008

En este podcast analizamos los factores a considerar durante una instalación de SQL Server 2008 o SQL Server 2008 R2.

 

Listen now or go to http://ecastrom.podbean.com/2010/05/10/instalacion-de-sql-server-2008/


Powered by Podbean.com

icon for podbean  Standard Podcasts: Play in Popup | Download

 

También lo pueden descargar desde http://cid-bf30da8b3fc2e667.skydrive.live.com/self.aspx/Comunidad%20Windows%20Costa%20Rica/Pod%20Cast%20SQL%20Server/InstaSQL2008.mp3

 

Saludos,

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/




Note: Cross posted from Eduardo Castro.

Permalink

Podcast de Introducción a SQL Azure

En este podcast http://podcast.com/show/217514/ hacemos una introducción a las bases de datos en la nube con SQL Azure. Puedes descargarlo desde esta dirección http://cid-bf30da8b3fc2e667.skydrive.live.com/self.aspx/Comunidad%20Windows%20Costa%20Rica/WebCast/IntroSQLAzure.mp3

 

Saludos,

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/




Note: Cross posted from Eduardo Castro.

Permalink

viernes, 7 de mayo de 2010

Error on SQL Server Reporting Services for Team Foundation Server 2010

If you are installing a Reporting Services 2008R2 instance that is going to be used as report repository for TFS 2010, you may find this error:

TFxxxxxx: SQL Server Reporting Services is configured to require a secure connection, however no HTTPS URL is configured with a valid certificate


If you want to use certificates, just request a new one an configure it, but if you don’t want to use SSL you can follow these steps to get over this error:

 

  1. First remove the SSL binding from the report server using the Reporting Services Configuration Manager
  2. Navigate to your report server folder (by default MSRS10.MSSQLSERVER\Reporting Services\ReportServer), open the rsreportserver.config file and locate the entry named SecureConnectionLevel and set its value to 0
  3. Now you can run the configuration checker and the error will be gone.

 

Regards,

 

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/




Note: Cross posted from Eduardo Castro.

Permalink

Introduction to SQL Azure: database in the cloud

In this presentation we introduce the basic SQL Azure concepts.

Regards,

 

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/




Note: Cross posted from Eduardo Castro.

Permalink

martes, 4 de mayo de 2010

Error al instalar SQL 2008 SP1 en Windows 7 o Windows 2008 R2

Si se presenta el siguiente error cuando se está instalando el SQL 2008 SP1 en Windows 7 o Windows 2008 R2

 

Invoke or BeginInvoke cannot be called on a control until the window handle has been created

 

Este es un problema ya conocido y usted tiene dos opciones:

1. Volver a ejecutar el instalador del SP1 y debería instalarse sin ningún problema

2. El instalador crea un directorio temporal C:\{GUID} usted puede copiar ese directorio (contiene el setup.exe y los archivos del SP1) en el escritorio u otro directorio temporal y ejecutar el instalador desde ahí.

 

 

Saludos,

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Note: Cross posted from Eduardo Castro.

Permalink

Error installing SQL 2008 SP1 in Windows 7 or Windows 2008 R2

If you receive the following error when installing SQL 2008 SP1 in Windows 7 or Windows 2008 R2

 

Invoke or BeginInvoke cannot be called on a control until the window handle has been created

 

This is a known issue with the installer and you have two options:

1. Rerun the service pack and you should be able to install it

2. The installer creates a directory  C:\{GUID} you can copy that folder (that contains setup.exe and the supporting files) to your desktop or a temporary folder and then install the service pack.

 

Regards,

 

Saludos,

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Note: Cross posted from Eduardo Castro.

Permalink

lunes, 3 de mayo de 2010

Problemas con las DMV de Indices

Deseo compartir con ustedes este excelente artículo publicado por Paul Randall, http://www.sqlskills.com/BLOGS/PAUL/post/Missing-index-DMVs-bug-that-could-cost-your-sanity.aspx

Existe un detalle con las DMV de índices no existentes que podría causarle muchos problemas cuando está analizando consultas con el plan de ejecución. Este es el problema: el código de índice faltante podría recomendar un índice non clustered que ya existe, una y otra vez. Además podría recomendar un índice que no ayuda en la consulta. Este caso ya ha sido reportado  (Connect item #416197) y será corregido en SQL11 pero no en versiones anteriores.

Este es un ejemplo utilizando SQL Server 2008 SP1.

Estos son los pasos para reproducirlo:

CREATE TABLE t1 (
    c1 INT IDENTITY,
    c2 AS c1 * 2,
    c3 AS c1 + c1,
    c4 CHAR (3000) DEFAULT 'a');
GO
CREATE UNIQUE CLUSTERED INDEX t1_clus ON t1 (c1);
GO

SET NOCOUNT ON;
GO
INSERT INTO t1 DEFAULT VALUES;
GO 100000

Esto crea una tabla con muchas filas, y ahora ejecutamos la siguiente consulta: 

SELECT COUNT (*) FROM t1
    WHERE c2 BETWEEN 10 AND 1000
    AND c3 > 1000;
GO

Se despliega el plan de ejecusión

...Me recomienda crear un índice:

Ahora creamos este índice:

CREATE NONCLUSTERED INDEX [_missing_c2_c3] ON [dbo].[t1] ([c2],[c3]);
GO

Ahora creamos este código de ejemplo para fines ilustrativos, es cierto no debería utilizar cursores pero es solo para fines ilustrativos.

DECLARE testcursor CURSOR FOR
    SELECT c1 FROM t1
    WHERE
        c2 BETWEEN 10 AND 1000
        AND c3 > 1000;

DECLARE @var BIGINT;

OPEN testcursor;

FETCH NEXT FROM testcursor INTO @var;

WHILE (@@fetch_status <> -1)
BEGIN
    -- empty body
    FETCH NEXT FROM testcursor INTO @var;
END

CLOSE testcursor;
DEALLOCATE testcursor;

Se despliega el plan de ejecución 

Hmmm, parece que me está solicitando el crear el mismo índice anterior (aunque está solicitando que c1 debe ser incluido, aunque ya existe un índice non cluster con  c1 como cluster key, el cual es incluído de forma automática). Bueno, voy a crear el índice que solicita:

CREATE NONCLUSTERED INDEX [_missing_c2_c3_inc_c1] ON [dbo].[t1] ([c2],[c3]) INCLUDE ([c1]);
GO

Y no cambia nada, siempre continúa solicitando el índice.  El índice no es utilizado por el *Key Lookup* en el plan de ejecución – pero el missing index code piensa que sería útil y lo sugiere. Este índice no ayudará en el Key Lookup, además ya existe!

Si utiliza una consulta que sumariza la salida del missing index DMV (tal y como lo hace Bart Duncan's excellent script) y si usted tiene consultas comunes en su sistema que se encuentran con esta características de las DMV entonces sus agregaciones podrían estar incorrectas.

 

Saludos,

 

Ing. Eduardo Castro, SQL Server MVP

Note: Cross posted from Eduardo Castro.

Permalink

Missing index DMVs bug that could cost your sanity

Just want to share with you this excelent post from Paul Randall, http://www.sqlskills.com/BLOGS/PAUL/post/Missing-index-DMVs-bug-that-could-cost-your-sanity.aspx

 

Here's yet another reason to be very careful when using the missing index DMVs...

There's a bug in the missing index DMVs that could end up causing you to knock your head against a brick wall and question your sanity. I know I did.

The bug is this: the missing index code may recommend a nonclustered index that already exists. Over and over again. It might also recommend an index that won't actually help a query.

Yes, I'm surprised by this too - as the missing index code is in the query optimizer too. However, it will continue to recommend you create the already-existing index - which is terribly annoying.

This is a little-known bug (Connect item #416197) which is fixed in SQL11 but won't be fixed in earlier versions.

I experienced this on SQL Server 2008 SP1 this weekend and I wanted to blog about it so you don't spend ages trying to work out what's going on.

Here's a repro for you:

CREATE TABLE t1 (
    c1 INT IDENTITY,
    c2 AS c1 * 2,
    c3 AS c1 + c1,
    c4 CHAR (3000) DEFAULT 'a');
GO
CREATE UNIQUE CLUSTERED INDEX t1_clus ON t1 (c1);
GO

SET NOCOUNT ON;
GO
INSERT INTO t1 DEFAULT VALUES;
GO 100000

This creates a table with a a bunch of rows, with each row pretty large so that the cost of scanning the table is expensive.

Now say I want to run a query:

SELECT COUNT (*) FROM t1
    WHERE c2 BETWEEN 10 AND 1000
    AND c3 > 1000;
GO

If I display the estimated execution plan...

...it will tell me there's a missing index I should create:

So I go ahead and create the index and everything's cool:

CREATE NONCLUSTERED INDEX [_missing_c2_c3] ON [dbo].[t1] ([c2],[c3]);
GO

Now what if I want to do something more complicted? How about a cursor over the table? (Don't start on about not using cursors - they're everywhere in application code we see - this is just an easy example to engineer.)

DECLARE testcursor CURSOR FOR
    SELECT c1 FROM t1
    WHERE
        c2 BETWEEN 10 AND 1000
        AND c3 > 1000;

DECLARE @var BIGINT;

OPEN testcursor;

FETCH NEXT FROM testcursor INTO @var;

WHILE (@@fetch_status <> -1)
BEGIN
    -- empty body
    FETCH NEXT FROM testcursor INTO @var;
END

CLOSE testcursor;
DEALLOCATE testcursor;

If I display the estimated execution plan again, it shows:

Hmm. That index is actually exactly the same as the one we created earlier (even though it's asking for c1 to be INCLUDEd, it already is in the existing nonclustered index as c1 is the cluster key and is included automatically). However, just to prove I'm not doing anything dodgy, I'll create the index it wants:

CREATE NONCLUSTERED INDEX [_missing_c2_c3_inc_c1] ON [dbo].[t1] ([c2],[c3]) INCLUDE ([c1]);
GO

And nothing changes. You cannot get the missing index code to stop recommending the index. The index isn't being used for the *Key Lookup* in the query plan above  - but the missing index code thinks the index would be useful and suggests it. Not only would that index not actually help the Key Lookup, it already exists!

If you use a query that aggregates the missing index DMV output (such as Bart Duncan's excellent script) and you have some very common queries on your system that are hitting this bug, you will find that the missing index DMV aggregation will be broken too.

Be careful out there!

 

Regards,

 

Ing. Eduardo Castro, SQL Server MVP

Note: Cross posted from Eduardo Castro.

Permalink