Don’t Forget to Maintain Your Indexes
Indexing | August 8, 2009 | 3:22 amSo long as data is inserted, updated and deleted from tables, indexes will become fragmented over time, and performance will suffer. Index maintenance is vital to keeping databases and their users happy. In this article, I go through the key index maintenance tasks and identify more essential areas that are a DBA’s duty to maintain. ...read more
Brad’s Sure Guide to Indexes
Indexing | | 3:21 amThere are many different types of index that exist in SQL Server. In this guide, I look at what a table and index are, before exploring how SQL Server 2005 and 2008 indexes work, including those that are filtered, special and compressed. Read more…
Policy-Based Management
Database Maintenance | | 3:20 amIf SQL Servers are treated as ‘islands’, each with their own subtly different configurations, managing multiple instances of them can be a frustrating experience for the DBA. SQL Server 2008’s policy-based management aims to help us enforce policies for SQL Server instances throughout an organization. In this article, I look at what policy-based management is, ...read more
Management Studio Improvements in SQL Server 2008
Database Administration, Database Maintenance | | 3:17 amSQL Server Management Studio in SQL Server 2005 has faced some tough criticism from DBAs over the years. Microsoft has tried hard to make up for the troubles of the past, bringing a multitude of improvements in SSMS 2008 that I go through in this article. Read more…
DBAs Continue to Make More than Other IT Professionals
DBA Career | August 1, 2009 | 8:27 amAccording to a study by PayScale, and published in the July/August 2009 issue of Inc. Magazine, Database Administrators make more than Web Developers, IT Managers, Programmer Analysts, and Software Developers (in this order of ranking).
In addition, the study shows that the more experience the DBA has, the more he or she makes. For example, a ...read more
RSS
Twitter
Linked In