Archive for the ‘SQL Server’ Category

#sqlsat35 looking ahead to the weekend

This weekend I’ll be traveling to the DFW metropolitan area to attend SQLSaturday #35; I’m very excited about it.Ā  I didn’t know if I’d be able to attend this weekend (had to trade kid time with the ex-wife), so I missed the call for speakers.Ā  I am looking forward to actually attending sessions and bumping [...]

May 21, 2010 Ā· stuart Ā· No Comments
Posted in: Blogging is FUN!, Conferences, PASS, SQL Server, SQLServerPedia Syndication, The Social Web

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

YAY! Somebody likes me…

I just got the email today; Red Gate friended me.  Or, rather, I am now a Friend of Red Gate.  What does this mean?  I try to think of it kind of like a NASCAR patch; I now have a perpetual sponsor for all of my various presentations in the SQL community.   I donā€™t know [...]

October 14, 2009 Ā· stuart Ā· One Comment
Posted in: SQL Server

Building ranges using numbers

A while back, I posted a solution to a problem I was facing where I needed to generate a table of ranges.  While I havenā€™t experienced any sort of issues with the solution, a couple of things have recently occurred which has caused me to go back and take a look at the problem, and [...]

September 27, 2009 Ā· stuart Ā· No Comments
Posted in: SQL, SQL Server, SQLServerPedia Syndication

FizzBuzz

Stumbled across Mike Hillwigā€™s post in response to a question posed by Brent Ozar.  Depending on how literally you want to use the word ā€œprintā€ (do you mean the actual command, or do you just want output?), I think I have a slightly more elegant solution than what Mike proposed. SELECT CASE WHEN n%3=0 AND [...]

September 27, 2009 Ā· stuart Ā· No Comments
Posted in: SQL, SQL Server, SQLServerPedia Syndication

Coming to PASS Summit 2009: Twitter BINGO!

So, last year at PASS Summit, I had my first real experience with a heavily-twittered event.  What was interesting was that I met a lot of people in real-life that I had just recently begun following on Twitter; I had made the comment (in passing) to someone that we should have had BINGO cards to [...]

September 25, 2009 Ā· stuart Ā· 23 Comments
Posted in: Conferences, SQL Server, SQLServerPedia Syndication, The Social Web

Another tale of the unwilling DBA – tempdb and the LUN

As many of you know, Iā€™m a database DEVELOPER; Iā€™ve been a DBA in the past, but my real specialty lies in getting different database platforms to exchange information with SQL Server.  I havenā€™t done a lot of hands-on administration (backups, maintenance plans, etc) in a while, but thatā€™s changed recently.  Our primary production DBA [...]

September 11, 2009 Ā· stuart Ā· No Comments
Posted in: SQL Server, SQLServerPedia Syndication

Wrapup: Columbus, GA SQL Server User Group, August 25, 2009

Tuesday, I drove to Columbus,GA to speak at the Columbus GA SQL Server User Group; I had first met Ken Simmons at the Birmingham SQL Saturday, and had promised him that I would drive down there to present.  Kenā€™s done a great job of organizing a PASS chapter in a small-town setting; Columbus doesnā€™t have [...]

August 29, 2009 Ā· stuart Ā· No Comments
Posted in: Conferences, SQL Server, SQLServerPedia Syndication, User Groups

Columbus, GA SQL Server Users Group – August 25th

Just confirmed today with Ken Simmons that Iā€™ll be presenting at the Columbus GA SQL Server Users Group on August 25th at 6 pm at the Columbus Public library; if youā€™re in mid-west Georgia (and a data geek), come join us, and stop by and say ā€œhi!ā€ Iā€™ll be re-hashing a talk I gave at [...]

August 2, 2009 Ā· stuart Ā· No Comments
Posted in: SQL Server, SQLServerPedia Syndication, User Groups

Fun with NEWSEQUENTIALID()

Weā€™re thinking about converting the constrain on an existing column in a table with billions of rows of data.  The column is a uniqueidentifier serving as a nonclustered primary key; weā€™re planning on replacing the NEWID() constraint to a NEWSEQUENTIALID().  What is challenging me is my concern over primary key collisions; will the new default [...]

July 31, 2009 Ā· stuart Ā· One Comment
Posted in: SQL, SQL Server, SQLServerPedia Syndication