Featured Article(s) Configure and Implement Database Mail in SQL Server 2005 Configure and Implement Database Mail in SQL Server 2005 Performance Management – Hardware or Tuning? The question was – for performance, do you "throw hardware at it" or "tune it?" Send in your feedback here. I have received SO MUCH feedback on this that I really want to keep […]

Featured Article(s) 7 things to check to resolve “A network-related or instance-specific error occurred while establishing a connection to SQL Server…” This article identifies 7 possible ways to resolve a common SQL Server connectivity error : “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that […]

Register here for the vWorkshop – Friday – June 5 – SQL Server 911 (Check out the course outline here, at the site) Featured Article(s) Troubleshooting SQL Server 2005 System Stored Procedures (Part 2) In this article, Alexander Chigrik explains some problems that you can have when you use SQL Server 2005 system stored procedures. He also tells how to […]

Last Few Days to Register for the SQL Server 911 vWorkshop on this Friday. 5 hours of intense instruction, certificate of completion, guidebook and much more. [Register Here] Featured Article(s) Inheritance in Windows Forms -Visual Studio 2005 In this article we shall understand how we can reuse FORM behaviors through Windows FORM inheritance – Visual Studio 2005 Announcement – Summer […]

Webcast: Tools for SQL Server Backup Heroes Recent trends in the database industry have lead to a number of challenges for managing SQL Server. Most databases grow in size over time. Regulatory requirements mandate maintaining certain amounts of data online. Users also want to see more of their data. And the number of users for database applications grows over time […]

Featured Article(s) Design and implement Database partitioning using GUI in SQL server 2005 Design and implement Database partitioning using GUI in SQL server 2005 Can You Help Settle an Argument, er, Discussion? I was talking with a DBA friend about what types of things are most common for a DBA to do in terms of maintenance and management. Backups? Recovery/Recoverability? […]

Don’t miss SQL Server 911 – June 5. Featured Article(s) SQL Server PowerShell : Basics PowerShell is a great tool that allows DBAs and Developers alike to script, manage and automate SQL Server tasks. Most of the objects and tasks will require SMO (SQL Server Management Objects). This article gets you started with SQL Server PowerShell by walking you through […]

Featured Article(s) Troubleshooting SQL Server 2005 System Stored Procedures (Part 1) In this article, Alexander Chigrik explains some problems that you can have when you use SQL Server 2005 system stored procedures. He also tells how to resolve these problems. Things to Watch for in a Tight IT Budget World I’ve been seeing some interesting trends in talking with people […]

Featured Article(s) Deleting Large Number of Records How to delete a large number of records from a table in SQL Server and manage the growth of the transaction log. Announcement: Chris Shaw vWorkshop – Deep-Dive SQL Server We’re proud to announce that Chris Shaw will be doing an incredibly intense and in-depth workshop, called "SQL Server 911" and will be […]

Featured Article(s) Database Failover clustering in SQL Server 2005 Find out about database failover clustering in SQL Server 2005, how it works and things to think about as you consider it or work with it. Important Information for SQL Server Evaluations I saw a post on the email discussion lists today that I wanted to be sure to pass along. […]