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

TSQL2sday #68 – Defaults

A big thank you goes out to Andy Yun (b|t) for hosting this month’s TSQL2sday party. This month’s topic is Just Say No to Defaults.

TSQL2sday #68

I have a Bachelor’s degree in Mathematics with a minor in Computer Science. So when I say I’m… Read more

1 comments, 106 reads

Posted in SQL Swimmer on 14 July 2015

The Whole Pie

Today should be such an exciting day, the day the speakers are announced for the 2015 PASS Summit. But as someone who has been involved with the process for the last 6 Summits, it’s a day that I usually turn my Twitter feed off because there’s always those one or… Read more

4 comments, 116 reads

Posted in SQL Swimmer on 26 June 2015

Earning my MCSE: Business Intelligence Certification

I earned my MCSE: Business Intelligence Certification on May 27, 2015. It was a long road, but I did it. Back in May of 2013, I wrote about being Certifiable and wasn’t really interested in pursuing any certifications. What made me change my mind you ask? The short answer is,… Read more

3 comments, 289 reads

Posted in SQL Swimmer on 28 May 2015

TSQL2sday #66 – Monitoring

A big thank you to Cathrine Wilhelmsen (blog | twitter) for hosting this month’s TSQL2sday party. Monitoring is this month’s topic and it’s a very important one. It could mean the difference between having a job and looking for a job.

When I started working with SQL Server… Read more

2 comments, 115 reads

Posted in SQL Swimmer on 12 May 2015

Becoming a PASS Chapter Leader – Challenge Accepted!

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

1 comments, 132 reads

Posted in SQL Swimmer on 14 April 2015

How to Add Users to Roles in SSAS, a.k.a., Where the Heck are the Buttons?

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

0 comments, 191 reads

Posted in SQL Swimmer on 7 April 2015

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, 393 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,894 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, 182 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, 5,060 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,095 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, 177 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, 467 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, 308 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, 395 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, 216 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, 330 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, 214 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, 483 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, 409 reads

Posted in SQL Swimmer on 17 May 2013

Older posts