|
SQL Mail vs. Database Mail
by Charles Tournear, Sr. Consultant,
MCT, MCSE, MCSD, MCDBA,
CRCP
SQL Server 2005 supports the SQL Mail service that came with SQL 7.0 and SQL
2000, but it also comes with a new component - Database Mail. Both allow you
to have SQL Server send emails as the result of a SQL Server Agent job process
or a SQL Server Notification Service process.
Also you can use stored procedures to send emails or email the results of
a query to users.
Read the full article...
|
Business Objects Enterprise |
Who Needs SQL?
by Kristen St. Jean, Sr. BI Consultant, CRCP
Many times we find ourselves needing quick answers that can
only be found by creating complex joins and writing complex SQL to extract the
necessary data from our database.
Not only is this time consuming, but creating complex SQL statements is not a
skill that all business users possess.
In order to make this process simpler and more efficient, Business
Objects has created Universes.
Read the full article...
|
Report Optimization Techniques
by Aaron Zechman, BI Consultant, MCSE
Have you ever had a report(s) that
runs longer than you think it should and only have read only access to the data
you are pulling back? There are two
categories of techniques that should be able to help you out in regards to
helping speed up your reports.
Read the full article...
|
Microsoft Business Intelligence
|
Understanding Microsoft SharePoint
by Michael Mullin, Consultant, MCAD
There is a lot of confusion among general users about SharePoint. Since
SharePoint is a key item in Microsoft’s BI product stack and is also tightly
integrated with the Office System, it is best that the user have a familiarity
with it. You will be hearing more about it. This article will give a very brief
introduction.
Read the full article...
Communication Between CMS's
by Joe Roberts, Sr. Consultant, BECP
Last month we talked about the CMS
start up procedures and how it affects the Enterprise system, especially
in relation to CORBA and the registration of services. This month
I want to go a little more in depth concerning how CMSs communicate
with each other in a clustered environment.
Read the full article...
|
