Learn about the options to add users to Azure SQL Databases including SQL authentication logins, contained SQL users, contained Azure Active Directory users, mapped logins to users - including code examples you can copy and use immediately.
The post Adding Users to Azure SQL Databases appeared first on SQLServerCentral.

Learn different ways to create FOR Loops using T-SQL such as using WHILE loops, cursors, tally tables and more.
The post How to Create a FOR Loop in SQL Server appeared first on SQLServerCentral.

The CData Query Federation Driver, allows you to federate and aggregate data across drivers as a single database connection. You can combine the Query Federation Driver with other CData JDBC Drivers or CData ADO.NET Providers to access all your SaaS, Big Data, and NoSQL sources as if they were one database. You can query or update data from a single […]
The post Run Queries Across Many Data Sources at Once with the CData Query Federation Driver appeared first on SQLServerCentral.

This article explains the fastest ways to restore the previous version of the database, to recover from a failed Flyway migration that leaves the database in an indeterminate state, and then how to adapt your database development process to avoid these problems.
The post Dealing with Failed SQL Migrations in MariaDB or MySQL appeared first on SQLServerCentral.

This article looks at what an average day of a SQL Server Data Architect looks like and some of the things you would need to as a Data Architect.
The post A Day in the Life of a SQL Server Data Architect appeared first on SQLServerCentral.

Want an insight into how your fellow DBAs work? This episode features Kevin Davis, Manager of Database Administration at Tower Loan, a consumer finance company with 250 branches across the US.
The post DBAs at work #3: The finance company Manager DBA appeared first on SQLServerCentral.

This article explores how to create and use views in SQL Server 2019 using SSMS.
The post Views in SQL Server 2019 with SSMS appeared first on SQLServerCentral.

Learn about joining SQL Server tables together for a query when there is a need to join on multiple columns.
The post Learn about SQL Joins on Multiple Columns appeared first on SQLServerCentral.