By Matt Hicks – Microsoft Corp. released a new feature for its SQL Server 2000 database that can generate personalized notifications to a range of devices, including mobile devices.
Tag: sql server
Setting up Merge replication: step by step guide
In this article, Alexander Chigrik defines some general SQL Server replication topics,including replication topologies, replication types, and replication agents; and alsodiscusses Merge replication. He then illustrates these concepts with a step-by-stepguide to setting up a Merge replication proces
Microsoft SQL Server 2000 Unleashed
If you can only afford one book on SQL Server 2000, this is the book to own. I have been a fan of the previous two editions (for 6.5 and 7.0), and the editions keep getting better. The best way to describe this book is as an encyclopedia of SQL Server 2000. Virtually every topic is covered, and most
Complex updates using the Case statement
(Neil Boyle) One of the keys to database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation.
Stored procedure to export/import images to SQL Server
(Eli Leiba) This stored procedure serves as an interface to the TextCopy utility that exports and imports images and documnets to SQL Server. (R)
Performance Study of Microsoft Data Mining Algorithms White Paper
Data mining is quickly becoming a widely used analytical technique in today’s e-business environment. Learn about the two data mining algorithms included in SQL Server 2000 Analysis Services: Microsoft Decision Trees (MDT) and Microsoft Clustering.
Microsoft adds notification services to database
Microsoft has announced the release of SQL Server Notification Services, a platform for developing and deploying database applications that enable users to subscribe to informational updates.
Separating Elements
By Itzik Ben-Gan – User-defined functions can help when you have to work with denormalized data, but don’t worry if you don’t have SQL Server 2000. You can also create a SQL Server 7.0 solution to this headache.
Retrieving the row for the Nth largest parametric column in a parametric table
By Eli Leiba – This piece of code returns the row corresponding to the Nth largest value for a given column name in a given table.
Microsoft details next version of Visual Studio
By Tom Sullivan – WITH ITS FIRST iteration of Visual Studio .Net now just over six months old, Microsoft on Thursday began revealing details of the next version as well as an upgrade to the .Net Framework. As part of its strategy to make Web services pervasive throughout its entire software s