corpus.blog
56,966 blogs · [ { "id": "01a0df54-a1f5-73a8-a04b-0991d78f9a10", "title": "Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure", "url": "https://www.sqlservercentral.com/articles/moving-beyond-the-reboot-finding-the-culprit-behind-memory-pressure", "published_at": "2026-09-25T00:00:50+00:00" }, { "id": "01a0df54-a1fa-7283-ad1b-72ce3f64dd88", "title": "Migrate SQL Server Databases to Different Active Directory Domain", "url": "https://www.sqlservercentral.com/articles/migrate-sql-server-databases-to-different-active-directory-domain", "published_at": "2026-09-25T00:00:08+00:00" }, { "id": "01a0df54-a1fa-7283-ad1b-72ce3fdf2c23", "title": "Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix", "url": "https://www.sqlservercentral.com/articles/optimized-locking-in-sql-server-2025-fewer-locks-less-blocking-and-the-cases-it-cannot-fix", "published_at": "2026-09-23T00:00:53+00:00" }, { "id": "01a0df54-a1fa-7283-ad1b-72ce402e9649", "title": "Database Animations: The Interview Question Everybody Gets Wrong", "url": "https://www.sqlservercentral.com/articles/database-animations-the-interview-question-everybody-gets-wrong", "published_at": "2026-09-23T00:00:27+00:00" }, { "id": "01a0df54-a1fa-7283-ad1b-72ce40399e2d", "title": "Finding Gaps in Sequential Data Using SQL Server", "url": "https://www.sqlservercentral.com/articles/finding-gaps-in-sequential-data-using-sql-server", "published_at": "2026-09-21T00:00:53+00:00" }, { "id": "01a0df54-a1fa-7283-ad1b-72ce411bd10a", "title": "What is cloud database vendor lock-in? The 3 types explained (and how to audit yours)", "url": "https://www.sqlservercentral.com/articles/what-is-cloud-database-vendor-lock-in-the-3-types-explained-and-how-to-audit-yours", "published_at": "2026-09-21T00:00:12+00:00" }, { "id": "01a0df54-a1fa-7283-ad1b-72ce415053b9", "title": "Practical Reporting Queries with CROSS APPLY (Part 3)", "url": "https://www.sqlservercentral.com/articles/practical-reporting-queries-with-cross-apply-part-3", "published_at": "2026-09-18T00:00:32+00:00" }, { "id": "01a0df54-a1fa-7283-ad1b-72ce419d48ce", "title": "Foreign Keys and Performance in a Microsoft Fabric Warehouse", "url": "https://www.sqlservercentral.com/articles/foreign-keys-and-performance-in-a-microsoft-fabric-warehouse", "published_at": "2026-09-18T00:00:32+00:00" }, { "id": "01a0df54-a1fa-7283-ad1b-72ce41dacd28", "title": "Implementing Type 4 Slowly Changing Dimensions in SQL Server", "url": "https://www.sqlservercentral.com/articles/implementing-type-4-slowly-changing-dimensions-in-sql-server", "published_at": "2026-09-16T00:00:52+00:00" }, { "id": "01a0df54-a1fa-7283-ad1b-72ce422f13fe", "title": "SQL Server login failures: how to monitor, report, and alert on them", "url": "https://www.sqlservercentral.com/articles/sql-server-login-failures-how-to-monitor-report-and-alert-on-them", "published_at": "2026-09-16T00:00:02+00:00" }, { "id": "01a0df7a-5265-7019-9cf2-421f412ef8ed", "title": "Database Animations: What’s a Residual Predicate and Why Is It Bad?", "url": "https://www.sqlservercentral.com/articles/database-animations-whats-a-residual-predicate-and-why-is-it-bad", "published_at": "2026-09-14T00:00:56+00:00" }, { "id": "01a0df7a-5265-7019-9cf2-421f408e14cb", "title": "Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure", "url": "https://www.sqlservercentral.com/articles/optional-parameter-plan-optimization-in-sql-server-2025-fixing-the-kitchen-sink-search-procedure", "published_at": "2026-09-14T00:00:39+00:00" }, { "id": "01a0df7a-5265-7019-9cf2-421f426d61e5", "title": "9 things I wish SQL Server had (and why they’d matter)", "url": "https://www.sqlservercentral.com/articles/9-things-i-wish-sql-server-had-and-why-theyd-matter", "published_at": "2026-09-11T00:00:41+00:00" }, { "id": "01a0df7a-5265-7019-9cf2-421f41ba348a", "title": "Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server", "url": "https://www.sqlservercentral.com/articles/managing-feature-flags-with-get_bit-and-set_bit-in-sql-server", "published_at": "2026-09-11T00:00:08+00:00" }, { "id": "01a0df7a-5265-7019-9cf2-421f42cc57fe", "title": "Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform", "url": "https://www.sqlservercentral.com/articles/databricks-genie-spaces-for-sql-analysts-natural-language-querying-without-leaving-your-data-platform", "published_at": "2026-09-09T00:00:58+00:00" }, { "id": "01a0df7a-5265-7019-9cf2-421f437b8de8", "title": "Webinar: What Application Owners Need to Know About SQL Server", "url": "https://www.sqlservercentral.com/articles/webinar-what-application-owners-need-to-know-about-sql-server", "published_at": "2026-09-09T00:00:46+00:00" }, { "id": "01a0df7a-5265-7019-9cf2-421f432a36af", "title": "How Azure Arc allows a DB admin to become SQL Server sysadmin – the vulnerability explained", "url": "https://www.sqlservercentral.com/articles/how-azure-arc-allows-a-db-admin-to-become-sql-server-sysadmin-the-vulnerability-explained", "published_at": "2026-09-09T00:00:04+00:00" }, { "id": "01a0df7a-5265-7019-9cf2-421f43e357ad", "title": "JSON indexing in SQL Server 2025: how it works and current limitations", "url": "https://www.sqlservercentral.com/articles/json-indexing-in-sql-server-2025-how-it-works-and-current-limitations", "published_at": "2026-09-07T00:00:45+00:00" }, { "id": "01a0df7a-5265-7019-9cf2-421f442540f1", "title": "Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't", "url": "https://www.sqlservercentral.com/articles/parameter-sensitive-plan-optimization-vs-parameter-sniffing-what-sql-server-fixes-and-what-it-doesnt", "published_at": "2026-09-04T00:00:49+00:00" }, { "id": "01a0df8a-6119-7172-98e3-9dc530d0d888", "title": "How to avoid nested REPLACE functions with TRANSLATE in SQL Server", "url": "https://www.sqlservercentral.com/articles/how-to-avoid-nested-replace-functions-with-translate-in-sql-server", "published_at": "2026-09-04T00:00:05+00:00" }, { "id": "01a0df8a-6119-7172-98e3-9dc531b8fe46", "title": "Importing Excel files into SQL Server using DuckDB and Python", "url": "https://www.sqlservercentral.com/articles/importing-excel-files-into-sql-server-using-duckdb-and-python", "published_at": "2026-09-02T00:00:53+00:00" }, { "id": "01a0df8a-6119-7172-98e3-9dc5328483e4", "title": "Database Animations: The Difference Between Row Compression and Page Compression", "url": "https://www.sqlservercentral.com/articles/database-animations-the-difference-between-row-compression-and-page-compression", "published_at": "2026-09-02T00:00:11+00:00" }, { "id": "01a0df8a-6119-7172-98e3-9dc532b89e3a", "title": "How Can SQL Server Detect Application Errors When Developers Can’t?", "url": "https://www.sqlservercentral.com/articles/how-can-sql-server-detect-application-errors-when-developers-cant", "published_at": "2026-08-31T00:00:31+00:00" }, { "id": "01a0df8a-6119-7172-98e3-9dc5332699a8", "title": "Configure SSMS Dark Mode Step By Step", "url": "https://www.sqlservercentral.com/articles/configure-ssms-dark-mode-step-by-step", "published_at": "2026-08-31T00:00:08+00:00" }, { "id": "01a0df8a-6119-7172-98e3-9dc533ef0eef", "title": "How to use the Power BI Desktop Bridge to automate tasks in Power BI Desktop and GitHub Copilot", "url": "https://www.sqlservercentral.com/articles/how-to-use-the-power-bi-desktop-bridge-to-automate-tasks-in-power-bi-desktop-and-github-copilot", "published_at": "2026-08-28T00:00:50+00:00" }, { "id": "01a0df8a-6119-7172-98e3-9dc533b345e7", "title": "Understanding Temp Tables and Table Variables in SQL Server", "url": "https://www.sqlservercentral.com/articles/understanding-temp-tables-and-table-variables-in-sql-server", "published_at": "2026-08-28T00:00:33+00:00" }, { "id": "01a0df8a-6119-7172-98e3-9dc5358367e2", "title": "sp_TexasHoldEm: Multi-Player Poker in T-SQL", "url": "https://www.sqlservercentral.com/articles/sp_texasholdem-multi-player-poker-in-t-sql", "published_at": "2026-08-26T00:00:51+00:00" }, { "id": "01a0df8a-6119-7172-98e3-9dc534949cc2", "title": "Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles", "url": "https://www.sqlservercentral.com/articles/kerberos-authentication-for-aurora-postgresql-mapping-ad-groups-to-database-roles", "published_at": "2026-08-26T00:00:40+00:00" }, { "id": "01a0df95-39d3-71f0-bf37-e86d981db278", "title": "How a SQL Server backup can execute attacker code during restore", "url": "https://www.sqlservercentral.com/articles/how-a-sql-server-backup-can-execute-attacker-code-during-restore", "published_at": "2026-08-24T00:00:51+00:00" }, { "id": "01a0df8a-6119-7172-98e3-9dc53661f47c", "title": "The memory toll of VARCHAR(MAX) in SQL Server", "url": "https://www.sqlservercentral.com/articles/the-memory-toll-of-varcharmax-in-sql-server", "published_at": "2026-08-24T00:00:14+00:00" }, { "id": "01a0df95-39d3-71f0-bf37-e86d98f22811", "title": "How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager", "url": "https://www.sqlservercentral.com/articles/how-we-reduced-sql-server-infrastructure-costs-by-33-on-aws-lessons-from-a-database-operations-manager", "published_at": "2026-08-21T00:00:41+00:00" }, { "id": "01a0df95-39d3-71f0-bf37-e86d9963d87f", "title": "What does a modern DBA actually do? 6 key points from a senior DBA", "url": "https://www.sqlservercentral.com/articles/what-does-a-modern-dba-actually-do-6-key-points-from-a-senior-dba", "published_at": "2026-08-21T00:00:24+00:00" }, { "id": "01a0df95-39d3-71f0-bf37-e86d99b747dc", "title": "Miscellaneous Thoughts About Building Stuff with AI in July 2026", "url": "https://www.sqlservercentral.com/articles/miscellaneous-thoughts-about-building-stuff-with-ai-in-july-2026", "published_at": "2026-08-19T00:00:58+00:00" }, { "id": "01a0df95-39d3-71f0-bf37-e86d9973a6ca", "title": "Automating SSAS Multidimensional Security Audits with PowerShell", "url": "https://www.sqlservercentral.com/articles/automating-ssas-multidimensional-security-audits-with-powershell", "published_at": "2026-08-19T00:00:07+00:00" }, { "id": "01a0df95-39d3-71f0-bf37-e86d99d78dc9", "title": "Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer", "url": "https://www.sqlservercentral.com/articles/automating-osm-data-refresh-in-power-bis-azure-maps-reference-layer", "published_at": "2026-08-17T00:00:32+00:00" }, { "id": "01a0df95-39d3-71f0-bf37-e86d9ac293d9", "title": "SQL Server index tuning: common mistakes and how to fix them", "url": "https://www.sqlservercentral.com/articles/sql-server-index-tuning-common-mistakes-and-how-to-fix-them", "published_at": "2026-08-17T00:00:14+00:00" }, { "id": "01a0df95-39d3-71f0-bf37-e86d9b392556", "title": "The Hidden Danger of Wildcard Operators In Join Operations", "url": "https://www.sqlservercentral.com/articles/the-hidden-danger-of-wildcard-operators-in-join-operations", "published_at": "2026-08-14T00:00:28+00:00" }, { "id": "01a0df95-39d3-71f0-bf37-e86d9bc63767", "title": "How to get clean, usable data out of SQL Server into Python", "url": "https://www.sqlservercentral.com/articles/how-to-get-clean-usable-data-out-of-sql-server-into-python", "published_at": "2026-08-14T00:00:12+00:00" }, { "id": "01a0df9d-ce16-716e-abfe-6582188aaddb", "title": "Create SQL Server 2025 Availability Groups with SSMS Wizard", "url": "https://www.sqlservercentral.com/articles/create-sql-server-2025-availability-groups-with-ssms-wizard", "published_at": "2026-08-12T00:00:54+00:00" }, { "id": "01a0df95-39d3-71f0-bf37-e86d9c65ee45", "title": "OUTER APPLY Fundamentals: Part 2", "url": "https://www.sqlservercentral.com/articles/outer-apply-fundamentals-part-2", "published_at": "2026-08-12T00:00:33+00:00" }, { "id": "01a0df9d-ce16-716e-abfe-6582192958e8", "title": "How to Work with On-Premises AI Models to Generate T-SQL Code", "url": "https://www.sqlservercentral.com/articles/how-to-work-with-on-premises-ai-models-to-generate-t-sql-code", "published_at": "2026-08-10T00:00:41+00:00" }, { "id": "01a0df9d-ce16-716e-abfe-6582198c1ee5", "title": "How SQL Server maintenance becomes an attack path – and what to do about it", "url": "https://www.sqlservercentral.com/articles/how-sql-server-maintenance-becomes-an-attack-path-and-what-to-do-about-it", "published_at": "2026-08-10T00:00:32+00:00" }, { "id": "01a0df9d-ce16-716e-abfe-65821b14b04b", "title": "Power BI Best Practices", "url": "https://www.sqlservercentral.com/articles/power-bi-best-practices", "published_at": "2026-08-07T00:00:40+00:00" }, { "id": "01a0df9d-ce16-716e-abfe-65821a5032d2", "title": "BIT_COUNT in SQL Server", "url": "https://www.sqlservercentral.com/articles/bit_count-in-sql-server", "published_at": "2026-08-07T00:00:03+00:00" }, { "id": "01a0df9d-ce16-716e-abfe-65821ba1c1e1", "title": "The best AI developer tools in 2026: from coding agents to code review", "url": "https://www.sqlservercentral.com/articles/the-best-ai-developer-tools-in-2026-from-coding-agents-to-code-review", "published_at": "2026-08-05T00:00:33+00:00" }, { "id": "01a0df9d-ce16-716e-abfe-65821b71bdea", "title": "T-SQL in SQL Server 2025: REGEXP_LIKE", "url": "https://www.sqlservercentral.com/articles/t-sql-in-sql-server-2025-regexp_like", "published_at": "2026-08-05T00:00:20+00:00" }, { "id": "01a0df9d-ce16-716e-abfe-65821c643917", "title": "Advanced T-SQL: Replacing Slow Cursors with Window Functions", "url": "https://www.sqlservercentral.com/articles/advanced-t-sql-replacing-slow-cursors-with-window-functions", "published_at": "2026-08-03T00:00:22+00:00" }, { "id": "01a0df9d-ce16-716e-abfe-65821cd875b0", "title": "Database Animations: You’ve Heard of Page Splits. Here’s What They Really Mean.", "url": "https://www.sqlservercentral.com/articles/database-animations-youve-heard-of-page-splits-heres-what-they-really-mean", "published_at": "2026-08-03T00:00:14+00:00" }, { "id": "01a0df9d-ce16-716e-abfe-65821d225c3c", "title": "Why SQL Server Database Attach fails and how to repair it", "url": "https://www.sqlservercentral.com/articles/why-sql-server-database-attach-fails-and-how-to-repair-it", "published_at": "2026-07-31T00:00:49+00:00" }, { "id": "01a0dfa4-d4dd-7296-aca2-c88f1f613756", "title": "Big data: what it is, why projects fail, and how to get value from it", "url": "https://www.sqlservercentral.com/articles/big-data-what-it-is-why-projects-fail-and-how-to-get-value-from-it", "published_at": "2026-07-31T00:00:46+00:00" }, { "id": "01a0dfa4-d4dd-7296-aca2-c88f20a16fce", "title": "Time Series Data Mining Example with T-SQL when Adding New Data", "url": "https://www.sqlservercentral.com/articles/time-series-data-mining-example-with-t-sql-when-adding-new-data-2", "published_at": "2026-07-29T00:00:20+00:00" }, { "id": "01a0dfa4-d4dd-7296-aca2-c88f203c5cfb", "title": "The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server", "url": "https://www.sqlservercentral.com/articles/the-successful-login-dilemma-why-your-login-auditing-strategy-might-be-hurting-your-server", "published_at": "2026-07-29T00:00:09+00:00" }, { "id": "01a0dfa4-d4dd-7296-aca2-c88f20ea4af2", "title": "5 T-SQL features that should already exist (2026 SQL Server wish list)", "url": "https://www.sqlservercentral.com/articles/5-t-sql-features-that-should-already-exist-2026-sql-server-wish-list", "published_at": "2026-07-27T00:00:37+00:00" }, { "id": "01a0dfa4-d4dd-7296-aca2-c88f20b7651f", "title": "CROSS APPLY Fundamentals: Part 1", "url": "https://www.sqlservercentral.com/articles/cross-apply-fundamentals-part-1", "published_at": "2026-07-27T00:00:03+00:00" }, { "id": "01a0dfa4-d4de-71bb-b895-2ddb4e77b883", "title": "SQL Server Data Warehouse Concepts, Schema Design, and Implementation", "url": "https://www.sqlservercentral.com/articles/sql-server-data-warehouse-concepts-schema-design-and-implementation-2", "published_at": "2026-07-24T00:00:49+00:00" }, { "id": "01a0dfa4-d4de-71bb-b895-2ddb4e329d36", "title": "SQL Agent Job Automated Change Capture Process", "url": "https://www.sqlservercentral.com/articles/sql-agent-job-automated-change-capture-process", "published_at": "2026-07-24T00:00:43+00:00" }, { "id": "01a0dfa4-d4de-71bb-b895-2ddb4f283339", "title": "Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened", "url": "https://www.sqlservercentral.com/articles/can-you-really-downgrade-from-enterprise-to-standard-and-save-thousands-heres-what-happened", "published_at": "2026-07-22T00:00:38+00:00" }, { "id": "01a0dfa4-d4de-71bb-b895-2ddb4fa5c702", "title": "Exposing a SQL injection vulnerability you’ve never heard of", "url": "https://www.sqlservercentral.com/articles/exposing-a-sql-injection-vulnerability-youve-never-heard-of", "published_at": "2026-07-22T00:00:29+00:00" }, { "id": "01a0dfaa-f104-71ed-95dd-532cbad98a84", "title": "Pros and Cons of Database Sharding for Performance and Maintenance", "url": "https://www.sqlservercentral.com/articles/pros-and-cons-of-database-sharding-for-performance-and-maintenance", "published_at": "2026-07-20T00:00:55+00:00" }, { "id": "01a0dfa4-d4de-71bb-b895-2ddb50a1c901", "title": "Connect an Azure Function to Azure SQL database Using a Managed Identity", "url": "https://www.sqlservercentral.com/articles/connect-an-azure-function-to-azure-sql-database-using-a-managed-identity", "published_at": "2026-07-20T00:00:22+00:00" }, { "id": "01a0dfaa-f104-71ed-95dd-532cbbb96468", "title": "Implicit Conversions Cripple SQL Server", "url": "https://www.sqlservercentral.com/articles/implicit-conversions-cripple-sql-server", "published_at": "2026-07-17T00:00:54+00:00" }, { "id": "01a0dfaa-f104-71ed-95dd-532cbbe2d071", "title": "Vector search in SQL Server: VECTOR_DISTANCE, VECTOR_SEARCH, and index trade-offs", "url": "https://www.sqlservercentral.com/articles/vector-search-in-sql-server-vector_distance-vector_search-and-index-trade-offs", "published_at": "2026-07-17T00:00:17+00:00" }, { "id": "01a0dfaa-f104-71ed-95dd-532cbc9670ef", "title": "How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning", "url": "https://www.sqlservercentral.com/articles/how-clustering-can-be-used-as-a-preprocessing-technique-for-classification-in-azure-machine-learning", "published_at": "2026-07-15T00:00:46+00:00" }, { "id": "01a0dfaa-f104-71ed-95dd-532cbcb30d91", "title": "Confession Time: I Never Taught You About B-Trees.", "url": "https://www.sqlservercentral.com/articles/confession-time-i-never-taught-you-about-b-trees", "published_at": "2026-07-15T00:00:34+00:00" }, { "id": "01a0dfaa-f104-71ed-95dd-532cbdc3581f", "title": "TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage", "url": "https://www.sqlservercentral.com/articles/try_parse-vs-try_convert-in-sql-server-from-basics-to-practical-usage", "published_at": "2026-07-13T00:00:34+00:00" }, { "id": "01a0dfaa-f104-71ed-95dd-532cbd5bb77c", "title": "It’s 2026. Why are databases still failing GDPR compliance audits?", "url": "https://www.sqlservercentral.com/articles/its-2026-why-are-databases-still-failing-gdpr-compliance-audits", "published_at": "2026-07-13T00:00:07+00:00" }, { "id": "01a0dfaa-f104-71ed-95dd-532cbef7300d", "title": "Correct SQL Server Always On Availability Group Not Synchronizing", "url": "https://www.sqlservercentral.com/articles/correct-sql-server-always-on-availability-group-not-synchronizing", "published_at": "2026-07-10T00:00:54+00:00" }, { "id": "01a0dfaa-f104-71ed-95dd-532cbebc4b44", "title": "Why Your SQL Permissions Disappeared", "url": "https://www.sqlservercentral.com/articles/why-your-sql-permissions-disappeared", "published_at": "2026-07-10T00:00:10+00:00" }, { "id": "01a0dfb0-c1a6-72d4-83ca-28c77f6c19ca", "title": "Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload", "url": "https://www.sqlservercentral.com/articles/five-intelligent-query-processing-features-in-sql-server-2022-that-quietly-tune-your-workload", "published_at": "2026-07-08T00:00:23+00:00" }, { "id": "01a0dfb0-c1a6-72d4-83ca-28c77fc2a8a6", "title": "How to call an Ollama-based AI text embeddings model from SQL Server 2025", "url": "https://www.sqlservercentral.com/articles/how-to-call-an-ollama-based-ai-text-embeddings-model-from-sql-server-2025", "published_at": "2026-07-08T00:00:06+00:00" }, { "id": "01a0dfb0-c1a6-72d4-83ca-28c77fe1d872", "title": "Calculating Geometric Mean in Power BI", "url": "https://www.sqlservercentral.com/articles/calculating-geometric-mean-in-power-bi", "published_at": "2026-07-06T00:00:26+00:00" }, { "id": "01a0dfb0-c1a6-72d4-83ca-28c78071ae3a", "title": "SQL Server Contained Availability Groups Configuration", "url": "https://www.sqlservercentral.com/articles/sql-server-contained-availability-groups-configuration", "published_at": "2026-07-06T00:00:14+00:00" }, { "id": "01a0dfb0-c1a6-72d4-83ca-28c780fe2f62", "title": "From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline", "url": "https://www.sqlservercentral.com/articles/from-sql-server-on-premises-to-claude-desktop-how-i-built-a-full-mcp-pipeline", "published_at": "2026-07-03T00:00:46+00:00" }, { "id": "01a0dfb0-c1a6-72d4-83ca-28c781fb2366", "title": "How to stop AI hallucinations in enterprise RAG systems (a complete guide)", "url": "https://www.sqlservercentral.com/articles/how-to-stop-ai-hallucinations-in-enterprise-rag-systems-a-complete-guide", "published_at": "2026-07-03T00:00:34+00:00" }, { "id": "01a0dfb0-c1a6-72d4-83ca-28c7810f30e5", "title": "SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About", "url": "https://www.sqlservercentral.com/articles/sql-art-part-4-happy-4th-of-july-a-british-dbas-guide-to-celebrating-a-war-we-dont-talk-about", "published_at": "2026-07-03T00:00:04+00:00" }, { "id": "01a0dfb0-c1a6-72d4-83ca-28c7826b5aed", "title": "How We Handled a Vendor Retry That Loaded Twice in Snowflake", "url": "https://www.sqlservercentral.com/articles/how-we-handled-a-vendor-retry-that-loaded-twice-in-snowflake", "published_at": "2026-07-01T00:00:47+00:00" }, { "id": "01a0dfb0-c1a6-72d4-83ca-28c782cb0b5a", "title": "Add New Disk to Windows Failover Cluster for SQL Server", "url": "https://www.sqlservercentral.com/articles/add-new-disk-to-windows-failover-cluster-for-sql-server", "published_at": "2026-07-01T00:00:23+00:00" }, { "id": "01a0dfb0-c1a6-72d4-83ca-28c7831bb47a", "title": "Parameter Sniffing in Production: How a 200ms Query Became a 90-Second Outage", "url": "https://www.sqlservercentral.com/articles/parameter-sniffing-in-production-how-a-200ms-query-became-a-90-second-outage", "published_at": "2026-06-29T00:00:32+00:00" }, { "id": "01a0dfb6-c287-71df-b55b-d926dc8a112e", "title": "Never ship a broken semantic model again: how to build automated tests in Power BI with user-defined functions", "url": "https://www.sqlservercentral.com/articles/never-ship-a-broken-semantic-model-again-how-to-build-automated-tests-in-power-bi-with-user-defined-functions", "published_at": "2026-06-29T00:00:08+00:00" }, { "id": "01a0dfb6-c287-71df-b55b-d926dcdc2232", "title": "SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values", "url": "https://www.sqlservercentral.com/articles/sql-server-enum-implementation-a-single-row-view-strategy-for-avoiding-magic-values", "published_at": "2026-06-26T00:00:24+00:00" }, { "id": "01a0dfb6-c287-71df-b55b-d926dd8bad84", "title": "Add Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster", "url": "https://www.sqlservercentral.com/articles/add-nodes-to-sql-server-2022-and-windows-server-2022-failover-cluster", "published_at": "2026-06-26T00:00:09+00:00" }, { "id": "01a0dfb6-c287-71df-b55b-d926de2945e2", "title": "How to host an AI text embeddings model for SQL Server using Ollama", "url": "https://www.sqlservercentral.com/articles/how-to-host-an-ai-text-embeddings-model-for-sql-server-using-ollama", "published_at": "2026-06-24T00:00:27+00:00" }, { "id": "01a0dfb6-c287-71df-b55b-d926e047c6ed", "title": "Why even the best teams struggle with cloud migrations", "url": "https://www.sqlservercentral.com/articles/why-even-the-best-teams-struggle-with-cloud-migrations", "published_at": "2026-06-22T18:27:29+00:00" }, { "id": "01a0dfb6-c287-71df-b55b-d926dfc641ae", "title": "How to Deploy SQL Server on Kubernetes running on Windows", "url": "https://www.sqlservercentral.com/articles/how-to-deploy-sql-server-on-kubernetes-running-on-windows", "published_at": "2026-06-22T00:00:45+00:00" }, { "id": "01a0dfb6-c287-71df-b55b-d926def6d5b5", "title": "Index Fragmentation Explained: Page Splits, Logical Reads, and What to Do", "url": "https://www.sqlservercentral.com/articles/index-fragmentation-explained-page-splits-logical-reads-and-what-to-do", "published_at": "2026-06-22T00:00:08+00:00" }, { "id": "01a0dfb6-c287-71df-b55b-d926e1f7f0e6", "title": "The LLM layer you’re probably missing (LLM gateway pattern explained)", "url": "https://www.sqlservercentral.com/articles/the-llm-layer-youre-probably-missing-llm-gateway-pattern-explained", "published_at": "2026-06-19T00:00:57+00:00" }, { "id": "01a0dfb6-c287-71df-b55b-d926e11892a2", "title": "You Probably Don't Need a Vector Database", "url": "https://www.sqlservercentral.com/articles/you-probably-dont-need-a-vector-database", "published_at": "2026-06-19T00:00:28+00:00" }, { "id": "01a0dfb6-c287-71df-b55b-d926e29a054c", "title": "What Happens When You Ask a Local AI to Query Your Database?", "url": "https://www.sqlservercentral.com/articles/what-happens-when-you-ask-a-local-ai-to-query-your-database", "published_at": "2026-06-17T00:00:20+00:00" }, { "id": "01a0dfbc-edf3-71ea-a022-ee13c2711b26", "title": "Your Database Just Hit One Terabyte: Now What?", "url": "https://www.sqlservercentral.com/articles/your-database-just-hit-one-terabyte-now-what", "published_at": "2026-06-17T00:00:00+00:00" }, { "id": "01a0dfbc-edf4-73bf-9b65-e2751452561b", "title": "Calculating the Harmonic Mean in Power BI", "url": "https://www.sqlservercentral.com/articles/calculating-harmonic-mean-in-power-bi", "published_at": "2026-06-15T00:00:05+00:00" }, { "id": "01a0dfbc-edf4-73bf-9b65-e275149eabc4", "title": "Display Active Slicers in Power BI using Dynamic DAX", "url": "https://www.sqlservercentral.com/articles/display-active-slicers-in-power-bi-using-dynamic-dax", "published_at": "2026-06-15T00:00:05+00:00" }, { "id": "01a0dfbc-edf4-73bf-9b65-e27515571755", "title": "SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry", "url": "https://www.sqlservercentral.com/articles/sql-art-whos-blocking-who-visualising-sql-server-blocking-with-spatial-geometry", "published_at": "2026-06-12T00:00:26+00:00" }, { "id": "01a0dfbc-edf4-73bf-9b65-e27516938b54", "title": "SQL Saturday Austin 2026", "url": "https://www.sqlservercentral.com/articles/sql-saturday-austin-2026", "published_at": "2026-06-12T00:00:21+00:00" }, { "id": "01a0dfbc-edf4-73bf-9b65-e27515cab343", "title": "How data scientists work with PostgreSQL from Python (and how to write queries that don’t break at scale)", "url": "https://www.sqlservercentral.com/articles/how-data-scientists-work-with-postgresql-from-python-and-how-to-write-queries-that-dont-break-at-scale", "published_at": "2026-06-12T00:00:01+00:00" }, { "id": "01a0dfbc-edf4-73bf-9b65-e275176049fc", "title": "SSMS Copilot is Messing With Your AI Prompts", "url": "https://www.sqlservercentral.com/articles/ssms-copilot-is-messing-with-your-ai-prompts", "published_at": "2026-06-10T00:00:12+00:00" }, { "id": "01a0dfbc-edf4-73bf-9b65-e275182dcd0c", "title": "Microsoft are retiring role-based certifications. Here’s why they shouldn’t", "url": "https://www.sqlservercentral.com/articles/microsoft-are-retiring-role-based-certifications-heres-why-they-shouldnt", "published_at": "2026-06-08T00:00:36+00:00" }, { "id": "01a0dfbc-edf4-73bf-9b65-e27517f64fc2", "title": "Vector Search in SQL Server 2025: Storing Embeddings, Querying Them, and What to Watch Out For", "url": "https://www.sqlservercentral.com/articles/vector-search-in-sql-server-2025-storing-embeddings-querying-them-and-what-to-watch-out-for", "published_at": "2026-06-08T00:00:10+00:00" }, { "id": "01a0dfc3-65cb-7013-b08e-427cf472247b", "title": "Understanding SQL Server PARTITION BY with Examples", "url": "https://www.sqlservercentral.com/articles/understanding-sql-server-partition-by-with-examples", "published_at": "2026-06-05T00:00:34+00:00" }, { "id": "01a0dfc3-65cb-7013-b08e-427cf487cb4e", "title": "Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform", "url": "https://www.sqlservercentral.com/articles/complex-data-processing-with-dbt-python-models-the-fabric-modern-data-platform", "published_at": "2026-06-03T00:00:08+00:00" }, { "id": "01a0dfc3-65cb-7013-b08e-427cf5b507c6", "title": "Fuzzy String Matching in SQL Server 2025", "url": "https://www.sqlservercentral.com/articles/fuzzy-string-matching-in-sql-server-2025", "published_at": "2026-06-01T00:00:48+00:00" } ] posts Claim your blog
Back to sqlservercentral.com
Blog · corpus.blog/blogs/sqlservercentral.com/posts

sqlservercentral.com

sqlservercentral.com

2026

Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressureoriginal ↗
25 Sept 2026
Migrate SQL Server Databases to Different Active Directory Domainoriginal ↗
25 Sept 2026
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fixoriginal ↗
23 Sept 2026
Database Animations: The Interview Question Everybody Gets Wrongoriginal ↗
23 Sept 2026
Finding Gaps in Sequential Data Using SQL Serveroriginal ↗
21 Sept 2026
What is cloud database vendor lock-in? The 3 types explained (and how to audit yours)original ↗
21 Sept 2026
Practical Reporting Queries with CROSS APPLY (Part 3)original ↗
18 Sept 2026
Foreign Keys and Performance in a Microsoft Fabric Warehouseoriginal ↗
18 Sept 2026
Implementing Type 4 Slowly Changing Dimensions in SQL Serveroriginal ↗
16 Sept 2026
SQL Server login failures: how to monitor, report, and alert on themoriginal ↗
16 Sept 2026
Database Animations: What’s a Residual Predicate and Why Is It Bad?original ↗
14 Sept 2026
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedureoriginal ↗
14 Sept 2026
9 things I wish SQL Server had (and why they’d matter)original ↗
11 Sept 2026
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Serveroriginal ↗
11 Sept 2026
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platformoriginal ↗
9 Sept 2026
Webinar: What Application Owners Need to Know About SQL Serveroriginal ↗
9 Sept 2026
How Azure Arc allows a DB admin to become SQL Server sysadmin – the vulnerability explainedoriginal ↗
9 Sept 2026
JSON indexing in SQL Server 2025: how it works and current limitationsoriginal ↗
7 Sept 2026
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn'toriginal ↗
4 Sept 2026
How to avoid nested REPLACE functions with TRANSLATE in SQL Serveroriginal ↗
4 Sept 2026
Importing Excel files into SQL Server using DuckDB and Pythonoriginal ↗
2 Sept 2026
Database Animations: The Difference Between Row Compression and Page Compressionoriginal ↗
2 Sept 2026
How Can SQL Server Detect Application Errors When Developers Can’t?original ↗
31 Aug 2026
Configure SSMS Dark Mode Step By Steporiginal ↗
31 Aug 2026
How to use the Power BI Desktop Bridge to automate tasks in Power BI Desktop and GitHub Copilotoriginal ↗
28 Aug 2026
Understanding Temp Tables and Table Variables in SQL Serveroriginal ↗
28 Aug 2026
sp_TexasHoldEm: Multi-Player Poker in T-SQLoriginal ↗
26 Aug 2026
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Rolesoriginal ↗
26 Aug 2026
How a SQL Server backup can execute attacker code during restoreoriginal ↗
24 Aug 2026
The memory toll of VARCHAR(MAX) in SQL Serveroriginal ↗
24 Aug 2026
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manageroriginal ↗
21 Aug 2026
What does a modern DBA actually do? 6 key points from a senior DBAoriginal ↗
21 Aug 2026
Miscellaneous Thoughts About Building Stuff with AI in July 2026original ↗
19 Aug 2026
Automating SSAS Multidimensional Security Audits with PowerShelloriginal ↗
19 Aug 2026
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layeroriginal ↗
17 Aug 2026
SQL Server index tuning: common mistakes and how to fix themoriginal ↗
17 Aug 2026
The Hidden Danger of Wildcard Operators In Join Operationsoriginal ↗
14 Aug 2026
How to get clean, usable data out of SQL Server into Pythonoriginal ↗
14 Aug 2026
Create SQL Server 2025 Availability Groups with SSMS Wizardoriginal ↗
12 Aug 2026
OUTER APPLY Fundamentals: Part 2original ↗
12 Aug 2026
How to Work with On-Premises AI Models to Generate T-SQL Codeoriginal ↗
10 Aug 2026
How SQL Server maintenance becomes an attack path – and what to do about itoriginal ↗
10 Aug 2026
Power BI Best Practicesoriginal ↗
7 Aug 2026
BIT_COUNT in SQL Serveroriginal ↗
7 Aug 2026
The best AI developer tools in 2026: from coding agents to code revieworiginal ↗
5 Aug 2026
T-SQL in SQL Server 2025: REGEXP_LIKEoriginal ↗
5 Aug 2026
Advanced T-SQL: Replacing Slow Cursors with Window Functionsoriginal ↗
3 Aug 2026
Database Animations: You’ve Heard of Page Splits. Here’s What They Really Mean.original ↗
3 Aug 2026
Why SQL Server Database Attach fails and how to repair itoriginal ↗
31 Jul 2026
Big data: what it is, why projects fail, and how to get value from itoriginal ↗
31 Jul 2026
Time Series Data Mining Example with T-SQL when Adding New Dataoriginal ↗
29 Jul 2026
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Serveroriginal ↗
29 Jul 2026
5 T-SQL features that should already exist (2026 SQL Server wish list)original ↗
27 Jul 2026
CROSS APPLY Fundamentals: Part 1original ↗
27 Jul 2026
SQL Server Data Warehouse Concepts, Schema Design, and Implementationoriginal ↗
24 Jul 2026
SQL Agent Job Automated Change Capture Processoriginal ↗
24 Jul 2026
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happenedoriginal ↗
22 Jul 2026
Exposing a SQL injection vulnerability you’ve never heard oforiginal ↗
22 Jul 2026
Pros and Cons of Database Sharding for Performance and Maintenanceoriginal ↗
20 Jul 2026
Connect an Azure Function to Azure SQL database Using a Managed Identityoriginal ↗
20 Jul 2026
Implicit Conversions Cripple SQL Serveroriginal ↗
17 Jul 2026
Vector search in SQL Server: VECTOR_DISTANCE, VECTOR_SEARCH, and index trade-offsoriginal ↗
17 Jul 2026
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learningoriginal ↗
15 Jul 2026
Confession Time: I Never Taught You About B-Trees.original ↗
15 Jul 2026
TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usageoriginal ↗
13 Jul 2026
It’s 2026. Why are databases still failing GDPR compliance audits?original ↗
13 Jul 2026
Correct SQL Server Always On Availability Group Not Synchronizingoriginal ↗
10 Jul 2026
Why Your SQL Permissions Disappearedoriginal ↗
10 Jul 2026
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workloadoriginal ↗
8 Jul 2026
How to call an Ollama-based AI text embeddings model from SQL Server 2025original ↗
8 Jul 2026
Calculating Geometric Mean in Power BIoriginal ↗
6 Jul 2026
SQL Server Contained Availability Groups Configurationoriginal ↗
6 Jul 2026
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipelineoriginal ↗
3 Jul 2026
How to stop AI hallucinations in enterprise RAG systems (a complete guide)original ↗
3 Jul 2026
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk Aboutoriginal ↗
3 Jul 2026
How We Handled a Vendor Retry That Loaded Twice in Snowflakeoriginal ↗
1 Jul 2026
Add New Disk to Windows Failover Cluster for SQL Serveroriginal ↗
1 Jul 2026
Parameter Sniffing in Production: How a 200ms Query Became a 90-Second Outageoriginal ↗
29 Jun 2026
Never ship a broken semantic model again: how to build automated tests in Power BI with user-defined functionsoriginal ↗
29 Jun 2026
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Valuesoriginal ↗
26 Jun 2026
Add Nodes to SQL Server 2022 and Windows Server 2022 Failover Clusteroriginal ↗
26 Jun 2026
How to host an AI text embeddings model for SQL Server using Ollamaoriginal ↗
24 Jun 2026
Why even the best teams struggle with cloud migrationsoriginal ↗
22 Jun 2026
How to Deploy SQL Server on Kubernetes running on Windowsoriginal ↗
22 Jun 2026
Index Fragmentation Explained: Page Splits, Logical Reads, and What to Dooriginal ↗
22 Jun 2026
The LLM layer you’re probably missing (LLM gateway pattern explained)original ↗
19 Jun 2026
You Probably Don't Need a Vector Databaseoriginal ↗
19 Jun 2026
What Happens When You Ask a Local AI to Query Your Database?original ↗
17 Jun 2026
Your Database Just Hit One Terabyte: Now What?original ↗
17 Jun 2026
Calculating the Harmonic Mean in Power BIoriginal ↗
15 Jun 2026
Display Active Slicers in Power BI using Dynamic DAXoriginal ↗
15 Jun 2026
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometryoriginal ↗
12 Jun 2026
SQL Saturday Austin 2026original ↗
12 Jun 2026
How data scientists work with PostgreSQL from Python (and how to write queries that don’t break at scale)original ↗
12 Jun 2026
SSMS Copilot is Messing With Your AI Promptsoriginal ↗
10 Jun 2026
Microsoft are retiring role-based certifications. Here’s why they shouldn’toriginal ↗
8 Jun 2026
Vector Search in SQL Server 2025: Storing Embeddings, Querying Them, and What to Watch Out Fororiginal ↗
8 Jun 2026
Understanding SQL Server PARTITION BY with Examplesoriginal ↗
5 Jun 2026
Complex Data Processing with dbt Python Models: The Fabric Modern Data Platformoriginal ↗
3 Jun 2026
Fuzzy String Matching in SQL Server 2025original ↗
1 Jun 2026
Next