SQL Server Indexes to Improve Query Performance

In this article, we look at how to design SQL Server indexes and why the way an index is created makes a difference in query performance.

Join a community like no other at Summit

There's not long until PASS Data Community Summit takes place. There's still time to register for an in-person or online pass, and unlock access to over 300 world-class sessions. Join liked-minded attendees at the year's largest hybrid data platform conference. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE
Register now

Leveraging the Script Activity within Azure Data Factory

Learn how to use the Script activity in an Azure Data Factory pipeline to deploy and populate databases using DDL, DCL, and DML statements.

Introducing the MySQL INSERT statement

In the previous article in this series, I introduced you to the SELECT statement, one of several SQL statements that fall into the category of data manipulation language (DML), a subset of statements used to query and modify data. Another DML statement is the INSERT statement, which lets you add data to MySQL tables, both permanent and temporary. This article covers the INSERT statement and the different ways you can use it to add data.

Sign up to PASS Data Community Summit 2022

There's still time to register for Summit and unlock access to over 300 sessions. Join peers and industry leaders in the data community homecoming. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE.

How SQL Monitor gives developers the information they need to develop faster and smarter

Leading Danish pharmaceutical company, Orifarm, has a mission to be 'Number 1 in making healthcare a better deal'. Find out why they chose SQL Monitor to give their whole IT team, developers included, the real-time metrics they need to highlight development issues and resolve them before they become problems.

SQL Cheat Sheet for Basic T-SQL Commands

In this article, we cover some basic T-SQL commands that show you how to interact with a SQL Server database table.

Expert-led PASS Data Community Summit Pre-cons

Spaces are still available for next month's PASS Data Community Summit pre-conference sessions - but they’re booking up fast! Choose from 18 deep-dive full day pre-cons, featuring some of the best minds in the data industry, covering everything from technical processes to personal growth. Register now.

SQL Stored Procedure Input and Output Parameters, Types, Error Handling, Security and more

In this article, we look at various aspects of creating SQL Server stored procedures along with several examples of how to build a stored procedure.

5 Database DevOps Trends Landing on your Shoulders

Are these challenges heading your way?

Join us on Nov 15th at PASS Data Summit to discuss key trends that impact Database DevOps, such as Containerization, and Cloud Build/CI systems. Reserve your place now.