Certification
Examples
News
Links
Users
Contact
Europe's leading IT Training Company Offering you e-Solutions in a e-Business World
Articles
In this page, we'll have links to interesting articles related to SQL Server. In some cases they will be articles stored in this site, in other cases they will be links to other sites.
Conference Sessions
SAD336 Dealing with SQL Server Security from ADO.NET (Presented by Fernando G. Guerrero at the SQL Server Magazine Live Conference, October 2002, Orlando, Florida, USA) Download the source code
VDA306 Dealing with SQL Server Security from ADO.NET (Presented by Fernando G. Guerrero at the VS .NET Connections Cnference, October 2002, Orlando, Florida, USA) Download the source code
SAD335: Concurrency problems and locking techniques in SQL Server 2000 and VB.NET (Presented by Fernando G. Guerrero at SQL Server Magazine Live Conference, October 2002, Orlando, Florida, USA). Code for Transactions and Locking Techniques
VDA305: Concurrency problems and locking techniques in SQL Server 2000 and VB.NET (Presented by Fernando G. Guerrero at VS .NET Connections, October 2002, Orlando, Florida, USA). Code for Transactions and Locking Techniques
VDA308: Achieve the Impossible: Use INSTEAD OF triggers in SQL Server 2000 to Deal Transparently with No-updateable Views (Presented by Fernando G. Guerrero at VS .NET Connections, October 2002, Orlando, Florida, USA). Code for Instead of Triggers
SQLUG: Concurrency problems and locking techniques in SQL Server 2000 and VB.NET (Presented by Fernando G. Guerrero at the SQL User Group Conference, October 2002, Reading, UK). Code for Transactions and Locking Techniques
VBUG: Concurrency problems and locking techniques in SQL Server 2000 and VB.NET (Presented by Fernando G. Guerrero at the Visual Basic User Group Conference, October 2002, Reading, UK). Code for Transactions and Locking Techniques
Connecting to SQL Server 2000 from ADO.NET (Presented by Fernando G. Guerrero at the SQLLive! Conference, September 2002, Orlando, Florida). Source Code for Connecting SQL Server 2000 from ADO.NET
Draft White Paper on Connecting to SQL Server 2000 from ADO.NET
Designing Efficient User Defined Functions in SQL Server 2000 (Presented by Fernando G. Guerrero at the SQLLive! Conference, September 2002, Orlando, Florida). Code samples for Designing Efficient UDFs
Concurrency problems and locking techniques in SQL Server 2000 and VB.NET (Presented by Fernando G. Guerrero at TechEd 2002 Europe, July 2002, Barcelona, Spain, as part of the Data Track). Code for Transactions and Locking Techniques
Delivering Dual-Language and Multi-Technology Courses (Presented by Fernando G. Guerrero at TechEd 2002 Europe, July 2002, Barcelona, Spain, as part of the MCT Track)
Modelo de Replicación de una Base de Datos SQL Server en la Web (Presented by Fernando G. Guerrero at the e-Gallaecia Database 2002 Conference, June 2002, Santiago de Compostela, Spain)
Handling results from special SQL Server statements in ADO.NET (Presented by Fernando G. Guerrero at the SQL Server Magazine Life! 2002 Spring Conference, May 2002, Palm Springs, California) Download the source code
Dealing with SQL Server Security from ADO.NET (Presented by Fernando G. Guerrero at the SQL Server Magazine Life! 2002 Spring Conference, May 2002, Palm Springs, California) Download the source code
Inside the SQL Server 2000 Indexes (Presented by Fernando G. Guerrero at the MCT Conference 2002, May 2002, Anaheim, California)
Concurrency problems and locking techniques in SQL Server 2000 and VBNET (Presented by Fernando G. Guerrero at the MCT Conference 2002, May 2002, Anaheim, California)
Advanced data access techniques with SQL Server 2000 and the .NET Framework (seminar presented by Fernando G. Guerrero at DevWeek 2002, March 2002, London, UK) Download the source code
Writing DotNET database applications with SQL Server and VB (seminar presented by Fernando G. Guerrero at DevWeek 2002, Feb 2002, London, UK) Download the source code
Create a Federation of Servers to Solve your Database Scalability (Presented by Fernando G. Guerrero at PASS 2001 North America, Jan 2002, Denver Colorado)
User-Defined Global Variables Management in SQL Server 2000 (Presented by Fernando G. Guerrero at PASS 2001 North America, Jan 2002, Denver Colorado) Download the source code
Using SQL2000 to Implement Relational Integrity Fully (Presented by Aaron Johal and Fernando G. Guerrero at PASS 2001 North America, Jan 2002, Denver Colorado) Note: the downloadable file include presentation material, source code and notes
Connecting to SQL Server 2000 from ADO-NET (Presented by Fernando G. Guerrero at PASS 2001 North America, Jan 2002, Denver Colorado) Download the source code
A day in the life of a SQL Server 2000 Index / Inside SQL Server 2000 Indexes (Presented by Fernando G. Guerrero at TechEd 2001 Europe)
Defining an Object Model for the SQL Server Northwind Database (Presented by Fernando G. Guerrero at the VBUG meeting in Bristol, June 2001)
Advanced OO Database Programming with VB, COM+ and SQL Server 2000 (Presented by Fernando G. Guerrero at VBITS 2001 Stockholm)
Master Document Management with VB and SQL Server 2000 (Presented by Fernando G. Guerrero at VBITS 2001 Stockholm)
Designing Efficient User-Defined Functions in SQL Server 2000 (Presented by Fernando G. Guerrero at VBUG Spring 2000)
Listings and examples for VBUG presentation on UDFs(Presented by Fernando G. Guerrero at VBUG Spring 2000)
New Database Denormalization Techniques with SQL Server 2000 (Presented by Fernando G. Guerrero at TechEd 2000 Europe)
Other Articles
Designing for Attribute-Rich Entities (Presented by Ron Talmage at PASS 2000 North America)