Mustafa Elmasry

Mustafa Elmasry is Microsoft Principle database consultant working as DBA for more than +10 Years I have a very good high level of knowledge about Database Migration, Consolidation, Performance Tuning, Automation Using T-SQL, and PowerShell and so many other tasks I am working as a freelancer and I do many of projects in multiple customers (Governmental and Private Sector ) here in KSA as of now, I am working in Banking sector AS Database Consultant Engineer managing the core banking system that is hosted in SQL Server Database 8 TB and other 200 SQL Server Clusters
I am Microsoft certified 2008 and 2016 in SQL Server (2x MCTS, 2x MCTIP, MCSA, MCSE) and I am Microsoft Certified Trainer (MCT) also I am azure Certified (AZ-900, AZ-103) also I was awarded by Microsoft Azure Heroes 3 times as (Azure Content hero, Azure Community hero and Azure Mentor) for more information about my experiences and my activity for spreading the knowledge please check my web page https://mostafaelmasry.com/about-me/
  • Tagline: DB Cloud Tech
  • Interests: SQL Server , Azure , Data Engineer
  • Blog: https://mostafaelmasry.com/
  • Jobs: Independent SQL Server Consultant
  • Skills: SQL Server , Azure

Blogs

Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents

By

(This is the third post in a three-part series on how AI is changing...

SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL

By

Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...

Yippee-Kai-Yay 2027 Summit in Denver

By

Next year the PASS Data Community Summit is in DENVER! and London, but Denver...

Read the latest Blogs

Forums

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance, which is...

Life hack that has worked well for me

By skeleton567

I wrote about this several years ago but will contribute again a life hack...

Trying to make this faster using not exists

By krypto69

Hi I have this query that is slow during the 'not in' part of...

Visit the forum

Question of the Day

Switching Schemas I

I run this query:

SELECT 
 s.name AS schemaname
 , o.name AS objectname
 FROM sys.objects o
 INNER JOIN sys.schemas s ON s.schema_id = o.schema_id
 WHERE o.name = 'Beer'
I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beer
What happens?

See possible answers