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...
blog
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...
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...
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...
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...
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...
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...
Top 3 Development Environments for PostgreSQL
PostgreSQL is an object-relational database management system (ORDBMS) supporting extensibility and standards-compliance. Just like any...
Knowing Your Storage Basics – 2 Life Lessons
In the software world, it is often the case where everyone wants to learn and master everything. The problem with this approach is that we land into...
Holiday Time Resources
Have a little free time over the holidays while providing coverage for work, or like to brush up on technical information? In addition to the many...
Proof of Concepts made Easy with The Cloud
As a Solutions Architect, there are times when you actually need to replicate customer scenarios, often becomes a challenge, unless you have your...
Consistent Data in Distributed Systems
This is a video replay from the DataU online conference. Data types that are not consistent across multiple systems where data movement occurs could...
Integrated cross-platform SQL IDE for increased database development efficiency
Have you ever wanted a SQL IDE that would help you code SQL for multiple platforms using a Single IDE? Now you can! with Embarcadero's RapidSQL...
2 Ways to identify that we have a bad plan in SQL Server
SQL Server is a complex RDBMS with a lot of capabilities in it. I am sure most of us have just scratched the surface when it comes to working with...
3 soft skills that you want to have in an interview
It was couple of years back that my friend had written this article on my blog - Interview Questions and Answers – Perspectives of an Author. I know...
Top 3 Sample Databases for PostgreSQL
If a developer is attempting to learn a new process or test some code, it’s best to utilize a test environment such as a sandbox rather than the...
The #1 Data Modeling Issue – Being ‘Dead’ Right – By Len Silverston, Universal Data Models, LLC
While many data modelers are very open minded and not righteous at all in their attitudes, over the years, I have heard the following statements...
How to Connect your Applications to your Data
This is a video replay from the DataU online conference. An Application Programming Interface (API) brings your own applications closer to your...
Cloud Databases – A Primer
Ever since the era of Cloud Computing featuring SaaS(Software as a Service) pioneered by Salesforce, Databases have not been left behind. Databases...
Exploring Microsoft SQL Server System Databases
The Microsoft SQL Server System comprises of four key System Databases master model msdb and tempdb The following table outlines the key points...
Empower your Applications with Embarcadero Team Server APIs
The Team Server REST Application Programming Interface (API) allows one application to talk to another application directly and securely. Team...
Result Cache Using Rapid SQL
Hi! The Result Cache is a newer structure for Oracle11 and newer databases. This feature remembers the invariables and return...
Oracle 12 New Limits
Hi! I’ve been working on PL/SQL topics and wanted to share with you a new Oracle12 feature. Oracle12 now allows for much longer...
3 Things You Didn’t Know About Black Box Trace
Black Box Trace In earlier versions of SQL Server, there have been situations where root cause analysis was never possible because data saved by SQL...