About Jeremiah

I'm a senior database administrator with Cass Information Systems, a SQL Server MVP, director-at-large with PASS, and I also help out with my local chapter and the Application Development virtual chapter.

You can learn more about me or contact me directly.


Google Reader
Google Profile
delicious

Links for the Week

SQL Server
GUID Ordering in SQL Server – Look, I know what I’ve said about GUIDs. Nobody wants them around, except developers. The point is that sometimes GUIDs are a necessity. We all might as well learn how to deal with them. Martin Bell does a great job of talking about the various ways of generating [...]

May 29th, 2009 | Tags: , , | Category: Code, SQL, SQL Server, nonsense | 2 comments

One quarter ago?

Lady GaGa has nothing on my ability to do zany math with SQL [...]

May 27th, 2009 | Tags: , , , , | Category: Code, SQL, SQL Server, syndication | Leave a comment

Links for the Week 2009.05.22

Big pile o’ link love this week. Honestly, I didn’t include a ton of GREAT links from Brent Ozar because people would start to think that Brent Ozar pays me to link to his site and say Brent Ozar a lot. He doesn’t, but if you click on the links to Brent Ozar maybe he’ll [...]

May 22nd, 2009 | Tags: , , , , , | Category: Code, Design, Information Architecture, SQL, SQL Server, nonsense, sqlpass | 2 comments

Copying Data Should Be Easy

Typically, moving data isn’t that big of a deal. You can either fire up SSMS and write a quick script to copy data from one server to another. Or, if you need to move data from production into development, you can just do a back up and restore.
“Typically” is the key word in the previous [...]

May 20th, 2009 | Tags: , , , , | Category: SQL, SQL Server, syndication | Leave a comment

RAISERROR and BIGINT

Thanks to Ted Krueger (onpnt if you’re on twitter or use lessthandot.com), I now know how to display a BIGINT in RAISERROR. You just used %I64d. It’s documented in BOL as a sidebar note, but you still have to wade through the RAISERROR documentation.
So, our code would look like this:

DECLARE @i AS BIGINT;
SET @i = [...]

May 15th, 2009 | Tags: , | Category: SQL, SQL Server, syndication | Leave a comment
 
  Older Entries »