Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

TheSqlPro.com - Ayman El-Ghazali

Ayman is a passionate SQL Server DBA, Developer, and Business Intelligence Developer. His passion for technology started when he was a young boy playing DOS games on his father's computer. From there, he moved up to computer programming in high school and went on to get B.S. and M.S. degrees in Information Systems from Drexel University in Philadelphia. He has worked with the SQL Server product since 2006 and has experience with SQL 2000 through SQL 2012. He holds a MCITP SQL 2008 DBA certification and is also a Microsoft Certified Trainer (MCT. He has been active with the virtual chapters of PASS, participating in online training and also giving presentations. Ayman has lived in many different countries around the world including the U.S., U.K., Egypt, Saudi Arabia and speaks fluent Arabic. He is huge football(soccer) fan and is always looking forward to learn more about SQL Server, SQL Server BI, and technology in general. www.thesqlpro.com

[SQL Snacks Video] Performance Tuning 101 – Baseline with PAL Tools

Welcome to Part 1 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand how to start performance tuning with SQL Server. This first video describes how to setup a baseline for your system using the PAL tools. It is essential to get a…

Read more

0 comments, 251 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 17 September 2014

Dear IT Guy, Customer Service is part of your job

It may be true that you are one of a kind, a true techie with specialized skills that are hard to find and hire for. One thing that is more true is that customer service is still very much a big part of your job. Which equates to the fact…

Read more

0 comments, 161 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 4 September 2014

Dear IT Guy, Why do you hesitate to attend my meetings?

I was attending Microsoft’s on-boarding training last week and one of the managers there mentioned that a lot of IT geeky guys and gals don’t like to attend meetings, and deal with people etc.  This was her opinion based on her 20 year career in IT, and even as a…

Read more

0 comments, 27 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 28 August 2014

The Good the Bad and the Ugly of my extended job search

Now that I’ve finally started a new job (explains why I haven’t blogged for a while) I can discuss my interview experience over the last two years starting in the Summer of 2012.  I have left out the company names out purposely because this is not a post to damage…

Read more

15 comments, 15 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 25 August 2014

SQL Saturday 294 Philadelphia Lessons Learned

Being in Philadelphia this past weekend was fantastic! I got to meet a lot of old friends, spend time with family, and make new friends in the SQL world.  This SQL Saturday was especially important for me since I lived in the Philly area for almost 10 years.  I got…

Read more

0 comments, 161 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 9 June 2014

SQL Saturday 294 Philadelphia, Nostalgic!

Less than a week left and I’m extremely excited about SQL Saturday in Philly on June 7th, 2014 and the Precon the day before (I signed up for Allan Hirt’s).  I lived in Philadelphia for about 10 years during which I went to college, had my first two full-time jobs,…

Read more

4 comments, 148 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 2 June 2014

[SQL Snacks Video] SQL Server Table Partitioning 103

Welcome back for part 3 of my SQL Snack Pack on Table Partitioning! If you have not watched the first two videos, I would highly encourage you to do so. In this third video I will discuss the following: How Partitioning can be beneficial in helping with blocked resource contention…

Read more

0 comments, 386 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 28 April 2014

SQL Server Internals Presentation Double Time!

I’ll be doing double time over the next two weeks with Two Presentations on SQL Server Internals. It is essentially just a repeat of the same presentation but with two chances to attend :) Here are the details of the timings for both presentations: April 29th @ 12 Noon EST…

Read more

0 comments, 254 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 22 April 2014

[SQL Snacks Video] SQL Server Table Partitioning 102

Welcome back for part 2 of my SQL Snack Pack on Table Partitioning! If you have not watched the first video, I would highly encourage you to do so. In this second video I will discuss the following: Creating a new Range in our Partition for new data (SPLIT RANGE)…

Read more

0 comments, 190 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 15 April 2014

[SQL Snacks Video] SQL Server Table Partitioning 101

I hope you’re hungry for another SQL Snack! In fact, this will be one of a series of snacks (dare I call it a SQL Snack pack?). Table partitioning is a fantastic feature that is easy to learn and can significantly improve your OLTP and Data-warehouse environments. It can be…

Read more

0 comments, 198 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 8 April 2014

SQL Saturday 277 RVA Lessons Learned

Once again it is an honor to attend such a great event and meet up with other like minded geeks. It’s an honor to be selected to speak and a privilege to deliver a session without any problems. I enjoy writing about my experience to encourage others to attend, and…

Read more

2 comments, 176 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 24 March 2014

[SQL Snacks Video] The Basics of Joins

This is a special edition for SQL Snacks.  It is one (of many hopefully) SQL Snacks that has been recorded with the intention of fulfilling a request by a SQL community member looking to learn more about SQL Server.  It is straight forward, very basic, beginner level information about Joins…

Read more

0 comments, 309 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 10 March 2014

SQL Saturday #277 Richmond – Covering new ground

SQL Saturday has been a fantastic experience for me here in the DC area (I blogged about it here) and I hope for the same thing in Richmond.  This is my first time to attend a SQL Saturday in a city outside my area of residency, and I will also…

Read more

6 comments, 186 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 4 March 2014

[SQL Snacks Video] The What, Why, and How of Instant File Initialization with SQL Server

Instant File Initialization (IFI) is an interesting topic with regards to how SQL Server works with storage. It is an easy feature to turn on and can improve the performance of your server; specifically with creation and growth of data files including TempDB rebuilds with SQL Server restarts.  There is…

Read more

0 comments, 177 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 11 February 2014

[SQL Snacks Video] Importance of COPY_ONLY Backups

There are many features/options we sometimes overlook and then wonder later what went wrong. The COPY_ONLY option with backups is one that I felt is important to highlight to SQL Server DBAs. This backup is independent backup that is not part of the regular cycled backups that you perform; hint…

Read more

0 comments, 200 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 29 January 2014

[SQL Snacks Video] Tail Log Backup and Recovery Demo

In December 2013 I presented at a SQL Saturday event in Washington DC. My presentation was about Backup and Recovery Fundamentals which I had done before for the PASS DBA Fundamentals Virtual Chapter. This time around, I decided to add a Tail Log (Active Log) Backup and Recovery demo to…

Read more

2 comments, 239 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 16 January 2014

[SQL Snacks Video] Introducing SQL Snacks! A healthy alternative to boring learning!

To snack lovers every where now you can consume SQL Learning the same way, in Snack Size!  Introducing the new way to snack with 0 calories intake, a simple solution to your learning cravings and available 24/7 from the click of a button! Late last year I introduced my YouTube…

Read more

4 comments, 198 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 16 January 2014

[Video] ApexSQL Log – Software Review

Today I will be reviewing the product ApexSQL Log which is a tool designed for Transaction Log discovery and recovery. The team at ApexSQL were very friendly and offered me lots of support and help in using the product.  I opted to do everything myself just to see how easy…

Read more

1 comments, 225 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 8 January 2014

SQL Server 2012 ???? ??????? ????? ??

??????? ??????? ?? ??????! ?????? ????? ? ???? ???? ? ?????? ???? ??? ???? ??????? ????? ?? SQL Server 2012. ????? ??? ?????? ????????? ?????? ???????? ????? ??? ???????? ?? ??????? ???????? ???????? ???????? ????????? ?? ????? ???????? ???? ?????? SQL Server ?? ?????? ??????? ??? ???? ??? ??????? ??????…

Read more

0 comments, 538 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 18 December 2013

TheSQLPro YouTube Channel

That’s right, it’s time to take this blog up a notch!  Last week I posted a video about using Hyper-V on Windows 8 to design your own SQL Lab.  I’m starting to like the whole concept of adding video to my blog. If a picture is worth 1000 words so…

Read more

0 comments, 248 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 11 December 2013

Older posts