Featured Blog
Understanding and Managing High Memory Usage in SQL Server
The Challenge of Variable Seasonal Database Usage
If the past year has taught us anything, it is that we can never know what’s coming next. Just to survive, we may need to reevaluate our...
Announcing General Availability of Aqua Data Studio 21.0
On behalf of the entire Aqua Data Studio team, we’re excited to announce the release of Aqua Data Studio version 21.0 with Enhancements in the...
How to ensure that SQL Server databases do not have fragmented indexes
Maintain the performance of databases by efficiently retrieving ordered data by resolving the fragmentation of the indexes. View the fragmentation...
Oracle 19.8 Patch for AIX is now supported by Precise 10.2
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Protect Your SQL Servers with Always Encrypted
The information stored in corporate databases needs to be protected in multiple ways. Database backups are necessary to recover from a physical or...
How to monitor the health of SQL Server database instances
Determine the health of instances by collecting real-time statistics. Such statistics include backup devices, databases, error logs, locks, logins,...
Geek Sync | Practical PowerShell For The Busy DBA
Many DBAs don't have time to learn PowerShell. Thankfully, there is an excellent PowerShell library already created specifically for handling...
Cloud Day 2—What Do You Need to Know About Cloud Security?
Cloud security is complex and has several layers to it—first and most important is access to the control plane. The control plane is your...
You Need to Plan a Strategy for SQL Server Backups
Backups are an indispensable component of all computing environments. Creating data backups regularly is considered best practice for everyone from...
How can you tune the performance of SQL Server by analyzing the past to predict the future?
The history of mankind says that we have learned a lot from our past mistakes and improved our future. Similarly, SQL Server performance tuning is...
How to Create a Plan for Regulatory Compliance
Many reasons may make it important for an organization that collects and stores digital information to be concerned with regulatory compliance. Data...
How do you start with performance tuning for Azure SQL Database?
Have you been interested to see how you can baseline performance and improve performance with an Azure SQL Database? Do you want to grasp the secret...
Announcing the Release of SQL Safe Backup 8.7
We’re excited to announce the release of SQL Safe Backup 8.7 SQL Safe Backup is the industry leading mission-critical backup and recovery solution...
Announcing the Release of SQL Defrag Manager 3.6
We’re excited to announce the release of SQL Defrag Manager 3.6 SQL Defrag Manager is an industry leading automated performance solution that...
How ISV’s Drive Innovation with InterBase
I recently ran a webinar, alongside Mary Kelly, discussing how InterBase ISV’s are innovating faster while improving profitability and return...
The Right Tools Make a DBA More Productive
The work-life of a SQL Server DBA can be unpredictable. One might be called upon to address a performance issue, setup logins, verify the backup...
What are the five essential SQL scripts for SQL Server performance tuning?
Performance tuning is a complex subject and one of the most critical. Every manager wants their server to run faster. And every database...
Migration Links from DelphiCOn 2020
Firstly, thank you to the hundreds of you who joined us for the panel discussion at DelphiCon2020. As promised during that session, here is a...
KB: Selection of PowerShell Resources
Microsoft Windows PowerShell Infographic: Why DBAs Should Learn PowerShell? Whitepaper: The Guide to Learning PowerShell Geek Sync Webcasts: The...
RATs Can be a Security Threat to Your SQL Servers
Before you click away, let me assure you that this post is not about rodents chewing on power cords or networking cables. RATs is an acronym for...
Where do you start with SQL Server performance tuning?
Performance tuning is the methodology of systematically identifying bottlenecks in applications, and improving performance. There are some places to...
Cloud Day 2—High Availability and Disaster Recovery in the Cloud
One of my favorite topics in cloud computing is disaster recovery. A decade ago, if you wanted to have true disaster recovery across multiple...
Why You Should Care about Database Index Fragmentation
Providing smoothly running systems that quickly respond to user queries keeps both customers and management happy. All but the most inexperienced...
How did a large enterprise, banking company in the USA achieve better system uptime and usability?
Mizuho Securities is a large enterprise banking company in the USA. They have 100 to 499 SQL Server databases in their environment. They suffered...
Where Can I Host MySQL Databases in the Cloud?
Organizations can enjoy many benefits by choosing to migrate some or all of their computing resources to the cloud. There are often financial...
How are you tuning SQL Server in the hybrid cloud?
As organizations migrate their databases to the cloud, database administrators need to manage databases on-premise and in the cloud with existing...
Keeping an Eye on All of Your SQL Servers
The majority of organizations that use SQL Server as one of their database solutions have more than one instance in their environment. In some...
How did a medium enterprise healthcare company in the USA proactively troubleshoot SQL Server issues?
Methodist Hospitals of Dallas, Inc. is a medium enterprise healthcare company in Dallas, Texas, USA. They have 10 to 24 SQL Server databases in...
Geek Sync | Improving Query Performance in Azure SQL Database
Moving to Azure SQL can help with many things, including faster scalability and easier disaster recovery strategy implementation. Unfortunately, one...
Delphi Con T-5 Days!
We are now only 5 days away from the start of DELPHICON 2020, and the line up is looking pretty cool! I also hear registration is pretty high too....