MS SQL
11/21
Discover, through a hands-on practice exercise, a more sophisticated business use for the MDX BottomCount() function, in combination with the Generate(), Descendants(), Ancestor() and other functions we have explored within our series. Join BI Architect Bill Pearson in this, the second part, of an extended examination of the MDX BottomCount() function. 11/18
The first installment of this series illustrating the power of Windows PowerShell in conjunction with SQL Server 2008 demonstrates how to install and use a simple PowerShell command and a simple AMO command.
11/14
One of the housekeeping challenges DBAs face is to keep track of their databases' growth and how much space is being used by each table and index in those databases. SpaceUsedAnalyzer extends the functionality of the spaceused system stored procedure to present information that is more detailed.
more...
Oracle
11/20
Steve Callan discusses what takes place inside the Oracle database when you're searching for something "LIKE" the value of interest. How does Oracle approach the problem of determining if the string 'ABCD' appears in the string 'ABCABDABCDAB' and if it does, how many times?
11/11
Learn how to join disparate or seemingly unrelated data using an Oracle-provided pseudo column to create the linkage.
11/06
Learn how to use health checks to stay on top of corruption in your Oracle database.
more...
MS Access
11/19
Garry Robinson discusses some of the subtleties that you can apply to your database tables prior to upsizing your tables to SQL Server. In this article, I will show you how to fix up some of your Access backend before you make the conversion.
10/17
Thanks to internet search engines, users are used to searching for text but unfortunately even the desktop search tools can't look into tables (easily). This article outlines a simple tool to search Access tables or linked tables to find if a text string(s) exists in those tables.
9/15
Learn how to set up an off-site copy of a working MySQL database, an Access version of the same back-end, and a front-end that could link to either.
more...
DB2
11/17
Learn how to take business logic such as stored
procedures, functions, or SQL statements and turn them into a Web service.
8/04
Earlier installments of this series discussed how to use Microsoft Access 2007 as a graphical front end to a back-end IBM DB2 data server and how to leverage Access 2007 and DB2 as an integration layer. This installment examines how to build reports that run against DB2 data servers.
7/01
In this chapter you will be introduced to the DB2 family of products that run on the Linux, UNIX, and Windows operating systems.
more...