


Creating and using CRUD stored procedures
April 7, 2014
Database table partitioning in SQL Server
April 4, 2014What is a database table partitioning?
Partitioning is the database process where very large tables are divided into multiple smaller parts. By splitting a large table into smaller, individual tables, queries that access only a fraction of the data can run faster because there is less data to scan. The main of goal of partitioning is to aid in maintenance of large tables and to reduce the overall response time to read and load data for particular SQL operations.
Read more »
Common SQL syntax errors and how to resolve them
April 2, 2014
SQL query performance killers – understanding poor database indexing
March 31, 2014
SQL Server Policy Based Management – evaluating policies on multiple SQL Server instances
March 28, 2014
SQL Server security and Policy Based Management – Advanced conditions
March 26, 2014
SQL Server security and Policy Based Management – Alerting
March 24, 2014
SQL Server query execution plans – Examples with the WHERE clause
March 21, 2014
SQL Server query execution plans – Examples with the SELECT statement
March 19, 2014

SQL Server query execution plans – Understanding and reading the plans
March 17, 2014In the previous parts of this series, we explained what SQL Server query execution plans were, why they should be used, and presented various methods to show them. In this part, we will explain the symbols used, how to read the plans, and how to use these plans in performance analysis and troubleshooting
Read more »
Using an XML file to configure an SSIS package
March 16, 2014
SQL Database design: Choosing a primary key
March 16, 2014
What is SQL Server log shipping?
March 16, 2014What is SQL Server log shipping?
SQL Server log shipping is a technique which involves two or more SQL Server instances and copying of a transaction log file from one SQL Server instance to another. The process of transferring the transaction log files and restoring is automated across the SQL Servers. As the process result there are two copies of the data on two separate locations Read more »
SQL Server security and Policy Based Management – In practice
March 16, 2014
SQL Server security and Policy Based Management – Introduction
March 16, 2014
Using SSIS packages to import MS Excel data into a database
March 15, 2014

SQL Server query execution plans – Viewing the plans
March 15, 2014In the SQL Server query execution plans – Basics, we described the query execution plans in SQL Server and why they are important for performance analysis. In this article, we will focus on the methods for opening the plans, both actual and estimated ones
Read more »
SQL Server query execution plans – Basics
March 15, 2014Why is query execution important for SQL Server performance?
SQL Server performance monitoring depends on the performance goals. The first step in monitoring is to determine optimal performance for your server and create performance trends based on the captured metric information. If performance is not satisfactory, it’s necessary to diagnose performance problems and find their origin. This involves testing how different queries and applications affect performance Read more »
What is SQL Server database mirroring?
March 15, 2014
SQL Server alerts in troubleshooting performance issues: How to create and use SQL Server alerts
March 15, 2014Before creating a SQL Server alert, make sure that Database Mail and SQL Server Agent properties are properly configured Read more »

SQL Server alerts in troubleshooting performance issues: SQL Server alerting basics
March 14, 2014Why is SQL Server alerting important?
To be aware of what’s going on with your system and how SQL Server performs, monitoring is necessary. However, just monitoring might not be enough. Being notified about a performance issue whenever a specific SQL Server counter meets a threshold value, or a specific event occurs, boosts monitoring usability. These notifications enable DBAs to be aware of every important system performance change as soon as it happens, and therefore they can act immediately to fix the issue and prevent further problems Read more »
What is a SQL Server disaster recovery?
March 14, 2014
What is a SQL Server failover clustering
March 14, 2014What is a failover cluster?
SQL Server failover clusters are made of group of servers that run cluster enabled applications in a special way to minimize downtime. A failover is a process that happens if one node crashes, or becomes unavailable and the other one takes over and restarts the application automatically without human intervention Read more »