We are excited to announce the release of a new free tool, SQL Query Store Optimizer, designed to help you improve the performance of SQL...
Welcoming a New Free Tool: SQL Query Store Optimizer
read more
blog
Happy System Administrator Appreciation Day! Participate and Win a Roku Streaming Stick!
Friday, July 29 is National System Administrator Appreciation Day! IDERA wants to thank and recognize System Admins and other IT workers for their...
Using a Lookup Component in SSIS for Surrogate Keys in a Fact table
There are many suggestions for loading a data warehouse using SQL Server integration Services (SSIS). Once you get started, you find a pattern to...
Decoded: A Day in the Life of a Database Administrator
Companies know they need a database administrator, but they probably don't have any clue about what they actually do. The primary duty for a...
What it takes to make Pokémon GO a reality
People, the world over, have been awed by the launch of Pokémon Go. The game has brought nostalgia, curiosity, and a unique gaming experience to...
August #SQLChat – Participate and Win a $100 Amazon Gift Card!
Our next #SQLChat will take place Wednesday, August 17 at 11 AM CT with Pinal Dave (@pinaldave). Pinal will lead a conversation discussing...
What Did Our #SQLChat Teach you About Growing Your Career?
IDERA hosted its July 2016 #SQLChat on Wednesday, July 6 at 11 AM CT with Monica Rathbun (@SQLEspresso). This was the second largest chat we have...
Database Lifecycle Management 2016 Survey
At IDERA, we believe data is king: how you use data, how your organizations use data, and how the world uses data. So, we set out on a journey to...
Extended Beacon sample for Delphi 10.1 Berlin: Standard, Alternative and Eddystone beacons
If you look at the ExtendedBeaconScanner sample that is included for Delphi in 10.1 Berlin, you will learn how to scan for Beacon devices using...
SQL Server 2016 Has a Little Something for Everyone
This Thursday, June 23, IDERA is sponsoring a virtual Windows IT Pro event to discuss what’s new with SQL Server 2016 — which was released on June...
What did our #SQLChat teach us about Execution Plans?
IDERA hosted its monthly live Twitter Chat on Wednesday, June 8 at Noon (CT) with Thomas LeBlanc (@TheSmilingDBA). Tips, techniques and resources...
Why use a Date Dimension Table in a Data Warehouse
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you are using the Kimball Dimensional Modeling...
Get Started with Execution Plans in our June #SQLChat!
Our next #SQLChat will be held Wednesday, June 8 at 12 PM Noon CT with IDERA ACE, Thomas LeBlanc (@TheSmilingDBA). We will be discussing how to get...
What Data Modeling Myths Were Uncovered in our #SQLChat?
IDERA hosted its 11th #SQLChat on Wednesday, May 11th with data modeling guru, Karen Lopez (@datachick). The myths and misunderstandings that...
May the 4th Be with You – Win Star Wars Legos from IDERA!
Do. Or do not. There is no try. IDERA is celebrating Star Wars Day all week long! And to prove it, we are giving away a box of Millennium Falcon...
Encryption vs. Security Analytics
I recently read 2 articles on security; The first covered the new model in which analytics are used to detect security issues; And a second...
Join IDERA at the Annual SSWUG Spring Virtual Conference
We are pleased to be a part of this year’s virtual SSWUG conference taking place April 28-29. There is a rockstar lineup of presenters which...
May #SQLChat – “Uncovering Data Modeling Myths”
Our next #SQLChat will take place Wednesday, May 11 at 11 AM CT with host Karen Lopez (@datachick) as she leads a conversation exploring the myths...
Tune and Profile Multi-platform Databases better with IDERA DBOptimizer
Streamline SQL Tuning Across Major DBMSs Tune poorly performing SQL code on all major DBMSs (Oracle, SQL Server, DB2 and Sybase) from a single...
April #SQLChat Wrap-Up: SQL Server Migrations
IDERA hosted its April #SQLChat on Tuesday, April 12 at 11 AM CT with Rie Irish, Director of Database Administration with Paymetric, Inc. This...
SSRS Report Won’t Render in VS Preview
I love getting get a laptop, but getting all the software reinstalled and making sure everything works can be trying. Last week, I was lucky enough...
Enabling a Data Culture Through Continuous Improvement
Progressive organizations recognize data as a strategic asset and rely upon it for critical decision making. Business intelligence spending has been...
The Shield
How many of you are known as the “Grumpy DBA” or have a bad reputation with users because you are always saying no or they have to wait? I know many...
April #SQLChat – “Migrating SQL Server"
Did you know SQL Server 2005 falls out of service April 12? Join us for a Twitter Chat and you’ll be fully prepared for future Server migrations!...