Subscribe to this blog
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
Archives: October 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…
0 comments, 258 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…
1 comments, 95 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…
2 comments, 102 reads
Posted in TheSqlPro.com - Ayman El-Ghazali on 8 October 2012
Finding and removing hidden characters in your data using dynamic T-SQL
It has been a long morning for me. It was supposed to be a standard run for our quarterly data aggregations but one of the data import SSIS packages kept failing. The problem was a conversion problem from varchar type to float and I kept getting the following error: Msg…
4 comments, 152 reads
Posted in TheSqlPro.com - Ayman El-Ghazali on 5 October 2012