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. […]

Featured Article(s) Using Bitwise Operators in T-SQL Using bitwise operations in SQL Server can reduce storage space and improve performance. This article will get you started. Watch the Latest SQL Server Show (132) SelectViews – Snapshots as Backups? David Penton, Keeping Customers, Database Inventory and More. Also find out about noise and news, tips tricks and other goodies. [Watch the […]

Watch the Latest SQL Server Show (132) SelectViews – Snapshots as Backups? David Penton, Keeping Customers, Database Inventory and More. Also find out about noise and news, tips tricks and other goodies. [Watch the Show] Previously: [Watch] Christopher Regan, Donald Belcham, John Welch [Watch] Herve Roggero, Jason Strate, and TJ Belt [Watch] Tim Heuer, Lynn Langit and Thomas LaRock. Featured […]

Featured Article(s) Understanding NOLOCK hint in SELECT clause- PART 2 Part 2 of the article series on understanding the NOLOCK hint in SELECT clause. Data Backup, Validation and Sourcing Comments Stephen writes: "Single source information (SSI?), interesting concept, however, here in the medical informatics world we call that ‘data quality’ and we have Data Quality working groups (of which I’m […]