Knowledge Base
Search Results ...
Bulk Loading Excel into SQL Server via SSIS
In the world of data management, Microsoft SQL Server Integration Services (SSIS) is a powerful tool that provides a platform for building high performance data integration solutions, including extraction, transformation, and loading (ETL) packages for dat[.....]
SQL Server Execution Plan Caching and Reuse
SQL Server's performance is key to the smooth running of many business operations. One factor that significantly influences SQL Server's performance is the execution plan caching and reuse. In this blog post, we'll delve into the intricacies of SQL Server[.....]
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[.....]
Combining DB2 and SQL Server Data in Power BI
As data professionals, we often find ourselves working with diverse databases. Two such databases are IBM's DB2 and Microsoft's SQL Server. Each of these databases offers unique features that can prove beneficial to your organization. However, there are ti[.....]
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[.....]
Security for Linked Server Connections Across Domains
As database professionals, we are often required to design and implement solutions that not only maximize data accessibility and performance but also ensure data security. One such situation is when we have to establish a linked server connection between S[.....]
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[.....]
Using sys.dm_exec_requests to Troubleshoot Blocking
SQL Server provides a wealth of dynamic management views (DMVs) that can be leveraged to troubleshoot a variety of issues. One of the most useful for investigating blocking issues is sys.dm_exec_requests. This DMV returns information about all requests tha[.....]
Basic Graph Queries in SQL Server 2017
Welcome to the SQLSupport.org blog. Today, we are going to delve into the realm of graph databases and how they can be utilized in SQL Server 2017. As you may know, graph databases are a type of NoSQL database that uses graph theory to store, map and query[.....]