Knowledge Base
Search Results ...
Using PowerShell to Document SQL Server Inventory
Maintaining a comprehensive and up-to-date inventory of SQL Server databases is essential for effective management and monitoring of your database environment. Whether you're an administrator of a small database ecosystem or a DBA managing multiple databas[.....]
DB2 Identity Columns vs SQL Server Sequences
In the world of databases, the means of generating unique, sequential values can be crucial for various applications. Two such methods of generating these values are DB2 Identity Columns and SQL Server Sequences. This blog post will delve into each of thes[.....]
Migrating SQL Server Workloads to Azure VMs (Pre-MI Era)
In recent years, the shift towards cloud computing has been rapidly gaining momentum and many companies are migrating their SQL Server workloads to Azure Virtual Machines (VMs). This transition can provide numerous benefits including cost savings, scalabil[.....]
PostgreSQL vs SQL Server for Medium-Scale Applications
In the world of database management, decisions about which database system to use can significantly impact the performance and efficiency of your applications. Today, we will focus our comparison on two big players in the industry: PostgreSQL and SQL Serve[.....]
Creating Vector Indexes in SQL Server for Similarity Search
A similarity search is a type of search that finds objects that are similar to a specified example. This type of search is common in areas like multimedia retrieval, data mining, bioinformatics, among others. To perform similarity searches efficiently, dat[.....]
Bulk Loading Parquet Files into SQL Server with PolyBase
Welcome to SQLSupport.org! Today we'll be exploring how to use PolyBase to bulk load Parquet files into SQL Server. Parquet, a compressed and efficient columnar storage format, has been rapidly gaining in popularity due to its impressive speed and flexibil[.....]
Hybrid ETL Architecture Across DB2, SQL Server, and MySQL
With the rise of big data and the need for real-time data analytics, modern data architectures are increasingly adopting a hybrid ETL (Extract, Transform, Load) approach. This approach allows for seamless data integration across diverse databases like DB2,[.....]
Automating SQL Server Patch Rollouts with PowerShell
The importance of regularly updating your SQL server cannot be overstated. With each patch, you get a host of bug fixes, security updates, and new features that can significantly improve the performance and security of your databases. However, manually pat[.....]
Cross-Site SQL Server Failover in Energy Sector DR Planning
The integrity and availability of data are of critical importance in the Energy sector. As such, Disaster Recovery (DR) planning should be at the forefront of any robust IT strategy. One of the most reliable ways to ensure data protection and high availabi[.....]
Migrating DB2 Data into SQL Server Using SSIS
The process of migrating DB2 data into SQL Server can be an intimidating task, but with the right tools and guidance, it can be achieved successfully and efficiently. One of the most reliable tools for this is SQL Server Integration Services (SSIS). SSIS i[.....]