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

Achievement Unlocked: 24 Hours of Pass Session Submitted

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

1 comments, 155 reads

Posted in SQL Swimmer on 19 March 2015

Automating SSAS Backups

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

0 comments, 5,671 reads

Posted in SQL Swimmer on 11 February 2015

Managing Security – TSQL2sday # 63

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

2 comments, 116 reads

Posted in SQL Swimmer on 10 February 2015

Transaction Isolation Level Blues

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

0 comments, 4,888 reads

Posted in SQL Swimmer on 15 December 2014

Giving Back T-SQL Tuesday #61

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

1 comments, 4,036 reads

Posted in SQL Swimmer on 9 December 2014

Summit 2014

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

1 comments, 131 reads

Posted in SQL Swimmer on 10 November 2014

Data Driven Subscription On A Budget, Part 2

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

0 comments, 242 reads

Posted in SQL Swimmer on 4 November 2014

I Didn’t Hyperventilate!

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

0 comments, 216 reads

Posted in SQL Swimmer on 28 August 2014

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

5 comments, 297 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, 158 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, 253 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, 176 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, 371 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, 356 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

2 comments, 315 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, 727 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, 429 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, 751 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, 364 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, 404 reads

Posted in SQL Swimmer on 24 August 2012

Older posts