June 2007 | Archive by Month | SearchSQLServer.com

June 2007

  • Quiz: Database Basics

    After reading the question, click on the answer that you think is correct.29 Jun 2007

  • Analysis Services 2005 defines for peak performance

    Microsoft Analysis Services 2005 in SQL Server offers greater flexibility for the cube architect. Build your cubes properly and get the best performance results by first defining attribute relation...27 Jun 2007

  • SQL Server 2005 business intelligence features

    SQL Server 2005 business intelligence features bring reporting and Analysis Services to a whole new level. Learn about the improvements to application performance.27 Jun 2007

  • Optimize disk configuration in SQL Server

    Proper disk configuration can result in a lifetime of high performance for SQL Server databases. Go beyond storage capacity requirements and consider drive performance. Database architect Denny Che...25 Jun 2007

  • 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 firs...25 Jun 2007

  • 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: ...24 Jun 2007

  • SQL Server cluster design: One big cluster vs. small clusters

    Clustering design in a SQL Server environment is a key strategy. You must consider options including load balancing, disk array failure, the number of nodes and instances.20 Jun 2007

  • 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 repl...20 Jun 2007

  • FAQ: Creating and altering SQL Server tables

    Whether you want to select rows, move records, track activity or perform various other table-related tasks, this collection of frequently asked questions offers expert insights to help.19 Jun 2007

  • Database security threats include unruly insiders

    Beware of the unruly insider when it comes to database security threats. Do you give your SQL Server users a blanket of security privileges they may not need? IT security specialist Kevin Beaver op...18 Jun 2007

  • FAQ: SQL Server stored procedure how-tos

    Write and run SQL Server stored procedures more effectively. This collection of FAQs will start you on the path to working with useful T-SQL routines.17 Jun 2007

  • Top 10 T-SQL tips for improved SQL Server development

    Learn to script SQL Server backups, why T-SQL in SSIS has pros and cons and workarounds for T-SQL code causing SQL Server performance problems.13 Jun 2007

  • Performance analysis tools for SQL Server

    Just being equipped with SQL Server tools is not enough. Database administrators and developers need to know how to use and ultimately optimize SQL Server tools like Query Analyzer, Index Tuning Wi...12 Jun 2007

  • Piecemeal restore with SQL Server 2005

    SQL Server 2005 extends the partial restore functionality with piecemeal restore, a feature that ultimately allows you to recover your entire database as your schedule permits. Baya Pavliashvili de...07 Jun 2007