Original Broadcast: 3.19.2014 Databases only perform as well as the systems they run on. Designing a system to power a true high performance database requires design choices that offer extreme performance, interoperability, availability and specific knowledge of tuning parameters that help streamline the operation of the database. The engineering resources and expertise required to design…

Original Broadcast: 3.19.2014 Databases only perform as well as the systems they run on. Designing a system to power a true high performance database requires design choices that offer extreme performance, interoperability, availability and specific knowledge of tuning parameters that help streamline the operation of the database. The engineering resources and expertise required to design…

Abhinav discusses how unsuccessful or delayed BI implementations are most often attributed to an improperly modeled repository not adhering to basic dimensional modeling principles.

Abhinav discusses how unsuccessful or delayed BI implementations are most often attributed to an improperly modeled repository not adhering to basic dimensional modeling principles.

Today’s organizations are subject to greater and greater demands for auditing and compliance; including SOX, HIPAA, PCI and a host of other external requirements. Learn how change tracking techniques can help you identify and track database changes and build a database for use by auditors. Eligible for Certificate: #IOUGeniusCert; #IOUGeniusSecure   Info: www.collaborate.ioug.org/certificates

"Security breaches, we have all heard they happen and how they can affect an organization and how expensive it can be when they do happen not to mention reputation damage.  Well know security breach happened from DBA credential being comprimized.  What can we do, what options do we have?  This presentation will start with the…

"Today’s organizations are subject to greater and greater demands for auditing and compliance; including SOX, HIPAA, PCI and a host of other external requirements. Learn how change tracking techniques can help you identify and track database changes and build a database for use by auditors.Eligible for Certificate: #IOUGeniusCert; #IOUGeniusSecure Info: www.collaborate.ioug.org/certificates  "

Recently we had a customer who wanted to have read only access to all tables in a schema, even tables not created yet. Apparently in Microsoft SQLServer, there is a way to grant a user schema permissions and includes objects not created yet. THis quick-tip presentation will demonstrate how to setup and deploy permissions to…