During this Support WebCast, we will focus on Microsoft SQL Server 2000 Windows CE Edition (version 1.1) techniques and troubleshooting. We will discuss database maintenance, error checking, tempdb relocation for performance, and other programming and debugging tips.

By Anton Baranchuk – A good tool in the hands of master craftsman is a key to make a good product. Sometimes it takes a lot of time to do some routine work. In such a case the instrument for automation of some processes can help us and save time for more important things. In this article we d

Learn how to manage the security-hotfix process from notification through deployment by reading this article on Microsoft TechNet.

by Josh Calderonello – Learn how to write Transact-SQL code to dynamically script mass INSERT statement scripts.

Read about the core features that make up SQL Server Notification Services and learn how they can be used to develop relevant, consensual communications to be sent to any subscriber device.

Alexzander Nepomnjashiy continues his new series that focuses on SQL Server alerts and errors with a detailed look into SQL Server performance condition alerts and how they are used to monitor the internal performance of SQL Server objects.

by Erland Sommarskog – In this article I will discuss the of use dynamic SQL in stored procedures in MS SQL Server, and I will show that this is a powerful feature that should be used with care. I first recapitulate why we use stored procedures at all, before I explain the feature as such. I then lo

By Russ Whitney – From analysis to final decision, every business process requires collaboration among team members. Here’s how you can use DSO to add collaboration features to your next analytic application.

Taking forward the topic of the previous article Transactions, within this article we will discuss Transactions with respect to databases and will also see an example which would be implemented in SQL Server displaying how to use Transactions.

This article discusses some common ADO properties (cursor location, cursor type and lock type) and their effect on performance. It’s mainly concerned with eliminating server-side cursors. These are identified in Profiler traces by sp_cursorfetch statements.