Knowledge Base
Search Results ...
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[.....]
Azure SQL Database DTU vs vCore Explained
In the world of cloud databases, Azure SQL Database presents two pricing models: Database Transaction Unit (DTU) and vCore. Both models offer a variety of service tiers to accommodate different requirements and budgets. But which one is best for your busin[.....]
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[.....]
SQL Scalar Function Inlining in SQL Server 2017
Welcome to SQLSupport.org's blog! Today, we're going to delve into an important feature introduced in SQL Server 2017 - SQL Scalar Function Inlining. This new SQL Server 2017 feature builds upon the technologies present in SQL Server 2016, MySQL 5.7, DB2 1[.....]
Diagnosing SQL Server Storage Bottlenecks
As a SQL Server Database Administrator, it is crucial to diagnose and resolve storage bottlenecks to ensure optimal performance of your databases. Storage bottlenecks can severely impact your database performance and can potentially cause disruptions in se[.....]
DB2 Federated Query Configurations
Welcome to another blog post from SQLSupport.org, today we will be discussing DB2 Federated Query Configurations. A federated database system is an integrated collection of databases, each with its own DBMS. They are self-governing but participate in a fed[.....]
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[.....]
MySQL Stored Procedure Error Handling Best Practices
In the world of SQL Server, MySQL, and DB2, stored procedures play a crucial role in organizing and executing repeatable sets of database operations. However, the successful implementation of these operations is highly dependent on robust error handling me[.....]
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[.....]