RSS

Author Archives: Ayman El-Ghazali

About Ayman El-Ghazali

SQL Server DBA and Developer (www.thesqlpro.com) Email: info[at]thesqlpro.com

SQL Server Internals Presentation Double Time!

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 – Dell Software
I will only cover the first half of the slides during this time slot
Click here to Register

May 6th @ 12 Noon EST  – PASS DBA Fundamentals Virtual Chapter
Click here to Register

Read the rest of this entry »

 

Tags: ,

[SQL Snacks Video] SQL Server Table Partitioning 102

[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.

Read the rest of this entry »

 

Tags: , , , , , , , , ,

[SQL Snacks Video] SQL Server Table Partitioning 101

[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 a little intimidating because it is tricky to get started with, but once you get the basics down you’ll realize it’s pretty straight forward and a very useful feature to have.  I will be providing the code and outline for each of the SQL Snacks related to table partitioning so that you have a chance to practice on your own.  Happy partitioning!

Read the rest of this entry »

 

Tags: , , , , , , , , ,

Toad World – SQL Pro of the Month (March 2014)

Toad World – SQL Pro of the Month (March 2014)

Thank you for all my readers that have supported me and allowed me to be recognized in this way.  I hope that the quality of my work continues to grow and I hope that I can meet your educational needs as much as I can.  I have been blessed to have great teachers and mentors, and I only hope that I can igive back a fraction of that to the Database community.

http://www.toadworld.com/platforms/sql-server/p/sqlpro.aspx

والحمدلله

 
4 Comments

Posted by on April 2, 2014 in Other

 

SQL Saturday 277 RVA Lessons Learned

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 for those that could not attend, maybe they will get some insight as to what can be learned from such events. I wrote about my experiences at the DC SQL Saturday late 2013.

Read the rest of this entry »

 
2 Comments

Posted by on March 24, 2014 in Presentations

 

Tags:

[SQL Snacks Video] The Basics of Joins

[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 with a few examples.

 

Tags: , , ,

SQL Saturday #277 Richmond – Covering new ground

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 be speaking there.  This is a bit of a new journey and one that I think I will enjoy.

This is a new experience and one that I have been excited about since speaking with Wayne Sheffield about it at the DC SQL Saturday in December 2013. I have him to thank for encouraging me to spread my wings and I hope for a smooth ride upward from here.  That is the embodiment of the Professional Association for SQL Server (PASS) after all; to establish life long learning and grow the community by giving back.  I think I could probably do a commercial for them or be a PASS spokesperson.  Seriously though, I’ve learned so many things that have helped my career for free or a very low cost.

For this SQL Saturday, I’m also planning to attend the PreCon event scheduled for the day before.  There is still time to register by going to the main site for the event here. I’ve selected to go to session by Robert Davis for my PreCon and it was a hard choice because the “Murder Thy Wrote” PreCon was very appealing as well and I hope to catch that one at the next SQL Saturday I attend.

Read the rest of this entry »

 

Tags: , , , , ,

 
%d bloggers like this: