In part one of our overview of SQL performance we examined relational optimization; part two took a look at query analysis and introduced...
SQL
November #SQLChat – Let’s Talk About Data Analysis!
A solid data analysis process and capable tools are key components of a strong data professional's skill set. Join IDERA...
We’ll See You at PASS Summit 2018!
It’s that time of year again! IDERA is excited to see everyone at PASS Summit 2018! This year’s summit will take place from November...
How can DevOps help database teams improve software delivery?
DevOps Research and Assessment (DORA) published a detailed report on the state of DevOps entitled "Accelerate: State of DevOps 2018: Strategies...
Secrets of FireDAC: Pagination With Grids And LiveBindings
If you want to display only a range of results from a recordset you can using paging (otherwise known as pagination) to do so. It is a common...
What is NoSQL and Why Should I Care?
Many database professionals have historically worked with traditional relational database management systems (DBMS) such as Microsoft SQL Server,...
Secrets Of FireDac: Last Inserted Auto Generated Id And Enterprise Connectors
A common pattern when inserting data into a database table which has an auto increment field set on it is to use an SQL query to select the last...
SQL Diagnostic Manager 10.3 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 10.3. Existing users may upgrade to this version through...
SQL Diagnostic Manager for MySQL 8.7 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager for MySQL 8.7. Existing users may upgrade to this version through...
Secrets Of FireDAC: Dynamic Where Clause Using Conditional Substitution Macros
If you are using FireDAC and building your SQL queries manually you may be using more verbose code than is needed. FireDAC has a feature called...
July #SQLChat – Death of the DBA
“The DBA is dying” has been a common concept for at least 15 - 20 years. What makes this time period different? Join IDERA...
TEMP is A Four Letter Word
It’s not uncommon to observe rampant over reliance of database application code on TEMP tables, most often as a SQL language programming...
Announcing the General Availability of Aqua Data Studio Version 19.0
We are pleased to announce the availability of the Aqua Data Studio version 19.0 release. This release greatly enhances several areas of...
Database Needs in The Cloud – May #SQLChat
Movement to the cloud is in full swing! Regardless of the cloud provider, you will need a migration strategy and the knowledge to make choices...
Changing Lanes: Shifting Roles with Relational and Big Data Platforms
As Relational and Big Data Store databases evolve, so do the responsibilities of the people that support them. Whether you are an Analyst dealing...
Is Redshift giving you the Blues? ER/Studio has the cure.
In my 35 years of data modeling many data platforms have come and gone, while others continue to change. For many, maintaining pace with the...
Announcing the General Availability of DB Optimizer 17.0.1
We are pleased to announce the General Availability of DB Optimizer 17.0.1 This release greatly enhances the features of the product for SQL Server...
March #SQLChat – GDPR
Come May 25, 2018, all companies that work with EU data will need to comply with GDPR - this covers about 92% of companies in the US! If you...
Creating and Using Failover Groups in Azure DBaaS – Part 2
Connecting to Failover Group So in Part 1 of this series, we created and configured our Failover Group. Well, now that the easy stuff is...
Configuring TempDB on Azure IaaS for SQL Server
Hey everybody! I am asked by clients/team members/friends a lot about how to setup TEMPDB to use the D:\ drive on an Azure VM for SQL Server. ...
February #SQLChat – Becoming a Microsoft MVP
Are you hoping to become a Microsoft MVP? Or, have you already gone through the application process yourself? Then participate in our next Twitter...
New Discovery and Tuning Suite Now Available
We are pleased to announce the availability of a new suite of performance products packaged to fill the core needs of most SQL Server DBAs....
January #SQLChat: SQL Server New Year Resolutions – Breaking SQL Bad Habits for 2018
The New Year is almost here! Have you made any resolutions for 2018? Participate in our next #SQLChat on Wednesday, January 3rd at 11 AM CT with...
Дополнительные утилиты FireDAC
Последнее время большую часть рабочего времени пришлось уделить разработке новых примеров для недавно включенной в состав RAD Studio библиотеки...