Eladio Rincón y SQL Server

Desde Torrevieja :)

Recent Posts

Tags

News

links de interes

Community

Email Notifications

Archives

Browse by Tags

All Tags » SQL Server 2005 (RSS)
Using Service Broker as SQL Server Agent
You might already know this, just in case… The short post would be “Service Broker has the ability to schedule conversation delays during messages processing”. With this in mind, it would be easy to create a dummy Service Broker infrastructure that fires...
Migration from SQL Server 2005 to SQL Server 2008 with only 4 seconds of database downtime
we’ve migrated recently one of our customers production systems from SQL Server 2005 to SQL Server 2008 with only 4 seconds of database downtime; yo’ve got more information about this here: http://eon.businesswire.com/portal/site/eon/permalink...
Devweek 2009: Partitioning Techniques, and What to do and What not to do with SQL Server 2008
For me was a pleasure to co-present those two sessions with my friend Javier Loria last week at DevWeek – London. you can download the presentations from those links: SQL Server 2008 Partitioning Techniques: Presentation (pptx) Demo Scripts SQL Server...
Cumulative Update #1 for SQL Server 2005 Service Pack 3
Microsoft has just released the Cumulative Update #1 for SQL Server 2005 Service Pack 3; this CU is specially compiled for customers that had SQL Server 2005 SP2 with CU10 or CU11; if you’re not in this case, you should avoid installing this CU; More...
SQL Server 2005 SP3 (Service Pack 3) ready to download
  just a quick note: http://blogs.msdn.com/nickmac/archive/2008/12/16/sql-server-2005-service-pack-3-released-to-web.aspx SQL Server 2005 SP3 contains the hotfixes that were included in cumulative update packages for SQL Server 2005 Service Pack...
Avoiding access to base tables using Foreign Key, and two suggestions...
Just a note before going further: I am going to maintain my blog in Spanish and English: The English version will be hosted at msmvps.com ( http://msmvps.com/blogs/eladio_rincon ) The Spanish version will be hosted at Solid Quality Mentors blog -- El...
Publicado White Paper de Database Mirroring en SQL Server 2005
Hola, menuda alegría me he llevado: me han publicado un WP de Database Mirroring la gente de DELL en colaboración con la revista Window ITPro (los editores de SQL Magazine). Esta es la introducción al WP: "Databases hold the vital information that...
Database Mirroring, inicios de sesión de SQL, y el procedimiento almacenado sp_change_users_login
Introducción En instalaciones que implementéis database mirroring, debéis realizar tareas de administración para cuestiones que se salen del ámbito de la base de datos; por ejemplo: ¿qué haces con los planes de mantenimiento como reindexaciones, copias...
Mejores prácticas en operaciones de copias de seguridad y restauración en SQL Server 2005
Nuestro compañero y gran amigo Javier Loria, ha publicado en siguiente artículo para la Revista SQL Magazine: "Best Practices for Backup and Restore in SQL Server 2005" http://www.sqlmag.com/Whitepapers/Index.cfm?fuseaction=ShowWP&WPID=415a010b...