|
News |
|
|
CONSOLIDATED
DATABASE HEADLINE |
|
|
Calendar of Events |
| M |
T |
W |
T |
F |
| 3 |
4 |
5 |
6 |
7 |
| 10 |
11 |
12 |
13 |
14 |
| 17 |
18 |
19 |
20 |
21 |
| 24 |
25 |
26 |
27 |
28 |
|
|
|
|
|
|
|
C . D . H
EDITORIAL |
|
|
|
 |
|
Welcome
to the first edition of SQLPASS Midwest Regional Group website's CDH
[Consolidated Database Headline] news section. We appreciate the readers &
participants to share what you thought as a DBA we could and should do to
secure database systems in the organization.
As SQL-SLAMMER slammed Microsoft SQL Server community,
Microsoft’s initial captivated measure from last July security hot-fix
looked vulnerable itself. Although some of us could choose to ignore security
hot fixes as they're released before; now you can bet perhaps the world of
Internet security will take a different priority in Database Admins’ world.
As per blame game and user friendliness of Microsoft we really need to
thank those developers who worked the Slammer weekend to put together Hot-FIX
streamline install. As Brian Moran’s apology article and some of our
confusion about not having a MSDE fix for this Slammer fades away, definitely
last month will be remembered as a 9-11attack in SQL server history book.
Finally
Our production web-site is launched. We still have some finishing touch to
get done with. At this time we are still recruiting for our contributing
editorial sections. If any of you are interested please feel free to send a
request to any of our management members. Their contact information could be
found in http://www.sqlpass-mrg.org
in the about us section.
If you are someone who see yourself to be in the DBA market anytime soon
please feel free to apply for a membership also. Our this months full
members meeting was a huge hit for membership drive. Have a great
month everyone.
Until
next time, see you on Net
Satya
Shyam K Jayanty
|
|
SQL
Server 2005: Late but Loaded
By Brian Moran Two weeks ago, I wrote about
the delay of SQL Server 2005, formerly code-named Yukon. Microsoft
has pushed
back
commercial availability of SQL Server 2005 to the first half of 2005 ...
[more]
[Click
Here to Read More...] |
An
ASP Class for XML Data Transfer
By Seth Juarez - Hey, I wrote the "A
Couple of ASP Functions for XML Data Transfer" functions and,
as any self-respecting programmer, was unhappy with its stiffness.
I decided enough is enough and created an actual class that handles
more things..
[Click
Here to Read More...]
|
|
Import
multiple Files to SQL Server using T-SQL
By Muthusamy Anantha Kumar - In a typical
IT environment, it is often necessary to import flat files to SQL Server
tables. Sometimes
it is necessary to import many files at the same time, from the same
or different folders..
[Click
Here to Read More...].
|
Tunneling Variables
by Bob DuCharmet - While coding
for a large, complex stylesheet project at work last year, I wanted to
reuse code that I had already written elsewhere in the same template
rule.... [more]
[Click
Here to Read More...] |
|
Microsoft
Application Center 2000 - An Introduction
By Sujith K. - CLUSTERING technology,
which allows multiple stand-alone computing systems to function as
a single
virtual machine, has become a powerful ally in the fight for e-commerce..[more].
[Click
Here to Read More...] |
Microsoft Research (MSR) Cambridge was the first Microsoft
research laboratory to be established outside the United States.
It was set up in July 1997 with three researchers. Today, 55
researchers, mostly from Europe, are engaged in computer
research at the lab.
Read
the full story....
|
|
|
|
|
The Endowment also organizes a tutorial
series to disseminate basic and advanced knowledge related
to the field of database management to the developing nations
worldwide.
 The
library program
provides libraries in developing countries, who ordinarily would
not be able to afford to subscribe to the VLDB Conference
Proceedings and The VLDB Journal, with this valuable material in
order to support database research.
The VLDB Endowment is governed by a Board
of Trustees consisting of 21 members.
Useful
Documents: Code
of Regulations - Conference
Guidelines - PC
Guidelines (old
version) - Organizers
Kit - Sample Plan
Changes
in the VLDB Conference PC Structure
The
DBLP Computer Science
Bibliography is mirrored
on this server.
[Click
Here to Read More...]
|
Finding
the index that enforces a primary key constraint
By Donald K. Burleson - One of the most
confounding issues with Oracle is the underlying indexes that are used
to enforce a unique constraint. In Oracle9i, the index can be dropped
and managed separately from the constraint, but we still need a script
to quickly locate the index that used by the unique constraint...
[more]
[Click
Here to Read More...]
Auditing Oracle Data
By Michael Klaene - Auditing data of business
applications is a common requirement. In this article, I'll demonstrate
one way to audit Oracle data that is both simple and flexible. The
code is written in Oracle PL/SQL... [more]
[Click
Here to Read More...]
A tablespace-full alert script
By Donald K. Burleson - Here is a great
script to alert the DBA whenever a tablespace grows beyond 95% full.
This script can be run with a Unix cron every tem minutes, and send
a pager alert or e-mail to the DBA whenever a data file is needed for
a tablespace..
[Click
Here to Read More...]
|
|
|
|
|
SQL
Server Service Pack 3 - Behind the Scenes
Ron Talmage PASS Community News Co-Editor President, Pacific Northwest
SQL Server Users Group
DBA
101 - Intro to XML
If you've spent
any amount of time in the IT industry, you have undoubtedly heard the term
"XML." But what is XML? And how does it relate to databases? And
why must everything have an acronym?
KB
Alerts
Microsoft has
updated and/or revised a very large number of Knowledge Base articles
during the months of December and January.
Product
Reviews - Web
Seminars Schedule - SQLMAG
Performance Portal
SQL
Server Magazine University To register: call 1-800-793-5697 or
1-970-663-4700. |
Slam
the Door on the SQL Slammer
Review Microsoft's latest security
bulletin about the SQL Slammer worm and download the fix to update your
systems
After
the Slammer
A worm called
SQL Slammer began spreading rapidly around the world January 24,
attacking systems through vulnerability in SQL Server 2000.
SP3
Adds Security Option for Cross-Database Ownership Change
SQL Server 2000
Service Pack3 (SP3) provides an enhanced security-related option for
configuring cross-database ownership chaining during setup: "Enable
cross-database ownership chaining for all databases." By default,
this option is disabled, and Microsoft recommends that you use the
default option because it makes your database server more secure.
Past,
Present, and Future
Michael Otey
revisits SQL Server’s six major releases, then looks to the future and
the upcoming Yukon release.
New
Language
None of SQL
Server’s upcoming programming-productivity enhancements will have more
impact on DBAs than the .NET Common Language Runtime (CLR). This new
capability begs the question, “Which .NET language should DBAs
learn?”
.....click here to see More
Articles
|
SQL
Anywhere Studio and .NET
Microsoft .NET is an XML-based Web
services platform which allows applications to communicate and share
data over Internet protocols, regardless of operating system, device, or
programming language.
e-Business
Platform
Sucess stories
- The promise of e-Business, in essence, is its potential to enable
companies to reduce costs, increase business agility, and enhance
customer loyalty. With broad-scale distribution of information,
processes, and e-commerce over a relatively low-cost and ubiquitous
medium, the possibilities for creating new sources of revenue, stronger
customer and supplier relationships, and more productive employees seem
unlimited.
SYBASE
Developer Network (SDN)
Use your SDN
account to experience the Enterprise Portal 5.0 demo! Explore the
completely redesigned portal interface and build your own portlets using
the new Portal Studio |
|
|
|
|
|
|
|
|
|
