By SATISH GOPI – Here is how to check the system drive space threshold in SQL Server. (You’ll need to install SQL Mail first.)
Tag: sql server
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
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
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
Build Apps that Provide Real-Time Information and Customized Content Using SQL Server Notification Services
By Mark Brown – Here the author provides an architectural overview of the core features that make up SQL Server Notification Services. Along the way he discusses how they can be used for pushing Web content.
Comparing Data Sets with SQL
Learn how to use SQL to compare two sets of rows, from either the same or different tables.
SQL Server Celebrating Its 10th Anniversary
By Brian Moran – SQL Server marks its 10th anniversary in December. Readers can help us celebrate by sharing their memories–wacky or wicked–of SQL Server’s past.
Microsoft SQL Server 2000 DBA Survival Guide: Second Edition
Book review from SQL-Server-Performance.com – Only the most successful SQL Server books made it to a second edition, as most are outdated (due to new software versions) long before there is time for a second edition to be written. One of those exceptions is Microsoft SQL Server 2000 DBA Survival Gui
Microsoft Security Bulletin MS02-061 : Elevation of Privilege in SQL Server Web Tasks
Who should read this bulletin: System administrators using Microsoft® SQL Server™ 7.0, SQL Server 2000, Microsoft Data Engine (MSDE) 1.0, and Microsoft Desktop Engine (MSDE) 2000.
Using SQL’s EXISTS Predicate to Identify Missing Data
Sometimes knowing that data is missing is just as important as finding data that exists. Use SQL’s EXISTS predicate to select data based on the presence (or absence) of other values.