Knowledge Base
Search Results ...
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[.....]
PowerShell Script to Snapshot Database Metadata
In today's database-driven world, database metadata is of utmost importance because it provides a detailed schema of how, where, and when data is stored and accessed. It is essential to have a snapshot of your database metadata, as it allows you to view an[.....]
SSRS Hidden Parameters and Conditional Visibility
SQL Server Reporting Services (SSRS) is a robust tool for building, deploying, and managing reports. In this post, we will delve into a couple of aspects that can significantly enhance your reporting capabilities, namely the use of hidden parameters and co[.....]
Transforming Flat Files with Irregular Delimiters in SSIS
When working with flat files in SQL Server Integration Services (SSIS), one of the most common challenges is dealing with irregular delimiters. An irregular delimiter is a character or sequence of characters that separates the fields in a flat file, but th[.....]
SSIS Project Deployment: Environment Variable Tips
SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. It is a platform for data integration and workflow applications. In this blog post, we wi[.....]
DBA Checklists: What to Monitor Every Morning
The life of a Database Administrator (DBA) revolves around ensuring that database systems run efficiently and securely. A crucial part of this is daily monitoring and maintenance. In this post, we will be discussing a checklist that a DBA should follow eve[.....]
Surrogate vs Natural Keys in Warehouse Dimensions
The choice between surrogate and natural keys in warehouse dimensions is one that can significantly impact the efficiency and effectiveness of your database management system. Before we delve into the specifics of each, it's important to understand that th[.....]
Managing SQL Agent Job Ownership and Alerts Note from the Data Whisperer
Welcome to another edition of SQLSupport.org's blog, where we unravel the complexities of SQL Server management. Today, we'll be discussing the nuances of managing SQL Agent Job Ownership and Alerts. This is a crucial task for DBAs as it ensures the smooth[.....]