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.
Category Archives: Other
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”
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.
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.
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.
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!!
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:
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!