Tag: database

Pro Members SQL Server Standard Members

RDBMS Concept In Normalization & De-normalization of Data — Part 3

by

RDBMS Concept In Normalization & De-normalization of Data – Part – 3 As stated in the last article that “In the forthcoming article we will be noticing particular fine point’s concerning diverse Normal Forms (3NF and BCNF)”, here is the article. Defining Different Normal Forms:- The Third Normal Form (3NF):- A database table is supposed to be in Third Normal...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Why Learning Fluent SQL Will Provide More Business Opportunities

by

Why Learning Fluent SQL Will Provide More Business Opportunities If your business deals with records, whether of contacts, inventory or other business needs, then you know the value of organizing those records for easy access. If you use a Structured Query Language (SQL) database, then you have already positioned yourself for both simplicity and the expansion of your business. SQL...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Useful Undocumented SQL Server 2012 DBCC Commands (Part 1)

by

Useful Undocumented SQL Server 2012 DBCC Commands (Part 1) DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the physical and logical consistency of a database, although they are also used for a variety of miscellaneous tasks. 1. DBCC addinstance This DBCC command can be used to add an object instance to track in...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

What’s In a Name? On Database Naming Standards

by

What’s In a Name? On Database Naming Standards By Craig S. Mullins The establishment and enforcing of naming conventions is often one of the first duties to be tackled when implementing new software. Adequate thought and preparation is required in order for such a task to be successful. What amount of effort should be extended in the creation of appropriate...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server Database Backups and Recovery Model – (Part 1)

by

SQL Server Database Backups and Recovery Models – (Part 1) Author: Basit A. Farooq Editor Notes: This is the three part article series on SQL Server Database Backups and Recovery Models. In the first part, you will learn about basics of SQL Server backup process and database recovery models.In the second part, you will learn about database backup and transaction...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Managing Database Storage

by

Managing Database Storage By Craig S. Mullins Database systems require data files to store the data under management. These files, or data sets, reside on storage media. So storage management should be a key part of the database operations required of a database administrator (DBA). Unfortunately, storage is sometimes relegated to an afterthought; after all, don’t we have storage administrators...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using SQL Server 2008 R2 database settings

by

Tips for using SQL Server 2008 R2 database settings To change the database settings, you can use the sp_dboption system stored procedure or you can use the graphical user interface (GUI). To change the database settings using GUI, you can do the following: – In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2008 R2 Snapshot Replication

by

Troubleshooting problems with SQL Server 2008 R2 Snapshot Replication If you have problems with SQL Server 2008 R2 snapshot replication, review this troubleshooting checklist to find potential solutions. 1. Check that you use the latest SQL Server 2008 R2 service pack. Because some SQL Server 2008 R2 snapshot replication bugs were fixed in SQL Server service packs, you should install...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
1 2