The Script Activity in Azure Data Factory
Learn about using the Script activity in Azure Data Factory to run DDL or DML statements.
Summit Learning Pathways Announced
Whatever your learning objectives or career goals are, Summit has the guided learning pathways you need to achieve them. Summit attendees can choose from 9 learning pathways, featuring over 40 industry-leading speakers, which have been designed to walk you through a specific set of learning outcomes to ensure that you leave Summit with the skills you need to make an immediate impact in your organization. Presenters include Ginger Grant, John Morehouse, Erin Stellato, Dustin Vannoy, and many more!
The ins and outs of joining tables in SQL Server
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
Steve feels it is not only important to keep your word, but communicate clearly what you mean to others.
Your First Repo in Azure Data Studio or VS 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?
A story about how a system engineer solved a MySQL performance issue written by Rajeshkumar Sasidharan
DevOps 101: Introducing Database DevOps
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
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
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
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…
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers