Posts Tagged ‘mssql server’

SQL Server Professional Accreditation

Saturday, January 15th, 2011

Will you get benefits from the newest easy to get SQL server professional accreditation?

In my opinion the very best DB platforms are Microsoft and Oracle. I have come to find that MySQL is widely used in start-up companies and DB folks who know this platform will make higher salaries, but I honestly rarely ever encountered MySQL in job searches.

One reason I prefer MS SQL Server is because it also includes the SSRS BI platform that is powerful and popular. DB people who know SSRS (SQL Server Reporting Services) have become very sought-after candidates in many companies. Generally, companies end up having to buy licenses for third-party BI (Business Intelligence) applications which often can cost a lot of extra money.

With SQL Server, BI and ETL (extract, transform, load) tools come with the first license. I know that maybe the interest in databases is primarily to understand DB construction, however , you can’t predict when or if you choose to branch out and get more information.

The advantage of SQL could be that the language itself is fairly universal. I say fairly because each vendor has added their own functions and syntax. Microsoft and Sybase both use T-SQL, Oracle uses PL/SQL and MySQL uses ANSI-SQL. Ultimately that which you learn on one platform can be used on other platforms.

Becoming a SQL Server Microsoft Certified Master (MCM) is a small task now. Lower than 1 percent of certified professionals hold a Master certification, and for good reason: In addition to having difficult minimum competencies (Five years SQL Server experience and deep knowledge in all aspects of SQL Server), practicing a SQL Server MCM has always come at a significant cost. In fact, that cost has been about $18,500, when you accumulate the necessary three week training and four exams.

The SQL Server MCM certification is the highest technical certification that Microsoft offers to SQL Server professionals. It’s suitable for those that have five years of hands-on SQL Server experience in critical environments. Competencies include designing and implementing high-performance, scalable enterprise environments and troubleshooting the most challenging SQL Server issues.

Well, at PASS (The Professional Association for SQL Server) this week, Microsoft announced all that is beginning to change. According to the company, the changes are in response to requests from experienced SQL Server professionals who want to earn MCM’s but (go figure) don’t have $18,500.

Now, candidates can earn the certification by passing just two exams: the four-hour Knowledge Exam, along with a six-hour hands-on Lab Exam, that is obtainable in early 2011.

Fortunately, Microsoft has made some significant changes for the program, including:

  • The 3-week in-person training has stopped being required. So, if you feel like you have what it takes, it is possible to march right up and consider the certification exams. You pay the expense of the exams, which can be about $2,500.
  • Nowadays there are only two exams rather than four: 88-970 (Knowledge Exam) and 88-971 (Lab Exam).
  • To aid SQL Server professionals prepare for the exams at a lower cost, Microsoft now offers some free MCM videos.

So you? Do you consider the brand new MS SQL Certification can help you in your job?

About the author: Michele P. Rouse is writing for the sql certification training blog, her personal and non-commercial in nature hobby blog aimed at recommendations to offer free info for data base beginners/professionals to help them find a new profession.

Related Posts:

Microsoft SQL Server Hosting

Saturday, February 13th, 2010

Microsoft SQL Server is Microsoft’s enterprise class database system and is designed for large businesses that are running database intensive applications and require a reliable and secure database hosting environment. Microsoft SQL Server is one of the most scalable database servers available meaning that it will be able to cope with a large number of queries at once, making it the ideal backend for some of the internet’s largest websites. Although there is a free version of Microsoft SQL Server available, the Express edition, in order to make the most of what Microsoft SQL Server has to offer over other traditional database servers you will need to pay for a higher-level edition of the application that doesn’t include any limitations.

What are the advantages of using Microsoft SQL Server?

Microsoft SQL Server is a highly reliable database application that can be deployed in a number of different circumstances but is usually the preference of larger businesses. Some of the advantages of using Microsoft SQL Server include:

  • Classic ASP and ASP.NET support – Microsoft SQL Server databases will work with and can be integrated with classic ASP and ASP.NET scripts very easily since both applications have been developed by Microsoft – this means that if you want to develop a highly scalable web application using Microsoft technologies then an MSSQL/ASP.NET combination will be able to provide you with the tools and platform that you require to develop such a web application
  • Scalability – Microsoft SQL Server is also a highly scalable database application meaning that it can be used in environments where constant contact with the database server is going to be required – this means that you should use a Microsoft SQL Server database as the backend of any busy web applications you may be planning, but it is also for this reason that Microsoft SQL Server is used internally by many large businesses – in order for the database server to be as scalable as possible you should consider having Microsoft SQL Server installed on a high specification Windows dedicated server
  • Secure – using an SQL based database server such as Microsoft SQL Server will allow you to ensure that the contents of your database is secure and that the chances of a hacker gaining entry are minimal – high end database applications such as Microsoft SQL Server use several different layers of security and user authentication to ensure that it is impossible for hackers to gain entry, and on top of that the database itself is going to be password protected meaning that for hackers to stand any chance of viewing the contents of the database they will need to know the password.

The advantages of using Microsoft SQL Server show that it is a system highly recommended for Windows web developers who wish to build dynamic classic ASP and ASP.NET based web applications.

What are the disadvantages of using Microsoft SQL Server?

Microsoft SQL Server is designed for use by larger businesses that have a distinct need for a reliable database system, but you may still face disadvantages when using Microsoft SQL Server. Such disadvantages could include:

  • Price – in order for Microsoft SQL Server to be effective you will need to purchase one of the premium editions of the software so that you won’t have any limitations when using the database server – any version of Microsoft SQL Server above the free ‘Express’ edition will cost you quite a bit of money and this is why Microsoft SQL Server is generally marketed at businesses rather than individuals
  • Complexity and management – Microsoft SQL Server can be quite a complex system to manage meaning that if you are going to be deploying it centrally within your business, you should consider hiring experienced systems administrators who will do a professional job of managing your Microsoft SQL Server databases – if you leave the management to an inexperienced individual then you run the risk of compromising the security of your Microsoft SQL Server databases as well as the reliability of the hosting server.

In conclusion, Microsoft SQL Server is a powerful database application that can provide businesses with many advantages when develop web applications for use in busy environments. Microsoft SQL Server can also be used as the database backend for desktop applications when used in a business hosting environment.

Related Posts:

Windows Hosting

Sunday, December 20th, 2009

There are two operating systems/platforms used by a large number of web hosting providers, these being Windows and Linux. Whilst Linux is the cheaper alternative because it is open source, Windows can provide businesses which a highly reliable and scalable web hosting environment when setup correctly. Windows is a commercial operating system, which means that Windows web hosting services are going to cost more than Linux web hosting services, regardless of the form of web hosting you choose to go with. Windows web hosting services are generally there for those who have a specific need for Windows web hosting, such as if you are going to be hosting a website that has been developed using classic ASP or ASP.NET.

What can Windows hosting offer me that Linux hosting can’t?

Although Windows and Linux are able to offer the same feature set to an extent, there are many differences between the two hosting platforms and what they are able to offer higher level users. A Windows hosting service will be able to offer you the following over a Linux hosting service:

  • Support for classic ASP and ASP.NET – classic ASP and ASP.NET are both popular scripting frameworks that have been developed by Microsoft, although ASP.NET is the only one of the two which is still in active development – both are hugely popular but since they have been developed by Microsoft, scripts and web pages developed using either will only function correctly on Windows hosting services
  • Microsoft Access and Microsoft SQL Server – these are the two main database applications that can be used in a Windows web hosting environment, and since Microsoft Access and Microsoft SQL Server have both been developed by Microsoft they are commercial products which means that databases created using either won’t function correctly on Linux hosting packages
  • Microsoft specific applications and services – there are specific applications developed by Microsoft, which will only work on Windows servers but are used by a large number of web hosting providers – such applications include Microsoft Exchange Server and Microsoft Sharepoint.

You should only consider Windows hosting over Linux hosting if you have specific requirements that somehow fall into one of the categories noted above.

What are the disadvantages to using Windows hosting?

You will find with any web hosting services that there are going to be disadvantages somewhere in the pipeline, and the main disadvantages that you may find with using Windows hosting may include:

  • Pricing – the cost of Windows hosting services can be off-putting to some users, but it is important to consider the advantages that you will receive from using a Windows hosting service – especially if your requirements dictate the need for a Windows web hosting package
  • Reliability and uptime – the reliability and uptime of Windows web hosting services can also be a disadvantage in some cases since the way in which the Windows operating system works does prevent some web hosting providers from being able to offer a reliable service to their Windows hosting customers
  • Platform limitations – sometimes there are limitations to using the Windows platform which means that Windows hosting services aren’t suitable for everyone, but for the most part you should be fully aware of what you require from your chosen web hosting package.

You should make sure that a Windows hosting package is the right form of web hosting for you prior to purchase any web hosting service since you want to be sure that you are buying something which you will be able to make full use of.

In conclusion, Windows hosting services are best suited to businesses who have a specific need for a Windows web hosting package – individuals may not find Windows hosting services so useful unless they are web developers who require a Windows hosting environment for testing. Although you may be put off from using Windows hosting due to the disadvantages, in reality you will find that you won’t really have any choice but to use a Windows hosting package if you are considering one; however, in some situations you may be able to find a more beneficial solution which will allow you to use a Linux hosting package over a Windows hosting package.

Related Posts: