 |
|
^ click above ^ |
05.25.04
Get
an early look at the new MySQL certifications
There are a couple of new certifications in town, and they call
themselves MySQL Core and Professional. The Core certification was
released in March 2003. The Professional exam went to beta test
a month later. These first two certifications are designed for users
and administrators. Each requires only one test, but you must have
Core certification before you go for Professional.
MySQL Core
The Core certification is for folks who use MySQL for more than
150 hours per month to perform simple queries, or who have to import
large amounts of data into an existing installation. Some advanced
information is covered as well. This includes some of the MySQL
extensions to the SQL standard syntax, as well as intermediate WHERE
and JOIN clauses.
Read
The Whole Article
MySQL
Adds High-End Enterprise Features to Database
IDC Canada, meanwhile, conducted a survey during the first quarter
about the adoption of open source databases. Its findings show that
18 percent of IT respondents across multiple industries said they've
deployed an open source database, and 10 percent may deploy one
over the next year.
Swedish open source database, MySQL, plans to unveil a new software
feature and partner program, raising the question about how well
it's faring against proprietary database sellers.
Read
The Whole Article |
NetIQ
and Idera Form Alliance to Deliver SQL Server Management and Administration
Solutions
Exclusive Technology Licensing, Development Partnership, Distribution
and Support Agreements Highlight Alliance
NetIQ Corp. (Nasdaq:NTIQ), a leading provider of Systems & Security
Management and Web Analytics solutions, and Idera, a leading provider
of management and administration solutions for Microsoft SQL Server,
today announced a strategic alliance highlighted by an exclusive
technology licensing, distribution and support agreement. As a NetIQ
technology partner, Idera will collaborate with NetIQ in identifying
opportunities to further integrate Idera's SQL Server management
tools with NetIQ's systems management products.
Read
The Whole Article
Understanding
SQL Performance Counters
SQL Server 2000 does a good job in optimizing using the present
hardware setup. But more often than not it becomes important for
DBA's to analyze how healthy SQL Server is from time to time. No
wonder DBAs get paid really good all around the world.
In this article I would list some of the interesting counters you
can ping to get the health on various parameters of SQL Server.
These are not the exhaustive list and it is not possible to enumerate
all in one go. Use Perfmon tools to get these parameters logged.
Read
The Whole Article
Computing
Percentiles in SQL Server
Say you score 570 on the verbal section of the SAT. How well did
you do? According to the College Board, 570 falls into the 71st
percentile. This means you did better than 71% of the other students
who took the test. Percentiles are a useful way to present rankings
among a large population. You may want to add percentiles to reports
you produce with SQL. This article by Bob Newstadt shows how to
calculate a percentile for a given group of scores. It also covers
finding a score for a given percentile.
By definition, a percentile is the score at or below which a particular
percentage of scores fall. The code given here was tested on Microsoft
SQL Server 2000. Using SQL may be the wrong tool for the job if
the number of data points is very large. An alternative is to use
Analysis Services which provides access to EXCEL worksheet functions
for use in MDX queries.
Read
The Whole Article
Publishing
SQL Server in Active Directory
If you've noticed the Active Directory tab under SQL Server Properties
in Enterprise Manager, you might have wondered how Active Directory
(AD) relates to SQL Server and what the benefits are of adding SQL
Server and its databases to AD. Network services such as file and
printer servers use AD to publish and store network resource information.
AD contains a list of user accounts and a directory of available
network resources.
Because AD considers SQL Servers and SQL Server databases to be
network resources, you can list them in AD. In SQL Server 2000,
Microsoft introduced the concept of publishing (i.e., listing) both
SQL Server and its databases in AD on a Windows Server 2003 or Windows
2000 domain.
Read
The Whole Article
Read this newsletter at:
http://www.sqlpronews.com/2004/0525.html |
|
 |
|
