Knowledge Base
Search Results ...
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[.....]
Paginated Reports with Dynamic Parameters in SSRS
When it comes to creating paginated reports with dynamic parameters in SQL Server Reporting Services (SSRS), it can be a bit of a challenge. The good news is that, with SQL Server 2016, SQL Server 2017, MySQL 5.7, DB2 11.1, and Azure SQL, there are several[.....]
SQL Agent History Retention and Cleanup Scripts
The SQL Server Agent is an integral part of managing and monitoring SQL Server. It provides an automated way to schedule jobs, monitor SQL Server, and process alerts. However, over time, the history of these jobs can accumulate and consume significant data[.....]
Using xp_cmdshell for Controlled File System Access
The xp_cmdshell is a powerful extended procedure installed by default in SQL Server. It enables the database system to issue operating system commands like those entered at the DOS prompt or the command prompt. This article will delve into the use of xp_cm[.....]
Using OPENROWSET for Flat File Processing
One of the essential tasks for any database administrator is to import data from flat files into relational databases. SQL Server 2016, SQL Server 2017, MySQL 5.7, DB2 11.1, and Azure SQL provide some powerful features to process flat files. One such featu[.....]