(Srinath MS) When creating XML files, sometimes there are fields (elements/attributes) where you need to use special characters like space, &,
Author: SSWUG Research
FIX: Error message when you use a Volume Shadow Copy Service (VSS) writer to back up a snapshot in SQL Server 2005 or in SQL Server 2000: ‘Attempt to release mutex not owned by caller’
When you use a Volume Shadow Copy Service (VSS) writer to back up a snapshot in Microsoft SQL Server 2005 or in SQL Server 2000, an event that resembles the following may be logged in the Application log: Event Source: SQLVDI Event Category: None Event ID: 1 Date: Time: User
Querying a Database Snapshot
(Sanjay Mishra, Michael Thomassy and Peter Byrne) Database Snapshots (http://msdn2.microsoft.com/en-us/library/ms175158.aspx) in SQL Server 2005 Enterprise Edition allow a read-only point-in-time view of data. Recently we encountered an interesting scenario with a customer implementation. The custom
Implementing Dynamic Scroll with Ajax, JavaScript, and XML
(Vlad Kofman) In this article, I will discuss implementing an Ajax-enabled scrollable table, in which rows are dynamically fetched from the server, as the user scrolls, without the whole page refreshing. This technique is unique and very convenient for implementing pages with a lot of dynamic conten
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part I
(Muthusamy Anantha Kumar) As you probably know, Windows PowerShell is the new command shell and scripting language that provides a command line environment for interactive exploration and administration of computers. In addition, it provides an opportunity to script these commands so that we can sch
End-to-end integration with pervasive messaging and IBM Lotus Expeditor micro broker
(Martin Gale) Micro broker, a new feature in IBM Lotus Expeditor V6.1, provides connectivity services beyond enterprise servers to mobile and pervasive devices. Learn about Lotus Expeditor micro broker and how you can enable true end-to-end integration in a Service-Oriented Architecture.
DB2 UDB for z/OS: SQL Performance Tuning
(Tom Moulder) Performance tuning of DB2 UDB for z/OS subsystems has been a common task since the announcement of that database subsystem by IBM. Performance tuning can be accomplished at the subsystem level or at the SQL statement level. It is generally accepted that 20% of the benefit from tunin
DB2 LUW Performance: Average Result Set Size (ARSS)
(Scott Hayes) You might think you have an OLTP transactional database. Or, you might think you have a Data Warehouse database. But what does your database think? How is it, or the queries within it, really performing?
Are Index Scans always good……
(Gerwin Hendriksen) During my work a lot of times I have heard the same rumour. Lots of people are stating that when a system is doing index scans the system is doing well. But is this actual true, that is the question. In my work I experienced a lot of times that I was called to look at a system […]
Why IS NULL doesn’t always work in MySQL
(Xaprb) How can a query like “SELECT * FROM tbl WHERE col IS NULL” return a row where the column has a (non-NULL) value? Read on to find out.