Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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

PolyBase: I now Pronounce you SQL and Hadoop

  Are you interested in Hadoop? With SQL Server 2016 just around the corner, a powerful new feature is being included called PolyBase.  To summarize what it is, just think about it as a marriage between SQL Server and Hadoop.  It is a way to store and query data on…

Read more

3 comments, 381 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 27 April 2016

SQL Server 2016: What’s the best new feature?

With SQL 2016 around the corner, and my blog without a post this year, I thought I would write about some of the new features.  However, I’m not sure which feature I like the most to talk about! So I’m going to summarize a few of the new features I…

Read more

12 comments, 3,906 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 19 April 2016

Get valuable Virtual Log File (VLF) information for all your databases log files

I had this problem where I needed to gather Transaction Log information on multiple databases and check for valuable statistics on them. Running the command [DBCC Loginfo] brings back a number of rows for each Virtual Log File (VLF) in your Log File. It is really hard to do anything…

Read more

9 comments, 1,776 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 2 November 2015

SQL 2016 Row-Level Security Demo: Users with various clearance levels

SQL 2016 is right around the corner and one of the new security enhancements promised is Row-Level security for tables.  It’s a great new feature and pretty easy to implement.  I have created a simple demo that gives various users access to data based on specific clearance level to the…

Read more

0 comments, 985 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 1 October 2015

Another Career Podcast – Working at Microsoft

I have to admit, I had a lot of fun at SQL Saturday in Philly this last June; I mean two podcasts recorded at one event!! It’s also convenient to do a Podcast with other professionals because they end up doing all the work?? Before I post the information, I…

Read more

2 comments, 284 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 7 August 2015

Podcast about my career and the SQL Server Community with Chris Bell

During my time at SQL Saturday in Philadelphia (Early June), Chris Bell invited me to be a guest on his Podcast.  Here is the result of that fun interaction?? https://wateroxconsulting.com/archives/podcast/010-ayman-el-ghazali/ I just want to reiterate my thanks to everyone who ever helped me on my career path from my colleagues…

Read more

0 comments, 381 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 9 July 2015

Working at Microsoft – A Year in Reflection

Last year after starting my new job with Microsoft as a Senior Consultant I wrote an article about my interviewing experience with many companies during my tenure at my last employer (Click here for article).  I realized it is now time to talk about my journey to Microsoft. It has…

Read more

1 comments, 455 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 24 June 2015

SQL Server 2014 BI ???? ??????? ????? ??

??????? ??????? ?? ??????! ?????? ????? ? ???? ???? ? ?????? ???? ??? ???? ??????? ????? ?? SQL Server 2014 BI. ????? ??? ?????? ????????? ?????? ???????? ????? ??? ???????? ?? ??????? ???????? ???????? ???????? ????????? ?? ????? ???????? ???? ?????? SQL Server BI ?? ?????? ??????? ??? ???? ???…

Read more

7 comments, 591 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 29 March 2015

[SQL Snacks Video] Performance Tuning 103 – T-Logs and VLFs

Finally the arrival of Part 3 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand how to start performance tuning with SQL Server. The first video was about performing a baseline using the PAL tool.I would highly recommend you review that video as…

Read more

0 comments, 585 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 31 December 2014

[SQL Snacks Video] Performance Tuning 102 – Files, FileGroups, and TempDB

Finally the arrival of Part 2 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand how to start performance tuning with SQL Server. The first video was about performing a baseline using the PAL tool.I would highly recommend you review that video as…

Read more

4 comments, 6,738 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 30 December 2014

PASS Summit 2014 – It’s not you, it’s me

After an exciting week at the PASS Summit, I’m back home with my family.  This was my first ever PASS Summit and instead of writing about what was good or what was bad, I’ve decided to write about what I did and did not do and what I think I…

Read more

7 comments, 380 reads

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

Bon Voyage fellow PASS Summit 2014 Attendees!

For the first time ever, I will be a PASS Summit Attendee! I’m very excited about going and I’ll be flying out tomorrow afternoon to attend a Pre-Con tomorrow.  If you would like to connect and meet while I’m there please feel free to Tweet out to me @TheSQLPro. That’s…

Read more

1 comments, 313 reads

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

[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

3 comments, 779 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, 375 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, 411 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

10 comments, 214 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, 388 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, 409 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

3 comments, 653 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, 507 reads

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

Older posts