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...

Overlapping Filter Application?

How do overlapping filters get handled by Compliance Manager. For example, I want a general filter that brings in anything from domainuser1 for all sql servers, but I also want an additional filter on a single SQL Server to also bring in only entries from domainuser2...

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...

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...

The DBA and Developer Career Tips eBook

The DBA and Developer Career Tips eBook

The DBA and Developer Career Tips eBook Author:Pinal Dave Like in any profession, DBAs and developers face competition in the workforce for job opportunities, promotions and prestige.  Getting and staying on top of your game is critical. Are you...

What You Know but Don't Know

What You Know but Don't Know

How To Know What You Don’t Know - Path to the DBA World As a new DBA to a company it can be overwhelming and sometimes confusing on knowing where to start and whom to approach. One is tasked to managing and administering databases either from a new environment or...

What You Know but Don't Know

Congratulations You're a DBA…Now What?!

This is a guest article by SQL Server MVP Mike Walsh (www.straightpathsql.com | www.linchpinpeople.com), based on an Embarcadero sponsored webinar by Mike Walsh and John Sterrett (www.johnsterrett.com). Introduction Being a DBA can be challenging and frustrating....

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...

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....

Updating SQL Elements health check intervals

Periodically when I am speaking to users of SQL Elements I receive a request related to changing the interval at which health checks are run for individual servers. The reasons are varied: some people want to get health checks more frequently, but quite often they...

Beginning Joins with SQL

Beginning Joins with SQL

Introduction When we are talking about relational database, we are usually talking about many different tables and the relationships between them. We define relationships with various keys like primary key, foreign key, etc. When we have to retrieve data from more...