Scripts and Tools

Exporting Data from SQL Server the Right Way: Agent, PowerShell, BCP, and SSIS Explained – SQLYARD Leave a Comment / Articles, Scripts / By SQLYARD Exporting Data from SQL Server the Right Way By David Yard · SQLYARD.com · April 2026 · Estimated read: 18–22 min Agent, CmdExec, PowerShell, BCP, and SSIS Explained with Real-World

SSIS Execution Best Practices: File System vs SSISDB Catalog with Complete Workshop – SQLYARD Leave a Comment / Articles, Scripts / By SQLYARD SSIS Execution Best Practices: File System vs SSISDB Catalog with Complete Workshop By David Yard · SQLYARD.com · April 2026 · Estimated read: 20–25 min Compatibility: SSISDB (the SSIS Catalog) has been

From Novice to Confident Builder This guide is designed as a skill journey, not just a tutorial. Most SQL articles teach you a few queries and stop. Real data warehouses are built in layers, over time, with increasing discipline and maturity. This guide walks you through that exact path. You will start as a beginner,

A practical guide to data virtualization in SQL Server from novice to expert Introduction In 2025, a lot of organizations are still running SQL Server on-prem. Some by choice. Some by regulation. Some because moving 50 TB of data is not a weekend project. The good news is this. You do not need to move

SQL Server 2025 makes “AI next to the data” practical by adding native vector storage, vector indexing and search, and first class hooks to embedding endpoints like Azure OpenAI through CREATE EXTERNAL MODEL. This lets you build semantic search and Retrieval Augmented Generation (RAG) without standing up a separate vector database. [1] [2] Below is

Introduction SQL Server 2025 introduces one of the most forward-looking features in its history: the ability to call external REST and GraphQL endpoints directly from T-SQL using the new stored procedure: This fundamentally expands SQL Server from a relational engine into a hybrid data-integration platform capable of: • Calling REST and GraphQL APIs• Triggering Azure

Introduction Continuing SQL Server 2025’s expansion of native regular expression support, today we cover two functions that focus on location and frequency: • REGEXP_INSTR() – returns the starting or ending position of a matched substring• REGEXP_COUNT() – returns the number of times a pattern occurs in a string Together, these functions let you analyze text

Introduction SQL Server 2025 continues expanding its native regular expression capabilities with two highly practical functions: • REGEXP_SUBSTR() – extract a substring that matches a pattern• REGEXP_REPLACE() – replace substrings that match a pattern These functions eliminate years of workarounds involving CHARINDEX, SUBSTRING, PATINDEX, XML methods, and CLR helpers. With SQL Server 2025, you can

Introduction If you have spent time tuning SQL Server queries, you have probably seen advice like “avoid implicit conversions” or “make sure your data types match.” This guidance shows up in execution plans, performance checklists, and even SQL Server warning messages. But does explicitly converting data types in SQL Server actually improve query runtime, or