schema

Solution Search:
IBM Optim Database Administrator by IBM
Learn how IBM information management software can assist you in managing change in dynamic application and database environments. Changing database schemas...
Faster Application Development via Improved Database Change Management by Embarcadero Technologies, Inc.
Change Manager™ puts the power of change tracking, schema comparison, software-generated synchronization scripts, and flexible reporting into the hands of the development team. From...
Performance and Scalability Benchmark: Oracle Communications Billing and Revenue Management on Sun SPARC Enterprise T5220 and M8000 servers running the Solaris 10 OS by Sun Microsystems, Inc.
with a single instance of Oracle Database and multi-schema Oracle RAC on Sun SPARC Enterprise servers running Solaris 10. Oracle Communications Billing and Revenue Management (BRM) on Sun...
Configuring Security in SQL Server by Global Knowledge
such as Server Security, Database Security, Schema Security and Object Security. Configuring access to SQL Server data and features is an important part of every DBA's job, but one...
JSON SOA-based Client/Server Application Development by The Ajax Experience
44; including Service Mapping Description (SMD) and JSON Schema, to quickly integrate JSON sources and develop applications using decoupled services for scalable high-performance...
ChangeAuditor for Active Directory by ScriptLogic Corporation
changes in real-time. From Group Policy Objects (GPO) and Schema changes to critical nested group and operational changes, ChangeAuditor tracks, audits, reports and alerts on the changes that...
A Metadata Management Strategy Checklist: What Metadata Really Matters? by Pervasive Software
Metadata is the essential blueprint for what data a company has, what it means and where they can get it. Without clear accessible metadata, an enterprise could...
SQL Server Resource Center
Solve SQL Server errors and more from the DBA trenches -- part 2
Application installed a proc called SchemaName.ProcName under a schema other than dbo, and now needs to be changed.

Resolution: Run "ALTER SCHEMA dbo TRANSFER... More...

Nov 13, 2008
Implementing security audit in SQL Server 2008

ADD (DATABASE_OBJECT_CHANGE_GROUP),
ADD (SELECT, INSERT, UPDATE, DELETE
ON Schema::HumanResources BY dbo)
WITH (STATE=ON)

In the first line of the CREATE DATABASE AUDIT... More...

Nov 11, 2008
Tutorial: Learn SQL Server basics from A-Z
Server permissions on a more granular basis. Get an an overview of user-schema separation and granular server permissions, as well as a new function to help you... More...
Nov 6, 2008
New datetime data types in SQL Server 2008 offer flexibility
AdventureWorks2008
GO
IF EXISTS (SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'Sales'
AND table_name = 'OrderDates')
DROP TABLE Sales... More...
Oct 21, 2008
SQL Related Articles
Saying yes, no or maybe to stored procedures by Jack Vaughan, Site Editor
that stored procedures provide is an abstraction layer between the schema and applications that access the database. It is almost impossible to refactor the schema without it. That abstraction layer can be... More...
Aug 16, 2006
Minding the data and databases by Steve Lemme, Contributor
A data architect has responsibility for: Creating data models and schema that meets the business requirements Change management and control of the data models Assisting with optimization of models for... More...
Jul 20, 2006