by Randy Dyess – At one point in time I was tasked with running over 70 databases on more than a dozen servers without any of the costly third-party tools that exist to accomplish such tasks, and I often get asked how can you handle such large numbers of databases. This is a short article that will
Author: SSWUG Research
Diagnose Server Performance Problems with SQL Server’s SQL Profiler
SQL Profiler is a great SQL Server tool that can help you reach your database optimization goals. This 10-Minute Solution presents a few preparatory steps to start using Profiler for monitoring performance problems. It discusses some techniques, tools, and commands that reveal information about serv
SQL Server Text Formatting Functions Contain Unchecked Buffers
Who should read this bulletin: Database administrators using Microsoft® SQL Server™.
Checking the system drive space threshold
By SATISH GOPI – Here is how to check the system drive space threshold in SQL Server. (You’ll need to install SQL Mail first.)
Domesticating the Database
By David H. Holtzman – IT NEVER CEASES to amaze me that companies know where every potted tree in the building is situated, yet have no idea what is planted in their computer systems. I’m talking about the enterprise databases—the most valuable asset a company has. The information contained in these
Slow growth: Just one Oracle challenge
By John Cox – In Oracle’s most recent quarterly results, network executives can see a vendor struggling to do pretty much what they are: squeeze out costs and juggle several projects to boost revenue in the face of a steep slowdown in enterprise software spending.
Wanted: A Database That Does What’s Needed
By Jason Brooks – From the first time I came into contact with a database product—for me, it was Symantec’s Q&A—I was excited by all the great organizational stuff I could do with a database. However, this gave way to frustration when my initial design didn’t do what I needed it to do, or didn’t do
Analyze Schemas with the XML Schema Infoset Model
IBM’s new XML Schema Infoset Model provides a complete modeling of schemas themselves, including the concrete representations as well as the abstract relationships within a schema or a set of schemas. Learn how to use this powerful library to perform complex queries on your own schemas.
Use recursion effectively in XSL
By Jared Jackson – Using XSL transformations effectively and efficiently requires understanding how to use XSL as a functional language, and this means understanding recursion. This article introduces the key concepts of recursion and its particular use in XSL. Techniques for optimizing XML translat
Novell and MySQL to Ship MySQL Database with NetWare
By Wayne Kawamoto – Novell and MySQL announced that Novell will ship a NetWare-optimized commercial version of the MySQL database with Novell NetWare 6 and subsequent releases of NetWare.The vendors believe the combined offering will provide savings to Novell customers and allow them to deve