My first real introduction to PASS was back in 1998. I was an “Accidential DBA” and needed some training. I heard about this conference in Chicago and my boss agreed it was the best place to start. Little did I know how that conference would influence the rest of my… Read more
I’ve been responsible for administering Analysis Services (SSAS) on a regular basis for the past 7-8 years via SQL Server Management Studio (SSMS), but developing is a whole different ball game (and set of tools). I only recently started doing development work with SSAS on a regular basis. Prior to… Read more
I have finally submitted a session for a speaking engagement. Those who know me know that this is a very BIG deal. I have a horrible fear of public speaking, but I am slowly starting to embrace that fear. Last year I presented at the Triad SQL BI User Group Read more
Backing up databases is one of the most important jobs of a DBA. If your data is not safe, your job is not safe. Data is the lifeblood of a DBA. That said, there are so many products out on the market that will help with backing up transactional databases… Read more
A big thank you goes out to Kenneth Fisher ( b | t ) for hosting this month’s TSQL2sday party. Security is a big deal. How many times have you opened the paper (I’m dating myself, I know – no one reads an actual newspaper anymore, it’s all online now)… Read more
Have you ever had a mental block in one particular area when learning something? It might be the simplest thing, but for some reason your brain turns to Teflon when you try to store the information. For example, I have a degree in Math, so I am pretty good at… Read more
First off I wanted to thank Wayne Sheffield (Twitter | Blog) for hosting this month’s T-SQL Tuesday party and Adam Machanic (Twitter | Blog) for starting this party five years ago. I can’t believe it’s been five years.
This month’s theme is Giving Back to the… Read more
It’s hard to believe it’s over. It felt like a whirlwind while I was in Seattle for my 7th PASS Summit, but now that I’m back home it feels like it was ages ago. I think time moves more quickly when you’re with friends and that’s where I was, with… Read more
Data Driven Subscriptions On A Budget – Part 2
Yes, this is Part 2, you can find Part 1 here to get background information.
This blog will talk about Point 3 – Distribute a report to a fluctuating list of subscribers.
Distribute a report to a (fluctuating) list of subscribers Read more
I gave what is officially my second presentation this week. I presented at the Triad SQL BI (Twitter | PASS) user group meeting and I didn’t hyperventilate! That’s a huge deal for someone like me, who is petrified of public speaking.
It started out a little rough though. Read more
Data Driven subscriptions in SQL Server Reporting Services (SSRS) is only available if you have the Enterprise or BI Editions for 2012 & 2014, Enterprise or Data Center Editions for 2008R2 or Enterprise for 2008. But what happens when the money is not in the budget for those versions? Can… Read more
Serving on the Nomination Committee (NomCom) is such an honor. One that I was lucky enough to experience two years ago. It allows me to give back to the community that has given me so much over the years and continues to give back on a daily basis. This year’s… Read more
Question: How many Oracle DBAs can you fit in Madison Square Garden?
Answer: None, their egos won’t fit through the door.
No, this blog is not a slight towards Oracle DBAs. I have several friends who are Oracle DBAs and they are some of the nicest, most humble people you… Read more
Voting is one of the many privileges that I have as an American citizen. It’s a privilege that most Americans take for granted today. My dad always used to say, “If you don’t like something, change it.” That’s exactly what voting allows us to do.
What does voting have to… Read more
According to Merriam-Webster the definition of grace is:
1a : unmerited divine assistance given humans for their regeneration or sanctification; b : a virtue coming from God; c : a state of sanctification enjoyed through divine grace; 2a : approval, favor <stayed in his good graces>; b archaic : mercy,…
I have recently begun to contemplate pursuing the MCSA Certification. I have been working with SQL Server for almost 20 years and have never considered getting a certification before now. I have met so many people through the years who have the certifications and were quite frankly “dumb as a… Read more
“The Long and Winding Road” is one of my favorite Beatles songs, it reminds me of my dad, he was a huge Beatles fan. My dad passed away almost five years ago, but I still miss him like it was yesterday and I still remember the advice he gave me… Read more
I presented on this topic at the TriadSQL User’s Group meeting on 3/26/13. I promised I would post my code/solutions, so here it is. For those that were not able to attend the meeting, here is a brief description of what I am posting.
I am lucky enough to be… Read more
What a whirlwind last week was. There were so many sessions to attend and only one of me. I needed to clone myself a couple of times over in order to catch all the sessions that I wanted to see. Unfortunately, that technology is nowhere near ready, so I had… Read more
I have just recently changed employers and in doing so, I’ve changed my role from Data Architect to DBA/BI Developer. I had been doing heads down development work for the last 4 plus years and not a lot of admin work. Given that, I missed out on something that I… Read more