• October 23, 2009 23 Oct'09

    Are data warehouses made for the cloud?

    Cost and scalability benefits might make data warehousing seem like a perfect fit for cloud computing, but storage limitations with Azure could slow deployments.

  • October 21, 2009 21 Oct'09

    Q&A: Business intelligence gets a facelift in SQL Server 2008 R2

    From grab-and-go reporting to Master Data Services, SQL Server 2008 R2 will include several changes to Microsoft business intelligence.

  • October 20, 2009 20 Oct'09

    Project Gemini gets a new name, Madison earns buzz

    PowerPivot for Excel and SharePoint (formerly codenamed 'Gemini') along with Project Madison will be of keen interest to those looking ahead to SQL Server 2008 R2.

  • October 19, 2009 19 Oct'09

    Q&A: Moving forward with SQL Server in the cloud

    DBAs and developers have concerns about cloud computing , but enhancements to Microsoft's SQL Azure Database could ease those worries.

  • October 08, 2009 08 Oct'09

    End of life comes for SQL Server 2005 SP2, 2008

    Mainstream support for at least two versions of Microsoft SQL Server is set to expire next year.

  • August 14, 2009 14 Aug'09

    Microsoft releases SQL Server 2008 R2 CTP

    The first CTP of Microsoft SQL Server 2008 R2 is available for MSDN and TechNet subscribers and previews new features such as application and multi-server management.

  • July 27, 2009 27 Jul'09

    SQL Server Reporting Services 2008 offers faster speeds, new variations

    Get the inside scoop on Reporting Services 2008 with Michael Lisin and Jim Joseph, co-authors of the new book, "Microsoft SQL Server 2008 Reporting Services Unleashed."

  • May 11, 2009 11 May'09

    Microsoft renames SQL Server release, adds data services

    Some say upping the logical processor support in SQL Server may be a reaction to Oracle's acquisition of Sun.

  • October 23, 2007 23 Oct'07

    Q&A: Create and tune indexes in SQL Server 2000

    DBAs can build a SQL Server index best designed for their database environments by learning about columns, clustered indexes, and more.

  • August 27, 2007 27 Aug'07

    Podcast: SQL Server high availability options

    SQL Server high availability options include database mirroring, replication and log shipping. In this podcast series, you'll get the basics and best practices for each.

  • August 16, 2007 16 Aug'07

    SQL Server backup and restore school

    In this SQL Server backup and recovery school you'll get overall best practices, learn commands for backup and restore functions and be introduced to SQL Server 2005 features – all via webcasts and podcasts.

  • July 24, 2007 24 Jul'07

    Podcast: Log shipping in SQL Server: Basics to best practices

    SQL Server database administrator Eric Johnson explains how to back up your primary database and restore it to a secondary server through log shipping. He'll explain log shipping setup via SQL Server Management Studio. Get the details on how to set ...

  • June 25, 2007 25 Jun'07

    Major SQL Server 2008 features outlined by Microsoft exec

    At TechEd 2007, Microsoft product manager Francois Ajenstat discussed some of the major features in SQL Server 2008 designed to appeal to database administrators and IT administrators. In this first podcast of a two-part series, Ajenstat provides ...

  • June 24, 2007 24 Jun'07

    Database mirroring in SQL Server 2005 2

    What is database mirroring in SQL Server and how can it benefit your environment? SQL Server database administrator Eric Johnson starts by outlining the three roles involved in database mirroring: principle, mirror and witness. He goes on to share ...

  • June 20, 2007 20 Jun'07

    Podcast: SQL Server replication basics

    In this podcast, you'll grasp the functionality of replication and what it can do for your SQL Server environment. SQL Server database administrator Eric Johnson starts by explaining the three replication types: snapshot, transactional and merge. He...