martes, 30 de marzo de 2010

SQL Server ejecutando en HyperV despliega el siguiente error Virtual machine could not be started because the hypervisor is not running. Boot Configuration Data.

Si por alguna razón usted edita el Boot Configuration Data debe ejecutar el siguiente comando después de la edición:

bcdedit /set hypervisorlaunchtype auto

Si no lo hace cuando intente levantar la máquina virtual de SQL SERVER  se desplegará el siguiente error “virtual machine could not be started because the hypervisor is not running”.

 

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/




SQL Server running in HyperV displays error: Virtual machine could not be started because the hypervisor is not running. Boot Configuration Data.

If for any reason you edit the Boot Configuration Data be sure to run the following command after the edit:

bcdedit /set hypervisorlaunchtype auto

If you don’t do it you will run into an error saying that your SQL Server virtual machine could not be started because the hypervisor is not running and then you will be presented with three possible errors, usually the main cause is where changes have been made to the Boot Configuration Data or BCD. This can also happen if you had sysprep'ed images with Hyper-V.

 

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/




lunes, 29 de marzo de 2010

SQL Server Machine Fails to Boot

If you have a SQL Machine that fails to boot with the following message:

 

“The boot selection failed because a required device is inaccessible”

 

You are facing the 0xc000000f error code, also you cannot boot into the system even at subsequent attempts of restarting the system. To solve this error follow these steps:

 

  • Insert Windows 2008 or Windows 2008 R2 installation disc into the computer and boot the system

  • Choose to boot from DVD

  • You need to then select the time, language and currency and the desired input method

  • On the Windows Installation Screen choose Repair Windows Installations

  • Click 'Next' and select 'Repair your computer' option

  • The 'System Recovery Options' dialog box appears, at which you need to select the Windows installation you need to repair, if you have more than one installation you must choose the correct one. Click 'Next'.

  • Choose to open the Command Prompt.

  • Run 'Bootrec.exe' with the option

    bootrec /RebuildBcd

  •  

    There are other possible problems, you can check this article http://support.microsoft.com/kb/927392 for more details about the bootrec command

     

    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/




    miércoles, 24 de marzo de 2010

    SQL Server 2008 Security Overview

    In the following Power Point we try to present the main security features in SQL Server 2008, we have ommited the account management, store procedure encryption and other security features that will be covered in future presentations.

     

     

    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

    Free SQL Server Training

    If you are looking for some introductory free SQL Server Training check out this link https://www.microsoftelearning.com/eLearning/offerDetail.aspx?offerPriceId=139087 it gives you access for one year to Microsoft SQL Server 2008 Clinics, these are the main topics:

     

    • What's New in SQL Server 2008 for Enterprise Data Platform
    • What's New in SQL Server 2008 for Business Intelligence
    • What's New in SQL Server 2008 for Database Development

     

    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/

    martes, 23 de marzo de 2010

    Microsoft Security Day

    The Microsoft Security was held today at Pueblo Antiguo, in this event we reviewed different Microsoft Products from the Security Perspective, among these products were Windows Server 2008 R2, SQL Server, Azure, Sharepoint and Visual Studio.

    The material of the presentation can be downloaded from http://cid-bf30da8b3fc2e667.skydrive.live.com/browse.aspx/Comunidad%20Windows%20Costa%20Rica/Microsoft%20Security%20Day?uc=12&isFromRichUpload=1&lc=1033

    If you want the Power Point Presentation you can downloaded from http://www.slideshare.net/ecastrom/windows-server-2008-security-overview-short-3533161

     

    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/

    viernes, 12 de marzo de 2010

    Converted SCSI Physical SQL Server to VHD does not boot

    Recently I did converted one Physical SQL Server to VHD, but the physical machine does had SCSI drives, so after the convertion the newly virtual machine did not boot and I got the a blue screen during  boot, to solve this issue I followed these instructions http://social.technet.microsoft.com/Forums/en/winserverhyperv/thread/ef8c12f7-c45d-442e-9a30-c43cd87df3b3, keep this reference, it can be usefull.

     

    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

    Convert Physical SQL Server Machine to Virtual Machine

    To do physical SQL Server Machine to virtual convertion you can use System Center, but if you don’t have it and you only want to a raw disk convertion you can use the Disk2VHD Tool from SysInternals, the VHD disk that this tool creates can be used as a VM for either Microsoft Virtual PC or Hyper-V.  You can download the tool from http://technet.microsoft.com/en-nz/sysinternals/ee656415%28en-us%29.aspx

     

    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, 9 de marzo de 2010

    Query Active Directory from SQL Server

    If you need to access some Active Directory information from SQL Server you can use the openquery command with the ADSI provider, below is an example for doing that

     

    select *

    from openquery(adsi, '

    select            displayName

    from    ''LDAP://dc=comunidadwindows,dc=org''

    where   objectCategory = ''Person''

            and

            objectClass = ''user''

            and sAMAccountName = ''useraccountname''

    ')

     

    You also must consider the segurity required inside Active Directory to allow the SQL Server Service account access to the corresponding OU, you can do it with Active Directory Users and Computers with Advance Features Enable and choosing the Security menu as show in the following figure:

     

    clip_image002

     

    You must give read access to the SQL Server Service Account.

     

    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

    sábado, 6 de marzo de 2010

    SQL Azure FAQ

    SQL Azure es SQL SQL Server en la nube, para aquellos que inician con SQL Azure estas son las respuestas a las FAQ más comunes:

    1. El tamaño máximo de las bases de datos es 1GB o 10GB, dependiendo de su suscripción, si necesita almacenar más datos deberá crear Shards http://en.wikipedia.org/wiki/Shard_%28database_architecture%29
    2. Se pueden crear todas las bases de datos que desee, pero no necesariamente estarán en el mismo servidor, esto debido al modelo de balance de carga de SQL Azure
    3. No se pueden hacer consultas entre base de datos ni entre servidores
    4. No hay Transparent Data Encryption
    5. Soporta un subconjunto muy completo de T-SQL pero no todos, http://blogs.msdn.com/ssds/archive/2009/07/07/9823115.aspx
    6. Soporta un subconjunto de SQL Types pero no todos, http://blogs.msdn.com/ssds/archive/2009/07/07/9823115.aspx

     

    For those who are starting with SQL Azure, these are the answers to most common FAQ:

     

  • Database maximum size is 1GB or 10GB based on your price plan, if you need to handle larger databases you must use Shards
  •     http://en.wikipedia.org/wiki/Shard_%28database_architecture%29

  • Unlimited number of databases, but they may not be on the same server, this is because the SQL Azure Balancing Mode
  • Currently you cannot do cross-database querying
  • There is no TDE in SQL Azure 
  • It supports a subset of SQL Server’s T-SQL commands, more detail in http://blogs.msdn.com/ssds/archive/2009/07/07/9823115.aspx
  • It supports a subset of SQL Server’s datatypes, more detail in http://blogs.msdn.com/ssds/archive/2009/07/07/9823115.aspx
  •  

    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/