The volume, velocity, and variety of data is ever-increasing. At the same time, data is becoming ever more critical to the growth of organizations....
Peter
Introduction to Windows Azure SQL Database
Many organizations are adopting the cloud computing as their primary computing environment, and others find ways to use Microsoft Azure to enhance...
Initializing replication from backup
Initialization of a transactional replication subscriber is a highly valuable tool. For very large databases (VLDBs), snapshot generation and...
Understanding database backup strategies
As seasoned database administrators, you should be well on top of your backup strategies. These strategies are not written in stone. It is a journey...
How to Start SQL Server Performance Tuning
Performance tuning is the methodology of systematically identifying bottlenecks in applications, and improving performance. There are some places to...
Five reasons your SQL Server is slow
Everybody would love to find the mythical “go faster” switch in SQL Server. Unfortunately, this switch does not exist. There are,...
Top 5 SQL Server cluster setup mistakes
Windows Server Failover Clustering (WSFC) provides infrastructure features that support the high-availability and disaster recovery scenarios of...
Updated Free Tool: PowerShell Scripts for SQL Server 6.0: Added Scripts for Microsoft Azure SQL Database
IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release features 15 new scripts for Microsoft Azure SQL...
Demystify tempdb performance and manageability
Microsoft SQL Server stores a significant amount of data in the tempdb system database. Consequently, tempdb can fill up quickly when disk space is...
Learn about index fragmentation to improve SQL Server performance
As the data in the database tables of Microsoft SQL Server changes, their indexes change. Over time these indexes become fragmented so that ordered...
How to increase SQL Server performance with existing hardware
Unlike their failed counterparts, solutions are successful solely because systems, users, and organizations have come to depend upon them. Solutions...
How to become a database administrator for SQL Server
Database administrators need to handle all facets of managing Microsoft SQL Server ranging from installation and patching to creating databases to...
How to learn PowerShell for free
Microsoft’s Windows PowerShell is a task-based command-line shell and scripting language. It is an automation platform and scripting language...
How To Improve a Business-critical Third-party Application by Optimizing Its Generic Database Settings
Problem Background A business-critical third-party application for Microsoft SQL Server configured the database with generic settings, including...
Learn More about the Cloud with these Free Resources
You may already know that the cloud provides always-on architecture, automatic monitoring and management, enterprise-class security, fast access to...
Virtual Machine Snapshots versus Database Backups
Virtual Machine Snapshots Virtual machines provide exciting possibilities concerning backup, recovery, and cloning of databases. Convenient...
Five Important Features of SQL Diagnostic Manager
SQL Diagnostic Manager is a robust performance monitoring, alerting and diagnostics solution for SQL Server. It proactively notifies of health,...
Updated Free Tool: PowerShell Scripts for SQL Server 5.0: Added Center for Internet Security (CIS) Benchmarks
IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release features 30 new scripts for Center for Internet Security...
product-oriented educational blog posts for Uptime Infrastructure Monitor
Here is a list of product-oriented educational blog posts for Uptime Infrastructure Monitor: Keep Track of Database Performance with Uptime...
Valentine’s Day (Product Bundles and Pairings)
Valentine’s Day is a special day to celebrate affection, friendship, and romance. Many people worldwide celebrate Valentine’s Day by...
Quickly deliver relevant data to the right people to improve DevOps
Challenge As the number of projects for developing applications increases, organizations struggle with quality assurance, release management, and...
How to monitor Always On availability groups
Always On availability groups are part of an integrated solution with the goal of achieving the highest level of data availability and disaster...
How to monitor tempdb databases
Introduction The tempdb system database is a workspace used to hold temporary user objects, results created through queries and sorts, and other...
How to plan future capacity
Capacity planning, especially when done for Microsoft SQL Server, is not for the faint of heart. Storage and disk capacity are apparent, but to...