We are pleased to announce the general availability of DB PowerStudio version 18.4! IDERA’s DB PowerStudio provides a powerful cross-platform...
Announcing General Availability of DB PowerStudio (DBPS) version 18.4
read more
Rapid SQL
Announcing General Availability of DB PowerStudio, version 18.2
IDERA’s DB PowerStudio provides a powerful cross-platform toolset for database development, tuning and database management. What's new in DB...
Introducing a Versatile Solution for Database Developers and Administrators
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
A Powerful Suite of Tools for Increased DBA Productivity
Working across multiple database platforms is the norm these days for many DBAs. Most organizations do not restrict themselves to using one...
Announcing The General Availability of DB PowerStudio 17.1
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
A Tool for Creating More Efficient SQL Code Quickly
Information technology has become one of the most important manifestations of society’s technological advancements. IT systems are widely used...
A Comprehensive Tool for Developing High-Performance SQL Code
Writing SQL code is something that database professionals are called upon to do regularly. The practice comes into play when developing new...
A One-Stop Solution to SQL Coding Problems
A One-Stop Solution to SQL Coding Problems One of the challenges a DBA must deal with on a daily basis is negotiating the multiple database...
Announcing the General Availability of DB PowerStudio 17.0.4
We are excited to announce the release of DB PowerStudio version 17.0.4 with improvements in the following areas. New Platform Support We have...
DB PowerStudio 17.0.3 General Availability
We’re excited to announce the general availability of DB PowerStudio 17.0.3. Existing users may upgrade to this version through the Idera...
Creating and Identifying Deadlocks in SQL Server
This video from John Sterrett shows you how to create a deadlock and how you can proactively monitor deadlocks using the default system_health...
10 Quick Tips & Tricks for SQL Server Developers
Here are 10 quick SQL Server tips and tricks for database developers compiled by SQL Server expert Pinal Dave. For inefficient query plans: Check...
10 Consejos y trucos rápidos para SQL Server Desarrolladores
Aquí hay 10 consejos de SQL Server rápidas y trucos para los desarrolladores de bases de datos recopilados por expertos de SQL Server Pinal de Dave....
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...
Finding Your Top Offending Statements with Extended Events
Finding the top offending statements for a specific workload can be hard if you are not using the best tool in your toolbox. On SQL Server 2012 and...
3 Cool SQL Server TSQL Snippets for Productivity
Nobody would want to shy away from some help. This is second to human nature and we never try to talk it out explicitly. When at work, if we can...
5 Different Ways to Start SQL Server Services
If nothing works, then a restart works. This is the exact sentiments that an Administrator has when it comes to working with software. If you are...
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...
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...
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...
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...