Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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

Did you know?

Did you know that the call for speakers for PASS Summit 2016 opened on February 3, 2016?

Did you know that the call for speakers for PASS Summit 2016 ends on March 2, 2016?

Did you know that there’s a Speaker Resource Page?

Did you know that you can… Read more

0 comments, 111 reads

Posted in SQL Swimmer on 15 February 2016

What is Power BI?

One of the “benefits” of being a chapter leader is that sometimes it means doing a presentation yourself when you can’t get a speaker.  I fell into this exact scenario for February’s meeting of Triad SQL.  I was trying to figure out what to present when the planets aligned.… Read more

1 comments, 2,094 reads

Posted in SQL Swimmer on 25 January 2016

What Do You Want?

It’s that time of year, planning for PASS Summit 2016.  We’ve already put out the Call for Volunteers, which closes today, January 22, 2016, so get those applications in and be part of the team that helps determine content for the Summit.  Don’t want to volunteer but still want… Read more

0 comments, 154 reads

Posted in SQL Swimmer on 22 January 2016

We Want You!

It seems like PASS Summit 2015 was just yesterday and here we are again, getting ready for Summit 2016 already.  This will be my seventh year of being a member of the Program Committee and my second year as a Program Manager.  If you have ever thought about volunteering for… Read more

0 comments, 193 reads

Posted in SQL Swimmer on 8 January 2016

Scripts – A Living History

As a DBA, I have a collection of scripts that I use for anything from auto-fixing logins to seeing who has the DAC.  Since I’ve been a DBA for a while (yeah, a while, we’ll go with that) I have quite the collection of scripts and I am constantly adding… Read more

2 comments, 621 reads

Posted in SQL Swimmer on 20 November 2015

Aggregation Design is Back!

If you use SQL Server Data Tools (SSDT) and SQL Server Data Tools – BI (SSDT-BI) for your SQL Server 2012 development, then you have no doubt been frustrated, like me, by the fact that if you have both of these installed you no longer have the ability to create… Read more

0 comments, 163 reads

Posted in SQL Swimmer on 19 November 2015

One Tool to Rule Them All – Almost

There we so many cool announcements at the PASS Summit this year, but one of my favorites was the “One Tool to Rule Them All”. The SQL Server Data Tools (SSDT) teams and the Visual Studio (VS) team have finally teamed up together to give us one tool to do… Read more

2 comments, 200 reads

Posted in SQL Swimmer on 18 November 2015

My Build and Deploy Process (as Requested by Bill Fellows)

Recently I attended Reg-Gate’s SQL in the City event in Seattle, WA. I was in Seattle for the annual PASS Summit, you can read about my Summit adventures here. While at RedGate’s event, I attended a session that called on SQL Server Data Tools (SSDT) users. RedGate wanted… Read more

3 comments, 1,062 reads

Posted in SQL Swimmer on 5 November 2015

The Whirlwind That Is October – Part 3

October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post is about the PASS Summit in Seattle, October 27 through 30. You can read about my SQL Saturdays here and here. Settle in, get a cup of <insert caffeinated… Read more

2 comments, 146 reads

Posted in SQL Swimmer on 3 November 2015

The Whirlwind That Is October – Part 2

October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post is about the second SQL Saturday I attended in Charlotte, SQL Saturday #452, on October 17, 2015, where I was a member of the organizing team. You can read… Read more

1 comments, 151 reads

Posted in SQL Swimmer on 18 October 2015

The Whirlwind That Is October – Part 1

October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post is about the first SQL Saturday I attended in Raleigh, SQL Saturday #445, on October 10, 2015, where I was both volunteer and attendee.

This event is put on… Read more

2 comments, 188 reads

Posted in SQL Swimmer on 16 October 2015

Fall Means Election Season

While it’s not officially Fall yet, it is definitely Election Season. Elections for the PASS Board of Directors opens up on September 17, 2015. Campaigning starts today with the announcement of the Official Slate of Candidates.

It’s a great slate and it will be hard to choose. I appreciate… Read more

0 comments, 633 reads

Posted in SQL Swimmer on 11 September 2015

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, 231 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, 200 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

10 comments, 586 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

3 comments, 239 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, 244 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, 315 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, 522 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, 6,138 reads

Posted in SQL Swimmer on 11 February 2015

Older posts