Knowledge Base
Search Results ...
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[.....]
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[.....]
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[.....]
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[.....]
Transparent Data Encryption Setup and Gotchas
In the world of data management, security remains a paramount concern. One of the most powerful tools in the arsenal of a database administrator is Transparent Data Encryption (TDE), a technology that encrypts database files to enhance security. This blog[.....]