Learn how to manage the security-hotfix process from notification through deployment by reading this article on Microsoft TechNet.
Author: SSWUG Research
The curse and blessings of dynamic SQL
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
SOAPing Up Web Services
Web services offer a new approach to an old idea: A set of interface specifications that don’t care about transport mechanisms, hardware architectures, or operating systems. And an integral factor in making that idea work is the SOAP specification.
Get Sample Records
by Pulkit Mathur – Here is a tip to get sample records from a table. Suppose there are 100 records in a table and you want to see the 5th, 10th …95th, and the 100th record. Or the 1st, 3rd, 5th… record.
SQL Server Agent – Creating Performance Condition Alerts on Database Server Objects
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.
Form Builder 5.0
Book by Stephen Edelstein – Sample Chapter 8: LibrariesPrevious versions of Oracle’s Forms Designer tools, SQL*Forms and Oracle Forms, had two ways of sharing procedural code with multiple applications:User Exits let designers write procedures in a programming language (C, COBOL, For
Normalizing XML, Part 1
by Will Provost – As regular readers of the XML Schema Clinic likely know, I tend to view the world of XML through object-oriented glasses. For this installment, though, we’re reaching out to the relational data folks, switching lenses for one eye at least. The goal is to see what relational concept
Jean Paoli on XML in Office 11
By Jon Udell – Next week’s issue of InfoWorld includes an article on the new XML capabilities of Office 11. While researching the story, I interviewed the architect of XML in Office 11, Microsoft’s Jean Paoli, one of the primary co-creators of XML. Here are some of his remarks.
Automatic Numbering, Part 1
by Bob DuCharme – XSLT’s xsl:number instruction makes it easy to insert a number into your result document. Its value attribute lets you name the number to insert, but if you really want to add a specific number to your result, it’s much simpler to add that number as literal text.
Tip: Using a DOM NodeFilter
XML’s DOM Level 2 Traversal module provides two new objects, the TreeWalker and the NodeIterator, which simplify the process of navigating a Document. More than that, the module defines a NodeFilter, which can be used to programmatically control what nodes are visible to the TreeWalker or NodeFilter