#SQLPASS–Data Professionals?

So, in my last post, I described the financial pressures of community building; two companies benefit from building a community organization.  I’ve tried to stay away from assumptions, but I am assuming that their influence must factor into the Board of Directors’ decision making process (Microsoft has a seat on the board; C&C is dependent […]

October 21, 2014 · stuart · 7 Comments
Tags: , ,  · Posted in: Blogging is FUN!, PASS, SQLServerPedia Syndication, The Social Web

#SQLPASS–Who’s Making It Rain?

  As promised in my previous post (#SQLPASS–Good people, bad behavior…), I’d like to start diving in to some of the controversies that have cropped up in the last year and critically analyze what I consider to be “bad decisions”.  This first one is complex, so let me try to sum up the players involved […]

October 20, 2014 · stuart · 12 Comments
Tags: , , , ,  · Posted in: Blogging is FUN!, PASS, SQLServerPedia Syndication

What I Wished I’d Known Sooner As A DBA

Mike Walsh has put together an excellent topic for discussion, and I’ve read several responses to this; all of them are great, but most them are a little optimistic for my experiences.  I like to think that most of my friends and peers in the #sqlfamily are happy people, so it’s understandable that their guidance […]

August 28, 2014 · stuart · One Comment
Tags: , , ,  · Posted in: Blogging is FUN!, SQLServerPedia Syndication

#SQLServer – Where does my index live?

Today, I got asked by one of my DBA’s about a recently deployed database that seemed to have a lot of filegroups with only a few tables.  He wanted to verify that one of the tables was correctly partition-aligned, as well as learn where all of the indexes for these tables were stored.  After a […]

August 14, 2014 · stuart · No Comments
Tags: , , , ,  · Posted in: Code, SQL, SQL Server, SQLServerPedia Syndication, XML

Hadoop for the SQL Server DBA – Initial Challenges

I’ve been intrigued by the whole concept of Big Data lately, and have started actually presenting a couple of different sessions on it (one of which was accepted for PASS Summit 2014).  Seems only right that I should actually *gasp* blog about some of the concepts in order to firm up some of my explanations.  […]

August 13, 2014 · stuart · No Comments
Tags: , , ,  · Posted in: Hadoop, SQL, SQLServerPedia Syndication

Determining the Primary Key of a table without knowing it’s name

So, I’ve been trying to find more technical fodder for blog posts lately in order to get in the habit of blogging on a regular basis, so I thought I would explore a few of my higher-ranked answers on StackOverflow and provide a little more detail than that site provides.  This is my highest-rated answer […]

July 23, 2014 · stuart · No Comments
Tags: , , ,  · Posted in: SQL, SQL Server, SQLServerPedia Syndication

Error 574 Upgrading SQL Server 2012 to SP1

This blog post is way overdue (check the dates in the errror log below), but I promised our sysadmin that I would write it, so here it is.  Hopefully, it’ll help some of you with this aggravating issue.  During an upgrade of our SQL cluster, we ran into the following error as we attempted to […]

July 15, 2014 · stuart · One Comment
Tags: , ,  · Posted in: SQL, SQL Server, SQLServerPedia Syndication

Speaking at CodeStock 2014

So, this announcement’s way overdue; in about 2 weeks (July 11-12,2014), I’ll be presenting a couple of sessions at CodeStock 2014 in lovely Knoxville, TN.   I haven’t been to CodeStock since 2009, so it’ll be interesting to see how it’s grown. The Elephant in the Room; A DBA’s Guide to Hadoop & Big Data by […]

June 26, 2014 · stuart · No Comments
Tags: , ,  · Posted in: Conferences, SQLServerPedia Syndication

Speaking at the #SQLPASS #Summit14

I know I’m a day late with this announcement, but I haven’t blogged in months, so what’s the rush?  I am very excited, however, about presenting a full session and a lightning talk at the PASS Summit in Seattle in November. THE ELEPHANT IN THE ROOM: A DBA’S GUIDE TO HADOOP AND BIG DATA Speaker(s):  […]

June 26, 2014 · stuart · No Comments
Tags: , ,  · Posted in: Conferences, PASS, SQL Server, SQLServerPedia Syndication

Steel City SQL Users Group–March 18, 2014– @SteelCitySQL

Next Tuesday, I’m loading up Big Blue, and driving over to Birmingham to present at the Steel City SQL Users Group.  I’ll be talking about the Agile DBA.  Should be fun! http://www.steelcitysql.org/ Featured Presentation The Agile DBA: Managing your To-Do List Speaker: Stuart Ainsworth Summary: Agile development is all the rage, but how do the […]

March 14, 2014 · stuart · No Comments
Tags: , , , ,  · Posted in: Conferences, Professional Development, SQL, SQLServerPedia Syndication, User Groups