Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Swimmer

I started out as a software developer back in 1996 in Denver, CO, doing Client/Server development in PowerBuilder. I am now a Data Architect, living in High Point, NC and I love what I do. I’ve worked with all versions of SQL Server since the infamous split from the Sybase code (a.k.a. version 4.21a). I’ve worn all the hats that come with dealing with SQL Server, developer to data architect and everything in between. Twitter handle: @SQLSwimmer

Data Driven Subscriptions On A Budget

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

2 comments, 141 reads

Posted in SQL Swimmer on 1 July 2014

2014 NomCom Slate is Amazing

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

0 comments, 91 reads

Posted in SQL Swimmer on 2 June 2014

Disheartening Apples

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

0 comments, 161 reads

Posted in SQL Swimmer on 21 March 2014

Will You Vote?

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

1 comments, 125 reads

Posted in SQL Swimmer on 23 September 2013

Saving Grace

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,…

Read more

0 comments, 280 reads

Posted in SQL Swimmer on 30 May 2013

Certifiable?

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

0 comments, 287 reads

Posted in SQL Swimmer on 17 May 2013

The Long and Winding Road

“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

0 comments, 261 reads

Posted in SQL Swimmer on 14 May 2013

Custom Reports for SSMS 2012

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

0 comments, 516 reads

Posted in SQL Swimmer on 29 March 2013

Summit 2012 is over, but not forgotten

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

0 comments, 362 reads

Posted in SQL Swimmer on 12 November 2012

Policy-Based Management, How Sweet It Is

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

0 comments, 552 reads

Posted in SQL Swimmer on 24 October 2012

PASS Election Season

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

0 comments, 300 reads

Posted in SQL Swimmer on 27 August 2012

Mentoring

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

0 comments, 333 reads

Posted in SQL Swimmer on 24 August 2012

Paying it Forward

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

3 comments, 1,377 reads

Posted in SQL Swimmer on 22 August 2012

Replication and TFS

 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

Read more

0 comments, 737 reads

Posted in SQL Swimmer on 16 August 2012

Simply NomCom

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

0 comments, 319 reads

Posted in SQL Swimmer on 18 June 2012

NomCom, what it’s all about

I submitted my application for the NomCom last week and the polls opened up yesterday.  I’ve seen an amazing amount of support not only from friends and co-workers, but also members of the community that I’ve never met.  That is what PASS is all about.  A community that encourages and… Read more

2 comments, 316 reads

Posted in SQL Swimmer on 14 June 2012

Just another SQL blog

I started out as a software developer back in 1996 in Denver, CO, doing Client/Server development in PowerBuilder.  The internet was just starting to blossom and my knowledge base was non-existent.  Over the past 16 years I’ve seen how the IT world has changed and grown, which in turn has… Read more

1 comments, 301 reads

Posted in SQL Swimmer on 6 June 2012