Sitemap

Posts

• How We Found the VM Cap Costing Our Client $30K in Wasted SQL Server Spend (April 13, 2026)
• SQL Server DBA Cost 2026: The 8 Budget Lines Most IT Teams Miss (March 18, 2026)
• SQL Server 2025 Has No SSRS Release. Here's What That Means for Your Migration (March 3, 2026)
• Why Your App Got Slow After Migrating SQL Server to Azure (March 3, 2026)
• ETL Process Optimization: A Practical Guide for SQL Server Teams (March 2, 2026)
• SQL Server 2016 End of Life: The Breaking Changes Nobody’s Auditing (February 17, 2026)
• How SQL Tuning Saved Six Figures and Cut Cores by 75% (February 17, 2026)
• How We Cut SQL Server Costs in Half and Added HA for Free (February 17, 2026)
• You Scaled Your VM to 32 Cores. Your TempDB Configuration Didn’t (February 17, 2026)
• Restarting SQL Server? You're Destroying the Evidence. (February 5, 2026)
• How to Spend $10k on SQL Monitoring and Still Fix Nothing (February 5, 2026)
• VM Snapshots Are Not SQL Server Backups: A Disaster Recovery Story (February 5, 2026)
• Stop Running Other Applications on Your SQL Server (February 5, 2026)
• SQL Server Enterprise Edition Is Not a Must (February 5, 2026)
• How a Simple VMware Misconfiguration Cost Our Client Months of Performance Issues (February 4, 2026)
• A Client Lost 1.5 Months of Data and It Wasn’t a Cyberattack (February 4, 2026)
• AI Won't Replace Your Senior DBAs. Here's What It Actually Does. (February 4, 2026)
• Your SQL Server Is Logging Deadlocks - Are You Reading Them? (February 4, 2026)
• How We Cut SQL Server Licensing Costs by 75% With Azure Migration For a Client (January 30, 2026)
• How We Made a Warehouse Management System 6.5x Faster by Fixing One SQL Server Constraint (January 27, 2026)
• Why Your SQL Server Column Design Could Be Costing You 20% of Your CPU Power  (January 14, 2026)
• How to Check SQL Server Disk Formatting: The 4KB Mistake Costing You Performance (December 9, 2025)
• How We Saved a Professional Services Firm $117,654 Annually by Right-Sizing Their SQL Server Infrastructure (November 25, 2025)
• Oracle Database (19c → 23ai): A C-Level Overview for 2025 (November 4, 2025)
• SQL Server xp_cmdshell: executive guide to risk, governance, and safer alternatives (October 28, 2025)
• SQL Server Emergency Recovery: How We Saved a Corrupted Database Without Backups  (October 21, 2025)
• What To Do When Your SQL Server Critical Report Starts Timing Out on Friday Evening (October 14, 2025)
• How Real Workload Testing Cut Azure SQL Hyperscale Costs by 46% and Saved $86,000 a Year (October 7, 2025)
• SQL Server Monitoring & Alerts and Why Most Companies Are Doing It Wrong (September 30, 2025)
• The CTO How-to Guide to SQL Server Migration: A Decision Framework (September 23, 2025)
• Case Study: How Red9 Transformed SQL Server Performance and Saved 66+ Minutes of Daily Processing in 6 Weeks (September 16, 2025)
• SQL Server 2025 Released: AI Integration, Developer Features, and Performance Gains (September 8, 2025)
• The SQL Server Software Assurance Guide (August 6, 2025)
• MySQL Explained: What It Is, How It Works, When to Use It (July 29, 2025)
• SQL Server Security Best Practices: The 12-Step Hierarchy (July 29, 2025)
• Why SQL Server Backups Fail When You Need Them Most: A 3-Month Bank Outage Case Study (July 19, 2025)
• Microsoft SQL Server: Definitive Guide (July 15, 2025)
• The Complete SQL Server Migration Strategy Guide (July 9, 2025)
• The $4 Million Mistake: True Enterprise Database Downtime Cost in 2025 (July 1, 2025)
• The SQL Server Memory Setting That Might Be Killing Your Performance (June 24, 2025)
• 4 Hidden Ways Sales Reps Overcharge You for SQL Server Licensing (Real Restaurant Chain Example) (June 24, 2025)
• SQL Server End of Life: Avoid Costly Downtime & Security Disasters (June 17, 2025)
• SQL Server Enterprise vs. Standard Edition: When to Downgrade and Save $6,000 Per Core (June 4, 2025)
• Enterprise SQL Server Security: Beyond Basic Protection (May 29, 2025)
• SQL JOINs Venn Diagram: A Visual Guide (May 16, 2025)
• Why Shrinking SQL Server Databases Is Almost Always a Terrible Idea (May 15, 2025)
• How to Identify and Fix Orphaned Users in SQL Server (And Why It Matters) (April 21, 2025)
• Comparison of SQL on Virtual Machine (VM) vs Azure Managed Instance (MI) vs Azure SQL Database (DB) (November 8, 2024)
• SQL Query Optimization: A Practical Guide for Database Admins and Developers (September 8, 2024)
• How to Copy Large Volumes of Data from One Table to Another Database[Or 18Gb in 5min] (September 8, 2024)
• 9 Sample SQL Databases for Practice to Download & Set Up in Minutes (September 8, 2024)
• Why Setting Up Right SQL Job Owner Matters? (August 9, 2024)
• SQL Server Database Assessments (July 5, 2024)
• [Case Study] How to Size Azure Managed Instance & Avoid Overspending (June 15, 2024)
• Easy Guide: Download and Install SQL Server Data Tools 2019 (SSDT 2019) (April 22, 2024)
• How We Slashed SQL Query Disk Read Operations by 1,152 Times (March 28, 2024)
• How We Made T-SQL Queries Run 34,785 Times Faster (March 19, 2024)
• How We Made T-SQL Query Run 17,000x Faster (March 18, 2024)
• How To Eliminate SQL Server Migrations Performance Degradation Risks With Distributed Replay (DReplay) (March 15, 2024)
• How To Fix SQL Server RECOVERY PENDING Mode (March 15, 2024)
• Why Disk Operations Matter The Most When Tuning T-SQL Calls For Performance (March 15, 2024)
• Why Should You Care About CLR Integration In SQL Server? (March 15, 2024)
• What Is SQL Server Parameter Sniffing? (March 14, 2024)
• Methods for Performance Tuning on Azure SQL Database (March 14, 2024)
• Top 10 SQL Server Performance Tuning Mistakes (March 14, 2024)
• When Was The Last Time Your SQL Server Wait Stats Were Cleared? (March 13, 2024)
• How to Check MaxDOP in SQL Server and Set it for Optimal Performance (March 13, 2024)
• Wasting CPU For Implicit Conversions In SQL Server (March 13, 2024)
• Using PowerShell To Monitor Disk Usage (March 13, 2024)
• Two Most Important Decisions In Disaster Recovery – RPO And RTO (March 13, 2024)
• Untrusted Foreign Keys And Constraints Can Degrade Your SQL Server Performance (March 12, 2024)
• Stored Procedures and RECOMPILE Option: When and Why to Use It (March 12, 2024)
• Why Should You Care About Users With Elevated Permissions In SQL Server? (March 12, 2024)
• Why the Database Compatibility Level Matters in SQL Server? (March 12, 2024)
• The Risks Of SQL Server Differential Backups (March 12, 2024)
• [Step-by-Step Guide] Configure Azure Managed Instance Replication to On-Premises SQL Server (March 12, 2024)
• Trace Flags In SQL Server (March 11, 2024)
• The Proper Way To Setup SQL Server Alerts (March 11, 2024)
• SQL Server Performance Has Been Tuned, But What I Got Is “I Cant Feel It!” Wait! What?? (March 11, 2024)
• Best Practices For SQL Server Statistics (March 10, 2024)
• SQL Server Startup Parameters (March 10, 2024)
• SQL Server Shrink: Best Practices (March 9, 2024)
• SQL Server Remote Dedicated Admin Connection (DAC) (March 8, 2024)
• SQL Server Page Verification CHECKSUM (March 8, 2024)
• Best Practices for SQL Server Availability on Amazon RDS (March 8, 2024)
• SQL Server On Amazon RDS (March 8, 2024)
• SQL Server Monitoring Software Tools (March 8, 2024)
• Managing SQL Server Objects with SET Options (March 7, 2024)
• SQL Server Migration To Amazon RDS Strategies (March 7, 2024)
• Main Differences Between MS SQL Server Native Backups And 3rd Party Tools (March 7, 2024)
• SQL Server Max Memory Parameter (March 7, 2024)
• SQL Server Log File Too Big (March 7, 2024)
• SQL Server High Availability (HA) (March 6, 2024)
• SQL Server High Availability - All You Need To Know (March 6, 2024)
• SQL Server Index Tuning for Performance (March 5, 2024)
• Why Picking the Right Data Types in SQL Server Matters (March 5, 2024)
• SQL Server Change Tracking: Benefits, Limitations, and When to Use (March 5, 2024)
• Why Should You Enable SQL Server Database Backup Compression By Default? (March 5, 2024)
• Should I Migrate My SQL Server To Linux? (March 4, 2024)
• SQL Server Data Encryption And Your Options (March 4, 2024)
• Review Your Windows Task Scheduler: It Can Impact Your SQL Server Performance (March 4, 2024)
• Removing Offline Databases And Orphaned Data Files From Your SQL Server (March 4, 2024)
• Page Life Expectancy & Why Should You Care? (March 4, 2024)
• SQL Server AlwaysOn Cluster Patching Window OS: Step-by-Step Guide (March 3, 2024)
• Optimal Window’s OS Page File Settings For SQL Server (March 3, 2024)
• Simple Recovery Model In SQL Server (March 3, 2024)
• New Microsoft Software Assurance Benefits For SQL Server High Availability And Disaster Recovery (March 3, 2024)
• Best Windows Power Plan for Optimizing SQL Server Performance (March 2, 2024)
• Migrating Microsoft SQL Server To Amazon AWS RDS (March 2, 2024)
• Microsoft SQL Server Migration Strategies To AWS (March 2, 2024)
• SQL Server – Priority Boost Option (March 1, 2024)
• Never Use The Full Recovery Model Without A Backup (March 1, 2024)
• Monitoring Deadlocks In The SQL Server (March 1, 2024)
• Microsoft SQL Server Management Studio (SSMS) (March 1, 2024)
• How To Troubleshoot A Slow-Running Query Using Wait Stats In SQL Server? (February 29, 2024)
• [7 Tips] How to Improve T-SQL Query Performance (February 29, 2024)
• How To Test SQL Server Migrations Using Log Shipping (February 29, 2024)
• How To Prevent SQL Injections (February 29, 2024)
• How To Re-Initialize SQL Server Merge Replication Publication (February 29, 2024)
• [3 step process] How to Check for Updates in SQL Server Management Studio (SSMS) (February 28, 2024)
• How To Identify Deprecated Features In Use On A SQL Server Instance? (February 28, 2024)
• Microsoft Dynamics 365 (February 28, 2024)
• 7 Essential SQL Server DMV Queries Every Admin Should Know (February 28, 2024)
• Encrypting Drives on Live SQL Server with AlwaysOn (February 28, 2024)
• Little Bobby Tables And SQL Injection? (February 28, 2024)
• Keep Your Jobs Safe Using SQL Agent Notifications (February 28, 2024)
• How To Enable SQL Server Query Store [Best Practices] (February 27, 2024)
• How to Configure Antivirus for SQL Server (and Improve Performance) (February 27, 2024)
• Keep SQL Server Backups Safe: Best Practices (February 27, 2024)
• Is Your SQL Server Generating Dump Files? (February 27, 2024)
• Increasing Cost Threshold For Parallelism May Improve Your SQL Server Performance (February 27, 2024)
• [4 ways] How To Check SQL Server Error Log Location? (February 27, 2024)
• How Many CPUs Is Your SQL Server Able To Use? (February 27, 2024)
• How High Virtual Log File (VLF) Count Kills SQL Performance (February 26, 2024)
• How Can You Find The SQL Server Jobs That Start Simultaneously? (February 26, 2024)
• Hardware And Performance Tuning In SQL Server (February 26, 2024)
• Improve Your SQL Server Transaction Log Performance Using Delayed Durability (February 26, 2024)
• Forcing Index, Order, And Join Hints And Being Careful (February 26, 2024)
• Improve Your SQL Server Performance Enabling Data Compression (February 26, 2024)
• Improve SQL Server Performance By Enabling Instant File Initialization (February 26, 2024)
• Disabling Windows “Visual Effects” To Boost Performance (February 24, 2024)
• Disable Unnecessary SQL Server Instances And Services (February 24, 2024)
• Database Engine Tuning Advisor (DTA) in Microsoft SQL Server (February 24, 2024)
• Database Blogs – Top 18 List (February 24, 2024)
• Dangerous SQL Server Builds (February 24, 2024)
• Ola Hallengren Maintenance for SQL Server [Full Guide] (February 23, 2024)
• SQL Server Agent Job History Retention (February 22, 2024)
• TempDB Best Practices for Optimal Performance (February 22, 2024)
• Best Practices For The SQL Server Error Log (February 21, 2024)
• Best Practices For Performance Counters In Microsoft SQL Server (February 21, 2024)
• Finding User Tables In SQL Server System Databases (February 21, 2024)
• [Full Guide] What is SQL Server Heap Table and How to Find Them (February 21, 2024)
• Fail-Safe Operator For SQL Server Agent (February 21, 2024)
• Enabling Lock Pages In Memory For SQL Server (February 21, 2024)
• [Tried & Tested] SQL Server Disk Configuration Best Practices (February 21, 2024)
• Disabling Windows Automatic Updates (February 21, 2024)
• Top Tips for Optimal Performance After SQL Server Installation (February 20, 2024)
• [Security Best Practices] SQL Server On Amazon RDS (February 20, 2024)
• Azure Stack On-Premises & How It'll Blow Your Mind (February 19, 2024)
• Choosing the Right Azure SQL Service Database: A Complete Guide (February 19, 2024)
• [Pros & Cons] Azure SQL Managed Instances (February 19, 2024)
• How to Install DBATools Powershell Module for SQL Server [Full Guide] (February 19, 2024)
• [Quick Guide] Autogrowth in SQL Server: Best Practices (February 19, 2024)
• How Triggers Affect Your SQL Server Performance (February 19, 2024)
• [Complete Guide] Amazon RDS Managed Instance (February 17, 2024)
• How To Use SQL Server FILESTREAM Feature For Large Databases (February 16, 2024)
• 7 T-SQL Development Tips For Faster Queries (February 16, 2024)
• Performance Tuning Techniques For SQL Server Replication (February 16, 2024)
• Selecting the Right Database for Your Application (February 16, 2024)
• Unlock the Secrets: How to Choose the Best Encryption Feature for SQL Server (February 16, 2024)
• Azure SQL And Security Best Practices (February 15, 2024)
• 54-Step SQL Server Setup Checklist (February 15, 2024)
• SQL Server Migration To Amazon RDS (February 15, 2024)
• SQL Server Installation Configuration Guide (February 15, 2024)
• AWS Storage Types Comparison: A Complete Overview (S3, EBS, EFS) (February 14, 2024)
• "Optimize For Ad Hoc Workloads" Option And SQL Performance (February 14, 2024)
• Comparing Performance of Two SQL Servers: Part 2 (February 7, 2024)
• Microsoft SQL Server License Guide: Complete Breakdown (February 6, 2024)
• What Is Cursor in SQL Server And Why Is It Used? (February 6, 2024)
• SQL Server Performance Tuning Using Indexes (February 6, 2024)
• Amazon SQL RDS vs Azure SQL - [Ultimate Showdown] (February 6, 2024)
• [Step-by-Step] Migrating SQL Server to Azure SQL Database (February 6, 2024)
• Comparing Performance of Two SQL Servers: Part 1 (February 5, 2024)
• Resources To Microsoft SQL Server (January 1, 2024)
• Different Ways To Sync SQL Server Data From Azure To On-Premise SQL Server (December 11, 2023)