Backup is one of the driest topics and it seems to be something non-negotiable for a DBA role. If we look into the fine prints of why someone should...
Understanding Database Backup Strategies by Pinal Dave
read more
Tim DelChiaro
5 Common Mistakes Every Database Developer Must Avoid
Being a developer is an awesome experience – trust us. You are an architect and the builder of your dreams. A developer shapes the way the...
Big Data the BuzzWord by Pinal Dave
The talk of the town these days is around Big Data if you are in a data-related domain. Most of the top CIOs are trying to get onto this bandwagon...
5 Things Developers Must Know for Working with their Databases
This article by Pinal Dave looks at some of the developer traits that one must keep in mind while working with databases Being in the databases...
Auto Replace in Rapid SQL by Dan Hotka
Hi! Dan Hotka here with more knowledge about Rapid SQL. I’ll address the auto replace feature of this tool and how you can use this feature to...
Rapid SQL Query Builder Tips and Techniques by Dan Hotka
Hi! Don’t you just love a good SQL query builder? I found this tool in Rapid SQL easy to learn and easy to produce the SQL I desired. You start it...
Mission Impossible? Effective Database Backup Strategies
Mission Impossible? Effective Database Backup Strategies Organizations use multiple strategies when working with backups. An effective restore...
SQL Syntax in Rapid SQL by Dan Hotka
Abstract: Guest blog post from Dan Hotka, Oracle ACE Hi! Wouldn’t it be handy to have some Oracle documentation such as SQL syntax right at your...
3 Leadership Tips defining Success
Every individual has their own set of leaders they look up to in their daily life. I am sure each and every one reading this blog post has a number...
SQL Server Tip: Optimizer using Index Scan and not Seek!
Other than coding, most of the time developers have to troubleshoot problems from their environments. Developers in SQL world would mostly face...
Preparing for Data Centric Interviews by Pinal Dave
These days the fundamentals of taking an interview have not changed much. The more experienced you are, the greater the likelihood of getting into...
Performance Improvements with SQL Server 2014
Whenever there is new model of any vehicle launched in the market, it is expected it should have some enhancements or new features which would make...
Rapid SQL Code Templates by Dan Hotka
This is part of a series of guest posts by Dan Hotka. Hi! This week I want to show how Rapid SQL can improve your coding productivity and technique...
SQL Server – Server Node Reports for Troubleshooting
This is a guest post from Pinal Dave. For many DBAs, restless nights start when end users complain that the application using SQL Server is too...
Executing Explain Plans Using Rapid SQL by Dan Hotka
This is a guest post from Dan Hotka, Oracle ACE Director. Learn more at his webinar Explain Plan Tips and Techniques. Hi! My name is Dan Hotka. I am...