News

News

  • 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 ...

  • Sponsored News

    • Discovering the Business Value of Streaming Analytics

      With streaming analytics you can solve business problems in new ways and seize new revenue opportunities. You can reduce costs and increase efficiency while improving the safety of employees and the security of assets and intellectual property. See More

    • Three Use Cases for Interactive Data Discovery and Predictive Analytics

      Interactive data discovery and predictive analytics technologies allow business users and analysts to identify important trends and relationships in data sets and drill down into questions from any angle. They also allow business users to collaborate with specialists to create, refine and select the best predictive models. See More

    • Better Together: Hadoop and Your Enterprise Data Warehouse

      You’re getting started with a big data analytics project on Hadoop and are impressed by the cost savings on storage compared with your data warehouse. You’ve read that TrueCar, a company that collects vast volumes of car price data for its online car-buying business, has cut its monthly data storage cost from $19/GB to $0.23/GB. So you’re wondering, should you consider moving all your business intelligence efforts to Hadoop? See More

    • Five Steps to Maximizing the Value of Hadoop

      You want to get started with a big data project at your company, but you're unfamiliar with Hadoop and you're unsure your project will deliver value. Relax. Many organizations are struggling to implement Hadoop for a variety of reasons. In "The Current State of Hadoop in the Enterprise," by the International Institute for Analytics and sponsored by SAS, you'll find a handy list of five steps to maximize the value of a Hadoop big data project for your organization. See More

    View All Sponsored News
  • 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...

  • January 15, 2007 15 Jan'07

    Top products named for SQL Server

    Quest Software's LiteSpeed for SQL Server 4.6 took the Gold for backup and recovery along with SQL Sentry Event Manager Enterprise Edition v2.7 for performance. Tableau v2.0 earned the top spot for general database product of the year.

  • August 16, 2006 16 Aug'06

    Saying yes, no or maybe to stored procedures

    The world of software somewhat resembles a pendulum. Styles of development swing in and out of favor. Take stored procedures, which work to some extent and may sometimes be the shortest way to a successful project.

  • August 02, 2006 02 Aug'06

    Litchfield: Database security is IT's biggest problem

    Black Hat: Database security guru David Litchfield unveils 20-plus IBM Informix flaws that attackers could exploit to create malicious files, gain DBA-level privileges and access sensitive data.

  • August 02, 2006 02 Aug'06

    SQL Server vs. MySQL: Syntax differences, similar GUIs

    Discover syntax differences between SQL Server and MySQL, code for a timestamp automation workaround and why it's important to keep your version of MySQL current.

  • July 27, 2006 27 Jul'06

    Dumping Microsoft SQL Server: MySQL, PostgreSQL attract big users

    Using open source databases doesn't have to be an all-or-nothing decision. Most will work just fine alongside SQL Server.

  • July 20, 2006 20 Jul'06

    Minding the data and databases

    The role of the database administrator can be broad or delineated by specialization. DBAs are constantly at the mercy of the project size, scope and application complexity.

  • July 14, 2006 14 Jul'06

    Best practices for improved database management

    The best practices for improved database management include a combination of the right people, processes and products.

  • May 26, 2006 26 May'06

    SQL Server DBMS' growing popularity is no coincidence

    SQL Server offers more robust features at a lower price point than competing database management systems, making its growing popularity no surprise to contributor Adam Machanic. In this column, he details the advantages of using SQL Server over ...

  • May 17, 2006 17 May'06

    PostgreSQL vs. SQL Server: PostgreSQL is right for the Microsoft stack

    Is open source database PostgreSQL ready to replace Microsoft's SQL Server in the enterprise? Web application developer and author W. Jason Gilmore tackles the question in this column.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close