RSS

Category Archives: Other

[SQL Snacks Video] Tail Log Backup and Recovery Demo

[SQL Snacks Video] Tail Log Backup and Recovery Demo

In December 2013 I presented at a SQL Saturday event in Washington DC. My presentation was about Backup and Recovery Fundamentals which I had done before for the PASS DBA Fundamentals Virtual Chapter. This time around, I decided to add a Tail Log (Active Log) Backup and Recovery demo to enhance my Presentation. The presentation went quite well, and so I’ve decided to put a short video together to demonstrate how to do a Tail Log Backup and Recovery.


***Make sure you change the backup, database, and log file paths to match your configuration***

Code for demo below.
Read the rest of this entry »

 

Tags: , , , , , , ,

[SQL Snacks Video] Introducing SQL Snacks! A healthy alternative to boring learning!

[SQL Snacks Video] Introducing SQL Snacks! A healthy alternative to boring learning!

To snack lovers every where now you can consume SQL Learning the same way, in Snack Size!  Introducing the new way to snack with 0 calories intake, a simple solution to your learning cravings and available 24/7 from the click of a button!

Late last year I introduced my YouTube Channel with a short video on Hyper-V followed by a 10 hour series of teaching SQL Server in Arabic.  This year, I hope to continue with those projects and in addition to that add to my newest delicious invention, the SQL Snack.  The idea of this video series is to provide short videos to teach SQL Server content; and other technologies relevant to SQL Professionals on a daily basis.  This allows for people to grab a snack and enjoy a short learning experience instead of having to sit down for a long drawn out lecture.  Real snack is optional and not provided by me… sorry!

Below is the SQLSnacks Playlist you can also access it at the top menu by hovering over “Videos” and selecting it.

Please enjoy and please feel free to suggest topics you would like to see in the comments and I will try to do my best to accommodate your requests.

 
4 Comments

Posted by on January 16, 2014 in Other, SQL Snacks!, Videos

 

Tags: ,

[Video] ApexSQL Log – Software Review

[Video] ApexSQL Log – Software Review

Today I will be reviewing the product ApexSQL Log which is a tool designed for Transaction Log discovery and recovery.

The team at ApexSQL were very friendly and offered me lots of support and help in using the product.  I opted to do everything myself just to see how easy it is to learn and use the product.  It took me about 30 minutes to get fully acquainted with it; although I’m not an expert now I know my way around the product very well. It’s always great to have a product with an easy to use interface that does not have a steep learning curve.

Note: this is not a product endorsement
Read the rest of this entry »

 

Tags: , , , , , , ,

SQL Server 2012 دورة تمهيدية شاملة في

SQL Server 2012 دورة تمهيدية شاملة في

الزملاء الأعزاء من العالم!
السلام عليكم و رحمه الله و بركاته
أقدم لكم دورة تمهيدية شاملة في SQL Server 2012. وتقدم هذه الدورة التدريبية باللغة العربية، وتهدف إلى المساعدة فى التقديم للمفاهيم الأساسية للمهنيين المتخصصين فى قواعد البيانات عامه وبخاصه SQL Server في محاولة متواضعه منى لنشر هذه المعرفة والعلم بين اخوانى الناطقين باللغه العربية.
تهدف هذة الدورة التدريبية الى تلبيه فضول واثاره اهتمام المتخصصين فى مجال SQL Server وعلى وجه الخصوص DBAs و كذلك Developers كما ان هذة الدورة مبسطه الشرح خاصة فى الدروس الاولى لكى يسهل على المبتدئين فى مجال SQL Server متابعتها واضعا فى اعتبارى انه لا يوجد الا القليل من المواد فى هذا المجال باللغة العربية. فقررت بعون الله وتوفيقه ان ايسر هذا العلم بين ايديكم لعل الله ينفع به احد من اخوانى و اخواتى فى اي مكان فى العالم. اسال الله عز وجل ان تنال هذه الدروس اعجاب الجميع و خاصه المهتمين بمجال SQL Server ارجو من جميع الأخوة والأخوات ان يذكرونى فى صالح دعائهم
و لاتترددوا فى مراسلتى و ابداء ارائكم و مقترحاتكم البناءة لتطوير هذا العمل الخيرى باءذن الله تعالى

أخوكم
أيمن الغزالى
ديسمبر2013 فى واشنطن- الولايات المتحدة الأمريكية

Link to Videos

Dear Colleagues of the Database World!
I present to you a comprehensive introductory course in SQL Server
2012. This course is presented in the Arabic language, and is
intended to introduce core concepts to Database Professionals that are
trying to acquire knowledge in SQL Server. The course is geared
towards those that aspire to become DBAs, Developers, or those just
interesting in learning the basics of SQL Server. Since there is very
little material in Arabic, I decided to try to use my skills to bridge
the knowledge gap for my SQL Family that communicates in Arabic. I
hope you enjoy the classes and please feel free to share and leave
constructive feedback.

Thank you and good luck future SQL Server Professionals world wide!

Special thanks to my friends Mohamed Elsharkawy, Jihad Abouhatab and my brother Islam El-Ghazali for their help and support with this production.

 
 

Tags: , , , , , , , , , , , ,

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

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 the volunteers there.  The feedback from the session was excellent, which means people learned and my goal was achieved.  As for myself, I attended three sessions that day and I learned a lot more than just technical information.

Read the rest of this entry »

 
17 Comments

Posted by on December 8, 2013 in Other

 

Tags: , , ,

Why SQL Server Professionals should love Windows 8

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 that I don’t have Windows 8 at my job, so I can only use it at home. It has been extremely beneficial for me for my SQL Server related work. Why? And why am I stalling to answer your question? And why am I going to change the subject to Hyper-V?

If you’re still reading, then great, you’ve got the patience for what is coming next. Windows 8 Pro includes a Hyper Visor in it (Hyper-V to be exact).  I’m not talking about software to connect to virtual environments, I’m talking about an actual Hyper Visor that allows you to create and manage virtual machines.  Once you enable the option you’re ready to go after a restart, it’s that simple.

So what does this have to do with me as a SQL Server Professional? Well, how else are you going to build your own lab environment at home or at work where you can play around, build and break things, and be your own domain admin (warning: power may go to your head on that last one). It’s all part of your life long learning journey and your drive to become a better SQL Server Professional and get the latest and greatest version on your machine to test out without ruining your OS. It so happens that I’m a nice guy, and I’ll show you how to get your environment setup and how to create “templates” for future VMs with this Hyper-V Tricks for the SQL Professional Video I put together.

Are you ready to push SQL Server to it’s limits, test things you’ve never tested before, build and break environments without losing your job? If the answer is yes then this video is for you! When you’re done with this video make sure you check out my Virtual SQL Server Lab with Clustering post to enhance your own Virtual playground.

PowerShell Scripts mentioned in video (Remember to rename your VM if you like and to change the paths to match your setup):

new-vm -Name “SQLPS” -MemoryStartupBytes 2048MB -Path R:\HyperV\

new-vhd -ParentPath “R:\HyperV\SQL 2012 Template\SQL2012 Template Drive.vhdx” -Path R:\HyperV\SQLPS\SQLPS.vhdx -Differencing

Add-VMHardDiskDrive -VMName SQLPS -Path “R:\HyperV\SQLPS\SQLPS.vhdx”

 

Tags: , , , , , , , , , , ,

SQL Live 360 Competition Winner and Answers!

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 and give some feedback about the winning answers to the questions.

Read the rest of this entry »

 
Leave a comment

Posted by on October 16, 2013 in Other

 

Tags: ,

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

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 we are always looking to improve the quality of our code and data.  This post is intended to show an easy way to use Database Snapshots in order to  test new code or change data and revert changes back quickly and easily.

Read the rest of this entry »

 

Tags: , , , , , , , , ,

New Logo and Media Partnership with SQL Server Live! 360

New Logo and Media Partnership with SQL Server Live! 360

Just recently I signed up to be a Media Partner and help spread the word about this great conference SQL Server Live! 360. It is simple, I help spread the word on their conference, and they spread the word about my website I don’t work for them they don’t pay me 🙂 Later this month I will be posting a code to give prospective conference goers a $500 discount. In September, I will hold a small competition and one randomly selected winner will get a free pass to the conference!

So check out my logos and check out the conference and let me know what you think.  Special thanks to my work colleague and long time iPhone Enemy Michael Myrick for creating the logos.

Read the rest of this entry »

 
Leave a comment

Posted by on July 26, 2013 in Other

 

Show Off Your SQL Server Spirit With Community Badges

Show Off Your SQL Server Spirit With Community Badges

Microsoft’s official SQL Server blog put out some cool SQL Server badges. Check them out, put them on your blog, facebook, LinkedIN, Twitter or whatever. Warning, identifying yourself as a geek might have negative consequences… you have been warned!!

Click here to see site

 

 

 
2 Comments

Posted by on January 16, 2013 in Other

 

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

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 that I am planning to attend with some brief reasons why. Hope to see you all there!

Read the rest of this entry »

 

Tags: , , , , ,

Free Second Shot offer for Microsoft Certification Exams

Free Second Shot offer for Microsoft Certification Exams

Nothing for me to really say except if you mess up, you get a free second chance 🙂

Click HERE to see the details.

So get started on your certifications with the confidence of having a second shot just in case you don’t do so well the first time.

Take a look at my post from August 6 for study resources for the new SQL 2012 exams.

 
3 Comments

Posted by on August 29, 2012 in Other

 

Tags:

8 Habits/Skills/Traits of Highly Effective DBAs

8 Habits/Skills/Traits of Highly Effective DBAs

The whole “7 Habits” title is so cliché so I decided to make it eight! Plus that will probably relieve me from any copyright violations as well. So anyway, these are the eight habits/skills of Highly effective Database Administrators in my humble opinion. Although I come from the Microsoft SQL Server world, I believe most of these traits or skills can be adapted cross-platform.

Feel free to add your feedback in the comments section, this is after all just my own opinion.

Read the rest of this entry »

 

Tags:

Open Heart Surgery Lessons Learned for IT Part 4 – Learning Beyond the Job Title

Open Heart Surgery Lessons Learned for IT Part 4 – Learning Beyond the Job Title

Finally we have come full circle to the final post on this lessons learned segment. In case you have not been reading the news lately, the healthcare market is booming especially with those that are lucky enough to be in the IT field.  It is a big industry here in the U.S. and will continue to grow.

As IT workers we need to step up to the challenge and not stop where our job title does. Being a developer, programmer, DBA, QA Tester, or whatever you may be is not an invitation to ignore the business side of things. Rather, as IT practitioners we should strive to understand and seek purpose in what we are doing. We also need to be innovative and find new solutions to existing problems as well as increase our skills sets and learn new technologies when possible. A career is a life long learning process, it’s not just about getting the job you want and sitting at your desk doing the same thing over and over and claiming it as gained experience. One of my good colleagues told me the other day “doing something for twenty years doesn’t mean you have twenty years experience, maybe you did the same thing 200 times!”

As you can see, the entire experience for me was a learning experience beyond the job title yet it helps me perform better at my work because I understand more about the data that I am working with.

Read the rest of this entry »

 
Leave a comment

Posted by on July 19, 2012 in Other

 

Open Heart Surgery Lessons Learned for IT Part 2 – Standards and Quality Control

Open Heart Surgery Lessons Learned for IT Part 2 – Standards and Quality Control

Welcome back to part two of my series on Lessons Learned. This time I want to talk about quality control.  Everyone knows that it is tough to become a surgeon. It is not that there is a height, weight, race, or whatever else requirement. Rather, there specific qualities and knowledge that are needed of doctors to be able to get a license to practice.  This is one way how standards and quality control is established in the medical field. Now to make it more specific to my experience.

Read the rest of this entry »

 
Leave a comment

Posted by on July 17, 2012 in Other

 

Open Heart Surgery Lessons Learned for IT Part 1 – Collaboration and Agility

Open Heart Surgery Lessons Learned for IT Part 1 – Collaboration and Agility

Last Friday (July 13, 2012) I got to see open heart surgery.  It is technically called Coronary Artery Bypass Grafting (CABG) and it was a triple bypass; which means that three coronary arteries were by passed due to blockage.  As a SQL Developer and DBA at the American College of Cardiology I felt like this would be an excellent opportunity to learn about the data I am responsible for collecting and protecting. I learned a lot, and although this post isn’t going to be very technical it’s still something every DBA, Developer, or anyone who works in IT might learn a little from. Of course I will be giving it a DBA twist to keep it in line with the purpose of this blog 🙂

So let me break down some of the things I observed and relate them to how things work in IT or how we can use some of these strategies day to day to make our jobs better. I will separate the posts across the next three days so that people don’t get bored reading one long post.  This is the first of four parts, enjoy.

Read the rest of this entry »

 
Leave a comment

Posted by on July 16, 2012 in Other

 
 
%d bloggers like this: