Knowledge Base
Search Results ...
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[.....]
Columnstore Indexes in SQL Server 2016: Real-World Use
In the world of big data, the ability to quickly and efficiently analyze large datasets is vital. SQL Server 2016 introduced a significant feature to help with this task: Columnstore Indexes. This type of index stores column data together, as opposed to tr[.....]
Minimizing TempDB Contention in SQL Server
As a database administrator, one of the challenges you may encounter is TempDB contention in SQL Server. This can notably impact the performance of your databases. TempDB contention happens when multiple tasks are trying to create or delete temporary objec[.....]
Backup Compression Ratios: SQL Server vs MySQL
In the world of database management, backing up your data is a critical operation. Equally important is the ability to effectively compress these backups to maximize storage efficiency. This article will compare the backup compression ratios of SQL Server[.....]