Fernando G. Guerrero

Fernando G. Guerrero is a SQL Server lecturer and developer and a principal technologist for QA, UK. He is an MCDBA, an MCSD, an MCSE+Internet, and a SQL Server MVP and MCT. He is coauthor of Microsoft SQL Server 2000 Programming by Example (Que).
Email: fernando.guerrero@qatraining.com

My Latest Content

My Latest Comments

Author Articles

UDFs Provide a New IDENTITY

By Fernando G. Guerrero, 02/22/2001

Use UDFs in SQL Server 2000 to create new IDENTITY functionality.

Using Fake Temporary Tables

By Fernando G. Guerrero, 01/24/2001

You can use data sets inside triggers and in stored procedure calls by creating permanent tables that emulate temporary tables.

Fake Temporary Tables and SQL Server 2000

By Fernando G. Guerrero, 01/24/2001

SQL Server introduces several new features that might have implications for whether and how you use fake temporary tables with this new release.

A/C Circuits and T-SQL

By Fernando G. Guerrero, 11/10/2000

Here's a practical application of using a user-defined function (UDF) to manipulate complex numbers.

Downloads

Have to create custom code just to determine who has what permissions? Try Security Explorer, an enterprise security management solution for SQL, SharePoint, and more. As expert Robert Davis reports, “DBAs who deal with compliance regulations will find this tool indispensible.”

Tip Guides

Migrating to Windows 7 comes with one major drawback: Win7 “application obsolescence.” This tip guide explains how VMware ThinApp can encapsulate applications in self-contained executables and how you can avoid the ten most common Win7 application migration pitfalls.

Subscribe to SQL Server Magazine!

Web Seminars

Despite the promise of cloud computing, IT administrators may be hesitant to entrust the performance of their business-critical processes to a 3rd party. View this webinar to learn how you can reap the benefits of cloud computing while maintaining absolute control over your data.

eLearning Series

Windows IT Pro brings the experts direct to you to share their real-world perspective, experience, and expertise. During each event, three sessions stream in real time, allowing you to learn, to ask questions, and to get solutions.
Upcoming event: SQL Server Consolidation

© 2012 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.