Troubleshooting problems with SQL Server 2008 R2 performance counters If you have problems with SQL Server 2008 R2 performance counters, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 performance counters bugs were fixed in SQL Server service packs, you should install the latest SQL...
SQL Server
DML Triggers to Track SQL Server Agent Jobs Creation, Deletion and Modification Events (Part 2)
DML Triggers to track SQL Server Agent Jobs creation, deletion and modification events (Part 2) Author: Basit A. Farooq Now that we have created our tables, the next step is to create the four triggers to monitor and log any job modification activities that are occuring on SQL Server instance: 1) AuditDB_AuditNewSQLAgentJobTrigger – will trigger, when the new job will...
Troubleshooting problems with Analysis Services in SQL Server 2008 R2
Troubleshooting problems with Analysis Services in SQL Server 2008 R2 If you have problems with Analysis Services in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 Analysis Services bugs were fixed in SQL Server service packs, you should install the...
DML Triggers to Track SQL Server Agent Jobs Creation, Deletion and Modification Events (Part 1)
DML Triggers to track SQL Server Agent Jobs creation, deletion and modification events (Part 1) Author: Basit A. Farooq Introduction to Problem As we know, SQL Server Agent jobs are crucial to any SQL Server environment, as they are used for scheduling and performing critical business and operational tasks. For example, I’ve got several hundred SQL Server Agent jobs that...
Troubleshooting problems with user-defined functions in SQL Server 2008 R2
Troubleshooting problems with user-defined functions in SQL Server 2008 R2 If you have problems with user-defined functions (UDF) in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 UDF bugs were fixed in SQL Server service packs, you should install the...
What Does Mentoring Mean to You?
What Does Mentoring Mean to You? Professional development series This is Laura Lee Rose, instructor for the GoTo Academy: Tools for the GoTo Guy and Gal. I am a business and life coach that specializes in professional development, time management, project management and work-life balance strategies. This is a segment from the GoTo Academy Leadership series In the previous SSWUG...
Detecting and Removing Duplicate Indexes
Detecting and Removing Duplicate Indexes Author: Basit A. Farooq Problem Indexes are the solution to many performance problems, but with too many indexes on tables can hurt the performance of your database. This is because SQL Server performs extra work in order keep these indexes up-to-date during insert/update/delete operations against tables where these indexes exist. This means that the SQL...
Troubleshooting problems with CLR in SQL Server 2008 R2
Troubleshooting problems with CLR in SQL Server 2008 R2 If you have problems with Common Language Runtime (CLR) in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 CLR bugs were fixed in SQL Server service packs, you should install the...
DB2 Buffer Pool Essentials (Part 1)
DB2 Buffer Pool Essentials (Part 1) By Craig S. Mullins If you use DB2 for z/OS as your database management system you know that you need to keep a watchful eye on your memory. DB2 just loves memory. Some might say that the more memory you throw at DB2, the better. But simply adding more and more memory to your...
What is The Best Way to Create a ‘One Team’ Culture?
What is the best way to create a "One Team" Culture? Professional development series This is Laura Lee Rose, instructor for the GoTo Academy: Tools for the GoTo Guy and Gal. I am a business and life coach that specializes in professional development, time management, project management and work-life balance strategies. This is a segment from the GoTo Academy Leadership...