SQL Server

SQL Server In Farming {4}

by Jorge R
The main purpose of the article is to explain how SQL Server can be implemented into the farming business. In the dairy business, milk is the banner child for their main product. Over the years the demand for dairy products have skyrocketed, which led researchers to find new innovative ways to improve farming techniques. In order to produce the best cows, researchers needed to look at the family tree, they need to pinpoint the cows with the best genes by using genetic evaluation, “…in the animal breeding and genetics depth analysis of the theory based on the use of advanced computer object-oriented programming ideas…”.The first step is to perform Test Day Model (TDM),”is a series of test day records for genetic evaluation of the object as a treatment mode”. The second step is to design a create a system structure of dairy cow genetic evaluation performance. Upon collecting a variety of data from multiple cows, the data can be organized into data tables. The implementation of cow genetic performance evaluation needs to include data such as pedigree, descent, condition growth, development and childbirth. The article also explains the basics on how to update, delete, and insert data into SQL Server. read more...

Data Types {2}

by Jamal A
The article I read talks about the most important contemplations of selecting correct data types when designing a SQL Server database. It talks about how choosing a correct data type in the database design phase can have a significant impact on the efficiency and performance. According to the article, the SQL Server offers six sets of data types. First and formost commonly used data types that stores numeric information are called “The Exact Numeric Data Types” that includes: int, decimal, and money.  The next data type is called “The Approximate Numeric Data Types”, this data type are not as commonly used as the exact numeric data types. The approximate numeric data type includes: float, and real. Moving on, the next data type that is mentioned in this article is called “Date and Time Data Types”, this data types allow designers to easily work with time zones. After that, the next data type in the category is called “Character String Data Types”, it is used to store text values in Microsoft SQL Server databases, and this includes: char, nchar, varchar, nvachar, and text.  The next data type that is mentioned in this article is called “Binary Data Types”, it allows DBAs to store any type of binary data, this includes: bit, binary, varbinary, varbinary(max), and image. Finally, the last data type that is mentioned in this article is called “The Other Data Types”, it includes: cursor, sql_variant, table xml, and uniqueidentifier. read more...

SQL ‘big data’ driving {1}

by Quoc L
2012 is going to be a big year for Microsoft’s SQL server. It going to get a huge overhaul and cloud support this year. The explosive increase of data is forcing SQL server to change the way of managing and storing data. Up and coming solid state drive usage have spike recently as a new and faster way of data storage.solid state drive is the new up and coming tech for data storage. The new hard drive have more then twice the speed of traditional hard drive.  Another huge internet trend that is affecting SQL is cloud computing and storage. Cloud computing is where data are store on the “cloud” where anybody on the internet can access the data with ease. These data are storage in data warehouse that is constantly connected to internet. With these two new trend, database is going to become faster and efficient then it was in the past. read more...

SQL Server R2 2009 Update: Code Name Kilimanjaro {Comments Off on SQL Server R2 2009 Update: Code Name Kilimanjaro}

by Evin C
This week I have chosen another peer-reviewed article discussing new business intelligence (BI) functionality and management features that will be or has been implemented into SQL already. Referring to the “mini-release” as code name Kilimanjaro, this release has the potential to really innovate the way businesses apporach SQL and it’s DBMS capabilities. Some of the features of this update include three exciting new features: self-service analysis, self-service reporting and Master Data Services. SQL Server Analysis Services (SSAS) allows the user from their desktop to “access, manipulate and report against managed and unmanaged data sets, including large data sets.” This allows for more freedom for information workers (IW’s) and also improves the efficiency of the IT departments in any organization. “For IT, Gemini helps keep core data secure, while freeing IT from having to spend a lot of time addressing ad hoc user requests. IT pros have the tools to manage shared Gemini solutions— including data refresh, model security, and resource utilization—and can enhance the model as more and more workers use it.” read more...

SQL Server Alternative {5}

by Jorge R
The main focus of my article is to explain the advantages from moving from SQL Server to MYSQL. The author starts by stating that he worked as a SQL Server DBA, and at the time there was no other program that matched Microsoft’s user friendly interface. As timed progressed he found MYSQL to be a database that could match SQL Server ease of use, reliability and performance. One of the benefits of using MYSQL is the running the program in a multitude of operating systems, with low computer resources and hardrive space. Another advantage of using MSQL is the use of storage engines. This allows the DBA to have a flexibility to have transactional tables, main memory, and compressed data. A point expressed by the article is the companies using MYSQL such as Google, Yahoo, and Facebook. Their performance and scalability is above and beyond their competitors. There are wide arrays of monitoring and tuning tools packed into MYSQL; they are trying to make their products as user friendly to use. The article states that there are multiple ways to transition into MYSQL. A method is to use a program made to convert SQL Server data into MYSQL data.  One of the most attractive features of MYSQL is the low costs. read more...

Indexing SQL Server Relational Databases For Performance {Comments Off on Indexing SQL Server Relational Databases For Performance}

by Toan T
In a relational database, indexing is used to retrieve data quickly from a system. With indexing, data is sorted in a way that made it relatively easy for users to search for which is very similar to an index in a book. In this article, we will be talk about some issues that are often overlooked with regards to indexes. Generally, having more indexes means that quickly you will be able to retrieve the data. However, large amount of indexes can also increase the time it will take to insert new data. In Microsoft SQL Server, there are two supported indexes: clustered and nonclustered. Clustered indexes mean that the data are already physically ordered while nonclustered indexes contain pointers in the data rows that typically contain a reference to the location in the clustered index if it exist. Indexes are often automatically created by the database to ensure that no duplicate data can be inserted. In MS SQL Server, 256 nonclustered indexes can be created per table. That might seems to be a lot but it is no advisable to do so because indexes require additional storage space in both memory and on the disk drive. They also lead to a decrease in performance when performing insert statements because the data needs to be inserted according to the indexes instead of the first available space which requires more time to complete. read more...

Open Source Database for Small Company {1}

by Tuyen H

 

While Eclipse is very successful for Java Development, MySQL and PostgreSQL are very populating open source Databases.We cannot compare with brand name like Oracle, Microsoft, or IBM, but MySQL and PostgreSQL are very reasonable for small business.  If your data is less than a terabyte, both MySQL and PostgreSQL definitely can handle it. However, if your data is really big, you better think of Oracle, DB2, and Microsoft enterprise RDBMSes. Open source database is less secure than brand name database, so you have to keep in mind that “how safe is my data”  (Gravelle, 2011). read more...