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 Server 2012 ???? ??????? ????? ??

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

Read more

0 comments, 566 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, 253 reads

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

SQL Saturday DC Lessons Learned – Humility, Paying it Forward, and Dedication

This past weekend I attended SQL Saturday #233 in Washington DC. I presented a session this year titled “Backup and Recovery Fundamentals.” There was a great turn out of the session, with the room filled.  Although there were some technical issues at the start but I got great support from…

Read more

10 comments, 187 reads

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

Why SQL Server Professionals should love Windows 8

Alright, I’ve got your attention. You’re probably thinking “who is this crazy guy that is using the word Love with Windows 8 in the same sentence?” Honestly though, I have not had many problems with Windows 8 and I’ve been happy running it for a long time. I’m actually disappointed…

Read more

3 comments, 229 reads

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

I’m speaking at SQL Server Saturday #233 – Washington DC!

It’s that time of the year again when SQL Saturday makes its way back to the Washington DC Area. Here is a link to register and to get all the details you need http://www.sqlsaturday.com/233/eventhome.aspx. I hope to meet a lot of new SQL Server professionals this year. Last year, I…

Read more

0 comments, 180 reads

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

Only one month left! Register for the SQL Server Live! Conference in Orlando Through TheSQLPro.com and Receive a $500 Discount

The SQL Server Live! Conference in Orlando is between November 18-22, 2013. There is a discount code provided for those who register using the discount code on my website. The Agenda includes many great topics of interest for both Developers and DBAs: SQL Server Administration & Maintenance SQL Server Performance…

Read more

0 comments, 307 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 28 October 2013

SQL Live 360 Competition Winner and Answers!

About a month ago I started a competition (hosted by the event organizers) to give away a free pass to the SQL Live 360 Conference in Orlando. You can still get a $500 discount by registering through this link by the way. Now it is time to announce the winner…

Read more

0 comments, 258 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 16 October 2013

Slides for SQL Server Internals Presentation with PASS DC Chapter

For those of you that attended yesterday and are interested in the slides, you can download them here. Thanks! Topic: SQL Server Internals Party: Storage, Memory and the Query Life-cycle Abstract: Come meet the Internals of SQL Server at this special get-together! In this presentation we will cover the basics…

Read more

0 comments, 305 reads

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

Social Engineering: How to prevent unauthorized access to SQL Server using SQL Logins

People are always concerned about Security when it comes to their data.  I don’t blame them, I love keeping my job and I love to protect the sensitive data we store. You also don’t want someone with little SQL skills going in and running huge queries that bring the server…

Read more

2 comments, 323 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 2 October 2013

SQL Server Internals Presentation with PASS DC Chapter October 10, 2013

If you’re in the DC/Baltimore area, or just feel like coming to DC to learn about SQL Server, please join me for my presentation on SQL Server Internals. The date is Thursday October 10, 2013 at 6:30PM at the Microsoft Building in Chevy Chase. For more details please visit http://passdc.sqlpass.org/…

Read more

0 comments, 123 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 24 September 2013

Free Conference Pass to SQL Server Live! in Orlando

Want a free pass to the SQL Server Live! conference in Orlando this year? Look no further, here is your chance to win a free pass to the conference. Of course, you first have to answer a few questions to be considered! So here is how it works. 1. The…

Read more

0 comments, 260 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 16 September 2013

Register for the SQL Server Live! Conference in Orlando Through TheSQLPro.com and Receive a $500 Discount

The SQL Server Live! Conference in Orlando is between November 18-22, 2013. There is a discount code provided for those who register using the discount code on my website. The Agenda includes many great topics of interest for both Developers and DBAs: SQL Server Administration & Maintenance SQL Server Performance…

Read more

0 comments, 269 reads

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

Spend some quality time with your Database using Database Snapshots for testing

First let’s get things straight, this post is not an encouragement for anyone to spend more time with his/her Database or with Database Snapshots for that matter. If you’re married to your Database, that’s a different story all together and I don’t think I could help you. As database professionals…

Read more

4 comments, 218 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 1 August 2013

Indexing Fundamentals Presentation – Pending Questions Answered

On July 10th 2013, I gave a presentation with the Professional Association for SQL Server (PASS) DBA Fundamentals Virtual Chapter. The topic was Indexing Fundamentals and there were some questions that we did not have time to answer. I have combined similar questions and given one answer to cover the…

Read more

2 comments, 333 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 17 July 2013

Indexing Fundamentals Presentation

**This Session has been rescheduled for July 10th @ Noon EST (16:00 UTC)** On July 10th 2013 @ Noon EST (16:00 UTC) I will be giving a presentation with the Professional Association for SQL Server (PASS) DBA Fundamentals Virtual Chapter. Entrance is free as always and details can be found…

Read more

1 comments, 374 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 26 June 2013

SQL Server Management Studio Rainbow Edition

Ever wanted to know the reason behind the Database color scheme in SQL Server Management Studio? I have always wondered why all the Databases in management studio were Yellow (Online), Grey (Read-Only), Lighter Yellow with text next to it (something like Restoring), or Yellow with a Red Icon (Offline). Have…

Read more

5 comments, 330 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 12 June 2013

How to Avoid a Database “Heart Attack”

For the past couple of months I have been working with Ben Weiss a Digital Marketing Strategist at Infusive Solutions (http://www.infusivesolutions.com/). Our partnership was based on a mutual understanding that there is much needed career growth and guidance among IT Professionals. Since my background is primarily with Database Management Systems…

Read more

0 comments, 302 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 5 June 2013

Email Response: SQL Server 2012 Planning and Architecture

I received an email from a connection on LinkedIn seeking some advice for architecture on a new reporting system. Although I don’t know the gentleman personally, he is a SQL Server professional and I felt obliged to help out a fellow colleague in the field. The email is included below…

Read more

4 comments, 333 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 15 May 2013

Estimate Table Size based on the Metadata from INFORMATION_SCHEMA.COLUMNS

A problem I face often is not knowing the size of a new table that I’m creating. I put some basic code together that pulls the column information from INFORMATION_SCHEMA.COLUMNS and with some basic math gets the approximate size of the table based on the estimated number of rows. The…

Read more

5 comments, 280 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 24 April 2013

Free SQL Server 2012 Installation Guide

Everyone’s favorite four letter word is back, FREE! Yes, it is time I gave back to the community since I’ve been mooching off them them for so long. I’ve put together a short Installation Guide for those interested in getting their feet wet with SQL Server. I’m trying to encourage…

Read more

0 comments, 146 reads

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

Newer posts

Older posts