Microsoft SQL Server 2012 finally release. There are three main version: Microsoft SQL Server 2012 Enterprise Edition Microsoft SQL Server 2012 Business Intelligence Edition Microsoft SQL Server 2012 Standard Edition…

 The “CREATE DATABASE <Database Name>” will impact to database performance issue  if it’s not utilize properly. There are many articles has discussed and posted. I would recommend to issues a…

I wanted to keep two good references handy in case needed. First resources is SQL Authority with Pinal Dave. http://blog.sqlauthority.com/2007/05/15/sql-server-dbcc-commands-list-documented-and-undocumented/ The second resources is MSDN library http://msdn.microsoft.com/en-us/library/ms188796

I’m very impressed with an article that I found on SQL Server Pro. http://www.sql-server-pro.com/sql-server-configuration.html The article discussed how to installing and configuring Microsoft SQL Server  after completed  the software installation.…

Over the years, I learned that Microsoft SQL Server product has TCP/IP port configured to 1433 by default.    I strongly advised to change the SQL Server TCP/IP port to unique port…

Microsoft SQL Server database backup in full recovery model consisted of: Full Database Backup Differential Database Backup Log Backup.

How to create a database CREATE DATABASE TestDB ON PRIMARY  (NAME = N’TestDB_Data’, FILENAME = N’M:\SQL_Data\TestDB.mdf’,   SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 16MB),  FILEGROUP FG1  (NAME = N’TestDB_Data2′, FILENAME…

Recently I was assigned to move the Dynamics SQL Server production database into a development environment.  In addition, I setup , install, and configure the Microsoft DYNAMICS. Installed, Setup, Configure Window…

SQL Server  – Common Table Expression (CTE) Common Table Expression (CTE) was implemented in SQL Server 2005 CTE are not design to be a replacement of the Temp Table CTE…

  How to setup Database Mail in Microsoft SQL Server 2008 R2. Enable and configure Email Create Profile and Account Configure Email. USE master GO EXEC sp_configure ‘show advanced’, 1…