Archive for the ‘SQL’ Category

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

#TSQL2sDay 003: Maslow and relational design

Rob Farley is hosting the third installment of TSQL Tuesday, and it’s a fun one: relationships (in honor of Valentine’s Day).   While I’m not currently in much of a mood to opine on the virtues of love and databases, I did think I wanted to post something a bit more esoteric this time.  Not many [...]

February 9, 2010 · stuart · 2 Comments
Posted in: SQLServerPedia Syndication, TSQL2sDay

#TSQL2sDay 001: Date/Time Issues and Data Modeling

This is my first post for T-SQL Tuesday (thanks, Adam, for the idea!); I’m hoping this will be a continuing block party, and hopefully connect a lot of us SQL bloggers together.  There’s a lot of great content out there, and sometimes it’s just tough to find. Just a few notes before I get started [...]

December 8, 2009 · stuart · One Comment
Posted in: TSQL2sDay

Good Habits To Adopt: Enforcing the natural primary key

I’ve been reading Aaron Bertrand’s great series of blog posts on bad habits to kick, and have been thinking to myself: what are some good habits that SQL Server developers should implement?    I spend most of my day griping about bad design from vendors, yet I hardly ever take the time to document what should [...]

October 22, 2009 · stuart · 3 Comments
Posted in: Good Habits, SQL, SQLServerPedia Syndication