Using SQL Server 2000 and XML to Monitor the Usage of your SMTP Server
This article describes how to monitor Microsoft SMTP usage using SQL Server 2000 and XML.
2001-11-29
3,550 reads
Basics
XML for SQL Server 2000: Optimizing Your Performance
The XML features of Microsoft® SQL Server® 2000 and the subsequent XML for SQL Server 2000 Web releases enable a whole new class of XML-aware applications. This article shows you how to improve the performance of this new feature.
2001-11-01
2,241 reads
Using Uniqueindentifier Instead of Identity
Identity columns are last years news. Have you experimented with uniqueindentifiers - better known to programmers as GUID's? Guaranteed to be unique in the world, they offer a powerful alternative to identity columns.
2001-09-17
11,439 reads
Upsize Your Database: Convert Your Microsoft Acces
What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0.
2001-08-09
1,435 reads
Prove Your Case and Win a Buck!
Your database design should be impervious to this documented behavior of the ADO delete method. Be one of the first five members to give a compelling reason why not, and take a dollar from starving columnist Sean Burke.
2001-05-21
3,320 reads
Blogs
Notifications in Azure Data Factory: Email, Internal Alerts, Log Analytics Alerts
By Rayis Imayev
(2019-Dec-15) While working on data integration projects and using Azure Data Factory as your main...
SSMS Tip: Portable User Settings
By Tim Mitchell
I’m a creature of habit. With the software tools that I use, I like...
Schema evolution solved using Delta Lake & Databricks
By Gerard
Don’t know about you, but one of my least favourite data pipeline errors is...
Forums
SQL Job advice...am I being ripped off?
Hi, I have a small business which uses Zoho recruit- its a kind of...
The mystery of SQL Memory
Hi All, In server 2012 and 2016 , SQl error logs show this error...
Same DB, geographically diverse?
Hi Everyone, I have a database (~50GB in size) with content that is constantly...
Ask SSC