The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
This issue brings you advice from the experts to help you plan your future as a SQL Server professional. Learn how the role of the SQL Server DBA is changing; how you can adapt and specialize to increase your earning potential, job security, and job satisfaction; and what resources are available to help you along the road.
By Richard Waymire
Microsoft’s SQL Server development team provides code that retrieves extended properties in a Web-based SQL Server administration application.
By Brian Lawton
DTS can jumpstart your career by helping you master ETL implementation.
By Ron Talmage
Now that you've seen how you can easily set up, reconfigure, and monitor log shipping in SQL Server 2000, beef up your knowledge of role changes, role reversals, and where to place the monitor server.
By Brian Moran
What does the value LPC mean in the net_library column of my master..sysprocesses table?
Microsoft’s SQL Server development team explains why a transaction log expands and offers remedies for the problem.
Although SQL Server 2000's Standard Edition lacks the log shipping utility that the Enterprise and Developer Editions contain, you can use the Simple Log Shipping Tool to ship database logs.
By Rich Rollman
To prevent XML Bulk Load from truncating your data without notice, you can use SAX2 validation with XML Schema mapping schemas to ensure that only data of the correct type is loaded into your database.
I'm using distributed partitioned views to run a query on two servers. However, the two parts of the union execute serially rather than in parallel. Why?
By Michael Otey
By providing a native JDBC driver for SQL Server, Microsoft hurdles the Java stumbling block and continues to push SQL Server into the enterprise.
What trends will affect your role in the SQL Server world? What areas of specialization will put you ahead of the pack? This advice from the experts can help you choose the right SQL Server career paths.
Can I compare the image value in one row with the image contents of another row to determine whether the contents are identical?
SQL Server 2000 doesn't support recursive queries. However, by using the new sql:max-depth annotation, you can easily generate recursive hierarchies without the complexity of building a FOR XML EXPLICIT query.
I'm trying to use T-SQL to return the relative percentage of two summed values when I divide the values into each other. Why does my calculation behave as if it's doing integer math?
By Morris Lewis
SQL Server trainer and consultant Morris Lewis recommends a variety of resources that SQL Server administrators and developers can use to improve their knowledge and advance their careers.
Bibliographic references for all books, online resources, and MOC courses that Morris Lewis describes in "Learning for Life."
Here are seven more undocumented extended stored procedures that can add power to T-SQL.
SQL Server Analysis Services can get you in the door to the exciting, expanding field of business intelligence.
By
Readers write in about the implications of increasing SQL Server's programmability, using computed columns, and understanding transaction isolation levels.
By Russ Whitney
To write queries that always return the most recent information, you need an MDX formula that moves forward in time as you add new information to the database. Here are four ways to create this time-dynamic MDX.
By Kalen Delaney
Rewriting your queries to use TOP instead of SET ROWCOUNT can be a form of query tuning.
By Scott Firestone IV
A collection of the latest SQL Server-related new and improved products.
Sort a set in ascending order while making sure the parents appear after the children.
Microsoft’s SQL Server development team explains how to accommodate the most SQL Server connections on one node.
By William Vaughn
Use SQL-DMO and other techniques to keep your application and users working effectively long after your MSDE installation is complete.
Microsoft’s SQL Server development team explains why dynamic snapshot processes articles for replication multiple times.
How can I see when my SQL Server 2000 database file grows and how much it grows each time?
The proposed changes in SQL Server's programming model, including the integration of the Common Language Runtime (CLR), will bring both opportunities and challenges.
Prepare yourself for a sea of change by upgrading your SQL Server skills, and become familiar with .NET technology even if you don't plan to use it.
By Michelle A. Poolet
Create a set of history tables in your database or build a separate history database without jeopardizing your database’s performance.
Microsoft’s SQL Server development team tells a reader how to enforce a trigger’s unique value by using a custom CHECK constraint or, in SQL Server 2000, INSTEAD OF triggers.
advertisement