My first book review! SQL Server 2014 with PowerShell v5 Cookbook

Current Events, PowerShell, SQL
Has been a very busy year for me, haven't posted lately, but was very excited to share this. I've had the opportunity to be a technical reviewer for three PowerShell books this year! One that I've really enjoyed reviewing has just been released, and the publisher Packt is offering an end of year sale for $5 eBook editions. Donabel Santos (sqlbelle.com & @sqlbelle) is a wonderful blogger, author, trainer, and Microsoft MVP. This is her second PowerShell cookbook for SQL, and it's an incredibly useful resource for learning the practical details of PowerShell, both in general and when working with SQL Server. All her examples come with code samples so you can leverage her scripts to get productive right away. You can check out the book on the Packt website. It's only $5 for a great PowerShell & SQL…
Read More

Helping out at TechEd 2014 in Houston

Current Events
I am privileged to be a member of the fifty or so Microsoft Certified Trainers who are volunteering their time this week with the Hands On Labs here at TechEd 2014 in Houston. There are 300 general use machines plus 400 machines dedicated to Instructor Led Labs. Look at my computer lab! :) [caption id="attachment_366" align="alignnone" width="604"] Hands On Labs area at TechEd 2014 (click to enlarge)[/caption] There are over 150 different labs available at the conference, all created and hosted by HynesITe. They do this with over 70 host servers, many with half a TERABYTE of RAM, all from a single colocation facility in Tampa, Florida. The labs are made up of one to several  virtual machines that are spun up and ready for the attendees when they sit down to…
Read More

Bi-Annual blog post

Current Events
Yes, six months just went by. Since I've last posted: My youngest  is walking, and also talking (in his own language, English will come soon I'm sure.) I've assisted a small handful of clients and their customers with their database, application and infrastructure needs. Taught SQL querying and administration classes onsite around Florida. Delivered a custom PowerShell Module and PowerGUI interface to a client for testing. Next week will deliver a 5 day class on using SQL 2012 SSIS to populate a data warehouse. Then I'm off to Houston to learn and to volunteer along with the other MCTs there to help deliver hands on labs to thousands of TechEd attendees. Talk to you again in six months (or less, hopefully.)
Read More

Back to Work, and ain’t it Great?

Current Events
Aaaaaaaaaaaaaaaaand a month goes by.  :) PASS Summit 2013 was a great experience, made several contacts, a few friends, and learned a lot about SQL, and lot more about this I.T. industry we are in. It's a big place, and the rules are continually changing.   It was a pleasure to volunteer as an MCT Ambassador with the other MCTs and the Microsoft folks, helping people prepare for and take their certification exams. I was lucky to witness several very smart (and nervous) people taking the MCM SQL Exams before the program is retired at the end of the year. Talking to 'potential masters' during their breaks was inspiring. One takeaway from the conference for me was the appreciation for the community, and the desire to learn how to give back.…
Read More

What I’ve been up to

Current Events
Haven't posted in a while. Been working on a few different projects, taking care of clients, staying busy. I've been asked by some SQL students to post sites with useful SQL scripts I've found. There have been so many over the years.. but I've started my Useful SQL Scripts page, and will add to it as I can. Playing around with SQL Azure . Getting my head around working with a database that I'll never touch... While many people won't want to give up control of their databases, I see possibilities for syncing SQL data between a SQL Azure instance and your local SQL 2012 database. Also wanted to learn something outside the SQL Server realm. Been creating some very basic apps using the Sencha Touch 2 javascript/css framework. This lets…
Read More

On the road!

Current Events
I'm on the road, training this week in Tempe, AZ. It's cold, but it's a dry cold! Have 3 client projects in the works, plus learning SQL 2012 ins and outs. Looks like it's going to be a busy year.
Read More

Too busy to blog

Current Events
SO..... Despite my best intentions, I haven't kept up with blogging. The reason why is actually good news... I've been crazy busy. Since I've last blogged I have: Trained a few SQL classes (MOC 6232B and 2778A, 70-432 and 70-433 test prep.) Built my first WCF Restful web service prototype for a long time client. Built customized SQL reports for an ASP.NET web application. Entered a consulting engagement with a client who upgraded from SQL 2000 to 2008 R2 and needs to learn and apply new features to their 24/7 web application database. Joined a team of consultant developers on a new ASP.NET / Ajax custom project. Created a wordpress blog for a local business and trained the client how to maintain it on their own. Continued to work in…
Read More

SQL cluster on the cheap with Hyper-V and iSCSI

Current Events, Presentations, Speaking, SQL
Speaking on how to set up SQL clustering in a virtual environment, for development and testing. Discuss options for production deployment. Now, how to compress 9 hours of setup into a session... Expect some smoke and mirrors along with some neat technology. Does anyone have some SSDs I can borrow? :) July 23rd http://itcampsaturday.com/southflorida/ Tentative outline: Setup Hyper-V Host Install two virtual networks (lan,iscsi) Create OS template Deploy and install 3 servers Configure iSCSI storage and targets Configure Windows Cluster Install SQL Node 1 Add SQL Node 2 Test Discuss production deployment options Q & A
Read More

Catching up on blogging, new opportunities

Current Events
So today I'm catching up after a year of no posts. While I can see the value in blogging, I've just had too many distractions to count. Recent events have convinced me it's important to start up again. I recently attended the first PASS SQL Rally in Orlando, had a great time, met good people, and learned a TON. After learning so much from the fine folks that volunteered their time and knowledge to the SQL community (THANKS GUYS!), I think I'm finally starting to get it... blogging and speaking and participating in the community gives one back way more than it costs, in terms of learning, in recognition and connections, and in challenging opportunity. I've been invited to submit a topic for the South Florida IT Camp Saturday event in…
Read More