SQL INDONESIA

Personal Notes of Edwin Eu

Month: June 2012

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

  • SQL Server – Restore a database

    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)

    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…

Navigation

About

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