The Microsoft ODBC Driver for DB2 and the Microsoft OLE DB Provider for DB2, each of which are implemented as an IBM Distributed Relational Database Architecture (DRDA) Application Requester, use packages to issue dynamic SQL statements after connecting to DB2 running on supported platforms. This
Other News
Oracle Administration – Part 1
(Steve Callan) For most DBAs, not only is there Oracle database administration to deal with, but there are Oracle administration issues as well. What do I mean by “Oracle administration?” Depending on your role within your company, “administration” can encompass several areas related to the use and
Microsoft’s New XML Web Services Offering
Microsoft, with the release of Web Part and Web services toolkits for its SharePoint Products, continues to advance interoperability of enterprise applications. The software giant mounts another push in its on-going efforts aimed at setting XML Web services standards. Moreover, with the introduction
Misconceive Early, Misconceive Often
(Edd Dumbill) While XML’s noblest and best are away directly injecting their brains with mind-altering drugs at Extreme Markup, there’s still plenty of food for thought for the rest of us from last week’s XML mailing lists and weblogs.
Sending SQL notifications with CDOSYS
(Desiree Harris) While SQL Server has a very mature set of tools, one thing that is lacking is the ability to send a simple email alert based on a pre-defined set of rules. At first glace, it appears that email notifications exist but what becomes a problem to many people is the requirement for
Kerberos Protocol Transition and Constrained Delegation
(Twan Van Beers) That title’s quite a mouthful, huh! Let’s start by explaining what we’re actually trying to achieve here. Actually, before we start, let’s just say that this paper shows you how I implemented protocol transition and constrained delegation with SQL Server and IIS, and it is not inten
Risky Business, Part 2
(Dorian Pyle) In part 1 of this column, I discussed assessing risk (in other words, estimating the probability that an adverse consequence will result from some action). After the column was published, readers reminded me of a truth about risk: It’s inherent in every activity, even writing (or readi
A Look at Rich Internet Applications
(Cameron O’Rourke) For the last two years or so, interest has been building in the idea of a “rich client”: a user interface that is more robust, responsive, and visually interesting than what can be achieved with HTML. Rich Internet Application (RIA) technologies allow us to deploy rich clients
Port Blocking, SQL Server, and the Internet
(Denny Figuerres) While random blocking of ports by ISP’s could lead to a severely crippled Internet I do not believe that it is in the best interests of most users (private or business) to leave all ports open to all users. As an example of this lets take a look at the “MSBlast” worm and the damage
Health Check
This script looks at the statistics of your Database. (script)