Author Archives: Mustafa EL-Masry

About Mustafa EL-Masry

I love fixing problems and learning new technologies that can help me fix those problems faster and better than I did the time before. In my spare time I like to read, speak, write blogs and learn new things. I currently work as a Principal Database Administrator where I solve fairly interesting problems on fairly large databases. And troubleshooting High sensitive Performance Cases ► I am Microsoft Certified in SQL Server Administration and Development 2008 , 2012 MCTS, MCTIP , MCSA , MCSE ► I have deep practical knowledge about T-SQL performance , HW Performance issues, Data Warehousing and data mart solutions , SQL Server Replication, Clustering solutions (Active Active and active passive)and Database Designs for different kinds of systems , HAG, I worked on All SQL Server Versions (2005,2008,2008R2,2012,2014) diving deeply more check the below information about me : ► Founder of Community :SQL Server Consultation :http://MostafaElmasry.com/ ► Co-Founder : http://www.SQLGULF.net ► Audience Marketing Manager and Executive Board member: SQLSERVER PERFORMANCE TUNING http://sqlserver-performance-tuning.net/ ► LinkedIn: https://www.linkedin.com/in/mostafaelmasry ► My Community Annual report : http://mostafaelmasry.com/2014/annual-report/ ► I am Technical Writer and Reviewer : http://www.slideshare.net/MostafaElmasry3/ ► Fluent Participator at Microsoft Forums of SQL Server at http://Social.technet.microsoft.com ► +200 blogs in SQL Server technology English and Arabic: http://mostafaelmasry.com/community-founder/all-tips/ ► Microsoft Profile: https://www.mcpvirtualbusinesscard.com/VBCServer/EngMostafaElamsry/profile For any inquiries you can contact me on my phone or by mail: Mobile: +966 543990968, +2 01114668821 Mail: dbconsultant@mostafaelmasry.com & SQLGULF@mostafaelmasry.com

Concept and basics of Temporal tables in SQL Server 2016

In this article I’ll cover all aspects of a new SQL Server 2016 feature, Temporal Tables (System-Versioned), including: Introduction What is a temporal table? Why Temporal table? How does temporal table work? Consideration and limitation Temporal tables vs CDC Creation … Continue reading

Aside | Posted on | Tagged , | Leave a comment

Cannot add new node in SQL Server 2014

Problem  Hi my followers today i have task to build two new SQL Server Clusters when i am working i go to for adding new Node at this time i revived very new issue for me Rule “SQL Server Database Services … Continue reading

Gallery | Tagged , , , , , , | Leave a comment

SQL Server 2014 Health check DMV queries Day 2

This gallery contains 1 photo.

Hi guys in the Previous post i explained How we can get the SQL Server instance version and How we can know the installed date for SQL Server instance put today is DAY 2 and i will show new DMV in … Continue reading

Gallery | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

SQL Server 2014 Health check DMV queries Day 1

This gallery contains 1 photo.

Hello Guys Follow Me from today and over the next 30 days i will share with in this 30 days 70 DMV each day we will have at least 2 new DMV this DMV Library used for healthy check in SQL … Continue reading

Gallery | Tagged | Leave a comment

First quarter Achievements in 2015

Hello Guys I am Mustafa El-Masry Principal Database Administrator & DB Analyst I am Production DBA and Development DBA also I am author and technical Writer to know more about me Visit my site from HERE Thank God by the … Continue reading

Gallery | Leave a comment

How to build , Manage and monitor your SQL Server replication

Hello my friends this my small posts in SQL Server replication it is not everything about replication but at least it is the what any DBA should know it What is SQL Replication? Types of SQL Replication Replication Overview  How … Continue reading

Gallery | Tagged , , , | Leave a comment

My First Arabic Post in SQL Server 2014

Hello my friends this my first Arabic post in SQL Server technology I do it in SQL Server 2014 it is about { Durable vs. Non-durable tables: In-Memory OLTP} ISA I will select the best posts on my library and … Continue reading

Gallery | Leave a comment