Archive for the ‘Something New’ Category

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

Three Myths about Agile Development

I recently attended Microsoft Tech Ed in Atlanta, and while there wasn’t much new being announced about SQL Server (I had heard about many of the features for Denali at PASS Summit 2010), I did find myself drawn to several sessions regarding Agile principles and development.  My shop has been using the Scrum method for [...]

June 9, 2011 · stuart · No Comments
Posted in: Good Habits, Something New, SQLServerPedia Syndication

Something new for 2011: bunches of little stuff

OK, it’s the last day of March, and I’m phoning in this blog post.  It’s not that I haven’t spent a lot of time learning something new this month, it’s that I’ve got a pile of stuff to get through before leaving on vacation next week, and I really just don’t have more than 15 [...]

March 31, 2011 · stuart · 3 Comments
Posted in: Something New, SQLServerPedia Syndication

I’m doing it wrong…

At some point in your career, you have to realize that you’re going about it in the wrong way.   It may hit you like a ton of bricks, or it might be a subtle realization, but either way you realize that things aren’t working out for you like you expected.  I’ve had a couple of [...]

February 21, 2011 · stuart · 3 Comments
Posted in: Something New, SQLServerPedia Syndication, The Social Web

Something new for 2011: XML & XSD, part 2

I’m continuing my study of XML and XSD’s for January, and I realize that I ended my last post a bit abruptly.  I explained that I can cast an XML datatype to a SQL Server datatype, without giving a lot of background on WHY that’s important.   Understanding Types. Without going into too much detail about [...]

January 31, 2011 · stuart · No Comments
Posted in: Something New, SQLServerPedia Syndication, XML

Something new for 2011: XML and XSD

As part of my New Year’s resolution for 2011, I vowed to do a deep-dive on something technical every month; for January, I’m focusing on XML.  I’ve been using XML and XQuery in SQL Server for a while now (even presenting on it), but I still don’t consider myself an expert in the area.  For [...]

January 10, 2011 · stuart · 4 Comments
Posted in: Something New, SQLServerPedia Syndication, XML