Eladio Rincón

"Comparte lo que sabes, aprende lo que no sepas" FGG

July 2008 - Posts

Novedades TSQL en SQL Server 2008

hola, otra publicación: creo que sabes que Itzik Ben-Gan (gran compañero y mejor amigo), está preparando la serie de libros de Inside SQL Server para 2008:

 

Como aperitivo, tenemos esta publicación en MSDN, que

An Introduction to New T-SQL Programmability Features in SQL Server 2008

http://msdn.microsoft.com/en-gb/library/cc721270(SQL.100).aspx

"Summary: This paper introduces key new Transact-SQL programmability features in Microsoft SQL Server 2008 as well as SQL/Common Language Runtime (CLR) enhancements. New Transact-SQL features provide improved performance, increased functionality, and enhanced globalization support. Transact-SQL programmability enhancements in SQL Server 2008 address the needs of both OLTP and data warehouse environments."

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 users need to do their jobs and that applications need to communicate with services and processes. So in many organizations, you need to ensure that your databases are up and running 24x7. These days, with database system design getting more and more complex, you must consider database availability from the early design stages. This is where Microsoft high availability technologies such as clustering, transaction log shipping, replication, and database mirroring come into play. This whitepaper introduces you to database mirroring, a new feature in SQL Server 2005 that transfers transaction log records directly from a principal server to a mirrored standby server and that lets you quickly fail over to the standby server. In this paper, you’ll learn:

  • The roles of the participants and how database mirroring works
  • How to set up, configure, and monitor database mirroring
  • How database mirroring compares with other high availability technologies"

 

el White Paper completo en PDF lo puedes descargar desde:

http://www.windowsitpro.com, sección Recursos, elemento Whitepapers. luego allí busca la sección SQL Server y databases.

image

 

la url directa es: http://windowsitpro.com/Whitepapers/Index.cfm?fuseaction=ShowWP&wpid=4bebbba9-8451-441e-bbff-97d110338981

para poder descargar necesitas SOLAMENTE registrarte en la web, no es necesario que seas subscritor de SQLMag.

 

También quería agradecer a mis compañeros Enrique Catalá, Javier Loria, y Rubén Garrigós por sus comentarios técnicos, y por su puesto a Kathy Blomstrom por su gran ayuda en la revisión lingüistica.

Espero que os guste :)