Red9
1-877-891-1870Book your free call
Menu

Author

Mark Varnas

Founder & Partner, Red9 · 75 articles

Articles by Mark

  1. How to Copy Large Volumes of Data from One Table to Another Database[Or 18Gb in 5min]SQL Server Performance TuningNov 11, 2026
  2. 7 Essential SQL Server DMV Queries Every Admin Should KnowSQL Server Performance TuningNov 11, 2026
  3. Database Blogs – Top 18 ListSQL Server TipsNov 11, 2026
  4. What Is Cursor in SQL Server and Why Is It Used?SQL Server TipsNov 11, 2026
  5. How to Choose a SQL Server Managed Services Provider (and How 8 Providers Compare)SQL Server TipsNov 9, 2026
  6. Ola Hallengren Maintenance for SQL Server [Full Guide]SQL Server Health CheckNov 9, 2026
  7. How to Install DBATools Powershell Module for SQL Server [Full Guide]SQL Server TipsNov 9, 2026
  8. [Pros & Cons] Azure SQL Managed InstancesSQL Server Migrations & UpgradesOct 29, 2026
  9. How to Fix SQL Server Recovery Pending ModeSQL Server TipsOct 27, 2026
  10. How to Enable SQL Server Query Store [Best Practices]SQL Server Performance TuningOct 26, 2026
  11. [4 Ways] How to Check SQL Server Error Log Location?SQL Server Health CheckOct 26, 2026
  12. SQL Server 2016 End of Life: The Breaking Changes Nobody’s AuditingSQL Server Migrations & UpgradesOct 24, 2026
  13. SQL Server End of Life: Avoid Costly Downtime & Security DisastersSQL Server Migrations & UpgradesOct 24, 2026
  14. SQL JOINs Venn Diagram: A Visual GuideSQL Server Performance TuningSep 8, 2026
  15. How to Configure Antivirus for SQL Server (and Improve Performance)SQL Server Health CheckAug 10, 2026
  16. How to Troubleshoot a Slow-Running Query Using Wait Stats in SQL Server?SQL Server Performance TuningAug 4, 2026
  17. Easy Guide: Download and Install SQL Server Data Tools 2019 (SSDT 2019)SQL Server TipsAug 2, 2026
  18. How High Virtual Log File (VLF) Count Kills SQL PerformanceSQL Server Health CheckAug 2, 2026
  19. SQL Server DBA Cost 2026: The 8 Budget Lines Most IT Teams MissSQL Server TipsJul 31, 2026
  20. The $4 Million Mistake: True Enterprise Database Downtime Cost in 2025SQL Server SecurityJul 31, 2026
  21. SQL Query Optimization: A Practical Guide for Database Admins and DevelopersSQL Server Performance TuningJul 31, 2026
  22. [Quick Guide] Autogrowth in SQL Server: Best PracticesSQL Server Health CheckJul 31, 2026
  23. 4 Hidden Ways Sales Reps Overcharge You for SQL Server Licensing (Real Restaurant Chain Example)Client Result · SQL Server Migrations & UpgradesJul 29, 2026
  24. SQL Server Enterprise vs. Standard Edition: When to Downgrade and Save $6,000 Per CoreSQL Server TipsJul 29, 2026
  25. Different Ways to Sync SQL Server Data From Azure to On-Premise SQL ServerSQL Server Migrations & UpgradesJul 23, 2026
  26. Little Bobby Tables and SQL Injection?SQL Server SecurityJul 12, 2026
  27. Is Your SQL Server Generating Dump Files?SQL Server Health CheckJul 13, 2026
  28. Using PowerShell to Monitor Disk UsageSQL Server TipsJun 30, 2026
  29. AWS Storage Types Comparison: A Complete Overview (S3, EBS, EFS)SQL Server Performance TuningJun 30, 2026
  30. Comparing Performance of Two SQL Servers: Part 2SQL Server Performance TuningJun 30, 2026
  31. Comparing Performance of Two SQL Servers: Part 1SQL Server Performance TuningJun 30, 2026
  32. Outsourcing Statistics 2026Research & StatisticsJun 29, 2026
  33. SQL Server Security Best Practices: The 12-Step HierarchySQL Server SecurityJun 26, 2026
  34. 9 Sample SQL Databases for Practice to Download & Set Up in MinutesSQL Server TipsJun 26, 2026
  35. How to Eliminate SQL Server Migrations Performance Degradation Risks With Distributed Replay (DReplay)SQL Server Performance TuningJun 26, 2026
  36. Why Disk Operations Matter the Most When Tuning T-SQL Calls for PerformanceSQL Server Performance TuningJun 26, 2026
  37. The Risks of SQL Server Differential BackupsSQL Server TipsJun 26, 2026
  38. Optimal Windows OS Page File Settings for SQL ServerSQL Server Health CheckJun 26, 2026
  39. Why SQL Server Backups Fail When You Need Them Most: A 3-Month Bank Outage Case StudyClient Result · SQL Server SecurityJun 25, 2026
  40. SQL Server Monitoring Software ToolsSQL Server TipsJun 25, 2026
  41. [3-Step Process] How to Check for Updates in SQL Server Management Studio (SSMS)SQL Server TipsJun 23, 2026
  42. How to Prevent SQL InjectionsSQL Server SecurityApr 8, 2026
  43. Azure Stack On-Premises & How It’ll Blow Your MindSQL Server TipsApr 8, 2026
  44. Page Life Expectancy & Why Should You Care?SQL Server Performance TuningFeb 17, 2026
  45. Why Shrinking SQL Server Databases Is Almost Always a Terrible IdeaSQL Server TipsOct 29, 2025
  46. How to Identify and Fix Orphaned Users in SQL Server (and Why It Matters)SQL Server SecurityOct 29, 2025
  47. Why Setting Up Right SQL Job Owner Matters?SQL Server TipsOct 29, 2025
  48. How We Made T-SQL Queries 8 Times FasterCase Study · SQL Server Performance TuningOct 29, 2025
  49. Top 10 SQL Server Performance Tuning MistakesSQL Server Performance TuningOct 29, 2025
  50. How to Check MaxDOP in SQL Server and Set It for Optimal PerformanceSQL Server Health CheckOct 29, 2025
  51. Two Most Important Decisions in Disaster Recovery – RPO and RTOSQL Server Migrations & UpgradesOct 29, 2025
  52. Untrusted Foreign Keys and Constraints Can Degrade Your SQL Server PerformanceSQL Server Performance TuningOct 29, 2025
  53. Stored Procedures and RECOMPILE Option: When and Why to Use ItSQL Server Performance TuningOct 29, 2025
  54. Why the Database Compatibility Level Matters in SQL Server?SQL Server TipsOct 29, 2025
  55. [Step-by-Step Guide] Configure Azure Managed Instance Replication to On-Premises SQL ServerSQL Server Migrations & UpgradesOct 29, 2025
  56. SQL Server Performance Has Been Tuned, but What I Got Is “I Cant Feel It!” Wait! What??SQL Server Performance TuningOct 29, 2025
  57. Best Practices for SQL Server StatisticsSQL Server Performance TuningOct 29, 2025
  58. SQL Server on Amazon RDSSQL Server Migrations & UpgradesOct 29, 2025
  59. SQL Server Log File Too BigSQL Server TipsOct 29, 2025
  60. Why Picking the Right Data Types in SQL Server MattersSQL Server Performance TuningOct 29, 2025
  61. SQL Server Data Encryption and Your OptionsSQL Server SecurityOct 29, 2025
  62. New Microsoft Software Assurance Benefits for SQL Server High Availability and Disaster RecoverySQL Server TipsOct 29, 2025
  63. [7 Tips] How to Improve T-SQL Query PerformanceSQL Server Performance TuningOct 29, 2025
  64. How to Test SQL Server Migrations Using Log ShippingSQL Server Migrations & UpgradesOct 29, 2025
  65. Encrypting Drives on Live SQL Server with AlwaysOnSQL Server SecurityOct 29, 2025
  66. How Many CPUs Is Your SQL Server Able to Use?SQL Server Performance TuningOct 29, 2025
  67. How Can You Find the SQL Server Jobs That Start Simultaneously?SQL Server Performance TuningOct 29, 2025
  68. Hardware and Performance Tuning in SQL ServerSQL Server Performance TuningOct 29, 2025
  69. Disable Unnecessary SQL Server Instances and ServicesSQL Server Health CheckOct 29, 2025
  70. Best Practices for the SQL Server Error LogSQL Server Health CheckOct 29, 2025
  71. [Full Guide] What Are SQL Server Heap Tables and How to Find ThemSQL Server Performance TuningOct 29, 2025
  72. How to Use SQL Server FILESTREAM Feature for Large DatabasesSQL Server TipsOct 29, 2025
  73. 7 T-SQL Development Tips for Faster QueriesSQL Server Performance TuningOct 29, 2025
  74. Performance Tuning Techniques for SQL Server ReplicationSQL Server Performance TuningOct 29, 2025
  75. 54-Step SQL Server Setup ChecklistSQL Server Performance TuningOct 29, 2025

More From the Content Team