SQL Server identity columns are easy to add to a table, but you must understand how they work to use them effectively. In this article, Greg Larsen explains the nuances of SQL Server identity columns.
The post Working with SQL Server identity columns appeared first on SQLServerCentral.

Big data plays a key role in promoting both manufacturing and scientific development through industrial digitization and emerging research. Integrating big data demands scalable tools for enabling not only big data ingestion and curation but also efficient large-scale exploration and discovery. There is a solution to scale up to large volumes of data distributed across multiple […]
The post CData Connect: Derived Views and Query Federation appeared first on SQLServerCentral.

Learn about the different iterator activities in Azure Data Factory.
The post Iteration and Conditional Activities in Azure Data Factory appeared first on SQLServerCentral.

This article from Phil Factor will get you up and running quickly with Flyway migrations on MariaDB or MySQL databases, from PowerShell.
The post Flyway with MariaDB for Those of a Nervous Disposition appeared first on SQLServerCentral.

Troy Hunt joins Steve Jones to discuss the critical and complex role of monitoring in organizational data security and compliance.
The post Troy Hunt talks Security and compliance in estate monitoring appeared first on SQLServerCentral.

Learn how to enable or disable full text search for a specific database on a SQL Server instance where the Full Text Search components have been setup.
The post How to Enable and Disable Full Text Search for SQL Server Databases appeared first on SQLServerCentral.

PolyBase is a new feature of SQL Server that allows you to connect to relational and non-relational data. You can run queries on any external data sources you might have, such as Oracle, PostgreSQL, Salesforce, MongoDB, Hadoop, etc. When paired with the CData ODBC Driver for PostgreSQL, you get access to your PostgreSQL data directly […]
The post Connect to PostgreSQL as an External Data Source using PolyBase appeared first on SQLServerCentral.

When you execute a query, the database server has to figure a lot of things out. For even the simplest queries, there are usually several possible ways to get the job done.
The post What Is a Cost-Based Optimizer? appeared first on SQLServerCentral.