Security
Automate Security Analysis and
Entitlement Reporting
Idera announced SQLsecure, a new security analysis solution for SQL Server
implementations. The software identifies users who have inappropriate access rights
and permissions, eliminates security holes and weaknesses, and monitors changes in
access rights to ensure compliance. SQLsecure gathers a picture of your entire SQL
Server environment and settings and provides tools for analysis and reporting. You
can review and audit all SQL Server access controls, security-related properties, and
integrated Windows security across computer, network, and Active Directory (AD) settings. SQLsecure costs
$995 per SQL Server
instance. For more information, contact
Idera at 713-533-5144, 877-464-3372,
or http://www.idera.com.
Technical Resource
SQL Server 2005
Integration Services
Resource
Sams Publishing released "Microsoft SQL
Server 2005 Integration Services" by Kirk
Haselden, development manager for Microsoft's SQL Server Integration Services (SSIS). The book
provides
real-world
solutions to
real-world
problems. If
you're new
to SSIS,
the beginning chapters include
"Setting up
Integration
Services"
and "Basics and Concepts." For more complex concepts,
you can delve deeper in chapters such as
"Control Flow Services" and "Management
Services." The 744-page book costs $59.99;
a downloadable Adobe Reader PDF version
is available for $43.19. For more information, contact Sams Publishing at http://www.samspublishing.com.
Reporting
Migrate Crystal
Reports to
Reporting Services
dataReference announced that
Report Migrator works in conjunction with SQL Server 2005
so that you can migrate Crystal
Reports output into Report
Definition Language and run the resulting reports through SQL Server
2005 Reporting Services. With Report
Migrator, you can continue to use Crystal
Reports Designer to develop reports, but
you can distribute the reports through
Reporting Services. This functionality maintains your investment in report design
and gives you the flexibility to distribute
reports across your organization without
retraining your development staff. For more
information, contact dataReference at 214239-0820, 866-489-4512, or http://www.datareference.com.
Performance Monitoring
Quest Releases .NET
Application Management
Solutions
Quest Software announced two .NET
application management solutions that help
discover, diagnose, and resolve .NET application performance and availability problems. Quest Management Pack for .NET
works with Microsoft Operations Manager
(MOM) 2005, and Foglight for .NET
is part of Quest's Application Advantage
strategy for managing complex application
environments and expands to monitor and
manage .NET applications. Both solutions
proactively monitor your applications and
inform you of impending performance and
availability problems. For more information,
contact Quest Software at 949-754-8000 or
http://www.quest.com.
Development
Manage .NET Application
Life Cycle
Lattix announced Lattix LDM for .NET, a
tool that uses the Lightweight Dependency
Model approach to analyzing the architecture
of your .NET applications. Lattix LDM for .NET lets you analyze .NET application
architecture in detail, edit the structure to
create test scenarios, and specify design rules
to formalize and communicate the design
structure to others. The tool provides a high-level view of your architecture and lets you
drill down to a subsystem and examine code
associated with its dependencies. The product
can also remove unwanted dependencies and
rename subsystems. Lattix LDM for .NET
starts at $495 for the Professional Edition.
For more information, contact Lattix at
978-474-5022 or http://www.lattix.com.
Database Management
Visualize What's Happening
Within Your Database and
SQL Code
Killer Bite Software announced SQL Visualizer, a Windows client–based database query
and management tool that lets you navigate
around your database objects and visualize
what's happening within your database and
SQL code. The software searches for database
objects and content across multiple databases
and servers and is able to override server
connections properties at the database level. You can also view the history of previously
executed queries, which are maintained
between sessions. SQL Visualizer features
IntelliSense, custom object scripting, data
scripting, code snippets, and code regions.
SQL Visualizer is a free download. For more
information, contact Killer Bite Software at
http://www.sqlvisualizer.com.
Business Intelligence
Integrated BI Solution for
SQL Server 2005 and 2000
XMLA Consulting announced ReportPortal 2.1, an integrated business intelligence (BI)
solution that provides
analysis, reporting, and
advanced data visualization features for SQL
Server 2005 and 2000.
ReportPortal is a client
application for Microsoft SQL Server 2000
Analysis Services that
lets you build, publish,
and view a variety of
reports, including OLAP,
data-mining, and SQL
Server 2005 Reporting
Services reports. The latest release includes a tree map and pie-chart tree, bar-chart tree, geographical map
chart, and dashboard reports. For more
information, contact XMLA Consulting at
813-866-3483 or http://www.reportportal.com.
Database Comparison
Compare and Synchronize Databases and Schema
TulaSoft announced SQL Examiner 1.5
and SQL Data Examiner 1.1, which compare and synchronize SQL Server database schemas and SQL Server databases,
respectively. SQL Examiner compares
the schema of two SQL Server databases
and locates the changes in tables, views,
stored procedures, and any other object in the
database. When you use SQL Examiner with
SQL Data Examiner, you can also compare
and synchronize data differences between the
two databases. And now, SQL Examiner can
compare and synchronize Common Language
Runtime (CLR) objects that SQL Server 2005
supports. Pricing for SQL Examiner and SQL
Data Examiner starts at $199.95. For more
information, contact TulaSoft at http://www.sqlaccessories.com.
End of Article
