-->
SQL Clone
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

New Session: Data Types Do Matter

I started speaking on a semi-regular basis this year after many years of trepidation.  You can read about my first speaking experience here.  It’s three years later and I have discovered that I love speaking.  I always wanted to be a teacher when I was younger, but it didn’t… Read more

0 comments, 132 reads

Posted in SQL Swimmer on 17 November 2017

girls + data is coming to SQL Saturday Charlotte

I am so excited to be part of the organizing team for SQL Saturday Charlotte again this year, the CBIG folks are always a pleasure to work with and I am honored to be able work with them.  I am proud to say that this year we are raising the… Read more

0 comments, 195 reads

Posted in SQL Swimmer on 5 October 2017

Visual Studio 2017 Irritants From the SSIS Developer View

I was among the many Integration Services (SSIS)/Database (DB) developers out there that cheered when Microsoft finally announced support for SSIS in Visual Studio 2017.  I mean really, VS2017 was released back on March 7, 2017, but if you wanted to develop any SSIS packages in VS2017, you had to… Read more

0 comments, 241 reads

Posted in SQL Swimmer on 5 October 2017

Speaking at SQL Saturday Spartanburg (#681)

I am so happy to announce (and honored to be selected) that I will be speaking at SQL Saturday Spartanburg (#681) on September 23, 2017.  I will be presenting my What is Power BI? session at 8:30am.  I know it’s early, but I’d love to see you if you are… Read more

0 comments, 184 reads

Posted in SQL Swimmer on 30 August 2017

SQL Saturday Charlotte (#683)

I am so excited to be helping out with SQL Saturday Charlotte again this year.  This is the 6th year that Charlotte BI Group (CBIG) has put this event on and the 3rd year that I’ve been asked to be part of the organizing team. 

We have a great lineup… Read more

0 comments, 209 reads

Posted in SQL Swimmer on 22 August 2017

Speaking at SQL Saturday Denver (#673)

Wow, I can hardly contain my excitement.  I was selected to speak at SQL Saturday Denver on September 16, 2017.  I’ll be presenting my Intro to Integration Services session.  I’m excited for so many reasons, but firstly, this will be my first trip back “home” in seven years.  We planned…

Read more

0 comments, 168 reads

Posted in SQL Swimmer on 28 July 2017

Don’t Forget the Keys

I was recently given the nod to upgrade my monitoring server from SQL Server 2012 (SP 3) to SQL Server 2016.  This came none too soon as SQL Server 2012 (SP3) goes out of mainstream support on July 11, 2017.

We decided to go with a brand new box since… Read more

0 comments, 1,845 reads

Posted in SQL Swimmer on 30 June 2017

Working on my Microsoft Professional Program for Data Science

Microsoft announced a new program last year to help you understand the skills that a Data Scientist needs in their daily life.  It consists of nine courses and a final project, you can get all the details about it on the Microsoft Academy site.  I started working on this at… Read more

0 comments, 345 reads

Posted in SQL Swimmer on 21 June 2017

Import Export Wizard Mapping Files

Recently I had to copy data from our AS400 to a SQL Server database.  Normally I would whip up my fancy SQL Server Integration Services (SSIS) project and get it hammered out pretty quickly.  Unfortunately there were over 4,000 tables that I needed to pull data from, no way in… Read more

2 comments, 434 reads

Posted in SQL Swimmer on 7 June 2017

Speaking at SQL Saturday Atlanta (#652)

I am so excited and honored to have been selected to speak at SQL Saturday Atlanta (#652) this year.  This is huge event where I’ve been a volunteer and attendee in the past, but this will be my first time as a speaker.

I will be presenting my session What… Read more

0 comments, 201 reads

Posted in SQL Swimmer on 25 May 2017

SQL Saturday Richmond (#610)

On Saturday, March 18, 2017, I spoke at my very first SQL Saturday.  I have been an attendee, involved in organizing and volunteered at many over the years, but this was the very first time I was a speaker.  My session, What is Power BI?

I have presented this session… Read more

0 comments, 226 reads

Posted in SQL Swimmer on 22 March 2017

Check Those Settings

Recently, I was tasked with “enhancing” a third party application.  This third party application (TPA) outputs a bunch of files to a file share in a way that makes sense to the application, but makes no sense to a human. 

The Task

Make a copy of these files in a… Read more

1 comments, 2,025 reads

Posted in SQL Swimmer on 16 March 2017

Next Stop, SQL Saturday Richmond

I can’t believe it’s almost time for SQL Saturday #610.  I’ll be there presenting What is Power BI?  If you are in the Richmond area Saturday, March 18, 2017, please stop by and say “Hello”, I’d love to see you.  There are tons of other sessions as well, so… Read more

0 comments, 238 reads

Posted in SQL Swimmer on 11 March 2017

Triad Developers Conference – My Debut

I did it!  I did my first “real world” presentation this morning at the Triad Developers Conference in Winston-Salem.  What I mean by “real world” is not a PASS audience.  These were total strangers off the street that I didn’t know, well, there were some familiar faces and even a… Read more

0 comments, 223 reads

Posted in SQL Swimmer on 10 March 2017

Speaking at Triad Developer’s Conference

I am honored to have been recommended by a colleague and selected as a speaker for the Triad Developer’s Conference in Winston-Salem on March 10, 2017.

The Triad Developer’s Conference is a low cost one day learning event put on by a myriad of local user groups in the Piedmont… Read more

0 comments, 236 reads

Posted in SQL Swimmer on 9 February 2017

Pesky Percent File Growth

As DBAs we all know setting your file growth to grow by percent is not optimal.  It can cause all kinds of issues, which rear their ugly heads as performance problems (see these articles by Brent Ozar, & Tim Ford).  So, when I have to support… Read more

1 comments, 374 reads

Posted in SQL Swimmer on 31 January 2017

My First SQL Saturday – As A Speaker!

I am so honored and excited to have been selected to speak at SQL Saturday Richmond on March 18, 2017.

I will be presenting my What is Power BI? session.  There have been a ton of changes to Power BI since I last presented this, so I’m off to start… Read more

0 comments, 311 reads

Posted in SQL Swimmer on 31 January 2017

How to Exclude Entire Sections in VS Schema Compare

Right now I am so excited, and a little embarrassed.  After using Visual Studio (VS) for database projects for the last 7 years, I am just now finding out about this feature?!  What feature is that, you ask?  Let me tell you…

When using VS for database projects I typically… Read more

0 comments, 321 reads

Posted in SQL Swimmer on 23 January 2017

So Long, Farewell, I Hate to Say Goodbye

The Sound of Music is one of my all time favorite movies.  It reminds me of some great times with family during the holidays when I was a kid.  The adults would all be in the living room talking about “boring adult stuff” and all us kids would be piled… Read more

8 comments, 360 reads

Posted in SQL Swimmer on 12 October 2016

SQL Saturday Charlotte is Coming!

That’s right, SQL Saturday Charlotte is coming September 17, 2016.  Next to the annual PASS Summit, this is my favorite SQL Event!  This is the fifth year that the Charlotte BI Group (CBIG) has put on this great event.  They’ve expanded the event this year to include two Pre-Cons… Read more

0 comments, 312 reads

Posted in SQL Swimmer on 1 September 2016

Older posts