Posts

Showing posts from March, 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 autoSi 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.orghttp://comunidadwindows.orgCosta Rica Technorati Tags: SQL Server LiveJournal Tags: SQL Serverdel.icio.us Tags: SQL Serverhttp://ecastrom.blogspot.comhttp://ecastrom.wordpress.comhttp://ecastrom.spaces.live.comhttp://universosql.blogspot.comhttp://todosobresql.blogspot.comhttp://todosobresqlserver.wordpress.comhttp://mswindowscr.org/blogs/sql/default.aspxhttp://citicr.org/blogs/noticias/default.aspxhttp://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 autoIf 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.orghttp://comunidadwindows.orgCosta Rica Technorati Tags: SQL Server LiveJournal Tags: SQL Serverdel.icio.us Tags: SQL Serverhttp://ecastrom.blogspot.comhttp://ecastrom.wordpress.comhttp://ecastrom.spaces.live.comhttp://universosql.blogspot.comhttp://todosobresql.blogspot.comhttp://todosobresqlserver.wordpress.comhttp://mswindowscr.org/blogs/sql/default.aspxhttp://citicr.org/blogs/noticias/defa…

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 systemChoose to boot from DVDYou need to then select the time, language and currency and the desired input methodOn the Windows Installation Screen choose Repair Windows InstallationsClick 'Next' and select 'Repair your computer' optionThe '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 /RebuildBcdThere are other possib…

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.Sql Server 2008 Security EnhanmentsView more presentations from Eduardo Castro. Regards, Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP http://mswindowscr.orghttp://comunidadwindows.orgCosta Rica Technorati Tags: SQL Server LiveJournal Tags: SQL Serverdel.icio.us Tags: SQL Serverhttp://ecastrom.blogspot.comhttp://ecastrom.wordpress.comhttp://ecastrom.spaces.live.comhttp://universosql.blogspot.comhttp://todosobresql.blogspot.comhttp://todosobresqlserver.wordpress.comhttp://mswindowscr.org/blogs/sql/default.aspxhttp://citicr.org/blogs/noticias/default.aspxhttp://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.orghttp://comunidadwindows.orgCosta Rica Technorati Tags: SQL Server LiveJournal Tags: SQL Serverdel.icio.us Tags: SQL Serverhttp://ecastrom.blogspot.comhttp://ecastrom.wordpress.comhttp://ecastrom.spaces.live.comhttp://universosql.blogspot.comhttp://todosobresql.blogspot.comhttp://todosobresqlserver.wordpress.comhttp://mswindowscr.org/blogs/sql/default.aspxhttp://citicr.org/blogs/noticias/default.aspxhttp://sqlserverpedia.blogspot.com/

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=1033If you want the Power Point Presentation you can downloaded from http://www.slideshare.net/ecastrom/windows-server-2008-security-overview-short-3533161View more presentations from Eduardo Castro. Regards,Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP http://mswindowscr.orghttp://comunidadwindows.orgCosta Rica Technorati Tags: SQL ServerLiveJournal Tags: SQL Serverdel.icio.us Tags: SQL Serverhttp://ecastrom.blogspot.comhttp://ecastrom.wordpress.comhttp://ecastrom.spaces.live.comhttp://universosql.blogspot.comhttp://todoso…

Deliver Professional Presentations with MaxiVista

Have you ever run in the situation where you need to deliver a presentation to  an audience and you need a second monitor to see what is being projected when you use the Presenter Mode in Power Point? If so, one solution is to use MaxiVista http://www.maxivista.com/ it allows to run a PowerPoint presentation on your laptop and transmit the slides to another PC, and use the another PC to do the Projection, this is usefull when your are far away from the projector and you need the dual monitor.It also allows you to reuse the old notebooks, with MaxiVista you to use the monitor of any spare PC as an extended screen for your Primary PC, if you haven’t try it out I recommend to do so, you can download an evaluation copy here http://www.maxivista.com/download.htmRegards,Eduardo CastroSQL Server MVP

BIO

Eduardo Castro posee el reconocimiento de MVP de Microsoft, su rol comprende el diseño de soluciones de negocio e infraestructura, así como brindar recomendaciones sobre las herramientas tecnológicas y su integración en ambientes corporativos.Posee más de 15 años de experiencia en el área de TI trabajando especialmente con clientes corporativos y gobierno, tanto en Centroamérica como en Estados Unidos.Eduardo Castro es un orador frecuente en los WebCast de Technet y MSDN en Latinoamérica, ha participado como orador y experto invitado en Conferencias en Estados Unidos. Además es el líder de la Comunidad Windows, organización que se encarga de realizar eventos y charlas sobre infraestructura Microsoft, el sitio de la comunidad puede ser accedido en http://comunidadwindows.org

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.orghttp://comunidadwindows.orgCosta Rica Technorati Tags: SQL ServerLiveJournal Tags: SQL Serverdel.icio.us Tags: SQL Serverhttp://ecastrom.blogspot.comhttp://ecastrom.wordpress.comhttp://ecastrom.spaces.live.comhttp://universosql.blogspot.comhttp://todosobresql.blogspot.comhttp://todosobresqlserver.wordpress.comhttp://mswindowscr.org/blogs/sql/default.aspxhttp://citicr.org/blogs/noticias/default.aspxhttp://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.aspxRegards,Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP http://mswindowscr.orghttp://comunidadwindows.orgCosta Rica Technorati Tags: SQL ServerLiveJournal Tags: SQL Serverdel.icio.us Tags: SQL Serverhttp://ecastrom.blogspot.comhttp://ecastrom.wordpress.comhttp://ecastrom.spaces.live.comhttp://universosql.blogspot.comhttp://todosobresql.blogspot.comhttp://todosobresqlserver.wordpress.comhttp://mswindowscr.org/blogs/sql/default.aspxhttp://citicr.org/blogs/noticias/default.aspxhttp://sqlserverpedia.blogspot.com/


Note: Cross posted from Eduardo Castro.

Permalink

Query Active Directory from SQL Server

Image
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 thatselect * 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: You must give read access to the SQL Server Service Account. Regards, Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP http://mswindowscr.orghttp://comunidadwindows.orgCosta Rica Technorati Tags: SQL Server LiveJournal Tag…

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: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%29Se 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 AzureNo se pueden hacer consultas entre base de datos ni entre servidoresNo hay Transparent Data EncryptionSoporta un subconjunto muy completo de T-SQL pero no todos, http://blogs.msdn.com/ssds/archive/2009/07/07/9823115.aspxSoporta un subconjunto de SQL Types pero no todos, http://blogs.msdn.com/ssds/archive/2009/07/07/9823115.aspxFor 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…