SQL Shack round-up – April 1st, 2014 – Policy Based Management, SQL query execution plans, SQL database design, log shipping, and SSIS packages

In the last two weeks, we wrote series of articles about SQL Server Policy Based Management and SQL Server query execution plans, and started a series about SQL query performance killers with a poor database indexing article. We also explained how to use an XML file to configure an SSIS package and how to choose a right primary key

SQL Server security and Policy Based Management – Introduction is the first article in the Policy Based Management series. It explains the concepts, terms, and common tasks used in Policy Based Management. It shows how to create and modify conditions and policies, and how to export, import, and evaluate policies

The next part of this series gives steps to create a Policy Management condition, create and evaluate a policy

In Alerting, we explained how to use SQL Server Alerts and Operators to automate the process of policy violation notification

We described and provided a step-by-step example for creating an advanced Policy Based Management policy which uses T-SQL within its condition in Advanced conditions. We provided an example for a policy which verifies whether SQL Server Agent alerts were reset

In Evaluating policies on multiple SQL Server instances, we explained concepts, terms, basic and advanced tasks that create complex conditions and policies

Three parts from the SQL Server query execution plans series are written this week. Understanding and reading the plans explains the symbols used in SQL Server query execution plans, how to read the plans, and how to use these plans in performance analysis and troubleshooting

The series continues with Examples with the SELECT statement, where we showed a series of examples for basic T-SQL queries, explained the SQL Server query execution plan, and its components for each example, as well as why indexing is important and how it affects the query execution plan structure and cost

The last part in this series shows Examples with the WHERE clause

Using an XML file to configure an SSIS package gives steps for creating an XML configuration file in Business Intelligence Development Studio that can be used to update the property values at run time

What is a primary key and how to select the right one from candidate columns is explained in SQL Database design: Choosing a primary key. We presented the rules to follow when choosing a primary key for a table, defined a natural and surrogate key, and performed tests to depict processor usage for different primary keys

Besides answering the What is SQL Server log shipping? question, this article provides implementation examples, advantages and disadvantages of using SQL Server log shipping

The SQL query performance killers series starts with Understanding poor database indexing. It explains what SQL Server indexes are and the difference between clustered and nonclustered indexes, heap and clustered tables. It gives steps to create an index using T-SQL and SQL Server management Studio options

April 1, 2014