Yan Pan

In Part 1 of this series, we discussed how to prepare for SQL Server cluster installation on a two-node Windows Server 2003 cluster. We had two machines, NODE1 and NODE2, in our example. In this installment, I will show you how to install SQL Server Database Engine on the cluster. Although Analysis Services can be […]

SQL Server failover clustering provides the best high-availability solution for an entire SQL Server instance. When the active node in a SQL Server cluster goes offline due to hardware problems, OS problems or scheduled reboots, the SQL Server failover instance configured on the cluster automatically fails over to another node and continues running there. With […]

When a SQL Server instance supports the TCP/IP protocol, it listens for incoming connections on particular TCP ports. By default, a default instance is configured to use a fixed port 1433, and a named instance is configured to use dynamic ports. However, you can change the fixed port of a default instance, or make the […]

In part 1 of this article series, we illustrated how to use SQL Server Audit to monitor server-level actions and write audit results to the Windows Application Log. In this article, we will show you how to monitor database-level actions and write audit results to files. A Database Audit Specification collects database-level audit action groups […]

SQL Server 2008 February CTP introduces a new feature, SQL Server Audit. This feature facilitates auditing of Database Engine events by providing simple T-SQL statements to enable, store, and view audits on server and database objects. Compared to auditing with SQL Server trace files, using SQL Server Audit is much easier and cleaner. SQL Server […]

As discussed in Part I, the execution mode of each policy is determined by the characteristics of the Management facet that is used by the condition in the policy. Facets support “On Change – Prevent” if there is transactional support for the DDL statements that change the facet state. Only the Login, User and Database […]

Policy-base Management is a new feature in SQL Server 2008 that helps SQL Server administration. It allows Database Administrators to manage SQL Server instances by intent through clearly defined policies, thus reducing the potential for administrative errors. The policy-based framework implements the policies behind the scene with a Policy Engine, SQL Server Agent jobs, SQLCLR, […]

In this article, we are going to discuss how to copy SSIS packages stored in SQL Server and their associated package roles using the dtutil command line utility. SSIS packages can be saved in three types of storage locations: SQL Server, File System, and SSIS Package Store. When an SSIS package is saved into SQL […]

As a DBA working at a global financial services company, I face a tough task each year – making sure that SQL Server hosts around the globe change time correctly whenever there is a Daylight Saving Time (DST) event in the US or EU (luckily AS does not observe DST for now). Incorrect time on […]