RSS

Tag Archives: sql server

SQL Saturday 294 Philadelphia, Nostalgic!

SQL Saturday 294 Philadelphia, Nostalgic!

Less than a week left and I’m extremely excited about SQL Saturday in Philly on June 7th, 2014 and the Precon the day before (I signed up for Allan Hirt’s).  I lived in Philadelphia for about 10 years during which I went to college, had my first two full-time jobs, and my first to kids were born in that area. This SQL Saturday is going to be a blast from the past for me.  The actual event takes place in Malvern PA which is off of 202 in the Northwestern Region of the Philadelphia suburbs.  It is part of the “mainline” and close to Valley Forge, King of Prussia and other historic/tourist attractions.  I used to work in the Mainline area for Johnson Matthey in Wayne (and part time in Malvern) so I’m very excited about taking this trip back to visit friends and family.

For those of you that don’t know about SQL Saturday it is a fantastic event. Here are some of the reasons I’ve encouraged people to attend SQL Saturday events:

Read the rest of this entry »

 

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: , , , , ,

TheSQLPro YouTube Channel

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 a video at 30fps should be about 30,000 words per second. Well I guess you can’t do the math like that but it was worth a try! Now you don’t have to just read my posts anymore, you can enjoy the sound of my voice speaking geek at you while clicking all over the screen to show you how things are done.

So how do I get to this YouTube channel you speak of? Here is the link https://www.youtube.com/TheSQLPro or you can just click on the top navigation menu where it says “Video.”

There isn’t much up on the channel yet but later this month I will be releasing a very special video series. No hints, that’s all I’m saying. This is just the start with hopefully a lot more quality content to come in 2014.

A huge thanks to all my blog readers/supports/subscribers for their support and feedback over the last 18 months. This is blog post #60 and I just wanted to say thanks for being the driving force that keeps me blogging!

 
Leave a comment

Posted by on December 11, 2013 in Videos

 

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: , , , , , , , , , , ,

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

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 met a gentleman that now works with me, so as you can see networking pays off 🙂

Now this year’s SQL Saturday is a little different for me because I will be one of the speakers! I am very excited, as well as a little nervous.  I think having some nervousness helps me prepare because I mentally tell myself “makes sure you know what you are talking about so you don’t look like an idiot!” My topic will be about the fundamentals of Backup and Recovery with SQL Server.  It is targeted towards beginners and here is a brief abstract:

Backup and Recovery are essential parts of and DBA’s job. After all, if you lose your data you lose your job so you need a great backup strategy. In this session we will cover Recovery Models, Backup Types, Backup Strategy, Restores, RTO, RPO, and understanding how your Transaction Log is maintained through backups.

Finally, I wanted to share my thoughts on some of the other interesting sessions that are being held that I will be trying to attend. My disclaimer is that there are so many really great sessions that it is almost impossible to pick sometimes.

Read the rest of this entry »

 

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: ,

 
%d bloggers like this: