(Douglas Reilly) In Part I of this series, I discussed the role and value of conferences in the career development of SQL Server and .NET developers. In this article, I move on to discuss online technical forums, focusing on what to do before you post on a newsgroup or forum in order to derive maxim
Author: SSWUG Research
Speed Up Your SQL Inserts
(Alex Kozak) Database performance is one of the most critical characteristics of almost any application, and for the developer or DBA it usually depends on how fast they can retrieve data. Hence, many a performance optimization and tuning book discusses the ways to make queries faster. Even RDBMS ma
Discover and lock down vulnerable SQL Server services
(Kevin Beaver) In a previous tip, 10 hacker tricks to gain access to SQL Server, I outlined various ways SQL Server can be compromised. Here I’m going to expand upon a couple of vulnerabilities that I see time and time again when performing security assessments. (R)
Oracle unveils BI suite
(Heather Havenstein) Oracle Corp. unveiled a suite of business intelligence (BI) tools and applications that folds in analytic technology from Siebel Systems as part of an effort to go up against Microsoft Corp. — from the low end of the market up through the enterprise level.
AJAX Isn’t All Purpose Soap
(Justin Schultz) In this article, my goal is to provide you with a thorough AJAX primer and give you a real-world illustration of its usefulness.
XForms meets Ajax: Can they get along?
(Rich Seeley) When the W3C released a second edition of XForms this month as a recommendation for “new generation of Web forms,” the question that begged to be asked was where does this fit into the Web development world where Ajax is the hot technology? (R)
The Four Horsemen of Replication Part II
(Josh Berkus) Sorry for the delay. I’ve been busy organizing the PostgreSQL Anniversary Summit, and didn’t get back to this as soon as I’d have liked to. If you’re just picking up now, please read part 1 first.
Revisiting an older disk management DSNZPARM
(Willie Favero) For this entry, I am going to stick with the disk management theme and step back in time to take a look at a DSNZPARM parameter that has been around forever, the SEQUENTIAL CACHE installation option or SEQCACH on DSNZPARM macro DSN6SPRM. This parameter is used to specify whether to u
IBM DB2 Content Manager Standard Edition for iSeries
(Jack Boswell) This article guides you through the installation of DB2 Content Manager Standard Edition for iSeries. The article discusses the installation of the prerequisite software, Content Manager, System Administrator Client, Windows Client, and the eClient. Use this information in conjunction
Returning Only Numeric Data
(Craig S Mullins) I frequently get e-mail from folks asking about ways to accomplish things in DB2 and SQL. A recent question I got went something like this: Is there any option to check whether data “IS NUMERIC” in a DB2 table? We want to examine CHAR data but return only those where the entire