The Internet of Things (IoT) is the term used to describe the connection of network-capable devices to the Internet and other connected devices. The...
database-tools
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- 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
Using Data Analytics for a Competitive Advantage
In the ultra-competitive markets of the 21st Century, business leaders are always in search of methods with which to gain an advantage over their...
Downloading Useful Scripts
The PowerShell Gallery not only offers public modules with new PowerShell commands but also public scripts. Before you invest time, you may want to...
Welcome to the Modern Precise
Welcome to the modern Precise UI. Precise is now available on all modern browsers such as Chrome and Firefox and can even be launched on tablets...
What You Need to Know About SQL Server Blocking and Locking
When implementing SQL Server instances, performance is one of the key factors in determining the success or failure of a database and its...
Speeding Up PowerShell Remoting
PowerShell remoting is insanely powerful: with Invoke-Command, you can send arbitrary PowerShell code to one or many remote machines and execute it...
Learn about advanced database performance tuning for SQL Server and Azure SQL Database.
The roles of database professionals are always evolving. However, their tuning skills should remain sharp. Tuning proficiency is still one of the...
IDERA Newsletter August 2020 (Database Administrator edition)
Product Release SQL Diagnostic Manager for SQL Server 10.6 We are delighted to announce that the latest release of SQL Diagnostic Manager is...
IDERA Newsletter August 2020 (Database Developer edition)
Product Release New! Aqua Data Studio 20.6 We are delighted to announce that the latest release of Aqua Data Studio is now available....
Database Development in Multi-Platform Environments
Multi-platform database environments are the norm in today’s business world. A database developer or administrator may still exhibit expertise...
How do you ensure the security of personally identifiable information (PII) within U.S. federal government agencies?
Safeguarding personally identifiable information (PII) in the government's possession and preventing incidents and breaches are essential to...
Creating PowerShell Functions Dynamically
New-Item can create new things on any PowerShell drive, including the function: drive that holds all PowerShell functions. If you’d like, you...
Tuning SQL Servers On-Premises and in the Cloud
Tuning database performance comprises a major part of a DBA’s responsibilities. The usefulness of the most informative database filled with...
Advantages of Automating Database Performance Tuning
Database professionals are usually strapped for time. It’s part of the job in most cases. Multi-platform database environments are the norm in...
Validating User Account Passwords (Part 3)
In the previous parts, we created the Test-Password function that can test user account passwords for both local and remote user accounts. In our...
How can you better manage a large number of SQL Server agent jobs?
Managing a large number of SQL Server agent jobs across a large enterprise environment can be difficult and frustrating. Database administrators are...
How can you properly set up permissions and security?
Being in the computer industry is one of the most challenging things anyone can get into. When upgrading one’s knowledge to keep the data...
The Problem of Identifying Internal Security Threats
Providing security for their systems is one of the main concerns of IT professionals and corporate management everywhere. Worrying about security...
Validating User Account Passwords (Part 2)
In the previous tip we showed how PowerShell can validate and test user account passwords, however the password was requested in plain text....
What is big data and what are its benefits for your organization?
The term big data is familiar to anyone with even a passing interest in the world of information technology (IT). Big data is not a new concept....
IDERA Live 2020! Free Virtual Conference
Join us at our fourth annual virtual conference, IDERA Live 2020: How to Overcome Rapidly Evolving Database Challenges, designed to educate and...
Minimizing the Cost of Missed SLAs
A service level agreement (SLA) is a document that defines the level of service that a customer expects from an IT vendor or supplier. It is...
Validating User Account Passwords (Part 1)
PowerShell can test user account passwords for you. This works both for local and domain accounts. Here is a sample function called Test-Password:...
What are best practices for security practices for SQL Server?
There are several examples where data theft has brought organizations to a halt or resulted in a bad press that will leave a tarnished image. For...
Reading 4K-Hash
Windows operating systems can be uniquely identified by a so-called 4K-Hash: this is a special hash string that is 4000 bytes in size. You can use...
How can you achieve predictable business intelligence (BI) performance with unpredictable queries?
SQL Server database administration is difficult; queries and indexes require tuning in response to application changes. For many database...
Announcing the General Availability of SQL Compliance Manager 5.8
We are excited to announce the release of SQL Compliance Manager 5.8. SQL Compliance Manager is the industry leading SQL Server auditing solution...
Announcing Precise 10.2 General Availability
We are pleased to announce the release of Precise 10.2, the company’s application performance monitoring platform. This latest release...
What are the complications of cybersecurity in the cloud?
Cloud computing services offer many advantages for companies or organizations that make use of them. There are often financial incentives involved...
Sophisticated Battery Report
If your laptop battery is going low too soon, or you’d like to investigate related issues, there is a simple way to generate an extensive...