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 4 of 19 (184 total posts)
  • More information on the Patch Tuesday updates for SQL Server

    Last week, Microsoft released a series of patches for all supported versions of SQL Server (from SQL Server 2005 SP3 all the way to SQL Server 2008 R2). The reason for the patch against SQL Server installations is largely a client-side issue with the XML viewer application, and for SQL Server specifically, the exploit is limited to potential ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on June 19, 2011
  • Security updates for all supported versions of SQL Server

    It's patch Tuesday! [UPDATE June 19 : Please see my follow-up post about this security update.]  Today Microsoft released a security bulletin covering several issues that could potentially affect SQL Server; these exploits include remote code execution, denial of service, information disclosure and elevation of privilege. You should test ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on June 14, 2011
  • Endpoints Need Privileges Too

    Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I was having trouble with my demo environment. Since early this year, after I upgraded my laptop to a Lenovo W510 with 10GB RAM, I've been using VM Workstation for my demo and test machines, replacing the Microsoft Virtual PC demos ...
    Posted to Allen White (Weblog) by AllenMWhite on May 26, 2011
  • Change SQL Servers Authentication Mode with PowerShell

    Lately I've been working on scripts to check and set security and configuration settings for SQL Server using PowerShell. One of the settings that I normally set and forget at install time is the Authentication Mode setting. Best practices suggest that you set this to Windows Authentication, but my experience has been that it's always better to ...
    Posted to Allen White (Weblog) by AllenMWhite on May 19, 2011
  • Cumulative Updates for SQL Server 2008 SP1 & SP2 are available

    Today Microsoft has released cumulative updates for both SQL Server 2008 SP1 and SQL Server 2008 SP2. SQL Server 2008 Service Pack 1 KB #2527187 : Cumulative Update #14 for SQL Server 2008 Service Pack 1 There are 10 fixes listed for this update, and the build # is 10.00.2821.SQL Server 2008 Service Pack 2 KB #2527180 : Cumulative Update #4 for ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 16, 2011
  • 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
« First ... < Previous 2 3 4 5 6 Next > ... Last »
Privacy Statement