Archive for the ‘Code’ Category

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

#TSQL2sDay: Resolutions

For this month’s T-SQL Tuesday, Jen McCown asks: So tell us: what techie resolutions have you been pondering, and why?  Are you heading for a certification? An award? Are you looking to pick up CLR because that guy at the Summit said it’s “bitchin’”? Go crazy… I’ve already covered a lot of my techie resolutions [...]

January 11, 2011 · stuart · No Comments
Posted in: SQLServerPedia Syndication, The Social Web, TSQL2sDay

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

The 12th day of SQL

My Christmas tree is like this post; short, easy to assemble, and a little tacky. So, at the first FreeCon, a bunch of writers gathered together and talked about stuff. Most of the stuff we talked about was how to be a better technical writer, as well as how to blend our writing skills with [...]

December 24, 2010 · stuart · 2 Comments
Posted in: Blogging is FUN!, SQL, SQLServerPedia Syndication

How many licks DOES it take…?

So, it’s been a while since I’ve posted, but I’ve finally managed to eke out some time after Summit 2010, and wanted to follow up on a conversation that Tim Mitchell, Arnie Rowland, and I had at the Friends of Red Gate dinner.  We were doing a SQL Server oriented trivia contest which asked the [...]

November 23, 2010 · stuart · 2 Comments
Posted in: SQL, SQLServerPedia Syndication

#TSQL2sDay – My Least Favorite SQL Server Myth

  It’s time again for another T-SQL Tuesday, hosted this month by Sankar Reddy; the topic is misconceptions in SQL Server.  It’s been a while since I wrote one of these (I usually forget about them until the following Wednesday), but this topic is a good one.  I’ve had many discussions with people about the [...]

October 12, 2010 · stuart · No Comments
Posted in: SQLServerPedia Syndication, TSQL2sDay

Querying XML in SQL Server 2005+: namespaces

I recently helped a friend solve an XML problem, and thought I would post the solution here.  Although there are lots of notes on how to use XQuery in SQL Server 2005+, this was a real world scenario that was trickier than I expected.  The friend works for an insurance company broker, and in one [...]

September 1, 2010 · stuart · 2 Comments
Posted in: SQL, SQLServerPedia Syndication, XML

T-SQL tip: Use a role for EXECUTE permissions

If you are in a high-security environment, this may not be the best tip for you, but if you’re in a situation like mine where you have a SQL user that is connecting to a database in order to EXECUTE stored procs, and you know that user needs to be able to EXECUTE every proc [...]

July 23, 2010 · stuart · 4 Comments
Posted in: SQL, SQLServerPedia Syndication

Speaking at Atlanta.MDF on Monday, June 14

Quick  note:  I’ll be presenting my thoughts on XML and relational design at next week’s meeting of AtlantaMDF.  If you’re in the area, please come join us for free pizza and education. http://atlantamdf.com You Got XML In My Database? What’s Up With That?

June 9, 2010 · stuart · No Comments
Posted in: SQL, SQLServerPedia Syndication, User Groups, XML

Speaking today: PASS AppDev Virtual Chapter

I know it’s short notice, but to be honest, I totally forgot about this until a couple of weeks ago.  I’ll be presenting today at noon eastern on a LiveMeeting for the Application Developers Virtual Chapter of PASS.  Deets below: “You Got XML In My Database? What’s Up With That?” May 11th 12:00 PM EDT (GMT [...]

May 11, 2010 · stuart · No Comments
Posted in: PASS, SQL, SQL Server, SQLServerPedia Syndication, XML