SQL Server

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/

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 ...

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 /Rebuil...

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 Enhanments View more presentations from Eduardo Castro .   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

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://sqlserver...

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 View more presentations from Eduardo Castro .   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 htt...

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.htm   Regards,   Eduardo Castro SQL Server MVP

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

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 poste...

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 post...

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:     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 Ser...

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%29 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 No se pueden hacer consultas entre base de datos ni entre servidores No hay Transparent Data Encryption Soporta un subconjunto muy completo de T-SQL pero no todos, http://blogs.msdn.com/ssds/archive/2009/07/07/9823115.aspx 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 h...