Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Microsoft's SQL Server is a robust and widely adopted database...
Blog
Categories
- Free tools
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Do you know the Risks to your Database?
Databases are vitally crucial to modern businesses across all market sectors. They are the repository of an organization’s information resources,...
Harnessing Big Data: A Strategic Advantage for Modern Organizations
There are different claims regarding the coinage of the term big data, but the concept of big data has existed since the mid-20th Century....
Key Insights into Ensuring SQL Server Security with These Practices
There are several examples where data theft has halted businesses or resulted in bad press that will leave a tarnished image. For instance, in 2017,...
Improve SQL Server Usage Management and Efficiency
If your organization deals with a high volume of customer data, telemetry, or other metrics, it’s likely you'll have some substantial databases to...
Initialize Transactional Replication from your Backups
This blog provides guidance on the perceived limitations and restrictions on initializing transactional replication subscribers from backups. The...
Manage data and result sets, and SQL queries with Aqua Data Studio
Aqua Data Studio improves access and consistency by accessing data sources from a single tool to minimize the learning curve and maximize the...
SQL Diagnostic Manager 12.0 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 12.0. Existing users may upgrade to this version through the Idera...
Analyze blocking for SQL Server
Blocking is a normal activity that occurs in SQL Server and it does that to control data integrity and make sure only one resource can change a set...
Top 5 Benefits of Universal Database GUI
Universal database graphical user interfaces (GUIs) are among the most productive tools available to database administrators (DBAs) and developers....
Finding and Fixing Locking Issues on SQL Server Databases
In SQL Server, locking helps improve efficiency by preventing resources from being used simultaneously by different transactions. Issues with SQL...
Top 5 Reasons for Slow SQL Server Queries and How to Fix Them
Slow SQL Server Queries are a common issue among database administrators (DBAs). You would be hard-pressed to find a SQL Server DBA who was not...
What Is an IDE? – The Difference Between IDEs and Code Editors
When evaluating integrated development environments vs. code editors, the right option comes down to your requirements. IDE's have a broad...
What Is Non-Uniform Memory Access (NUMA)?
Bare metal to cloud hosted virtual machines Non-Uniform Memory Access (NUMA) is a four-letter word in every sense, well beyond simply the number of...
Identifying Performance Problems Part 1
Every server, database, storage appliance and network encounter some sort of performance issues. It is a major part of our job as database...
How to analyze the health of SQL Server database indexes
To keep databases running smoothly, it is important to evaluate the properties and performance statistics of indexes of databases. For this purpose,...
Relational Division
Dr. Codd’s original relational algebra had eight basic operations. Since relational database management systems are based on set theory, the...
How to add SQL Server instances to SQL Diagnostic Manager for SQL Server
With SQL Diagnostic Manager, monitor the performance of the entire SQL Server environment by quickly and easily adding SQL Server instances. There...
Installing the SQLDM CWF dashboard during a trial
In this blog post, I'll be guiding you through the installation of the SQL Diagnostic Manager and the IDERA Dashboard in a trial...
Cloud Building Blocks and Layers
Welcome back to our blog series, Solutions for the Cloud. Now that we’ve discussed three concepts of virtualization related to the cloud, we...
How-To: Configuring Your RAD Server Instance
This guide is a full reference for configuring your RAD Server instance. It was written by Eli M. and is part of the collection of New RAD Server...
Returning JSON: TJSONValue, TJSONWriter, and Other Options from RAD Server
[See the full index of articles for more information] RAD Server provides support for handling JSON data that can be consumed by different...
Introduction to Building Your First RAD Server Service
[See the full index of articles for more information] In this blog post, you’ll learn how to build your first RAD Server service-based applications...
The Impact of Cloud on DBA
The DBA is the information technology professional responsible for ensuring the ongoing operational functionality and efficiency of an...
New VCL and FireMonkey Styles in RAD Studio 10.3.1
In today’s blog post, I wanted to highlight the 15 new custom VCL Windows and FireMonkey multi-device styles that we added to Delphi, C++Builder and...
Using Custom Styles in RAD Studio 10.3
It’s very easy to customize your user interface using FireMonkey styles in RAD Studio 10.3. We’ve added all of the premium styles to GetIt (Tools...
SQL Performance, Part 2: Query Analysis and Access Path Formulation
In part one of our overview of SQL performance we examined relational optimization and the things that impact it. In today’s blog post, we...
Data Architecture: The Foundation for Enterprise Architecture and Governance
"Data modeling is all about understanding the data within our organizations and then representing this data in a precise visual (the...
How to Find and Fix SQL Server Deadlocks
Introduction Locking is required for concurrent operations of relational databases to prevent data inconsistency and loss. However, locking impairs...
Monitoring Master-Slave Replication in MySQL 8
MySQL 8 introduced a number of enhancements to improve both replication performance and the monitoring thereof. Improvements included more efficient...