Digital Rights Management

I recently changed laptops and I moved some music over that I bought at Walmart.com. When I went to play the song, I got an error. See the graphic in this post. I find it an interesting method to control music download. It was not easy to get my new computer authorized. I am okay with it. Artists have the right to get paid for their music.

Troubleshooting SQL Server 2005 Install

Verify that you meet the hardware and software requirements for your version of SQL Server. For more information see Microsoft’s MSDN site.

If your SQL Server install did not finish then the first place you should look is in the Windows Event Viewer. Look in the Application log, write down the error number and search for help at support.microsoft.com.

If you did not find an error in the Application log of the Event Viewer then search the phrase “UE 3,” –short for Return Value 3, which means an error occurred– in the following locations:

• X:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG
  • Open the Summary.txt file
  • Open the SQLSetupxxxx.cab file
  • Open the SQLSetupxxxx_Computername_Core.log file
  • If you saw an error during the graphical portion of the setup process
    • Open the SQLSetupxxxx_ComputerName_WI.log
• Open the SQLSetupxxxx_ComputerName_SQL.log file

If you have tried to install SQL Server and received the error message: “There was an unexpected failure during the setup wizard” then see this Microsoft’s Support solution.

What is the newest version of MS SQL?

SQL Server 2008 is the greatest and latest in server software. It brings the most premier levels of security, reliability, and scalability for business applications. It helps your organization manage any data, any place, and any time! Here is just a few applications it covers; Business Intelligence, Server Consolidation, Data Warehousing, Virtualization, Online Transaction Processing(OLTP), Application Development. SQL Server 2008 permits data to be disbursed from custom applications recognized by Microsoft .NET and Studio and from within service-oriented architectures and business processes through Microsoft BizTalk Server. Try the NEW SQL SERVER 2008 TODAY!

Can upgrade SQL 6 to SQL 2005?

Yes, we can but !!!!!!!
Migrating from SQL 6 or 6.5 is possible is you have SQL 7.

SQL Server 2005 is capable of running in several “database compatibility modes”, allowing 2000 and 7.0 databases to run within a SQL 2005 instance.  SQL 6 waswhat Microsoft get and 7 was his first version. In order to upgrade to SQL Server 2005 users will need to move from 6 to 7 first then upgrade to SQL 2005. David Campbell  a member of Professional Association for SQL declared in the SQL Magazine explain more about“

Build a Server on Dell.com to run SQL Server 2005 standart

There are two versions of SQL Server 2005 Standart Edition available: 32 and 64 bit. Depending on the size of business there are different configurations might be chosen. However, 64 bit edition is the most stable one, but it will need a more advance type of server. The requirements for SQL Server 2005 Standart Edition can be found on the following link:

SQL Server 2005 (64-bit)	Processor type1	Processor speed2	Memory (RAM)3
SQL Server 2005 Enterprise Edition 4 SQL Server 2005 Developer Edition SQL Server 2005 Standard Edition	IA64 minimum: Itanium processor or higher x64 minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support	IA64 minimum: 1 GHz IA64 recommended: 1 GHz or more x64 minimum: 1 GHz x64 recommended: 1 GHz or more	IA64 minimum: 512 MB IA64 recommended: 1 GB or more IA64 maximum: 32 TB Operating system maximum Minimum:512 MB x64 recommended: 1 GB or more x64 maximum: Operating system maximum

http://www.microsoft.com/Sqlserver/2005/en/us/system-requirements.aspx

If there is a company that wished to build a server for their business with SQL Server 2005 Standard edition on it Dell offers a Server customization. (www.dell.com)

In the selection for small businesses there is a section that allows to build server. After customizing if for the needs of your business, the prices may vary anywhere from 6,000-40,000$ or even more.

SQL Server 2005 with a server is an expensive solution but very needful for businesses that don’t want to lose their information. Because information is money in this world.

What are the advantages of Mixed authenitcation mode?

Mixed authentication is a mode that you are able choose for security levels. The windows authentication is a default mode that you can not disable. The SQL is less secure but usable to a large company. It all depends on what you want, more security use only the windows via a domain or SQL that is all online.

http://msdn.microsoft.com/en-us/library/ms144284.aspx

http://msdn.microsoft.com/en-us/library/aa905171(SQL.80).aspx

Installing MS SQL Standard Edition

We, my students and I, installed MS SQL this week and I thought of a few questions related to installing MS SQL?

Why not to use SQL 2005 Express?
Where can I find the hardware requirements for SQL 2005 enterprise edition?
How important is Raid 5 hard drive to SQL server 2005?
What is MySQL and why would you use it over SQL 2005?
What site would you use to troubleshoot SQL server install?
Can upgrade SQL 6 to SQL 2005?
What are the advantages of Mixed authentication mode?
What are the advantages of Windows authentication mode?
What does the MDF file extension mean?
Why use SQL 2005 Express?
Build a Server on Dell.com to run SQL 2005 Standard?
What is the newest version of MS SQL?
What is sysbase and why use it?
What is Oracle and why use it?

Why not to use SQL 2005 Express?

SQL 2005 Express has database size is 4GB, maximum RAM is 1GB, but enterprise has NO Limit. Partitioning enterprise is support for large-scale database. Also express don’t have online restore, but enterprise has online restore. While Express edition will install on a machine with multiple CPUs and more than 1GB of RAM it will not use the additional hardware. To increase the performance of express through additional CPUs and RAM you need to upgrade to Workstation, Standard or Enterprise edition.

SQL Server 2005 enterprise level features are not available in SQL Server 2005 Express Edition:

• Analysis Services (both OLAP and Data Mining)
• Integration Services (DTS successor)
• Notification Services
• Report Builder (although Reporting Services is included)
• SQL Agent
• Database Tuning Advisor
• Full-text search
• Log shipping

SQL Server 2005 Express Edition will also run on Microsoft Windows Server 2003 64-bit x64 Standard, Enterprise, or Datacenter edition with Service Pack 1 or later running in Windows on Windows. Server Express will only be able to have connections originating on the
local machine where SQL Server is installed.

What does the MDF file extension mean?

The question that I have been studying is “What does the MDF file extension mean?”.
I did some research and found 3-4 different meanings of the MDF file extension. The first one, it refers to a media disk image file which is .mdf file. CD or DVD data saved as a disc image by a disc authoring program. It is similar to an .ISO file.
The section one refers to a Measurement Data Format File, which is a standard file format, used by the automotive industry for storing measurement data.
And the last one, I would like to focus on is the SQL Server Database File. MDF stands for “Master Database File”. It is primary database file format used by Microsoft SQL Server, an enterprise-level databaseprogram; used for database files installed with SQL Server and related add-ons; custom MDF files may also be created by the user.
There are at least two types of SQL Server database files; .mdf and log files. The file that contains the database data has an .mdf file name extension—for example, AccountsReceivable.mdf is a data file.
Each data file has a corresponding log file that contains the transaction log. The log file has an .ldf file name extension. So, for example, the log file for our database would be named AccountsReceivable_log.ldf.
In conclision, Microsoft SQL Server uses the MDF extension for the Master Database File that tracks all the databases on a SQL Server.

Referrence
Wolter, R. (2005, November). SQL Server 2005 Express Edition User Instances. Retrieved January 13, 2010, from http://technet.microsoft.com/en-us/library/bb264564(SQL.90).aspx

What is MySQL and Why Would I Use It Over SQL 2005?

MySQL is a relational database management system like Microsoft SQL Server.   While it can do the same things the Microsoft product can, MySQL has a few advantages:

• Open Source
• Available on two-dozen platforms (32 and 64 bit) including Windows
• Pluggable Storage Engine Architecture
• Unique Query Cache

(Schumacher, 2008)

Personally, I would use MySQL for these reasons and because I know it is also a well accepted product, used by companies such as Google, Yahoo, and Facebook.

Reference

Schumacher, R. (2008). Why Move to MySQL from Microsoft SQL Server? Retrieved January 12, 2010, from MySQL: http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server.html