http://scarydba.wordpress.com Intimidating databases and developers Fri, 26 Jun 2009 12:49:38 +0000 http://backend.userland.com/rss092 en I keep thinking I've got a handle on the way execution plans are dealt with in SQL Server. I had a pretty simplistic view of things, there's the estimated plan which comes out of the optimizer and there's the actual plan which comes out of the data engine. The one ... http://scarydba.wordpress.com/2009/06/26/re-evaluating-execution-plans-again/ I wrote up an article on how we're configuring & deploying databases to disparate systems using a combination of database projects, server projects and compound projects in conjunction with configurations that has been published over at SQL Server Central. Please click over & read it. http://scarydba.wordpress.com/2009/06/24/visual-studio-team-system-article/ PASS just published a new Top 10 list of mine over at the their web site. This one is the Top 10 Articles on the web if you're trying to learn about spatial data. I'm not trying to say that I know what I'm doing with spatial data. I'm still feeling my ... http://scarydba.wordpress.com/2009/06/23/learning-spatial-data-in-sql-server-2008/ I never used to read editorials. Not in emails, magazines, newspapers, whatever. Now, I make it a point of always reading them. You can learn as much from an editorial as you can from the technical articles within, sometimes more. Tony Davis has just posted a guest-editorial over at SQL ... http://scarydba.wordpress.com/2009/06/17/object-database-editorial/ And if you think keeping this below 250 words was easy... You try it. I've received a lot from the PASS conference. I've attended technical sessions that blew my socks off and made me twitch in my seat, fighting the urge to start writing TSQL code, immediately. I don't think any of that is the ... http://scarydba.wordpress.com/2009/06/17/the-best-thing-i-learned-at-pass/ Allen White, who introduced me to the wonders of PowerShell at last year's PASS Summit, has published a white paper on using PowerShell within SQL Server 2008 with Microsoft. This is great news. If you're, as Brent Ozar so nicely put it, a noob like me in working with Powershell, ... http://scarydba.wordpress.com/2009/06/14/powershell-white-paper/ I keep thinking I've got a handle on spatial data and I keep finding out I'm wrong. I rewrote the cursor that my co-worker used into a query that joined the list of test criteria onto our list of locations. I used an OUTER APPLY to more or less run ... http://scarydba.wordpress.com/2009/06/11/more-spatial-headaches/ The Pre/Post Conference Sessions and the Spotlight Sessions for the PASS Summit 2009 have been announced. Go check it out. This is going to be a fantastic conference this year based on the topics and the people presenting (and I'm still humbled to be included with that group). I wasn't aware that ... http://scarydba.wordpress.com/2009/06/10/pass-summit-session-preview/ I was feeling quite confident about my new-found abilities with spatial indexes so I did a presentation for my team, to share what I had learned. I had also been sharing with one co-worker as I developed the knowledge of spatial indexes. While I was preparing my presentation, he was ... http://scarydba.wordpress.com/2009/06/09/spatial-indexes-and-a-lack-of-data/ Joe Sack has started a new team blog for the Microsoft SQL Server Premier Field Engineers. If you don't know who they are, you should. The first post is just introductory, but this blog is likely to become a great resource. These are the guys that MS zip lines into ... http://scarydba.wordpress.com/2009/06/08/microsoft-sql-server-premier-field-engineers/