- May 11, 2009
Some say upping the logical processor support in SQL Server may be a reaction to Oracle's acquisition of Sun.
- October 23, 2007
DBAs can build a SQL Server index best designed for their database environments by learning about columns, clustered indexes, and more.
- 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 ...
Sponsored by CloudHealth - As enterprises continue to add new use cases and workloads to their cloud portfolio, the stakes keep rising for potential governance speed bumps. Business users and IT professionals alike are now using the cloud for everything from compliance and security to cloud-native application development and infrastructure optimization. But this makes policy management more difficult, time consuming and costly, especially with so many cloud services being purchased and deployed outside the scope, visibility and control of a centralized IT operations group. See More
Sponsored by CloudHealth - In the era of Cloud 1.0, early adopters were often drawn to the cloud because it allowed them to reduce Capex and move to a more predictable subscription pricing model. In recent years, cloud adoption has surged because organizations have recognized that it not only reduces their hardware purchases and per-seat software licenses but provides many operational benefits as well. See More
Sponsored by CloudHealth - For more than a decade, the biggest gating factor in cloud computing adoption was perceived security risks. IT professionals and business leaders alike were often extremely concerned about a perceived loss of control of mission-critical data and essential applications when moved to the cloud. See More
- 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 ...
- 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.