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
Did you know that it’s election season for PASS? Did you know that you can pose questions to the potential candidates via the Election Forums? The NomCom is busy interviewing candidates and is offering you the opportunity to ask the candidates question, via the NomCom. Do you have a… Read more
I’m putting my money where my mouth is, with respect to my last blog post. I am officially a mentor with The Mentoring Experiment. I am so honored to have been selected as a mentor and am so excited to begin. I’ll let you know how it turns out… Read more
My company has recently put forth an effort to hire fresh college graduates and interns. I think this is a great thing. A long time ago, in a galaxy far far away, I was a fresh graduate, with no real world experience and my first employer took a big chance… Read more
So, we’ve had this issue lately at work with our TFS build/deploys causing a significant amount of contention and only partially succeeding.
A little about our environment:
- SQL Server 2008 R2 Enterprise Edition, 64-bit.
- Visual Studio 2010
- Team Foundation Server (TFS)
- Using Transactional Replication
- Using partial projects for replicated objects
So there seems to be some confusion as to what the NomCom’s job is. I have to admit I was confused about its job at one time as well. It took a couple of hours of sifting through blog posts, forums and documentation on the PASS site to finally figure… Read more