Tuning Takes Metrics When you get to tuning your SQL Server, you quickly find that it’s about having a great look at your system today combined with solid metrics over time. You can compare, contrast and learn from the trends, then use that information to dig into what your server is doing, why and what you can do to tune […]

Featured Article(s) Tips for using SQL Server 2005 Database Console Commands (Part 1) In this article, Alexander Chigrik shows how you can optimize SQL Server 2005 performance by using database console commands. Food For Thought…. Indexing, Full-Text Indexing I’ve been seeing a somewhat odd trend of late as we’re looking over applications both internally and externally. As we look through […]

SelectViews Video Show Community thoughts on SSD drives, moving jobs between servers, last update date tips. Also, indexed views, database hack recovery, foreign key pros and cons and more. Each show features the Accidental DBA Tip, the 60-second SQL Server Tip of the Day, Noise and News in the Industry and a lot more. [Watch The Show Here] New SQL […]

Featured Article(s) Getting Started with Triggers Triggers are great tools for controlling, auditing or just plain changing how and what information is updated on your system. This article looks at the essentials for setting up triggers and what they can be used for. New SelectViews Show Posted Community thoughts on SSD drives, moving jobs between servers, last update date tips. […]

Featured Article(s) Backup Compression Tool Review Everyone knows the backup tools that are out there. But have you seen hyperbac? I put this tool to the test on my system. Now Is The Time – Plan For Your Time Off If you haven’t yet, now is the time to get going on those plans so you can take some time […]

Webcast Today! Understanding the Hazards that Zap your Hardware Resources! This webcast will explore the challenges around maintaining optimal performance in a SQL Server environment while keeping downtime to a minimum. Well discuss methodologies you can take and use to administer your environment efficiently, and offer solutions to easily view server resources and anticipate growth. > Register Now Top Database […]

Featured Article(s) Tips for using SQL Server 2005 User-Defined Functions Here are some helpful tips to work with SQL Server 2005 User-Defined Functions. Webcast Tomorrow – Register Now Understanding the Hazards that Zap your Hardware Resources! This webcast will explore the challenges around maintaining optimal performance in a SQL Server environment while keeping downtime to a minimum. Well discuss methodologies […]

Understanding the Hazards that Zap your Hardware Resources! This webcast will explore the challenges around maintaining optimal performance in a SQL Server environment while keeping downtime to a minimum. Well discuss methodologies you can take and use to administer your environment efficiently, and offer solutions to easily view server resources and anticipate growth. > Register Now > Webcast date: 12/11/2008 […]

Featured Article(s) New Features and Improvements in ASP.NET 3.5 and Visual Studio 2008 (Part II) This is the second and concluding part in the series of articles on the new features and improvements in ASP.NET 3.5 and Visual Studio 2008. In this part the following points will be discussed: JavaScript Debugging and Intellisense Support Support for inbuilt Silverlight and C++ […]

Featured Article(s) The ASP.NET 2.0 Provider Model The provider model in ASP.NET, based on the Provider Design Pattern, provides a plug-and-play architecture that allows you to implement a well-documented and easy to understand API that can be used to store state information virtually anywhere! The Provider Model incorporates a number of patterns in it – abstract factory, singleton and the […]