I recommend The MCITP SQL Server 2005 Database Administrator Core Requirements book set to anyone preparing for the certification. These books provided me with invaluable knowledge & helped me pass all three exams on the first try. I started my certification by reading The SQL Server 2005 Implementation and Maintenance. I also utilized a Transcender […]

I purchased my copy back in 1999 and it is one of my favorite SQL books. I find the information very accurate and relevant to the MS SQL versions (6.5 & 7.0) printed on the cover of the book. I think it was the best SQL book for many years. Since 1999, many books for […]

If you have several years experience with MS SQL 2000 you may be able to pass the 70-229 with this book only. A great way to measure your readiness is by taking the test that comes included in the CD. If you pass it with an 85 or above, I’ll say you’re ready. If you […]

By far, this is the best overall MS SQL 2000 server book written until today. Most topics are covered from basic to advance level. This book is a must have for anyone who is looking to get a well rounded knowledge of what’s possible with MS SQL 2000. The chapters I liked the most are: […]

This guide is very concise & straight to the point. Do not be fool by its size. Team and project managers along with business analysts should find this guide very useful. This pocket book is an easy read that packs enough meat to get you going with Extreme Programming. It is written for anyone who […]

Aquí les presento una manera de generar la fecha en Español utilizando el resultado de la función DATE_FORMAT(myDate,’%M’) or DATE_FORMAT(myDate,’%W’). January > Enero February > Febrero March > Marzo etc etc Monday > Lunes Tuesday > Martes Wednesday > Miércoles etc etc  

Algunas veces he tenido la necesidad de mover los archivos LOG de la base de datos de un disco duro a otro. En este artículo, voy a describir el código T-SQL que utilizo para lograr este objetivo. Primero selecciono la base de datos y ejecuto el procedimiento de systema SP_HELPFILE para obtener el nombre y […]

El poder generar una secuencia de comandos (Script) para generar todos los objetos de una base de datos es una función necesaria para cualquier administrador. Puedes salvar estos Scripts para comparar las diferentes versiones o para una migración de la base de datos a otro ordenador. La utilidad SCPTXFR te permite generar esta secuencia de […]

Los registros de un documento XML pueden ser insertados fácilmente a una base de datos de MS SQL 2000 utilizando el objeto XML Bulk Load. El XML Bulk Load es parte del SQLXML Data Access Component y funciona de manera similar al BULK INSERT o la utilidad bcp. Es un objeto tipo COM que te […]