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

Jason Carter

Jason Carter has spent most of his career as a .NET developer, with time spent as a development manager, accidental DBA, and most recently a full-time DBA. Having worked with large databases as a developer, he found great interest in tuning, tweaking, and making databases run faster. With the support of his wife, he gave up his managerial duties, jumped the development ship and dove head first into his new career as a Database Administrator.

Second Year Presenting at SQL Saturday Orlando

Coming up on my schedule is another appearance at SQL Saturday Orlando.   Orlando is quite special to me as it was my first ever presentation, and their team is quite welcoming, and just plain awesome.

Looking at the line up this year, I’m quite excited to see a few… Read more

0 comments, 119 reads

Posted in Jason Carter on 7 August 2014

SQL Downgrades Made Easy

I was reading Kendra Little’s ( b | t ) post on SQL Server Edition Changes and it reminded me of the work I did at my last position.   I did LOTS of downgrades, seriously, LOTS.

When we started auditing our systems we found TONS of Enterprise and Standard Editions… Read more

3 comments, 7,553 reads

Posted in Jason Carter on 6 August 2014

Export XML Columns to Individual Files

I was reading SqlServerCentral.com Articles Requested forum and saw this request.

Looking for an article that takes data from an XML column in a table and exports each field as a separate document.

While the request did indicate a PoSH or SSIS method, I wanted to give it a try… Read more

2 comments, 7,563 reads

Posted in Jason Carter on 4 August 2014

Tampa Code Camp Revivial

If you were to look around Florida at the various cities technology based User Groups, and their accompanying local conferences you will see some of the best in the land.  Orlando started SQL Saturday since 2007 with Tampa following closely thereafter.  South Florida has hosted Code Camp for 10 years… Read more

0 comments, 163 reads

Posted in Jason Carter on 21 July 2014

Powershell Goodies

If you haven’t seen some of the other blog post, or the Microsoft Powershell Blog, Microsoft recently release Script Browser for Powershell ISE.   This little addin allows you to quickly search and import Powershell scripts directly from TechNet Script Center.    Currently the database section has 577 scripts in the repository,… Read more

1 comments, 750 reads

Posted in Jason Carter on 25 April 2014

Come see me present SQL Saturday Atlanta

Have you seen the schedule for SQL Saturday #285 – Atlanta?   Holy cow they have jam packed too many hard decisions into that schedule.    I’ll be presenting Maintenance and Backups: Intro to Ola Hallengren bright and early at 8:15 in the Admin Room, aka Room 3.   Luckily for everyone… Read more

2 comments, 164 reads

Posted in Jason Carter on 22 April 2014

Mr. Carter, Where Did You Go?

It has been nearly a month since your last blog post Mr. Carter, and frankly your last post was nothing more than a list of things you did in Madison.  What gives?  Where are you?  What is so important that you must leave with such reckless abandon as to not… Read more

0 comments, 197 reads

Posted in Jason Carter on 22 April 2014

SQL Saturday Madison – Recap

A few notes from our trip to Madison for SQL Saturday.  We arrived two days early and acted like tourist for the first two days, here are few notes:

Food

  • Monty’s Blue Plate Cafe – Small place, yet excellent meals, large portions worth the wait.
  • Great Dane – great atmosphere,…

Read more

4 comments, 204 reads

Posted in Jason Carter on 1 April 2014

Presenting Orlando Code Camp

I’ve been attending Orlando Code Camp for years now, and they always put on a great event.  It was at their event a few years ago after helping a young first time presenter field some questions on Mono that it was recommended that I speak at these events.  I held… Read more

0 comments, 56 reads

Posted in Jason Carter on 11 March 2014

First Remote Presentation

I threw it out there and they said yes.   They being Meredith Ryan of the Albuquerque PASS Chapter.  They were looking for a speaker for their March user group meeting, I provided the two talks I have fully developed and she asked that I give my 5 T-SQL Things presentation.… Read more

0 comments, 63 reads

Posted in Jason Carter on 3 March 2014

Tell Me How I’m Doing: A Fable About the Importance of Giving Feedback

I read a lot of blogs using BlogTrottr as my inbox delivery mechanism, but it has been quite a while since I’ve been cover to cover on a good book, or any book for that matter.  My wife calls me a reference reader, I know how to find information I… Read more

1 comments, 71 reads

Posted in Jason Carter on 26 February 2014

Be Nice

Years ago when I was just out of the Marine Corps and found myself as the only IT guy in an environment filled with various levels of technologically challenged mortgage brokers, realtors, title agents, and other office workers.  In that environment, I was the sharpest guy around, I was so… Read more

0 comments, 71 reads

Posted in Jason Carter on 19 February 2014

Next Up 70-432

As a self-taught developer, I’ve never really given any credence to certifications.  Certifications in the development arena seem like a way to certify someone knows how the company wants you to use their latest and greatest features, but doesn’t really test the underlying knowledge about why to use those features,… Read more

0 comments, 60 reads

Posted in Jason Carter on 13 February 2014

5 Things Series – APPLY Operator

In this series I’m going to detail the 5 T-SQL Commands that review in my  5 T-SQL Commands I’ve been Missing, but were there the whole time presentation.  The gist of this presentation details my past as an uninformed developer, as it pertains to T-SQL and its vast features.   This… Read more

0 comments, 70 reads

Posted in Jason Carter on 12 February 2014

5 Things Series – Output Clause

In this series I’m going to detail the 5 T-SQL Commands that review in my  5 T-SQL Commands I’ve been Missing, but were there the whole time presentation.  The gist of this presentation details my past as an uninformed developer, as it pertains to T-SQL and its vast features.   This… Read more

0 comments, 78 reads

Posted in Jason Carter on 9 February 2014

Powershell – Extract Versions for SQL Features

 

Over the last few months I’ve been directed to ensure that all of our SQL Servers in the Development and QA segments have been installed with the proper licensing, namely Developer Edition.    One of the challenges I’ve ran across is how do I verify the SSRS and SSAS features… Read more

0 comments, 82 reads

Posted in Jason Carter on 5 February 2014

Upcoming Presentations

Since I took the leap last year and submitted to talk at SQL Saturday, I’ve come to enjoy the challenge that is presenting.  Every time I present a topic, I learn something new.  Every time. Sometimes there is a subject matter expert in attendance that might correct a minor point… Read more

0 comments, 62 reads

Posted in Jason Carter on 4 February 2014

Blogtrottr – RSS to Email

Anyone who is a fan of RSS Feeds will likely know that the discontinuing of service by Google Reader caused many of its users to go looking for another option.  One of the winners for the pure RSS reader was Feedly.com, a slick, intuitive reader with native apps on… Read more

1 comments, 116 reads

Posted in Jason Carter on 24 January 2014

Its the little things – Service Master Keys

In advance of the yearly licensing reconciliation with Microsoft at work, I have led the charge to ensure all of our Development and QA servers are running the proper editions, namely Developer edition. In doing so I have done a lot of downgrades for SQL Server. Part of this process… Read more

1 comments, 84 reads

Posted in Jason Carter on 23 January 2014

T-SQL Tuesday #050 – Automation

In my developer life, my motto was ‘Automate all the things’  and since transitioning to a DBA role, my motto hasn’t changed a bit.   Since taking my first official DBA position earlier this year I found that other intelligent folks love automation as well.  It seems that automation in IT… Read more

0 comments, 74 reads

Posted in Jason Carter on 14 January 2014

Older posts