The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
This month, learn how Kerberos authentication with SQL Server 2000 gives you the most bite for your security buck and how to secure objects in a multidatabase environment. Also, go inside a Web service, catch our Visual Studio .NET FAQs, and much more!
By Morris Lewis
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 Brian Moran
A reader asks how to prevent users from stopping and starting the SQL Server Agent.
By Russ Whitney
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 Dan Guzman
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
Microsoft’s SQL Server Development Team illustrates three ways to move data from a SQL Server 2000 database to SQL Server 7.0.
Utilization is a common measurement of performance in a consulting agency. This month's puzzle solution shows you how to create the MDX for a measure that calculates utilization for a selected employee and time period.
Sometimes you need to create a cube that has only calculated measures visible. This month's puzzle challenges you to write a query that displays a cube's visible measures without directly referencing them.
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.
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.
Readers write in about creating Web-based analysis systems, finding answers to their problems in SQL Server Magazine, and the future of mdXML.
By Rich Rollman
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 Kalen Delaney
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.
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 Michelle A. Poolet
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 Michael Otey
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.
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.
Microsoft’s SQL Server development team tells a reader how to link login accounts from one server to another.
Examine the strengths and weaknesses of each encryption method for the best security.
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.
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 Itzik Ben-Gan
You might have missed out on proving Fermat's Last Theorem, but here's your chance to solve Blank's Puzzling Problem. Ready?
By Carolyn Mader
Check out the latest SQL Server-related new and improved products.
advertisement