(Bill Graziano) In SQL Server 2008 we get a new DATE date type that allows you to store a date without a time.
Other News
OMIGOSH Moments and Getting Your Feet Under You
Featured Article(s) Troubleshooting SQL Server 2005 CLR Problems In this article, Alexander Chigrik explains some problems that you can have when you work with CLR objects. He also tells how to resolve these problems. Thanks To Our Sponsors We’ve worked with some great companies this year! We really appreciate their support and help in bringing you SSWUG. Over the next […]
SQL Server Triage – Where to Start?
Featured Article(s) Oracle 11g Software Installation on LinuxCentOS-5 After going through the 2-Day DBA guide and talking about installing Oracle software, I thought it would be interesting to write an article that covered an actuall install of Oracle 11g on Linux–CentOS-5. Thanks To Our Sponsors We’ve worked with some great companies this year! We really appreciate their support and help […]
XForms – Who Needs Killer Apps?
(Kurt Cagle) The XML 2007 Conference has come and gone, with as usual a number of thought provoking talks and controversies. During the evening of the first day, there was a special XForms Evening, with a number of the industry gurus in that space providing very good examples of why XForms is a comp
Dissecting MySQL Fulltext Indexing
(Ted Dziuba) I was working on a database project the other day, and one of the client’s requirements was that the database be “searchable”. Every programmer is familiar with such a vague requirement, and is therefore familiar with the “creative license” it allows him. The database engine for this pr
TechTip: Know the Drill!
(Gene Cobb) Hopefully, by now you’ve had a chance to install and use the new DB2 Web Query for System i tool. Hailed as the successor to the popular Query/400 product as the strategic System i query and reporting tool, DB2 Web Query can do things that Query/400 could only dream of. One of these adva
Frameworks, XML and duplication
(Dan Wilson) Duplicating code is Bad! When designing software, take great pains to avoid duplication of code. After all, if an application has a lot of duplicated logic, or cut/pasted processes, it is very easy for parts of the system to get out of wack. A small tweak here, a short change there and
IBM DB2 9 for z/OS: New Tools for Query Optimization
(Paolo Bruni, Terry Berman, John Iczkovits, Basuki Soetarman, Bart Steegmans and Mike Turner) The cost-based optimizer of IBM DB2 for z/OS has continually evolved since its initial inception. Support has included new optimization algorithms, join methods, complex relational data structures, such as
A First Look at the VS2008 ReportViewer
(William R. Vaughn) Now that Visual Studio 2008 has shipped, you finally can get a firm grip on what’s there (and what’s still missing). One of my favorite features of Visual Studio 2005 is the ReportViewer control that leverages the considerable work done by Microsoft to develop and refine the Repo
Data Quality Starts With Proper Data Type
(Craig S. Mullins) Data type and length are the most fundamental integrity constraints applied to data in a database. Simply by specifying the data type for each column when a table is created, the DBMS automatically ensures that only the correct type of data is stored in that column. Processes that