By Bellevue College Student on 2/1/2011 11:00 PM
Post By: Alberto Ortoll Orellana (Bellevue College, WA)
Clustering is an Operating System (OS) Server based technology used to provide failover capabilities, and it is inherently redundant. Microsoft SQL Server is, more specifically, an application server that runs on top of the OS. There are some additional steps involved with setting up SQL Server in a Windows Server configured as a cluster. Server Clusters are composed of 2 or more servers, each server is called a Nodes. On a 2-Node cluster configuration, the first node is active and the second node is passive, it is common to refer to this configuration as a Cluster in Active/Passive mode.
|
By Bellevue College Student on 2/1/2011 9:53 PM
Post by: Adrian Claxton (Bellevue College, WA)
Let’s talk a little bit about migration when it comes to DBMS of the relational model. Migration is a process of moving data and applications from one operating environment to another operating environment. Such environments are relational database management systems for small businesses to enterprise server database management systems for large organizations. Examples of these environments are Oracle, MySQL, SYBASE, Visual FoxPRO, and Microsoft Access. All of these applications can be migrated to Microsoft SQL Server. |
By Saleem Hakani (Microsoft Corporation) on 2/1/2011 9:46 PM
What if you have 100's of SQL Server 2005 in your company and you would like to configure all the servers based on some standards (Example: Surface Area Configuration Properties). Take an example you have just installed a SQL Server and also have configured the surface area configuration (SAC) for that SQL Server based on your standards and now you would like to replicate this configuration to 100's and 1000's of other SQL Servers in your company. How would you do that? |
By Bellevue College Student on 2/1/2011 9:26 PM
Post by: Silin Kuang (Bellevue College, WA)
In nowadays, our lives have heavily relied on information that is available for us. To make sure database high availability, in another word, to make sure the information is available when you need it, has made a DBA’s role crucial in an organization. As a consumer, you use the most updated product information available on the website to make a purchase decision. As a doctor, you use the patient’s information available for you to judge the operation procedures for a surgery. As a marketing analyst, you use the sales transaction history available to make marketing forecast and financial reports. With the huge amount of data being added to the database every second, how does DBA’s ensure database high availability? This article demonstrates the major high availability technologies in Microsoft SQL server 2005 and 2008. |
By Bellevue College Student on 2/1/2011 9:09 PM
Post by: Gary Mitchell (Bellevue College, WA)
I chose Stored Procedures as a topic because, while Database Administration can be done without writing them, they are a key to automating many of the administration tasks. The intent is not to determine what can be automated or to cover the T-SQL language, but to cover some features and possible methodologies for stored procedures. |
By Bellevue College Student on 2/1/2011 8:31 PM
Posted by: Chun-Ming Chen (Bellevue College Student, WA)
Concurrency is an ability that allows multiple users to access the same data at the same time. However as more users access the data at the same time, the greater the chance for users to change the same set of data at the same time and overwrite each other’s input. The integrity of the data is compromised without the users initiating the operations knowing it. There are four types of concurrency problems:
· Lost updates
· Dirty reads (uncommitted dependencies) · Nonrepeatable reads (inconsistent analysis) · Phantom reads |
By Bellevue College Student on 2/1/2011 8:21 PM
Post contributed by: Jun Wong (Bellevue College Student)
Triggers are a part of SQL Server that provides an important set of features that can be utilized for a variety of programming needs. It is essentially a special type of stored procedure that runs when a particular event occurs in the database server. |
By Saleem Hakani (Microsoft Corporation) on 12/29/2010 2:46 AM
There are times when you may want to change the date to a specific format at the server level instead of making changes to individual procedures/objects. It would be very tough to perform this change at every object level. However, below commands will help you identify the current date format at the server level and how to change that format. |
By Saleem Hakani (Microsoft Corporation) on 12/28/2010 11:10 PM
It becomes very challenging to remember long object names when you are working with linked servers or using a non-standard object naming convention in SQL Server. |