I’m excited and honored to announce that I’m presenting a Community Session at the PASS Business Analytics Conference in Chicago, IL on April 10 – 12.here.
Register for the PASS Business Analytics Conference here. See you there!
See you there!
By the end of this post, I will have you convinced that you can work out and stay fit all day at work. Seriously.
If you’ve not been to a gym in a long time, this might seem like a lot of working out, but I promise, in no time, you’ll be so used to this schedule that you’ll start to incorporate fitness into other aspects of your life; like dinner time!
Read on for my story:
Hi. I’m husky (read: fat). And out of shape. Well, I was… I liked to blame lots of outside factors: Fast food, preservatives, salt, fruit (no, really), sitting at a desk all day…
Wait, what was that last one? Sitting all day? That probably has something to do with it, right? About a year ago I decided to really do something about it. I really didn’t want to go as drastic as a new desk with fancy heights for standin’; I like my desk and I like my chair. I don’t want to stand all day. But, I did want to get in shape.
Problem is, I work from home. I also live in the woods. There is no gym or fitness center close to me. And honestly, I typically go 4 or 5 days without leaving the house so there’s little chance that I would end up at the gym on a regular basis.
Since I tend to put in a lot of hours in between work and family, completing a long, drawn out weekly workout schedule isn’t going to cut it either. I need something that I could do during the day that wouldn’t impact my productivity.
It took me a few iterations (I’m agile!) and several months, but I finally ended up on something that works well for me and I’d like to share it.
Staying fit really is simple. Although having a Shake Weight is pretty awesome, you don’t need a bunch of fancy gadgets. To stay fit, you only need your body. Nothing more than that; well, maybe a floor, and some gravity. But really, that’s it.
So, how do I stay fit AND get lots of fantastic work done without changing into workout gear? Simple. Read the following three tips:
1.) I have an hourly reminder set (on my phone) that tells me to do 10 push-ups.
It’s like having a drill instructor, without all of the yelling. It’s easy, takes 10 seconds to complete, and through the day I’m routinely doing 80 – 100 pushups. Spreading them out over the day helps with the “But I can’t do 100 push-ups” mentality. Everyone can do 10 push-ups. You can use your knees to start with (see here). Over time, you’ll get stronger and be able to do standard push-ups.
As you advance you can get really crazy and start doing things like
- Military Style Push-ups
- Explosive Push-ups
- Diamonds of Death
- Under the Fence
There are lots of examples online. I’ll let you investigate further.
2.) I also have a reminder to tell me to do 10 sit-ups.
Again, you CAN do 100 sit-ups a day. Start simple; build complexity as you get stronger. Anyone can do this. Other example for hourly reminders can include:
- Tricep Dips – Use your desk chair for simplicity!
- Squats – weighted or no!
- Lunges – great for cardio strength!
- Jumping Jacks – 25 for plyometric strength and cardio in one!
I routinely change up my reminders throughout the week so I’m not sticking with the same exercise every day. Variety is key when it comes to easy fitness.
3.) Engage a friend!
This is probably the most important thing I did to take my fitness to the next level. I found a friend (YAY!) that was willing to play a little game with me. Have you heard of tabatas? If not, read this, then come back….
As I was saying, I found a friend that was willing to play a little game with me. At random intervals through the day, we IM each other – keeping mindful of Presence Indicators – and say “Tabata Time!” Ok, we really don’t say that — it sounds to TMNT-ish.
After describing what the tabata is (at our discretion), we complete said tabata. An example might be: 60 second wall-sit, 10 push-ups, 20 lunges, Repeat, GO. This does take a little more time than the 10 push-ups mentioned above, but we have a limit that it can’t take any more than 5 minutes and there is a 10 minute window for accepting and starting. Doing this craziness with a friend makes it fun, and also helps to PUSH me. That’s a big one. Having that accountability is key.
Generally we do this 3 or 4 times a day, although some days may be more or less depending on uncontrollable factors. Still, it’s fun, it’s a workout, and it helps to keep you in shape.
If Cardio is more your style; there are things you can do there too!
Some of my friends have had the pleasure of building a treadmill desk – which I understand as a treadmill with a shelf attached for a laptop. Setting the speed to something nice and slow – under 2 mph – is good enough for an hour or two long walk while you check email, or write queries, or build cubes! That’s a lot of caloric burn during that productive time.
So what did we learn?
In a normal day, I spend no more than 30 minutes completing all of this working out: 100 or so push-ups, sit-ups, and various tabatas. No workout gear, no special attire. Simplicity. That’s what I love about this kind of working lifestyle. Even if you work in an office you can do this. Sure, you may look a little foolish to those around you…but, I ask you, who will look more foolish in 6 months when you’ve toned up and others are spreading out?
The above points have worked well for me and my friends. What would you like to be able to incorporate into your day to help stay in just a little better shape?
With the November meeting complete, the year is now closed for West MI SQL. We’ll be meeting again in January, with a special holiday event!
I would like to thank each and every one of our members for not only showing up to the meetings but also for making this a little bit of #sqlfamily right here in Grand Rapids. Without YOU this organization would not exist. Thank you for showing up, for bringing friends, for asking questions, and for stepping up to the plate, getting out of your comfort zone and speaking!
Looking back at 2012 I think I’m most proud of our members who have stepped up and gave their first community presentation at our podium. We have had 4 this year! Four! And of those four, two have went on to speak at one or more SQL Saturdays. As a User Group leader, nothing makes me happier than to see members from our group up there on stage at a SQL Saturday. A special thank you to Kevin, Anthony, Emily, and Dustin for your efforts for the SQL Community this year. I’m looking forward to MORE presentations from you, and others from the audience as well!
I also would like to thank a few of our sponsors for helping to burden some of the cost of dinners, and for the great giveaways that we are able to provide. To New Horizons for the generous use of their facility month after month, thank you! To TekSystems, Confio, and BlueGranite for their monetary support through the year, thank you! To O’Reily, Apress, RedGate Publishing, and Microsoft Press, for the generous donations of books and other giveaways, thank you!
These “thank yous” wouldn’t be complete without a special shout-out to PASS, for providing support via Regional Mentors (thank you Joe and Arlene), Karla Landrum, and the online presence — thanks PASS IT!
We are well under way to making this a great SQL Server event!
Lots of hard work as been done up to this point, and we are extremely excited to be bringing all of YOU a day of FREE SQL Server training. We would like to take a minute to thank all of our wonderful speakers who have submitted, our sponsors for making this event possible, and our attendees for trusting us to provide them with great community training!
The SQL Saturday 160 team is committed to provide YOU, our SQL Saturday attendees, with top-shelf training. One way we are holding this commitment is by providing an opportunity to attend Spotlight Sessions.
What is a Spotlight Session?
A Spotlight Session is very much like normal SQL Saturday session only twice as long. We have invited well known community speakers who have expressed interested in spending more time on one of their topics to submit abstracts.
Topic areas for Spotlight Sessions will include DBA and BI topics.
What does this mean for me?
Having 2 hours of speaking time will allow a presenter to dive much deeper into a topic, and have more time for discussions with the crowd. This means that, should you choose to join a spotlight session, you will receive more information to take back to your workplace. Think of it this way: Would you rather spend an hour learning about different types of indexes, or two hours and add in practical indexing knowledge as well?
But what if I don’t want to attend a spotlight session?
No problem! We will have MANY other sessions to attend as well. The spotlight sessions are being working into our schedule to take up exactly two sessions slots. Attendance to a spotlight will not in any way affect your schedule before or after. Attendance is TOTALLY optional, and no special charge nor requirement is made to join in.
When will I find out what the sessions are?
We will be announcing the Spotlight Sessions along with our standard sessions during the first week of August. Check back soon for more details.
Thanks for your time today, and if you haven’t registered for SQL Saturday #160 in Kalamazoo yet, do so now! Limited space is available and will fill quickly!
Experienced SSIS developers will recognize the usefulness of the simple data viewer object used during the development process to peek into the data set and see what is going on at various stages of execution.
One piece of functionality that has been missing since SQL 2005 is the ability to do this from a production SSIS server. Since the data viewer required the use of BIDS, and most organizations don’t allow development tools to be connected to production; troubleshooting data issues often involved lots of blind poking around and vague assumptions.
This problem is nullified in SQL 2012 with the introduction of the SSIS Data Tap. This is a run-time utility than can be used to peek into the data at various stages of execution – JUST LIKE THE DATA VIEWER!
Data tap files are output to the SSIS root install directory, and must be configured through SSMS. First some information about the package must be gathered in SSDT, so fire up your development environment and follow along.
2. Collect the IdentificationString. To find this, enter the Data Flow object and select the connector that exists between the two transformations that you wish to tap. Copy the value of IdentificationString
With these two pieces of information, it’s off to SSMS for the rest of the procedure!
Connect to your SQL Server 2012 Instance that hosts the SQL 2012 Integration Services Catalog. Mine is SSISDB on my default instance. Once there, execute the following stored procedures in order.
To make it REALLY easy, I’ve written a SQL Script using template parameters that YOU CAN HAVE! All you need to do is use <CTRL>+<SHIFT>+M to replace the defaults with the values that are required for your instance. Get a copy of the script here. Email me if you have trouble with the download and I’ll be happy to send it to you.
After the package is executed, check your SSIS Install directory – mine is
C:\Program Files\Microsoft SQL Server\110\DTS\ – for a subfolder called DataDumps. You should see a file there with the name specified in the catalog.add_data_tap stored procedure.
There is your output! Now you can see EXACTLY what SSIS was working with at any point of the execution, EVEN IN PRODUCTION!
Some Important Notes
1. Data taps are only valid for ONE execution, so unless you create a job step with all of this code, you’ll only get a data tap when you explicitly specify it.
2. Data taps create I/O (go figure). This means that performance WILL be affected when running a data tap. I wouldn’t recommend running them for every execution. Only use them when needed.
3. Data taps use the catalog schema, which means they require an SSIS 2012 Integration Services Catalog to be used. Tapped packages also need to be deployed to this catalog.
Finally! The day has come. The official announcement of SQL Saturday #160, otherwise known as SQL Saturday Kalamazoo 2 –
Electric Boogaloo The SQL.
If you joined us at KVCC last year, I hope you enjoyed yourself so much that you’ll want to join us again! If you didn’t get a chance to join us last year, then now’s the perfect time to register!
I, and the wonderful volunteer team that I’m working with, will be disseminating more details regarding the event as we have them. For now I can tell you this: You’ll be getting top-shelf, high-class SQL Server training from both local presenters and well seasoned public speaking professionals. You’ll also get a chance to talk with local, national, and worldwide IT and data vendors. You’ll also get get lunch, and chance to win great prizes – don’t believe me? Last year we gave away an iPad2 and a brand new Xbox 360 with Kinect!
You’ll get all of this – and more – for the low, low price, of absolutely nothing! That’s right, you don’t have a pay a dime for all of the training that you are going to have access to (ok, we are charging a small fee of $10 to help cover breakfast and lunch, you’ll have to pay that)
I am so excited and honored to be hosting another SQL Saturday event in Kalamazoo this year. It’s a humbling experience, but one that is very rewarding.
I’m looking forward to digging in and making this event one of the greatest of 2012. I hope to see you there.
Wow! What a weekend in Madison, WI. First this happened.
Then things got better.
SQL Saturday #118 was a HUGE SUCCESS!!! Thank you so much to ALL of the organizers, sponsors, speakers, and most of all THE ATTENDEES!
I was happy to present my session on Administering the BI Stack again. I really love this presentation, and I was happy to have it be the one that was selected for Madison.
You can find my slides here.
Coming up next: I’ll be giving the same presentation in Chicago for SQL Saturday in May. Although, I will be revamping it for SQL 2012. I hope to see you there!