Indianapolis, United States

Well here we are it’s August already. I have been slow to start on SQLSaturday events and have IMO missed some great ones. Hopefully next year will come easier.

I am traveling to my home state of Indiana to present at #SQLSatIndy on August 12. I will be doing my new presentation “Reduce your DBA (& DEV) task list by using Microsoft BI tools” just before lunch. I am evolving this session as I go along, trying to incorporate ideas the class comes up with.

Hope and John do an awesome job for this event. This year they have brought back their beginner track. This track is open to anyone . . . → Read More: Indianapolis, United States

Columbus, United States here I come

Yes folks for the second year in a row I will be traveling to COLUMBUS OHIO for #SQLSat653. I am really excited to be visiting them again this year.

If this is your first visit to Columbus I have to recommend you visit the zoo. It is an awesome zoo with a lot of walking but most of it is shaded by natural walkways. Do it!

If you are new here SQLSaturday is a one day free training event for data professionals. These events are organized by volunteers and the speakers pay their own way. It is a great opportunity to get a day full of free #sqllearning and . . . → Read More: Columbus, United States here I come

Chattanooga here I come!

I am so honored to be speaking at SQLSaturday Chattanooga again this year. This is going to be a great trip! Sadly it is my first speaking event this year, we were a little side tracked with other things. We will be traveling from Arrington with Dean, Stacia, Tess, Cricket and Mimi. In a shocking twist we are not leaving early but we are staying late! Yup not leaving till Monday morning. We need to figure something out to do Sunday, but I am sure we will manage.

So what am I presenting on? Uh….well it’s a new session. Much like my 45 minutes till your first SSRS report, this . . . → Read More: Chattanooga here I come!

Great Things from Pass Summit 2016

I have been home from Pass Summit 2016 for less than two days and needed to express some of the greatness last week had. First I’d like to share something personal; I had the great fortune of padding a few days before and a few days after the Summit for some fun and sight seeing. I got to visit Woodinville one day on both weekends and it was pretty amazing. If you want to skip and get to just the news click here.

On our first trip we met Kevin White at his winery. There were 2 things that made visiting with him so memorable. Currently in Washington everyone is . . . → Read More: Great Things from Pass Summit 2016

The Season of SQLSaturdays has begun

Date Location Submission Status 4/2 SQLSat 497 Huntington Beach CA SPEAKING Speaking just after lunch! 5/21 SQLSat 521 Atlanta GA SPEAKING! 6/4 SLQSat 517 Philly SPEAKING! 8am (someone hates me) 6/25 SQLSat 498 Chattanooga SPEAKING! Mid Morning 7/16 SQLSat 527 Columbus, OH SPEAKING! 8/13 SQLSat 530 Indianapolis SPEAKING! Last slot of the day, pretty sure that I have held that spot every time.

This is the current plan, of course there will be more added. I have been working on a new session, guessing that deadline of needing to present it on 4/2 will really help. I’m planning a what’s new in Microsoft Business Intelligence 2016 – More Love . . . → Read More: The Season of SQLSaturdays has begun

Visualizing SQLSaturday Data–Session Details

Recently I downloaded the session submissions report from the SQLSaturday Admin site, it was time to work on the schedule. But first I must upload it into my SQLSat480 database. I like having a database year over year and I just love to play with data. So I ran some queries to give me information about my submissions. While relaying these details to my husband I declared “I need to put this into PowerBI”. When he got home from work he was able to see what it was I had created and said “so what did that take you like half an hour”, “Pffft!” I said, “like 10 minutes”. On . . . → Read More: Visualizing SQLSaturday Data–Session Details

Power BI–Visualizing SQLSaturday Data

Inside SQLSaturday

This morning I was having a discussion with my husband about our SQLSaturday location. He is extremely concerned that moving the event further away from downtown Nashville would hurt attendance. I tried discussing it with him but he finally said “I’d like to see the data so we could know where everyone is coming from.” I said well I have all the data give me a minute. 10 minutes later I am Skyping him asking how to share with him the 2 Power BI maps I have made.

How did we get here? I ran the last 2 Nashville SQLSaturday events. Because I took a big leap in . . . → Read More: Power BI–Visualizing SQLSaturday Data

Starting over with Power BI

I had decided it was time to write a new presentation and happily chose Power BI, being that it’s the new hotness and looks to be the future of Business Intelligence. My timing couldn’t have been better with the general release going live recently it seems like now is the time to get going. I have titled this starting over because I had been using Power BI to create maps and other fun things inside Excel; it seems fitting since the changes to Power BI are coming in fast and furious. So I am here to tell you what it took to get back on track with this new release.

. . . → Read More: Starting over with Power BI

#SQLSatIndy, Shaving Yak and Power BI

You are probably wondering how these things are all related. I love summer, when there isn’t a signed SOW I can find a million things to do outdoors. I love being out in the sun. This leaves me very unmotivated to be indoors doing things, like writing new presentations. Hence the problem.

The Indianapolis SQLSaturday is near and dear to our hearts. First we love Hope Foley [ BLOG | TWITTER ], she’s one kick ass woman and she’ really an inspiration. Next Indy is only an hour away from our family and they were the first user group I ever attended. So it’s no surprise that we both submitted . . . → Read More: #SQLSatIndy, Shaving Yak and Power BI

5 Simple things I forget about SSRS – Multi Select Parameters

For some reason whenever I get to working on a report I am really irritated at how I “forget” that SSRS doesn’t handle multi-select parameters at all. I am irritated at myself for pushing this horrid fact from my brain, my reluctance to remember or maybe that the painful truth is a coping mechanism or I am just in denial–maybe it’s been fixed.. Then I am reminded how Microsoft failed us by not making this an actual feature. I feel the writing has been on the wall for a while now SSRS is a fading technology. I do however know that there will be SSRS servers running for years to . . . → Read More: 5 Simple things I forget about SSRS – Multi Select Parameters