Blog

Data governance is a proven method of helping organizations handle their data assets with more consistency. Data modeling is an important aspect of implementing data governance and ER/Studio Enterprise Team Edition gives teams the tool they need to create a solid data governance foundation.

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 not as complex a subject as many think it is and we can learn a lot from the earlier behavior of SQL Se...

All organizations that collect and store data in SQL Server databases may be subject to regulatory guidelines. Maintaining compliance with these standards requires a strategic approach and the use of tools like SQL Compliance Manager.

We’re excited to announce the release of SQL Defrag Manager 3.6 SQL Defrag Manager is an industry leading automated performance solution that detects, documents and fixes SQL Server Index fragmentation. Centralized automation policies can be im...

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 for SQL Server deployments in environments ranging from a small business to a large scale enterpr...

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 sauce and how to monitor changes in performance to determine if you should pay more or less for the r...

SQL Server database administrators need to perform a lot of different activities in their daily work life. SQL Admin Toolset offers a DBA a single platform from which to launch many tools designed to streamline the administration of their databases.

Performance tuning is a complex subject and one of the most critical. Every manager wants their server to run faster. And every database administrator wants to make sure that they know the tricks to improve the performance of SQL Server. Watch the Ge...

Remote Access Trojans (RATs) are malicious programs that allow cybercriminals to execute code on infected machines. SQL Secure can help keep your SQL Servers safe from this and other types of malware that can lead to a data breach.

Performance tuning is the methodology of systematically identifying bottlenecks in applications, and improving performance. There are some places to start with performance testing. Performance for an application can be a problem on various dimensions...

One of my favorite topics in cloud computing is disaster recovery. A decade ago, if you wanted to have true disaster recovery across multiple geographic regions you had to build or lease multiple data centers with staff on-location in each of those r...

Index fragmentation can substantially slow down database performance. SQL Defrag Manager is a tool that enables a database team to automate index defragmentation to help keep systems running at peak efficiency.

Mizuho Securities is a large enterprise banking company in the USA. They have 100 to 499 SQL Server databases in their environment. They suffered from SQL Server performance problems due to: index and query issues; disk, memory, network, and processo...

This blog post describes how you can connect to and use the Team Server API. When you work with ER/Studio Data Architect, you can easily automate some tedious tasks by using macros through the COM based automation interface. Team Server p...

DBAs may be challenged by being required to support MySQL instances in a local data center as well as the cloud. SQL Diagnostic Manager for MySQL provides the features required to maintain high performance and availability for all servers in their environment.

As organizations migrate their databases to the cloud, database administrators need to manage databases on-premise and in the cloud with existing staff and tools. While it is relatively straightforward to provision and manage databases on virtual mac...

A monitoring tool can help database teams keep their SQL Servers running at peak efficiency. Choosing the right tool, like SQL Diagnostic Manager for SQL Server, provides the customization needed to avoid the pitfalls of alert overload.

Methodist Hospitals of Dallas, Inc. is a medium enterprise healthcare company in Dallas, Texas, USA. They have 10 to 24 SQL Server databases in their environment. They suffered from SQL Server performance problems due to: index and query issues; disk...

IDERA and John Morehouse discuss how to troubleshoot performance issues in Azure SQL Database and what you might be able to do to help fix these issues.

It can be challenging to keep users happy with database performance, yet it is vitally important with both internal and external users. SQL Doctor can help you maintain optimal performance in your SQL Server environment, resulting in happy and satisfied users.

SQL Doctor tunes SQL Server performance, security, and disaster recovery via expert recommendations in physical, virtual, and cloud environments - including managed cloud databases. Unlike its competitors, it displays the health of all SQL Servers, g...

Having a reliable and well-tested disaster recovery plan is essential to protect business-critical systems. SQL Safe backup provides an essential tool for creating the backups that are necessary to recover your SQL Servers if a disaster strikes.

Learn about your storage in the cloud and how to best configure it for SQL Server.

When companies are looking for a SQL Expert to help with performance challenges, they turn to Oregon-based consulting firm Lake IT for experienced SQL DBAs. The owner, Pete Chiboucas, has more than 30 years of experience in networking, IT, and server...