Archive for the ‘Code’ Category

What’s your mantra?

I’ve been busy lately making the shift from “hands-on engineer” to “hands-off manager”; it’s been tough, because I’m not accustomed to stepping away from a problem and letting someone else figure it out.  Even though I’ve got an education background, and have been (inconsistently) involved in technical communities helping other people solve problems, I’ve never [...]

June 25, 2012 · stuart · One Comment
Posted in: Good Habits, Professional Development, SQLServerPedia Syndication

#TSQL2sDay.. For Whom Do You Log?

This month’s T-SQL Tuesday is being hosted by Aaron Nelson [blog | twitter]; since I’m posting this late in the day, I got a chance to sneak a peek at some of the other entries, and most of them were great technical discussions on how to log, what to log, and why you should log.  [...]

June 12, 2012 · stuart · No Comments
Posted in: SQLServerPedia Syndication, TSQL2sDay

#SQLSat111 “Biggish Data”

Trying not to be to obnoxious about this, but I’m presenting on “Biggish Data” at SQL Saturday 111 in Atlanta tomorrow; if you’re there, swing by and see me.  I presented this on Monday at AtlantaMDF, and am attempting to incorporate the feedback from that presentation into this one.  Should be good, but I’m still [...]

April 13, 2012 · stuart · No Comments
Posted in: Conferences, SQL, SQLServerPedia Syndication

#TSQL2sDay 28–Jack of All Trades, Master of None

This month’s topic was chosen by Argenis Fernandez (blog | twitter): "Jack of All Trades, Master of None?".  It’s interesting to me lately because I seem to keep encountering blog posts and articles that ask some variant of this question.  I’m not sure if it’s spurred in part by the recent release of SQL Server [...]

March 13, 2012 · stuart · No Comments
Posted in: SQLServerPedia Syndication, TSQL2sDay

Stuff in the FROM Clause: Interfaces

Finally wrapping up this blog series (while standing at my mobile office waiting on my daughter to finish track practice); I’ve previously discussed four different categories of database objects that can be used as the source of various SQL statements: Base Structures Virtual Structures Temporary & Semi-Temporary structures I want to wrap up with the [...]

March 1, 2012 · stuart · No Comments
Posted in: Code, SQLServerPedia Syndication

Stuff in the FROM clause: Temporary & Semi-Temporary structures

So way back in October, I started a blog series on Stuff in the FROM clause; I never finished it.  I’m trying to return to writing, so I thought it would be best if I completed the remaining two posts (so I can tick one more item off my to-do list).  If you really want [...]

February 28, 2012 · stuart · No Comments
Posted in: Code, SQLServerPedia Syndication

Quick and Easy SQL Script

I haven’t been blogging enough lately, so I’m going to try something new to get past this mild case of writer’s block.  Instead of trying to do a long, in-depth post on some esoteric subject, I’m going to just put out a simple SQL script.  This one’s a bit of a hack, but you’ll see [...]

February 2, 2012 · stuart · No Comments
Posted in: SQL, SQLServerPedia Syndication

Presenting tonight…

In a few minutes, I’m packing up to head to Greenville, SC to work from the first WiFi-enabled sandwich shop I can find.  Tonight I’m presenting at the SQL Server Innovators Guild on the subject of Very Large DataBases, but I’ve still got a few hours of work ahead of me.  If you’re in the [...]

November 1, 2011 · stuart · No Comments
Posted in: Conferences, SQL

Stuff in the FROM clause: Virtual Structures

Continuing with my SQL Server basics series, I’m focusing this post on Stuff in the FROM clause: Virtual Structures.  My last post talked about the only Base structure in a relational database, but I’m now moving on to a slightly more complicated concept.  Virtual structures are database objects that don’t hold data in a tabular [...]

October 31, 2011 · stuart · No Comments
Posted in: Something New, SQL, SQLServerPedia Syndication

Stuff in the FROM clause: Base Structures

A few months ago, our user group started thinking about how we could get new members to start coming to our SQL Server user group meetings; we defined new user as one of two categories: 1: new to databases, or 2. new to SQL Server In both cases, we realized that we needed to start [...]

October 17, 2011 · stuart · No Comments
Posted in: Code, SQL, SQLServerPedia Syndication