Browse by Tags

Log Shipping + Database Snapshots == Bummer, dude!!
So, like most funny stories (involving me), this one starts with “Yesterday, I had this bright idea...” and goes downhill from there. Database mirroring is great. Full stop. But there’s this one little catch: it can only have a single mirror copy of the Read More...
Sybase loves AdventureWorks2008?
A SQL Ranger friend of mine in the UK gave me the heads up to this yesterday. (Thanks, Ben!!) Apparently, back in December 2008, Sybase ported some of our samples to SQL Anywhere. Needless to say, I’ve got mixed feelings about Sybase porting AdventureWorks Read More...
Tweeting AdventureWorks?
Earlier this week, the gravitational pull of Twitter got the better of me. Jimmy May emailed me that Paul Nielsen was trying to sort out the gender of the fictitious IT Manager of AdventureWorks (Jean Trenary) for the next edition of the SQL Server Bible Read More...
Who are you and what do you want with my data?
If you’ve got data, there are probably people who want to use it, analyze it, do things with it... that you never imagined and possibly don’t want them to. “Those people” might even be government agents. Who can put you in jail. If you’re not careful Read More...
Simplifying AdventureWorks setup
FYI, we’re actively working on improving the setup experience for the SQL Server 2008 sample databases (aka AdventureWorks). We’ve heard your feedback and we’re acting on it. Here are some of the salient points you’ll see for the Halloween update (Samples Read More...
Thank you, Captain Obvious.
Actually, my oldest son is the original Captain Obvious in my life, but Michael Campbell does a good impression of him in Performance Secrets for SQL Server Developers (sqlmag.com) . Heh. Not that it's a bad thing. Being reminded of the obvious every Read More...
Contrary to the FUD, The Relational Database™ is far from dead...
I've gotten questions over the past month or two from folks (mostly DBAs and trainers) who have attended FUD dissemination events where various "experts" have declared The Relational Database™ to be dead. Ha! I've had a good laugh at most Read More...
Breaking News! AdventureWorks abandoned for Katmai in favor of Northwind, pubs and...
In a striking change of direction, I'm happy to announce that AdventureWorks is being deprecated and abandoned for SQL Server 2008 samples in favor of long-time favorite databases of simple-minded data modelers: Northwind and pubs. Also, I can gleefully Read More...
How do I use Feature X in SQL Server?
Buck's got a great point about how SQL Server's development themes are managed from the top down: It isn't a matter of thinking up single features or changes to the product, it's a cohesive direction we all want to go. Carpe Datum : Why on earth are you Read More...
Hi, Mom! (And everybody else.)
"So, what do you do?" It's a common enough question, right? Usually immediately subsequent to "Where do you work?" People ask it to break the ice. They ask it because they're interested. They ask it because they can't believe somebody Read More...
FILESTREAM, Windows Vista and you.
I won't complain about yet-another-configuration-stored-procedure, since I hold out hope that managing FILESTREAM's status at the server level will be rolled into sp_configure or DDL before RTM... but this is me not holding my breath. *sigh* Anyway, if Read More...
SQL Server gurus! Get connected to CodePlex.
First off, CodePlex is looking for developers. That seems like the best way to get plugged in. Heh. I have a vested interest in seeing you top-notch coders working on CodePlex. I know several great coders out there; you know who you are, so apply! More Read More...
More upcoming webcasts
If you're intrigued by data mining or wonder how your SQL Server certifications will be affected, these are for you: TechNet Webcast: Mastering Time Series Prediction with SQL Server 2008 Data Mining (Level 300) , Thursday, Jan. 24, 8 a.m. - 9 a.m. Pacific Read More...
Upcoming SQL webcasts and virtual events (January 2008)
Some random virtual things that you might care about (I do): Get Ready for SQL Server 2008 Virtual Event (sponsored by SQL PASS et al) Thursday, Jan. 24, 11 a.m. - 4:15 p.m. Eastern Time MSDN Webcast: Optimizing Online, Enabling Offline with SQL Server Read More...
Belated happy annibirthary, SQL Server.
I always seem to miss birthdays and anniversaries. *sigh* Not sure whether to call this one a birthday or an anniversary. Maybe the anniversary of prenatal announcement? Or was this back when nobody announced a product until it was done. (Did that ever Read More...
More Posts Next page »

Search

This Blog

Syndication

Page view tracker