- August 27, 2007
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
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
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
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
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 by SAS Institute Inc. - 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
Sponsored by SAS Institute Inc. - 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
Sponsored by SAS Institute Inc. - 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
Sponsored by SAS Institute Inc. - 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
- June 20, 2007
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
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
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
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
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
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
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
The best practices for improved database management include a combination of the right people, processes and products.
- May 26, 2006
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
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.