Knowledge Base
Search Results ...
Managing SSRS Permissions via T-SQL Scripts
Welcome back to SQLSupport.org! Today, we will focus on managing SQL Server Reporting Services (SSRS) permissions via T-SQL scripts. Microsoft SQL Server 2016 and 2017, as well as MySQL 5.7, DB2 11.1, and Azure SQL all offer unique ways of handling SSRS pe[.....]
MySQL 5.7 JSON Data Type Use Cases
In recent years, MySQL 5.7 has introduced a JSON data type for storing and managing JSON documents. JSON, or JavaScript Object Notation, is a lightweight data-interchange format that is easy to read and write, and easy for machines to parse and generate. T[.....]
Creating Audit Trails Using SQL Server Change Data Capture
Welcome to SQLSupport.org’s blog! Today, we’ll be delving into the realm of creating audit trails using SQL Server Change Data Capture (CDC). In the world of database administration, it’s crucial to have the capability to track changes made to your data ov[.....]
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[.....]
SSMS Registered Servers: Tips for Organizing Fleet
Welcome to another informative post from SQLSupport.org. Today, we will be discussing SSMS Registered Servers and providing you with some valuable tips to help organize your fleet. Effective organization of your registered servers is essential to increase[.....]
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[.....]
SSRS Bookmark Links and Jump-to Functionality
Welcome to another edition of SQLSupport.org's blog. Today, we'll be delving into the powerful, yet often underutilized feature of SQL Server Reporting Services (SSRS), known as Bookmark Links and Jump-to functionality. In this article, we will explore how[.....]
Dimensional Modeling for HR Data Warehouses
Data warehousing has become an integral part of most organizations today, and one area that has seen a significant amount of growth in data warehousing is Human Resources (HR). In this blog post, we will discuss the concept of dimensional modeling and how[.....]
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[.....]
Service Broker Setup for Asynchronous Messaging
SQL Server Service Broker provides native support for messaging and queuing applications in the SQL Server Database Engine. This makes it easier to build reliable and scalable applications. The Service Broker is used to send and receive messages from one d[.....]