Tag omgponies

Entries 24 Total

Upcoming PASS AppDev SIG Presentation

Mar 19, ’09 6:25 AM

On March 31st, at 1 PM EST, I will be giving a presentation via Windows LiveMeeting for the PASS AppDev SIG. I know the next question on your mind, it’s probably “When are you going to shut up?” “Jeremiah, pray tell, what is the topic of this delightful and amazing presentation?” Well, folks, when you tune in on March 31st you be treated to my presentation, which is titled: Dynamic SQL: What’s all the fuss about, anyway?

As soon as I have LiveMeeting info, I will post it here and make sure an announcement gets out to the public.

If you’re interested in becoming a part of the AppDev SIG get in touch with Todd Robinson, his contact info is on the SIG’s web page, and ask for more information.

Comments (1)

Links for the Week of 2009-03-13

Mar 13, ’09 12:17 PM

SQL Server

SQL Server and NULL Values, Revisited Aaron Alton takes a good look at NULL values and makes reference to post on the same topic. They both provide good information and well-founded opinions on NULLs and their place in the database.

Does a GUID make a good clustered key? This is a subject that is near and dear to my heart and if you’re ever within earshot of me, please don’t mention that you use GUIDs for your clustered indexes. This is a much more well thought out argument than mine usually are, and I will memorize it for the next time I hear that horrible phrase “I’m using a GUID as a clustered index…”

Development

Patterns And Practices Application Architecture Guide 2.0, Something Everyone Should Read The new Patterns and Practices architecture guide is out. Get it while it’s hot! This document covers architectural best practices to help minimize costs and maintenance.

MacRuby 0.4 Mac Ruby 0.4 has been released with a slew of new features. If you’re a ruby developer and you’re also a Mac user, this is definitely something you should look into. This is Ruby that runs along side the Cocoa/Objective-C framework, natively, on your Mac. Good times!

Stuff & Things

Drinking Games: Upgrade Conference Call Edition Ever spend too much time on a conference call during an upgrade? Brent Ozar provides a humorous take on these seemingly ubiquitous phone calls. Read this and laugh to yourself the next time you’re up at 3 in the morning with 5 or 6 other grumpy, tired, people.

New emoticons for the skull spring formal There is no explanation for this.

Sorry about the lack of links last week, I had a fever or flu or sinus infection or something, but it made it difficult to concentrate very well and do anything apart from complain about being sick.

Comments (0)

Links for the Week of 2009-02-25

Feb 26, ’09 7:34 AM

SQL Server

Index-Index-Index-Index-GOOSE! (Part One) The always short, and occasionally humorous, Tim Ford dives into the statistics DMVs and returns with a good explanation of what they are and how to use them.

Suggested DBA Work Plan If you’re like me, you’re not a production DBA, yet. I’m an accidental DBA who became a development DBA who is happily on his way to becoming a production DBA. Rod Colledge put together a great list of daily, weekly, and monthly tasks to help keep your database running smoothly.

SQL Server 2008 Proximity Search With The Geography Data Type This is just plain cool, thanks Denis!

Development

Visual Studio 2010 Videos Get started learning visual studio now! Denis Gobo was kind enough to round up some links to VS2010 training videos from the Microsoft folks. Looks like some great features are coming for people out there in development land.

Stuff & Things

Three Panel Soul – On Rabbits Three panels of a comic. This one is about sneaky, sneaky wabbits.

AMP Font Viewer Do you like fonts? I like fonts. We should hang out. Bad references to Idiocracy aside, AMP Font viewer is a free font manager for windows. If you, like me, have multiple gigabytes of TrueType and OpenType fonts, then this will be a great managing that mess of fonts.

This was just too cool to not share

Comments (0)

Links for 2009.02.12

Feb 13, ’09 9:31 AM

SQL Server

Update Statistics Before or After an Index Rebuild? Colin Stasiuk talks about when you should update stats in relation to rebuilding/reorganizing indexes. I’m not just linking to this because I was the catalyst for his blog post, but because there are some great things in here and I learned a lot from it.

Best Practices for installing SQL Server service packs, hotfixes, cumulative updates Beatrice Nicolini put together a great list of best practices for keeping your SQL Server installations up to date. Some of this just came intuitively, some of it I didn’t know until I read this.

Index Fragmentation Findings: Part 2, Size Matters Part two of Brent Ozar’s enlightening series on Index Fragmentation. Brent does a great job of explaining index fragmentation, what it means, and why it matters in ways that even the thickest developer turned DBA can understand.

Development

Build a Silverlight game, win $5,000 I don’t think this needs any more description – make a game, ???, win cash. Thanks to Brian H. Prince for bringing this to everyone’s attention!

Things you now know I tagged Rick Kierner in our latest goofy meme and he reciprocated by providing some great advice for developers/DBAs/whatevers on how to enhance their career. Working on a project with Rick really changed the way I looked at a lot of the things I do on a daily basis and I owe him more than he realizes.

General Stuff

How To Drag Your Butt Through That (Fill In The Blank) Book Aaron Alton gives some motivational hints on how to make it through that tedious [subject goes here] book that you’re currently struggling to get through. Now you can get fit AND get nerdy at the same time!

Found Emoticons of the First Two Decades of the 21st Century William Gibson came across this list of electrical plugs somewhere and flipped it around to make some crazy emoticons. My favorite quote from the text is “Sixth row, sixth square from right, is a very bad romantic feeling that nobody will experience until 2012.”

Classy Games (Part 2 of 2) For those of you not familiar with it, Something Awful is normally a humor web site that can best be described as “mildly not safe for work”. Normally I wouldn’t link to them (even though I’m pretty sure I have before). Every Friday they run a Photoshop contest. This week it’s a re-imagining of classic video game covers. There are some artistic gems in here.

Comments (1)

This site is protected with Urban Giraffe's plugin 'HTML Purified' and Edward Z. Yang's Powered by HTML Purifier. 401 items have been purified.