Knowledge Base
Search Results ...
Managing SQL Server Permissions with Custom Roles
One of the most important aspects of database administration is managing SQL Server permissions. This task can be complex due to the multitude of permissions that exist within the database system. However, the use of custom roles can simplify this process[.....]
SQL Server Blocking Chains and Deadlock Analysis
In the world of SQL Server, understanding and managing blocking chains and deadlocks is crucial to maintaining optimal performance. Blocking chains occur when one process holds a lock on a specific resource, preventing another process from accessing it. On[.....]
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[.....]
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[.....]
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[.....]
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[.....]
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[.....]
Working with Legacy DTS on Modern SQL Servers
Legacy DTS (Data Transformation Services) packages can be a challenge to work with on modern SQL Server versions like SQL Server 2016 and 2017. They are no longer natively supported, but with a few workarounds, it is possible to continue using them, albeit[.....]
Backup Encryption in SQL Server 2016
In recent years, the importance of data security has become paramount. With SQL Server 2016, the need for data encryption, particularly for backups, has been addressed. The introduction of the Transparent Data Encryption (TDE) feature, which was first intr[.....]