Super SQL Server Systems

Turbocharge Database Performance with C++ External Procedures

Donald K. Burleson, Joseph Gama, Patrick Naughter - Collection IT In-Focus

550 pages, parution le 03/01/2006

Ajouter à une liste

Indisponible

Résumé

This unique book focuses on hypercharging SQL Server database performance with external procedures.

SQL Server runs databases for financial, bank, biotech, Ecommerce, data warehousing, scientific applications, etc. which often require huge data processing with complex formulas or algorithms.

Most of this work is done with TSQL stored procedures and .NET procedures (in SQL Server 2005), however neither one of them can achieve the performance and flexibility of external procedures which are natively compiled code. External procedures are analogous to stored procedures but with the power of C++ for CPU intensive algorithms, hardware/low level access, use of external libraries, etc.

Database administrators/developers can create more efficient code and avoid expensive, slow and unreliable third party tools. There is also the extra bonus of having the source compiled, to protect the intellectual property.

This book is intended for C++ programmers who want to learn about database programming and use their C++ skills seamlessly, and database administrators and/or programmers who need more performance, functionality and versatility than they can achieve with TSQL, .NET procedures or ADO.

L'auteur - Donald K. Burleson

Donald K. Burleson is one of the world's top Oracle Database experts with more than 20 years of full-time DBA experience. He specializes in creating database architectures for very large online databases and he has worked with some of the world's most powerful and complex systems.

A former Adjunct Professor, Don Burleson has written 30 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Rampant TechPress. Don is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences.

Sommaire

Introduction to Extended Stored Procedures
Misc compilers and languages
A C++ Class Framework for XP's (XP++)
Network Messaging (XP_NETSEND)
SMTP Mailing (XP_SMTPSENDMAIL)
NT Event Log (XP_NTLOG)
Disk Logging (XP_DISKLOG)
Audio Notification (XP_NOTIFY)
Encoding HTML special characters (XP_HTMLENCODE)
Cryptography (XP_CRYPTOAPI)
Random Data (XP_RAND)
INI File Manipulation (XP_INI)
Retrieving free disk space (XP_DISKSPACE)
Retrieving CPU usage (XP_CPUUSAGE)
Raw sockets sample (XP_RAWIP)
Geographical Information Systems (XP_GIS)
Regular Expressions (XP_REGEXP)
A Multiple Use XP (XP_SERVERREACHABLE)
Computational Astronomy (XP_ASTRO)
IP Configuration (XP_IPConfig)
Beyond C/C++ (XP_RUNSCRIPT)
Protecting Intellectual Property with XP's
Managed Code in SQL Server 2005
Security in SQL Server 2000
From TSQL to XP's
SQL Server database tutorial
SQL Server stored procedure tutorial
SQL Server User-defined functions (UDF's)
System XP's

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Rampant
Auteur(s)	Donald K. Burleson, Joseph Gama, Patrick Naughter
Collection	IT In-Focus
Parution	03/01/2006
Nb. de pages	550
Format	17 x 24,5
Couverture	Broché
Poids	500g
Intérieur	Noir et Blanc
EAN13	9780976157328
ISBN13	978-0-9761573-2-8