The ins and outs of joining tables in SQL Server

• by Additional Articles

• SimpleTalk

• Learn SQL

Most database queries require joining tables. In this article, Greg Larsen explains the ins and outs of joining tables in SQL Server.

Living Up To Your Word

• by Steve Jones

• SQLServerCentral

• Career Growth

Steve feels it is not only important to keep your word, but communicate clearly what you mean to others.

Stairway to ScriptDOM Level 1 - An Introduction to ScriptDOM

• by Mala Mahadevan

• SQLServerCentral

• ScriptDOM
• Stairway Series

Get an introduction to the Stairway Series and learn about the power of the ScriptDOM library.

Stairway to ScriptDOM Level 2 - Parsing, Tokens, and the Abstract Syntax Tree

• by Mala Mahadevan

• SQLServerCentral

• ScriptDOM
• Stairway Series

In this level of the Stairway to ScriptDOM, we examine the way the tool parses scripts and creates tokens from the text.

Your First Repo in Azure Data Studio or VS Code

• by Steve Jones

• SQLServerCentral

• Azure Data Studio
• Git
• Version Control Systems (VCS)
• Visual Studio Code

Learn how to get started with Git and avoid the command line by using VS Code or Azure Data Studio.

A MySQL story: Can system engineers solve database issues using system tools?

• by Additional Articles

• SimpleTalk

• MySQL

A story about how a system engineer solved a MySQL performance issue written by Rajeshkumar Sasidharan

DevOps 101: Introducing Database DevOps

• by Additional Articles

• Redgate

• Conferences, Classes, Events, and Webinars

Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover what we mean by Database DevOps, why you need to include the database in your DevOps initiative and the benefits its offer you, your teams, and your organization.

Crazy Interview Questions

• by Steve Jones

• SQLServerCentral

• Career Growth
• interview questions

Interviews are always a challenge, but sometimes there are crazy questions. We can do better, especially in terms of how we evaluate the answer to a question.

Who is the Best Batman in Power BI

• by Daniel Calbimonte

• SQLServerCentral

• Power BI Desktop

Who is the best Batman? – A Power BI Analysis of data Introduction Who is the best Batman? We were drinking some cold beers with some friends when someone said that Pattinson was the best Batman. People started to discuss and after 2 hours, the police had to stop the fight. The discussion inspires me […]

Flyway How-tos: a User’s Perspective

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

Flyway provides a database-independent way for a team to track, manage and apply database changes, while maintaining strict control of database versions. It updates a database by running a series of versioned migration scripts, in order, and keeps track of all the changes in a special "schema history" table. It sounds simple, but it is easy to derail this team discipline if you don't find the right answers to the following questions…