Reed Me

Development schtuff, SQL Server & other random geekness. Now with more [fill in the blank]!

Browse by Tags

Tagged Content List
  • Blog Post: Yes, I hate April Fools’ Day.

    I don’t hate April Fools’ Day on principle. (Yes, I do.) I just hate it because you can never tell whether the unexpected is a prank, or something more serious. Also, some people don’t seem to know where the line is between prank and something more serious. $149 Prank: Not a prank: Today just doesn’t...
  • Blog Post: 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 principal. Awesome for HA, but not so good for...
  • Blog Post: It’s been real and it’s been fun...

    I’ve really enjoyed my ~3.5 years here at Microsoft, especially the last year and a quarter inside SQL Server. Microsoft’s a great company that really takes good care of its employees and their families. It’s with some sadness that I leave all my friends in Building 35 next week (and some of y’all over...
  • Blog Post: Awww, aren’t they just so cute?!

    Look at all of them fixin’ to jump in the pool! Heh. Not to minimize the difficulty that they’re embarking on, what with a 20% pass rate and all, but it’s great to see more people diving into the deep end of the SQL Server pool. Let’s hope as many Certified Masters as possible emerge from the other end...
  • Blog Post: If you absolutely must call a WCF service from inside your database, here’s how you do it...

    When I was an operations DBA, this would probably fall into the category of “just because you can do something, doesn’t mean that you should”: Call a WCF Service from SQLCLR (by Niels Berglund) However, there are probably a couple of good scenarios where I might advocate for doing just this in future...
  • Blog Post: Updated Books Online (January 2009)

    I’m a couple days behind in, well, everything, not just my inbox. What can I say? It finally warmed up enough to get back on the motorcycle... Updated BOL for January 2009 are out there now! MSDN Download Center (MSI) Get yours while supplies last. Heh.
  • Blog Post: Samples forum consolidation.

    Until today, all of the various SQL Server community and samples projects each had their own discussion board on CodePlex. In the interests of simplification that our customers have asked for in our samples experience, we’re consolidating all of those disparate discussion locations to one MSDN forum...
  • Blog Post: 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 to their platform. Sort of like a cherry-cheese...
  • Blog Post: 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 and was tweeting on the subject. One thing led...
  • Blog Post: DTLoggedExec updated for the new year (and more).

    Davide describes it best in his own words: What is DTLoggedExec? If I were a full-time ETL developer or an operations DBA, this is definitely a tool I’d be using every day. Grab yours today from CodePlex: http://www.codeplex.com/DTLoggedExec/
  • Blog Post: Now with more open and soon with more source!

    Over the holidays, the SQL Server community & samples test team in China has been migrating all of our open product samples bugs out of our internal VSTS bug tracking database and into the VSTS database which backs the CodePlex TFS system. There are some non-bug work items which will be migrated...
  • Blog Post: 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 with your data. Do you have a plan for data governance...
  • Blog Post: AdventureWorks2010, anyone?

    We’re doing planning work for SQL Server Kilimanjaro and the next SQL Server wave that follows it, which means product samples, community projects and AdventureWorks. Some people have suggested doing away with AdventureWorks in favor of something new, but I don’t see that happening... unless there is...
  • Blog Post: Get your beta on! SQL Server 2005 SP3 Beta

    No new features. Lots of good fixes rolled up in one package. Download details: SQL Server 2005 SP3 Beta We don’t call them “service packs” inside SQL Server anymore, but it would seem that a lot of people have a Linus’ blanket reaction to the term, so we’ll call it SP3 to make everyone happy. Enjoy...
  • Blog Post: 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 Refresh 1): Fewer selections to make to choose...
  • Blog Post: SQL Server Samples in the News and Print

    The humorous old adage (which my friends in PR righteously deplore) is that "There's no such thing as bad press, as long as they spell your name right." SQL Server 2008: First Impressions Desperately Seeking Samples SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach (Recipes...
  • Blog Post: Testing the SQL Database

    Being a big fan of test-driven development of any kind, database or otherwise, I was honored to sit on a panel with some other much smarter people than I at TechEd*2008 entitled "Testing the SQL Database." Not only did I get to opine a bit, but I also got to learn some, too, which happens whenever you...
  • Blog Post: The Next Big Gaming Platform: SQL Server?!

    I realize that I'm normally off-topic, so it's weird for me to actually be blogging about SQL Server on my vacation... Figures.     I've blogged before about the Real Reason™ that most guys my age (at least in the USA) got into software development: video games. Back in my day, they wasen't even much...
  • Blog Post: SQL Server 2008 RTM samples are up on CodePlex now.

    A little snafu delayed things, but they're all signed, sealed and delivered now. I only had to skip a little of the launch party to get them out the door... Microsoft SQL Server Community & Samples - Release: SQL Server 2008 RTM Enjoy!
  • Blog Post: I was right: I was wrong. 15% was too much.

    One of the shiny new features added to Management Studio for 2008 allows you to plot spatial data for any table that has geography or geometry data in the new spatial types. This comes in pretty handy for doing quick visual inspection of small spatial data sets... and it turns out that my early suspicion...
  • Blog Post: Watching the watchers watch with SQL Server

    This popped up earlier this year, and I thought it was cool enough to put in the blog backlog. How Microsoft IT Uses SQL Server 2005 to Power a Global Forensic Data Security Tool (TechNet) Technical White Paper | IT Pro Webcast | TechNet Radio I'm always intrigued with forensic applications. Maybe it...
  • Blog Post: 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 once in a while is important. For the record, the...
  • Blog Post: In case you were looking for the SQL Server 2005 Metadata Toolkit...

    This cool toolkit went AWOL from the Download Center some time ago and has been hiding on Skydrive for a while now, but it seemed to me that it deserves a better home than that... So I created a resource page for it in the MSDN Code Gallery. SQL Server Metadata Toolkit - Home The current release for...
  • Blog Post: SQL Server 2008 RC0 Samples are up!

    I'm still recovering from three weeks OOF, but my teammates in Redmond and Beijing have done a great job getting the next preview of SQL Server 2008 samples ready for you. The main CodePlex portal for SQL Server Samples has links to all the individual projects. But if you want to just grab the whole...
  • Blog Post: 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 of the points that the so-called "experts"...
Page 1 of 3 (53 items) 123