Archives for February 2011

Come Aboard. We’re Expecting You

Those of us over a certain age (read - old as dirt) can remember the theme songs to certain TV shows better than we can the National Anthem. Try these lines out and see if you don't immediately remember the tune that goes along with them: Come and knock on our door | We've been waiting for you ... Makin' your way in the world today | Takes everything you've got ... Just some good ol' boys | Never meaning no harm ... Thank you for being a friend | Travel down the road and back again ... So when I got the news that my employer, Quest Software, wanted to send one of the team to an … [Read more...]

Wednesday Quest: On-Line Demos for Toad Data Analyst and Benchmark Factory

If you've attended any of my public sessions about SQL Server technology, then you might remember that I extend a standing offer to provide a free, long-term license to any of several products from Quest Software, such as Toad for SQL Server (including the SQL Optimizer), Toad Data Analyst, Toad Data Modeler, and the awesome performance and scalability testing tool Benchmark Factory. If you've ever wondered about these tools and why I tout them, why don't you take a couple minutes to look at the on-line demos available at each of the preceding links?  If you like what you see, drop me a … [Read more...]

Totally Awesome and Totally Free Training SQL Server Training

One of the things that I enjoy about working for Quest Software is that we give back copiously to the community.  From activities and offerings like SQLServerPedia, to our free posters mailed anywhere in North America (and don't forget the free hi-res PDFs for the rest of the world), Don't forget that free DVDs of our virtual conferences featuring me, along with Buck Woody (blog | twitter) and Brent Ozar (blog | twitter) will be mailed anywhere in North America free of charge, now available at this link. Enjoy! -Kevin Twitter at kekline More content at http://KevinEKline.com … [Read more...]

Adventures in the Land of CloudDB/NoSQL/NoAcid

Last year, some of my friends from Quest Software attended Hadoop World in New York. In 2009, I never would've guessed that Quest would be there with products, community initiatives, as a major sponsor and with presenters? There were just under 1,000 attendees who weren’t the typical devheads and geekasaurs you'd normally see at very techie events like Code Camps, SQL Saturdays, Cloud Camps and or even other NoSQL events such as the Cassandra Summit. We're talkin' enterprise customers with active Hadoop projects underway. Some observations from the show that may be of interest to … [Read more...]

Database Maintenance Scripting Done Right

I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008.  Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's on SQL Server v6.5 or some such.  But I digress... Anyway, I pointed out a couple useful sites where you could get some good scripts that would take care of preventative maintenance on your SQL Server, such as index defragmentation, updating statistics, and so forth.  One of the script kits came directly from Microsoft's internal … [Read more...]

Have You Heard About Project Lucy?

Quest Software's latest community initiative, Windows Azure-based Project Lucy, has debuted! Project Lucy is part infrastructure analytics, part social media experiment, and part performance data warehouse. The best things about Project Lucy include: It’s Free - just like our SQLServerPedia website, Project Lucy is free to anyone who wants to upload a trace file It’s 1oo% web-based - you don’t have to download or maintain anything and updates roll out seamlessly, all the time It really helps - just generate a SQL Trace on a SQL Server 2000, 2005 or 2008 instance, upload it on … [Read more...]

What’s Up With Discovery Wizard for SQL Server?

First, the Good News I really like the free SQL Server utility from Quest Software, nicknamed "Disco", that enables you to discover and inventory all versions and editions of Microsoft SQL Server from the mid-1990's onward.  You can see what it does at http://questkb.com/category/sqlserver/discovery-wizard/. I've had a lot of customers who have faced the challenge of bringing an unwieldy and chaotically growing SQL Server infrastructure  to heel.  It can be really daunting in a big enterprise trying to find all of the SQL Servers tucked behind third-party applications, Microsoft … [Read more...]

Yummy Carbs, Evil Carbs

 I've felt rather blessed in terms of not struggling too much with my weight. On the other hand, I want to hit a new level of physical fitness and so, as a consequence, I've decided to cut back on the carbs.It's been two weeks now and, with a few minor lapses, I'm getting used to eating low carb. What's really amazing about low carb is how quickly the weight melts away. I'll allow myself the equivalent of four slices of bread (40g), in case I want a couple sandwiches for lunch, in a single day. But most days I actually consume a lot less carbs than that. The only hard part has been … [Read more...]

I’m So Happy With You, Daddy

 This is the sort of look I get whenever I ask Katie for a hug or kiss. I hope it gets better when she's a teenager or else I'm done for! … [Read more...]

Sometimes They Argue. And Sometimes …

 ...they don't. Yeah, it's like that pretty much all the time. Overall, it's a really positive and really cute relationship. … [Read more...]