Check out these essential articles on SQL Server to help with your programming and administration needs, from Visual Studio Magazine 's and Windows Server System Magazine 's database experts. You'll learn to speed up queries and improve performance, understand how SQL Server fits in with Microsoft's platform strategy, and more.Visual Studio Magazine, April 4, 2005 Delve into SQL Server 2005's new native XML data type... [Read More] Visual Studio Magazine, February 10, 2005 Use the built-in functionality of SQL Server to make your business... [Read More] FTPOnline, February 9, 2005 With ADO MD.NET, organizing metadata is simple. This tip... [Read More] FTPOnline, February 2005 Tom Rizzo, the director of product management for SQL Server, shares... [Read More] From ADO.NET and System.Xml v. 2.0The Beta Version, January 14, 2005 This sample chapter gives you the scoop on Multiple Active Results Sets... [Read More] Windows Server System Magazine, December 14, 2004 Microsoft creates a multifaceted strategy for addressing communication... [Read More] Windows Server System Magazine, November 17, 2004 IBM, Microsoft, Oracle, and a small number of open sourcefocused... [Read More] Visual Studio Magazine, November 8, 2004 Examine three techniques for managing client state... [Read More] Windows Server System Magazine, November 1, 2004 The business side assumes IT knows what's wanted. IT assumes... [Read More] Windows Server System Magazine, October 15, 2004 Why DBMSs have a resurgent role in the application platform landscape... [Read More] Visual Studio Magazine, October 11, 2004 SQL Server 2005 supports developing UDFs, UDPs, user-defined triggers... [Read More] From Hitchhiker's Guide to SQL Server 2000 Reporting Services, October 1, 2004 Download two free chapters that help you tackle some of the more sophisticated... [Read More] by Buck Woody, WSSM, September 23, 2004 Learn the seven main tasks a database administrator needs to complete... [Read More] Video, FTPOnline, September 14, 2004 In this panel discussion at VSLive! Orlando, participants consider Yukon's... [Read More] by Roger Jennings, VSM, August 20, 2004 Despite some surprising feature-cutting, SQL Server 2005 Beta 2 gives a good idea... [Read More] by Peter DeBetta, VSM, August 20, 2004 ADO.NET 2.0 provides native support for user-defined data types (UDTs) by the data access client... [Read More] by Buck Woody, WSSM, August 17, 2004 Learn when to use graphical or command-line tools to manage SQL Server. [Read More] Visual Studio Magazine, August 13, 2004 Using a flexible query system enables you to build a system that is... [Read More] by Buck Woody, WSSM, July 12, 2004 How to think of your data as a set of components, not a monolithic table... [Read More] by Peter O'Kelly, WSSM, July 12, 2004 Longhorn represents both the culmination of the .NET vision and... [Read More] Visual Studio Magazine, July 2, 2004 Use the SQL Server Report Designer's wizards for a streamlined solution... [Read More] From A First Look at SQL Server 2005 for Developers, June 25, 2004 SQL Server 2005 includes new Transact-SQL functionality... [Read More] by Peter O'Kelly, WSSM, June 24, 2004 The 2005 versions of Visual Studio and SQL Server pave the road to Longhorn... [Read More] by Buck Woody, WSSM, June 15, 2004 It's important to have a solid understanding of how a system works before... [Read More] by William R. Vaughn, FTPOnline, May 26, 2004 This quick tip examines how to call complex stored procedures... [Read More] by Patrick Meader, FTPOnline, May 25, 2004 Analyze your databases and generate reports... [Read More] by Brian Connolly, FTPOnline, May 25, 2004 Data warehousing enhancements and analysis improvements... [Read More] by Buck Woody, WSSM, May 25, 2004 Installing System Management Server 2003 is a daunting task. Here's how to get started... [Read More] Visual Studio Magazine, May 21, 2004 Increase your app's flexibility and ease the installation by connecting... [Read More] Windows Server System Magazine, May 18, 2004 .NET has been revisited and revised for changing requirements... [Read More] by Keyur Shah, WSSM, May 11, 2004 Why database administrators and developers are excited... [Read More] by Roman Rehak, VSM, May 3, 2004 Learn 10 useful tips and tricks that help boost SQL Server… [Read More] by Jason Beres, VSM, May 3, 2004 Drag images from the file system over a WinForms PictureBox… [Read More] by Roger Jennings, VSM, May 3, 2004 Persist DataSets of lookup information as local XML files… [Read More] by Peter O'Kelly, WSSM, April 12, 2004 Making sense of Whidbey/Yukon and Longhorn… [Read More] by Craig Utley, VSM, April 9, 2004 Automate exception logging with one line of client code… [Read More] by Enrico Sabbadin, FTPOnline, March 26, 2004 Boost performance in server-side apps by using COM+ pooled objects… [Read More] by Bill Baker, FTPOnline, March 26, 2004 SQL Server 2005's Business Intelligence features onlined... [Read More] by Doug Thews, VSM, February 6, 2004 Learn how to secure a database connection string… [Read More] by Simon Guest, VSM, February 6, 2004 Create a shared database to provide interoperability between… [Read More] by Keyur Shah, FTPOnline, November 20, 2003 Learn how to map properties to a key in the configuration file… [Read More] by Buck Woody, WSSM, November 20, 2003 Here's a handy reference guide to the most popular SQL Server issues… [Read More] by Bob Beauchemin, VSM, November 7, 2003 Write procedural code and create user-defined types and aggregates… [Read More] by John Zipperer, WSSM, November 6, 2003 Careful planning helped ensure a manufacturing site's smooth transfer… [Read More] by Enrico Sabbadin, FTPOnline, October 28, 2003 Learn how to guarantee that you always access… [Read More] by Mark Shainman, WSSM, October 23, 2003 Control costs and improve support with a centralized SQL Server… [Read More] by Bob Beauchemin, VSM, October 7, 2003 Improve your code by understanding how SQL Server's default… [Read More] VSM, October 7, 2003 The Enterprise Manager hides function definitions for system UDFs… [Read More] by Stan Schultes, VSM, September 30, 2003 Extend the open source DotNetNuke ASP.NET portal… [Read More] by Fabio Claudio Ferracchiati, FTPOnline, November 2003 Issue SQL Server's money column often shows a decimal number. . . [Read More] by Roger Jennings, VSM, November 2003 Issue Numerical test data with real-world data objects can help you. . . [Read More] by Roger Jennings, VSM, October 2003 Issue Compare alternative approaches to SQL Server 2000 concurrency. . . [Read More] by Fabio Claudio Ferracchiati, VSM, October 2003 Issue Use the DataSet class to manage data you retrieve from. . . [Read More] by Roman Rehak, VSM, September 2003 Issue Use one of SQL Server 2000's newer features to write efficient and. . . [Read More] by Allan Hirt with Cathan Cook, Kimberly L. Tripp, and Frank McBath, .NET Magazine, August 2003 Issue Configure SQL Server properly to ensure high availability and optimal. . . [Read More] by Roman Rehak, VSM, August 2003 Issue Many database applications require the use of database transactions. . . [Read More] by Bob Beauchemin, VSM, August 2003 Issue Choose the appropriate level of protection to prevent. . . [Read More] by Fabio Claudio Ferracchiati and Juval Löwy, VSM, August 2003 Issue ADO.NET and SQL Server let you retrieve random images for display. . . [Read More] by Roger Jennings, VSM, July 2003 Issue Design SQL Server stored procedures to structure XML business. . . [Read More] by Roger Jennings, .NET Magazine, Tech Ed 2003 Issue Microsoft revives its autonomous-computing strategy with a. . . [Read More] by Jimmy Nilsson, VSM, June 2003 Issue Despite what Microsoft said in a recent. . . [Read More]
Back to top
