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...
Secrets Of FireDac: Last Inserted Auto Generated Id And Enterprise Connectors
read more
SQL
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...
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...
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 out of the...
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 библиотеки...
Database Continuous Delivery – It’s Not as Scary As You Think
Database continuous delivery can be a scary topic for database administrators. This requires the DBA to start trusting tools & processes,...
How Do You Approach a Performance Problem?
We all see performance problems on a regular basis. Some look to hardware first, some look to logical design. We all turn to IDERA and other tools....
Is your SQL drawing a blank? It’s NULL a surprise!
The title of this post is a play on words, but very appropriate. We are going to discuss the inconsistent results, as well as performance...
April #SQLChat Findings
Jim Donahoe (@SQLFlipFlopsDBA ) hosted a #SQLChat on Wednesday, April 5 over Career Satisfaction within the SQL Space. This was a busy conversation...
Let’s Discuss Migrating to the Cloud!
It’s that time again! Our next #SQLChat will take place Wednesday, March 15 at 11 AM CT with Mike Fal. Mike will be leading a discussion on...
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...