THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Katmai   (RSS)
Showing page 2 of 5 (47 total posts)
  • Call For Action: Spatial "geeks," please speak up!

    I've had a lot of ''fun'' working the with new spatial types in SQL Server 2008. Fun like your first root canal sometimes, fun like a great first date other times. One of the ''root canal moments'' for me has been around Geographic Markup Language (GML) support. I had spent a good chunk of time generating GML for use in class to subsequently ...
    Posted to Enjoy Another Sandwich -- Kent Tegels (Weblog) by ktegels on July 8, 2008
  • It's Q3 - where is SQL Server 2008?

    Microsoft has publicly stated that SQL Server 2008 will RTM in Q3.  It is Quarter 3 now.  Where is it?  :-) I'm sure that the final touches will now get taken care of now that Bill Gates is no longer a full-time MSFT employee.  I'm sure that his ''short-timer'' attitude trickled down to the develpers working on the product and ...
    Posted to Rick Heiges (Weblog) by RickHeiges on July 3, 2008
  • Are You Ready for SQL Server 2005? Use Upgrade Advisor for 2008!

    If you have systems that are still on SQL Server 2000 and that you are preparing for SQL Server 2005, run the Upgrade Avisor for SQL Server 2008 as well.  So, while you are under the hood of your database and app getting it ready for 2005, get it ready for 2008 too.  There are a lot of new features in 2008, but nothing that was taken ...
    Posted to Rick Heiges (Weblog) by RickHeiges on June 11, 2008
  • Upcoming talks on SQL Spatial and SSIS

    Yesterday I drove down from Sioux Falls to Omaha so that I could catch a talk being given by Sudhir Gajre to the Omaha SQL Server/BI Interest Group. I first got to know Sudhir when he, I and Luke Schollmeyer were restarting a SQL Server Users Group in Omaha. Sudhir is a stud at SQL Server performance tuning and helped write one of the best papers ...
    Posted to Enjoy Another Sandwich -- Kent Tegels (Weblog) by ktegels on June 5, 2008
  • The thing I hate about missing TechEd is getting the eye candy late

    But this eye candy is worth waiting for.  What I am talking about? I have spend that last weeks nose down in the Spatial bits for SQL Server 2008. I really believe this is the darkhorse super feature of the product. But a big problem with it has been visualizing the results. Unless you good at mentally visualing spatial relationships, it can ...
    Posted to Enjoy Another Sandwich -- Kent Tegels (Weblog) by ktegels on June 5, 2008
  • SQL Server has a new logo

    SQL Server's new logo has been published:   Courtesy of Wesley.  And I have taken a screen shot of the new splash screen for Management Studio:  
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on June 3, 2008
  • Some things don't change - Partitioning

    After spending the past couple of weeks at the MVP Summit in Seattle and at SQL Connections in Orlando, I thought I should blog about things that do not change in 2008 (at least partially). One of the reason s to partition your tables is to make it more managable.  Although there has been some enhancements in the manner that partitions are ...
    Posted to Rick Heiges (Weblog) by RickHeiges on April 27, 2008
  • SQL Server 2008 is getting close... I can smell it!

    No, this is not a ''funny funny, ha ha!'' April Fool's Day post (though I do find those entertaining, and considered posting one myself).  This is for real, and it almost made me tingle a little.  I saw this comment from Eric Kang in a Connect item yesterday morning:''This is a known issue that we have addressed in a release candidate ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 1, 2008
  • Filtered Indexes

    In SQL Server 2008, you can have what is called a ''Filtered Index''.  What does this mean?  An index may be created for a subset of rows in your table.  For instance you could create a filtered index for a ''state'' column if the value is ''CA'' for California; the rest of the states would not have a value.  When you create ...
    Posted to Rick Heiges (Weblog) by RickHeiges on March 18, 2008
  • Increased limits for columns / indexes / statistics

    I am still on the fence about whether this is a good thing or a bad thing.  However, in the next build of SQL Server 2008 you will be able to get your hands on, you will find that some element limits have changed, just a bit.  With the introduction of sparse columns, you can now jam 30,000 columns into a table.  No, that is not a ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 11, 2008
Privacy Statement