Knowledge Base
Search Results ...
MySQL Performance Schema vs SQL Server DMVs
In the ever-evolving world of database technology, having the right tools for performance analysis is crucial. Two such tools are MySQL's Performance Schema and SQL Server's Dynamic Management Views (DMVs). Both provide valuable insights into the functiona[.....]
Extracting Metadata from SSRS Reports for Cataloging
SQL Server Reporting Services (SSRS) is a powerful tool that allows developers to design and manage reports. However, when working with a large number of reports, it can become difficult to manage the metadata associated with each report. This blog post wi[.....]
Best Practices for Managing Linked Servers Securely
Linked servers provide a robust environment to execute distributed queries against different data sources, be it SQL Server, MySQL, DB2, or Azure SQL. However, managing these linked servers securely is a crucial aspect of any database administration. This[.....]
Tips for Tuning SQL Server Merge Statements
SQL Server MERGE statements, introduced in SQL Server 2008, offer a powerful way to perform multiple DML operations in a single statement. However, tuning these statements for optimal performance can be tricky. This article provides some tips on how to go[.....]
Using Change Data Capture (CDC) for Audit Requirements
In today's data-driven world, being able to track and audit changes to your database is not just a sensible precaution, it can also be a regulatory requirement. Fortunately, SQL Server 2012, SQL Server 2014, MySQL 5.6, DB2 10.5, and Azure SQL all support a[.....]
Using OPENQUERY for Cross-Platform Joins Between DB2 and SQL
For enterprises that manage multiple databases across different platforms, combining data from these varying sources may present a complex challenge. However, SQL Server provides a function called OPENQUERY that allows users to execute a pass-through query[.....]
Comparing SQL Server Full-Text Search and LIKE
When it comes to searching textual data in SQL Server, two options that usually come to mind are Full-Text Search and the LIKE operator. Both are tools that can be used for pattern matching and searching text, but they differ in their approaches and capabi[.....]
Migrating DTS Packages to SSIS 2016
Migrating DTS packages to SSIS 2016 can be a daunting task, particularly for databases that have been heavily invested in SQL Server 2012 or SQL Server 2014. However, with careful planning and execution, the transition can be a smooth one. This blog aims t[.....]
Introduction to Azure SQL Database: First Impressions Note from the Data Whisperer
Greetings, fellow data enthusiasts, and welcome back to SQLSupport.org. I am the Data Whisperer, and today I am excited to share my first impressions of Azure SQL Database. As many of you are already aware, Azure SQL Database is a cloud-based relational da[.....]
SQL Server Wait Stats Interpretation for Performance Tuning
In the world of SQL Server, understanding wait statistics is crucial for effective performance tuning. SQL Server uses wait statistics to track the amount of time a thread has to wait before it can get the resources it needs to execute a task. This data is[.....]