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

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, 179 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, 210 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, 166 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, 252 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, 292 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

3 comments, 271 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, 250 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, 277 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, 230 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, 115 reads

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

SQL Server 2012 Virtual Lab with Clustering using Hyper-V

After having a great opportunity to attend a Beta course for Hyper-V with Windows 2012 at Learning Tree, I decided to finally do what I have been planning to do for a while; build a fully working SQL Server Clustered Virtual Lab. I had been practicing with Hyper-V before I…

Read more

2 comments, 439 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 13 March 2013

SQL Agent and the case of the missing job owner…

One fine morning as I’m sitting at my desk doing my work I review some emails about cleaning out some old data from a table that stored webpage session information. I’m given hints about first checking out a job that supposedly purges the data automatically. With my first clue, the…

Read more

5 comments, 276 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 20 February 2013

SQL Server Backup and Recovery Fundamentals Presentation

SQL Server Backup and Recovery Fundamentals – February 5th, 2013 A copy of the recording is available here. Code and slides are under the Presentations section of this website. Correction:Compression on Backups is available on the Standard Edition of SQL 2008R2 and SQL 2012 but not SQL 2008. Thanks to…

Read more

4 comments, 323 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 22 January 2013

SQL Saturday in Washington D.C. December 8, 2012

This is my first time attending a SQL Saturday event and I’m quite excited. If you live in or near the D.C. Metro area I hope to see you there. If you have not registered, you still have a chance: http://sqlsaturday.com/173/eventhome.aspx I’ve put together a short list of the sessions…

Read more

2 comments, 407 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 30 November 2012

What if your database server was hacked and all your data was deleted?

Recently in the news an article circulated about a coordinated attack by a team of hackers known as Anonymous. Information about this incident is all over the internet here is one article with details RT News. Part of that attack included deleting a database belonging to the Israeli Foreign Ministry.…

Read more

1 comments, 259 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 19 November 2012

SQL Server Parallel Data Warehouse (PDW) and SQL Server Fast Track Data Warehouse

The SQL Server Parallel Data Warehouse and SQL Server Fast Track Data Warehouse are very high end builds of Microsoft’s SQL Server 2008R2 product; and SQL 2012 in the future. I’ve been intrigued by these products so I’ve started to learn about it. They have both been on the market…

Read more

0 comments, 441 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 14 November 2012

SQL Server 2012 Service Pack 1 available for RTM

SP1 for the RTM of SQL Server 2012 has been announced during PASS Summit 2012. It can be downloaded here: http://www.microsoft.com/en-us/download/details.aspx?id=35575 Don’t worry, it’s not for the CTP as I posted a some weeks back Filed under: Database Administration, SQL Server 2012 Tagged: LinkedIN, SQL Server 2012, sqlserverpedia

Read more

1 comments, 444 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 9 November 2012

Listing server and database roles for all logins and users in SQL Server – Part 3 – Using SSRS Reports to Monitor and Fix security problems

Finally the epic conclusion to my three part series about listing server and database roles. In this post I will show you how to create SSRS report to use for regular tracking or auditing purposes. This is a much easier and cleaner way of looking at the data and you…

Read more

0 comments, 350 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 23 October 2012

Listing server and database roles for all logins and users in SQL Server – Part 2 – Remote Servers

Building upon the code in my previous post, I will be retrieving permissions information from remote servers that I have access to. This was a little more difficult to accomplish because security is different on different servers and I did not want to create Linked Servers with escalated permissions. Read…

Read more

1 comments, 156 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 15 October 2012

Listing server and database roles for all logins and users in SQL Server – Part 1 – Local Server

I was approached with a unique problem to solve; find out who has what permissions on my Database Servers.  This is the first post in a three part series about finding all user permissions on your SQL Server instance. The next posts will build upon this and introduce a way…

Read more

2 comments, 183 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 8 October 2012

Newer posts

Older posts