THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SQL Server 2008   (RSS)
Showing page 5 of 24 (232 total posts)
  • Is SQL Server 2008 R2 a full release of SQL Server?

    This has come up in conversations more than once in the past little while - recently on twitter I made the casual comment that later this year, SQL Server 2008 will be ''two versions old.''  Well, not everyone agrees that that is technically true.  So, I thought I'd put something out there that isn't limited to 140 characters.  ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 9, 2011
  • Downgrading a database : "You can't get there from here!"

    I see this question a lot: ''I have a SQL Server 2008 R2 database.  Can I attach it to a SQL Server 2008 SP2 instance?'' Part of this stems from the confusion over exactly what 2008 R2 is in the first place.  It is not a service pack to SQL Server 2008; it is its own, full-fledged version.  A lot of people don't fully realize this ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 21, 2011
  • Uninstalling Reporting Server 2008 on Windows Server 2008

    Ha. I had quite disputable pleasure of installing and reinstalling and reinstalling and reinstalling – I think about 5 times before it worked – Reporting Server 2008 on Windows Server with the same year number in name. During my struggle I came across an error which seems to be not quite unfamiliar to some more unfortunate developers and admins ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on December 22, 2010
  • Speaking at SQL Saturday 61 in Washington DC

    The organizers of SQL Saturday #61 in DC (actually Reston, VA) created an Advanced DBA/Dev track for their event, which I think is cool. Both of the presentations I'll be doing there on Saturday are in that track. (In fact, they're the first two sessions of the day.) The first, Automate Policy-Based Management using PowerShell will walk through ...
    Posted to Allen White (Weblog) by AllenMWhite on December 2, 2010
  • Cumulative Updates for SQL Server 2008 are available

    On Monday, the SQL Server Release Services team released cumulative updates for both SQL Server 2008 SP1 and SQL Server 2008 SP2.  The cumulative update for SP2 restores the fixes that were potentially undone by applying SP2 (or the SP2 CTP) after applying CU9 or CU10 to SP1.  Confusing, yes, but at least it's straightened out now.  ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 18, 2010
  • Now we're getting somewhere : the MSXML6 issue

    Last February / March, I wrote several posts about an issue with MSXML6 on Windows XP which prevented the installation of SQL Server 2005, SQL Server 2008, and even service packs or cumulative updates in some cases:2009-02-20 : The XP SP3 / MSXML6 SP2 / SQL Server debacle 2009-03-16 : More info / good news : installing SQL Server on XP SP3 with ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 5, 2010
  • This time it's for real - SQL Server 2008 Service Pack 2 is available!

    I'm not going to blab about the speculation, or how Microsoft seems to like making their promised deadlines by the skin of their teeth.  I'm too busy preparing how we're going to deploy and test SP2 on all of our SQL Server 2008 instances.  So without any delay, here are the downloads / fix information:Download Details: Microsoft SQL ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 29, 2010
  • Discover Facets and Properties in PowerShell

    When you're trying to set up scripts to deploy policies to your servers (because you ALWAYS automate with PowerShell, right?), it can be sometimes difficult to determine exactly what facets are there, and when you do know the facet name, what properties are available to you. First, in a native PowerShell window you'll need to load the assemblies ...
    Posted to Allen White (Weblog) by AllenMWhite on September 27, 2010
  • A SQL Server 2008 update is available - but it's not SP2

    Last night Microsoft released Service Pack 1 Cumulative Update #10:KB #2279604 : Cumulative update package 10 for SQL Server 2008 Service Pack 1 The build number is 10.00.2799 and there seem to be some interesting fixes included if you browse through them.  But at least on first glance and at the gut level, I'm less interested in the fixes, ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 22, 2010
  • SQL Server 2008 R2 Best Practices Analyzer

    Maybe I'm a little late to the party, but I thought I would share with you the most recent release of Microsoft's Best Practices Analyzer for SQL Server 2008 R2 (you can also read the original blog announcement from CSS). Let me be clear: this tool is not just for people who are already on SQL Server 2008 R2.  It will also happily analyze ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 25, 2010
« First ... < Previous 3 4 5 6 7 Next > ... Last »
Privacy Statement