Windows Firewall to Remote SQL Server Configuration Manager (SSCM)

Previously we discussed about using computer management console to remotely configure SQL Server Configuration Manager (SSCM) in this post. If your environment has firewall turned on, there are additional firewall configuration need to be made to allow it to work.

SQL Server tempdb database size - file creation and file growth

SQL Server tempdb is a system database that used as global resource for temporary user objects, internal objects, row versioning and other operations. The database grows as these resources demand increases, and below the maximum file size limit if previously configured.

SQL ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

SQL Server ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT database options enable/disable the use of row versioning. These two options are often discussed independently and collectively due to their behaviors, and may have resulted some confusion on how these two database options correlate and affect each other on transaction isolation level.

SQL Statistics - Auto Create and Auto Update

SQL statistics includes histogram which display the distribution of values and it also contains densities, information of the correlation statistics between multiple columns. These information are used by query optimizer to estimate the cardinality (number of rows) of the query result and determine an optimal query plan for better query performance based on the estimation. As a result, creating and maintaining the statistics efficiently and accurately become a critical task.

SQL Server Configuration Manager (SSCM) on Remote Server

SQL Server Configuration Manager (SSCM) provides basic configuration management for SQL Server services such as setting service properties and network protocols. This tool is essential for managing SQL Server services. The console itself does not have the option to connect to remote SQL Server services, but actually there is another console designed for this.

SQL Server 2012 Enterprise Edition Licensing Model

Microsoft made some changes on the SQL Server 2012 licensing. One of the big change is from previously processor based licensing, to core based licensing model. While Microsoft try to simplify SQL Server 2012 licensing by retiring Datacenter, workgroup and small business edition, there are some confusion linger around with SQL Server 2012 Enterprise Edition Server plus CAL licensing model and SQL Server 2012 Enterprise Edition Core-based licensing model.

SQL Log File and Virtual Log File Size

When creating a database, its initial file size, file growth rate, and its auto growth options are some of the important settings need careful and detailed planning. The same hold true for its log file. This post mainly focus on the log file. What file size should be used?

SQL Database Recovery Model

Before planning on database backups, it is important to understand the recovery model that need to be defined for the database. Recovery model determine how transactions are being logged and the type of database restore operations are available.