Project Management in Rapid SQL - DBA and Developer Skill Sprints In this Skill Sprint, Scott Walz covers how to manage projects in Rapid SQL. This functionality is also available in DBArtisan. Learn how to create a new project and intialization options (from a database, existing file or version control). Then learn about the wizard options and how to complete the project setup. Then learn how to work with the project including Build Order, creating new Subfolders, adding files and objects, working with version control, updating project properties and more. ...
Resurrection of SQL with Big Data and Hadoop Did you really think that SQL was going away? Attend this session to learn how SQL is a vital part of the next generation of data environments. Find out how you can use your existing SQL tools in the big data ecosystem. This is a video replay from the DataU Online Conference. Click here to watch 15 more videos from the DataU series.Click here to learn more about DB PowerStudio. Oz Basarir is the product manager of Embarcadero's database management and development tools. Having worked over th...
The Top Productivity Solution for DBAs Why has Monster Energy drink become standard operating equipment for DBAs? Join us for a hard-hitting look at the state-of-the-union for DBAs, what to expect in the future and caffeine-free ideas for short-term success. This is a video replay from the DataU Online Conference. Click here to watch 15 more videos from the DataU series.Click here to learn more about DB PowerStudio. Wes Kranz currently serves as the Sr. Director of Database Products at Embarcadero. He has a passion for making lif...
Managing Database Security and Compliance When managing database security and compliance, the DBA can't take a chance on anything falling through the cracks. In this session, you'll learn how to set up a change control process for your databases that will provide the coverage needed to ensure your environment is staying in compliance. This is a video replay from the DataU Online Conference. Click here to watch 15 more videos from the DataU series.Click here to learn more about DB PowerStudio. Scott Walz has more than 15 years of exp...

Posted by on in SQL Development
Solving Performance Problems on Oracle DB DBAs and database developers regularly spend a lot of time tracking down and resolving performance issues on the database servers they are responsible for; it can be very difficult, frustrating, and expensive. Given the complex interactions of applications, users and databases, new performance issues can arise almost as fast as old ones can be addressed. This session will simulate common performance problems on an Oracle server and then both identify those problems and provide effective solution...
Bind Variables and Application Performance Not many people are familiar with Bind Variables or how they can be used. Find out how bind variables can be used effectively to make your SQL perform more efficiently and why they can achieve this performance. This is a video replay from the DataU online conference. Click here to watch 15 more videos from the DataU series.Click here to learn more about DB PowerStudio. Walter Couto is a Software Development Manager at Embarcadero Technologies for the Embarcadero DB Power Studio family of pro...
Achieving Database Schema Compliance at a UK Finance Institute The requirement to maintain and prove schema compliance within the organization's database inventory continues to expand. The key objective is to discover and report on schema anomalies in the production database landscape. The use of DB Change Manager enables comprehensive schema checks to run baseline schema snapshots against the production databases to easily highlight discrepancies and enables the DBA team to act rapidly to resolve any critical issues. This is a video replay from the DataU o...
Solving Common DBA Tasks at a Leading German Bank with DB PowerStudio A leading German bank uses DBArtisan to manage hundreds of databases in their organization. This case study will show how many common DBA tasks are solved using DBArtisan at large enterprises and how DBAs perform these tasks to keep the database operational, such as configuring the database, managing memory and storage, managing security, managing database objects, and more. This is a video replay from the DataU online conferenc. Click here to watch 15 more videos from the DataU series.Click he...
Documenting Your Data Landscape For The Organization When it comes to making informed decisions, data is the most critical asset an organization possesses. In this session, you'll see how to create documentation of organizational data, which is easily understood and readily available to anyone within the organization. Click here to watch 15 more videos from the DataU series.Click here to learn more about ER/Studio. Rob Loranger is a Sr. Software Consultant and Associate Product Manager for Embarcadero. Although he currently focuses his time ma...
Getting Physical - Using automation to build robust, high-fidelity schemas from your logical models High-fidelity database schemas capture essential business rules and help ensure data quality, but can be very time-consuming to produce and maintain. Enterprise-grade data modeling tools excel in automating the construction and maintenance of robust database designs from logical models. Learn how to leverage tooling and automation to build and manage consistent, high-quality database schemas from your logical models..  Click here to watch 15 more videos from the DataU series.Click here to ...

Check out more tips and tricks in this development video: