___________________________ Sponsors ________________________________
ISPCON Spring 2008
_____________________________________________________________________
*********************************************************************
Database Journal Newsletter - Monday, February 04, 2008
The Knowledge Center for Database Professionals
http://www.databasejournal.com/
All newsletters are sent from the domain "internet.com." Please use this
domain name (not the entire "from" address, which varies) when configuring
e-mail or spam filter rules, if you use them.
*********************************************************************
FEATURES
*********************************************************************
1. MDX Numeric Functions: The Min() Function
February 4, 2008
Business Intelligence Architect Bill Pearson introduces the numeric
Min() function, and leads hands-on practice examples of its use.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,715f,6jjq,i4sg,hysn
------------------------------------------------------------
2. Storing Images and BLOB files in SQL Server Part 2
February 1, 2008
Part two of this article focuses on using the SQL Server Binary data
type to store small image files.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,9ou,5hji,i4sg,hysn
------------------------------------------------------------
3. Parameter Support Objects, Pt II: Support OLAP Parameter Defaults
with Datasets
January 31, 2008
Join BI Architect Bill Pearson as he continues his examination of
parameterization within Analysis Services reports. In this article,
we provide a solution for supporting parameter defaults that
represent the last periods of data entry within our cube.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,fvv9,c39h,i4sg,hysn
------------------------------------------------------------
4. Building Custom Reporting Services Reports for SQL Server Management Studio
January 30, 2008
Learn how to build Custom Reports, without installing Reporting
Services, using a new feature found in Microsoft Service Pack 2 (SP2)
for SQL Server 2005.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,5oet,lpqx,i4sg,hysn
------------------------------------------------------------
5. Oracle Database 11g: SQL Plan Management, Part 1
January 29, 2008
This article - the first in this series - provides a primer to SQL
Plan Management principles and offers a simple demonstration of its
performance tuning capabilities.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,cyso,2b5x,i4sg,hysn
------------------------------------------------------------
6. Designing N-Tiered Data Access Layer Using Datasets - Part 3
The Dataset Editor in Visual Studio 2005 assists in the design of a
data entity structure and generates a set of classes that meets the
requirements of a good object relation mapper (ORM). This article
shows the code that needs to be added to provide tier separation and
how it can easily be generated automatically.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,1ust,d4sg,i4sg,hysn
------------------------------------------------------------
7. Working Around ASP.NET's HyperLink ImageUrl Bug
This article, by Donnie Hale, examines a bug in the HyperLink's
ImageUrl property when using URL rewriting, and examines a workaround.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,hcen,b57n,i4sg,hysn
------------------------------------------------------------
8. Microsoft Releases Service Pack 1 for .NET Framework 2.0 and 3.0
Last week, Microsoft quietly released .NET Framework 2.0 Service Pack
1 and .NET Framework 3.0 Service Pack 1. If your servers aren't
configured to install updates automatically, now might be a good time
to check and make sure you're up to date.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,h1qc,1mrm,i4sg,hysn
------------------------------------------------------------
*********************************************************************
/-------------------------------------------------------------------
ISPCON Spring 2008 - May 13-15, 2008, Chicago, IL
ISPCON is where the service provider industry goes to
GET REAL about the future of their businesses.
Whatever your plans, ISPCON will help you GET REAL
about them. This is the industry's only forum where
peers learn from peers in real one-on-one discussion
about what works, what doesn't and what's next.
GET REAL! Get to ISPCON!
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,mfve,hfpd,i4sg,hysn
--------------------------------------------------------------adv.-/
*********************************************************************
NEWS
*********************************************************************
1. LINQ to SQL: returning multiple result sets
February 4, 2008
As you probably know LINQ to SQL supports stored procedure (SP). You
can drag&drop a SP in the LINQ to SQL Designer and the magic happens:
a new method inside the DataContext class is generated and a new
return type is defined...
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,4x6z,bfeb,i4sg,hysn
------------------------------------------------------------
2. Navicat MySQL GUI Manager v.8.0.23 is released
February 1, 2008
Navicat MySQL GUI Manager ver. 8 is the latest iteration of the
database management tool...
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,10n4,lxkf,i4sg,hysn
------------------------------------------------------------
3. PHP 4 is Dead -- Long Live PHP 5
February 1, 2008
PHP 4 hits its end of life this year as developers push users to PHP 5.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,d7ra,c991,i4sg,hysn
------------------------------------------------------------
4. Oracle on the psychology of patching
February 1, 2008
Oracle has a belated reply to a survey a few weeks back on how
database administrators have never installed one of the company's
critical patch updates.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,iwp7,58nj,i4sg,hysn
------------------------------------------------------------
5. Sometimes a variables table is better than hard coding into a package
January 31, 2008
When writing PL/SQL packages, there are times where it's better to
store a variable in a table instead of coding it into the package.
It's most useful for a variable that you might want to change fairly often.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,6pgd,l1du,i4sg,hysn
------------------------------------------------------------
6. IBM Expands Data Warehousing Portfolio With Optim Technology
January 31, 2008
IBM today introduced new software that allows businesses to better
manage the growth of information by integrating data warehousing and
archiving capabilities.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,fv1y,160n,i4sg,hysn
------------------------------------------------------------
7. Oracle users fret over forced migration
January 30, 2008
Users fear that Oracle will ultimately force them to migrate to
Oracle-built software, according to a survey...
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,c4cj,82l,i4sg,hysn
------------------------------------------------------------
8. Another Amazon 'cloud' database, but this one will be Oracle-compatible
January 30, 2008
Upstart EnterpriseDB says it will start testing an online version of
its software in March.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,8l6x,6gdq,i4sg,hysn
------------------------------------------------------------
9. Active data warehousing explained and examined
January 30, 2008
Business intelligence (BI) is becoming an important part of more
organizations' day-to-day operations, and active data warehousing is
a prime enabling technology.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,3ir5,7pz,i4sg,hysn
------------------------------------------------------------
10. Microsoft's Lineup of SQL Server Related Webcasts for February 2008
January 28, 2008
Ten new webcasts are scheduled for February, covering such topics as
"Security Enhancements in SQL Server 2008", "SQL Server 2008 and Your
Microsoft Certifications" and more.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,fpnb,cv4,i4sg,hysn
------------------------------------------------------------
11. Oracle Releases Oracle's JD Edwards EnterpriseOne Tools 8.97
January 28, 2008
This latest release provides an open platform for customers to choose
hardware, operating systems and database technologies based on their
unique IT strategies and business requirements.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,drom,5ojt,i4sg,hysn
------------------------------------------------------------
*********************************************************************
SQL SCRIPTS
*********************************************************************
1. Script: Database Defragmentation
February 4, 2008
Over a period of time, because of the inserts, updates and deletes,
the data and the index pages can get fragmented. Here's a script that
can help to defrag the database.
http://nl.internet.com/ct.html?rtr=on&s=1,3rha,1,gyls,2v5k,i4sg,hysn
------------------------------------------------------------
*********************************************************************
You are subscribed to the Database Journal newsletter as dohubs@gmail.com. To unsubscribe from Database Journal please go to:
http://member.internet.com/unsubscribe.php?type=NL&uid=ce8c0cca67&rid=1755
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Newsletter Subscription Dept.
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This email is powered by EmailLabs (http://www.emaillabs.com)
Contact us for a FREE demo
No comments:
Post a Comment