When a user-defined function is in a high-stress scenario in Microsoft SQL Server 2000, you receive an access violation error message.
Author: SSWUG Research
Introducing the SQL Server 2005 Surface Area Configuration tool
(Adam Machanic) As part of Microsoft’s secure computing initiative, many new security features were added to SQL Server 2005. While features like encryption and granular permissions control secure databases within a server, other features are dedicated to securing the “surface area” of the server. T
SQL 2000 to SQL 2005: Where Have All the Old Features Gone?
(Boris Baliner) As more DBAs across the planet begin using SQL 2005 Tools, but still manage SQL 2000 servers with them, I suspect there will be lots of muffled moaning as to where all the good old features have gone. Although Management Studio has some very nice long-awaited features, some of the go
Master Pages: Tips, Tricks, and Traps
(scott) Master pages are a great addition to the ASP.NET feature set. Master pages help us build consistent and maintainable user interfaces. Master pages, however, are not without their quirks. Sometimes master page behavior is surprising, and indeed the very name master page can be a bit misleadin
An Object-based Approach to HTTP Compression in PHP
(Alejandro Gervasio) Welcome to the second tutorial of the series “Using HTTP compression in PHP.” In three parts, this series demonstrates how to apply HTTP compression to parsed PHP pages, in order to reduce their overall download times, which results in faster delivery of dynamic content.
CodeSnip: Charting with DataGrid Control
(Amal ElHosseiny) This article discusses how to create charts inside a DataGrid control using an XML file.
Redirect I/O to a TextBoxWriter in .NET
(Paul Kimmel) A data stream is like a river where you set data adrift. You put data on the river and it floats along, waiting to be plucked out at some other location. As with streams in nature, you can move up or down the stream, see what’s there, and put in or take out things. Streams in .NET work
Managing Distributed Transactions with ADO.NET 2.0 using TransactionScope
(Muhammad Mosa) A transaction is a unit of work. You use transactions to ensure the consistency and integrity of a database. If a transaction is successful, all of the data modifications performed during the transaction are committed and made permanent. If an error occurs during a transaction, you c
Oracle says may launch own Linux version
U.S. software maker Oracle is considering launching a version of the Linux operating system and has looked at buying one of the two firms dominating the technology, the Financial Times newspaper reported.
MySQL Switches Storage Engines
(Barbara Darrow) MySQL will use SolidDB OLTP storage engine for its popular open-source database, filling what could have become a void caused by Oracle’s acquisition last fall of Innobase. MySQL had been using Innobase’s InnoDB storage engine.