SQL Server Magazine July 2002
[Focus]
All security operations in SQL Server depend on authentication and authorization. Kerberos authentication, the Windows 2000 default, offers identification of both the client and the server.
By Morris Lewis
[Features]
Are you looking for ways to improve SQL Server object security in a multidatabase environment? Making better use of ownership chains can help. Here's a look at concepts, techniques, and best practices for working with ownership chains.
By Dan Guzman
[SQL Server Savvy]
A reader asks how to prevent users from stopping and starting the SQL Server Agent.
By Brian Moran
A reader asks why he can't get his SQL Server client tools to connect to a default instance of SQL Server 2000 through a dynamically determined TCP/IP port.
By Brian Moran
Although SQL Server Books Online can be misleading on this topic, a unique constraint doesn't let you add multiple records that contain a value of NULL.
By Brian Moran
You can use a T-SQL-based cursor to create a stored procedure that loops through rows and concatenates data into a variable, as you do in Visual Basic.
By Brian Moran
[Editorial]
Not all database benchmarks are created equal. The reasons why the TPC tests are successful are the same reasons why magazines and other interested parties can’t perform good database benchmarks.
By Michael Otey
[SQL Seven]
Developers are learning how important Visual Studio .NET will be to Yukon, the next release of SQL Server. Are you ready to begin testing Visual Studio .NET? Here are the answers to seven common questions that you might ask.
By Michael Otey
[Inside SQL Server]
Indexes that help with data modification operations can be totally different from the ones that help with retrieval. Learn how to choose UPDATE and DELETE indexes wisely.
By Kalen Delaney
[Mastering Analysis]
You've created a time-tracking application that uses Analysis Services' write-back capability. Now learn how to automate maintenance of your write-back cube and create a data-entry application so employees can enter billable time.
By Russ Whitney
[Solutions by Design]
Would you like to know instantly how much of one wallpaper batch remains in your warehouse bin? Or how your current cost for lawn mowers matches your cost over time? The product-distribution metamodel provides the framework for these details.
By Michelle A. Poolet
[T-SQL Black Belt]
You might have missed out on proving Fermat's Last Theorem, but here's your chance to solve Blank's Puzzling Problem. Ready?
By Itzik Ben-Gan
[Answers from Microsoft]
Microsoft’s SQL Server Development Team illustrates three ways to move data from a SQL Server 2000 database to SQL Server 7.0.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team tells a reader how to link login accounts from one server to another.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team sends readers to a database’s list of stored procedures and offers a code snippet that returns that information.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team explains why you can’t use T-SQL to roll back a transaction in the transaction log and provides code for a way to accomplish the task.
By Microsoft's SQL Server Development Team
[Exploring XML]
Now you can use Microsoft’s SOAP Toolkit 2.0 and the WSDL to create a Web Service that easily expands the volume of data you send your customers across platforms.
By Rich Rollman
[Letters]
Readers write in about creating Web-based analysis systems, finding answers to their problems in SQL Server Magazine, and the future of mdXML.
By Various Authors
[New Products]
Check out the latest SQL Server-related new and improved products.
By Carolyn Mader
|
