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
