Brian Kelley explains why he avoids the fixed DB data roles db_datareader and db_datawriter, and how they can compromise your server security.
SQL SERVER – SSIS Execution Control Using Precedence Constraints – Notes from the Field #021
Tasks running in the wrong order in your SSIS package? Tim Mitchell reviews the essentials of precedence constraints for SSIS execution control.
SQL SERVER – Index Fragmentation Next Steps – Notes from the Field #020
Indexes get fragmented as data grows. I asked my friend Tim Radney what he does then, and here are his index fragmentation next steps from the field.
SQL SERVER – SSIS Data Flow Troubleshooting – Part1 – Notes from the Field #019
SSIS data flow problems look simple but are hard to fix. In part 1, Andy Leonard explains how to troubleshoot the SSIS Data Flow Task.
SQL SERVER – Performance Statistic Collection – Notes from the Field #018
Good tuning starts with good numbers. In Notes from the Field #018, David Klee explains Performance Statistic Collection and how DBAs should gather server data.
SQL SERVER – Dude, Where is the SQL Agent Job History? – Notes from the Field #017
A job failed but you cannot find the SQL Agent Job History? John Sterrett explains this common problem he sees in the field and what to do about it.
SQL SERVER – Finding the Last Backup for All Databases – Notes from the Field #016
When did you take your last database backup? Tim Radney shares a simple script that shows the last backup for all databases on a server.