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 » SQL Server 2008 R2   (RSS)
Showing page 1 of 2 (13 total posts)
  • Vulnerability Affecting All Supported Versions of SQL Server

    Well, it's that time again: Patch Tuesday. SQL Server hasn't had a security update since August, but today we're giving the hotfix download servers a run for their money. Both GDR and QFE fixes were released in Security Bulletin MS15-058, to address a vulnerability in remote code execution (for details on the exploit, see KB #3065718). The long ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 14, 2015
  • MS12-070 : Security Updates for all supported versions of SQL Server

    This week there was a security release for all supported versions of SQL Server. Each version has 32-bit and 64-bit patches, and each version has GDR (General Distribution Release) and QFE (Quick-Fix Engineering) patches. GDR should be applied if you are at the base (RTM or SP) build for your version, while QFE should be applied if you have ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 10, 2012
  • Server level permissions for developers–why you should read books

    It is quite difficult recently for me to find some time to write a new post, so I don’t seem to be leading the rankings of the most frequent bloggers. I rarely recently have opportunity to lay my hands on the code too, so natural sources of ‘inspiration’ are less often. Hopefully this will change in 2012 and I will have more opportunities to write ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on January 1, 2012
  • 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
  • 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
  • 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
  • SQL Server updates - from Microsoft and from 3rd parties

    Ola's Index Maintenance scripts On August 3rd, Ola Hallengren (blog) released a substantial update to his Backup, Integrity Check and Index Optimization scripts - allowing you to more finely tune the object selection process.  Over this past weekend he also updated the error handling to get around some blocking issues.  For information ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 17, 2010
  • More testing of Unicode Compression in SQL Server 2008 R2

    Background Several weeks ago, I ran some tests on the new implementation of Unicode Compression in SQL Server 2008 R2 - both space-related and performance-related.  Of course it was pointed out that my performance tests were somewhat flawed, because I was using data from a very wide and atypical variety of characters sets.  I also ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 4, 2009
1 2 Next >
Privacy Statement