SQL INDONESIA

Personal Notes of Edwin Eu

  • Microsoft SQL Server 2012

    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…

  • Create a database

     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…

  • DBCC References

    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

  • Server Configuration

    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.…

  • SQL Server – How to change SQL Server 2008 R2 database port

    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…

  • SSIS – Precedence Constraint Editor

    A precendence constraint has the evaluation operations: Constraint – Evaluates the success, failure, or completion of the predecessor task or tasks. Expression – Evaluates the success of a customized condition…

  • SSIS – The Precedence constraint

    The precedence constraint arrows can have different colors  to represent different commands. Each color represents a status when a task executed. Green = On Success Red = On Failure Blue…

  • SSIS – Protection Level

    The SSIS Protection Level has: DontSaveSensitive EncryptSensitiveWithUserKey EncryptSensitiveWithPassword EncryptAllWithPassword EncryptAllWithUserKey ServerStorage

  • Database backup

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

  • SQL Server – Create a database

    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…

Navigation

About

Writing on the Wall is a newsletter for freelance writers seeking inspiration, advice, and support on their creative journey.