Using Replication Monitor in Legacy (Pre-2016) SQL Server Management Studio

by Faryl O'Neil | Nov 9, 2022 | Blog, SQL Server

Is SQL 2016 older than SQL 2005? Or is your outdated SQL Server Management Studio (SSMS) lying to you? Sometimes, the most interesting discoveries come from being lazy. Case in point: I was working with a few other DBAs on a client system having issues with...

What is NUMA: Why Does SQL Server Care?

by Ken Haff | Sep 13, 2022 | Blog, SQL Server

Multi-GHz processors need maximum memory bandwidth to reach their full potential.SQL Server needs maximum memory bandwidth to reach its full potential. They need to access memory as fast and with as much throughput as possible. A bottleneck develops when processors...

Best Practices for Deploying SQL Server Using vSphere

by Ken Haff | Sep 6, 2022 | Blog, SQL Server

A properly designed virtualized SQL Server instance running in a VM with Windows Server (or Linux), using vSphere is crucial to the successful implementation of enterprise applications. One main difference between designing for performance of critical databases and...

SQL Server Reporting Services (SSRS)

by XTIVIA | Aug 9, 2022

SQL Server Reporting Services (SSRS) On-premises tools and services that create, deploy, and manage mobile and paginated reports Talk with Our Experts R SSRS Architecture Review Review or audit the current architecture and provide recommendations in regard to...

SQL Server Integration Services (SSIS)

by XTIVIA | Aug 8, 2022

SQL Server Integration Services (SSIS) Microsoft’s Data Management and Analytics offerings you need to succeed! Talk with Our Experts While almost every production DBA will have at least some daily interaction with SSIS packages generated by maintenance plans or...

Scripting Basic Backups using SQL Server Agent

by Faryl O'Neil | Jul 13, 2021 | Blog, SQL Server

The most satisfying meal is the one you make yourself, and database backup jobs are no different. Many DBAs use maintenance plans as a “one-stop-shop” for maintaining their SQL Server databases. After all, they do backups, integrity checks, index...