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





