Knowledge Base
Search Results ...
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[.....]
Consolidating SSRS Catalogs from Multiple Servers
It is not uncommon for organizations to have multiple SQL Server Reporting Services (SSRS) servers, each with their own catalog of reports. However, managing these numerous catalogs can become a daunting task. In this blog post, we will discuss how to cons[.....]
Cluster Shared Volumes vs Traditional Drive Letters
The choice between Cluster Shared Volumes (CSV) and traditional drive letters can have a significant impact on your database performance, scalability, and manageability, particularly when it comes to SQL Server 2016 and SQL Server 2017. Both have their str[.....]
Parameterized DB2 Queries from Python via pyodbc
The power of Python cannot be overstated, especially when it comes to interacting with databases. Python's pyodbc module simplifies the process of connecting to ODBC databases, such as SQL Server 2016, SQL Server 2017, MySQL 5.7, DB2 11.1, and Azure SQL. I[.....]
Storing Configuration in SQL Instead of XML
The world of data storage and management is dynamic and ever evolving. With the rise of XML, JSON, and NoSQL databases, traditional SQL databases have had to adapt to these shifts in technology. One such adaptation is storing configuration data in SQL inst[.....]
Detecting Orphaned Users in SQL Server and Fixing Them
In the world of database management, maintaining a secure and seamless operation often requires the detection and resolution of issues before they escalate into serious problems. One such common issue in SQL Server is the presence of orphaned users, which[.....]
Using SQLCMD for Scripted Deployments
In the world of SQL Server, the SQLCMD utility provides a powerful command-line tool for SQL Server instances. It is an ideal choice for managing and administering SQL Server services, especially when used for scripted deployments. SQLCMD was introduced wi[.....]