(Paul DuBois, Stefan Hinz, and Carsten Pedersen) This chapter covers the following exam topics: –Invoking command-line client programs –Specifying command-line options –The mysql client –Using mysql interactively –Using script files with mysql –mysql client commands and SQL statements
Author: SSWUG Research
Control site appearance with ASP.NET 2.0 themes
(Tony Patton) Last week we examined ASP 2.0 master pages and discussed how you can use them to centralize a site’s layout. Developers often confuse themes with master pages, but the two elements are quite different. Master pages allow you to control the general layout of a site or a group of pages w
Run SQL Server as a domain account for network access
(Serdar Yegulalp) Like many services, SQL Server and the SQL Server Agent can run in a variety of account contexts. By default, both SQL Server and the Agent are installed in the Local System Account context. However, Microsoft notes in one of its own discussions that the Local System Account is pro
Monitor Your Database Servers with DTS, Part 2: Errorlog Monitoring of SQL Servers
(Neeraj Nagpal) In the first article in the series, I explained the setup of a report that ensures that backups are happening as per the backup policy. In this article, I will explain how to monitor SQL Server errorlog, leveraging the capabilities of DTS.
Collaborate ’06 Preview: IOUG’s Kaplan on RAC, security, mobility and more
(Mark Brunelli) One of the biggest Oracle user conferences of the year — Collaborate ’06 — kicks off later this month in Nashville. The conference, which this year represents the combined efforts of the Independent Oracle Users Group (IOUG), the Oracle Applications Users Group (OAUG) and the Quest
Efficiently Paging Through Large Result Sets in SQL Server 2000
(Scott Mitchell) When displaying large amounts of data to a user, it’s important that the information be presented in digestible chunks rather than slamming it all down their throats at once. For example, searching for “Microsoft” on Google returns approximately 2,190,000,000 results, but thankfully
Best Practices for Using WebSphere Business Modeler and Monitor
(Stephen White) The purpose of this Redpaper is to provide guidance for the preparation of business process models, developed with the WebSphere Business Modeler, which will ultimately be monitored by the WebSphere Business Monitor. The model preparation, including business measure development, and
Cut storage consumption in half with DB2 Viper Compression
(Chris Eaton) The next new feature in Viper that I want to talk about is row compression. DB2 has a number of types of compression in v8. For example there is value compression where the storage space for nulls and system defined defaults can be compressed out. There is also MDC which results in sig
Create and Populate Treeviews Dynamically
(Nagasai Mattegunta) In my recent project, a part of requirement is, to generate KPI score card. The KPI score card is a chart showing the KPI in tree like structures. All the KPIs are categorised and each category represents a tree. The tree hirarchy is defiend in database. This basically requires
Magellan’s Second Voyage: Site Navigation Tools in ASP.Net 2.0, Part 2
(Peter Aitken) In a previous article, I introduced you to ASP.Net 2.0’s site navigation tools. We saw how the Menu, TreeView, and SiteMapPath controls can be bound to a Web.Sitemap file, to quickly and easily provide navigation elements on your pages. When you go beyond these basics, however, you wi