Knowledge Base
Search Results ...
SQL Agent Job Schedules for Enterprise Workflows
SQL Agent Job Schedules are a fundamental part of managing enterprise workflows, especially when it comes to automating tasks and ensuring mission-critical operations are executed efficiently. SQL Agent Job Schedules, available in SQL Server 2016, SQL Serv[.....]
Implementing Data Quality Audits via SSIS
Data quality becomes increasingly important in an age where data is the primary currency for businesses. Ensuring data quality is fundamental to the reliability of business decisions, and to the overall success of data-driven strategies. In this post, we w[.....]
SQL Injection Defense Using Parameterized Queries
SQL Injection is a prevalent security risk for many database-driven applications, and one that cannot be overlooked in this day and age. A SQL injection attack occurs when a hacker manipulates an application's database query by inserting malicious SQL stat[.....]
SSRS Mobile Report Publisher Basics
SQL Server Reporting Services (SSRS) is a comprehensive and versatile platform for developing, deploying, and managing reports for your organization. One of the new features added to SSRS in SQL Server 2016 is the ability to create mobile reports using the[.....]
Using BCP Utility for Fast Imports
In the realm of SQL Server, the BCP (Bulk Copy Program) utility is a powerful tool that facilitates the fast import and export of large amounts of data. This command-line utility, which has been a part of SQL Server since its inception, and is available in[.....]
Using SQL Profiler Templates for Performance Audits
Welcome to SQLSupport.org! In today's blog post, we'll be focusing on using SQL Profiler templates to conduct performance audits. SQL Profiler is a powerful tool available in SQL Server 2016 and 2017 capable of capturing and analyzing SQL Server events suc[.....]
Using CROSS APPLY for Efficient Row Expansion
Welcome to SQLSupport.org. Today, we are focusing on the use of CROSS APPLY, a powerful SQL Server operator that can enhance your database queries, resulting in more efficient and flexible row expansion. Introduced in SQL Server 2005, CROSS APPLY has since[.....]
Generating XML Files with FOR XML PATH
XML, or Extensible Markup Language, is a powerful tool for storing and transporting data. In the world of database management, it's often necessary to generate XML files from SQL Server data. SQL Server 2016 and 2017, MySQL 5.7, DB2 11.1, and Azure SQL hav[.....]
Implementing ETL Logging Frameworks in SSIS
In the world of data integration and transformation, Extract, Transform, Load (ETL) processes are critical. An essential aspect of ETL is logging, which facilitates debugging, auditing, and performance tuning among other things. This blog post will discuss[.....]
Optimizing INSERT Performance with Minimal Logging Note from the Data Whisperer
Welcome to another blog post from SQLSupport.org. Today, we will discuss optimizing INSERT performance with minimal logging. This topic is crucial for anyone working with database systems such as SQL Server 2016, SQL Server 2017, MySQL 5.7, DB2 11.1, and A[.....]