About Microsoft SQL Server

Microsoft SQL Server (MSSQL) is a relational database system developed by Microsoft. Its primary purpose is to store and retrieve data as requested by applications (standalone applicatiosn, webservers, etc).

MSSQL has the ability to incorporate programming language and database manipulations with a method called Embedded SQL. These embedded Transact-SQL statements are written with source code of the different languages. SQL preprocessors take over the SQL statements then send them to the code library. Then the host compiler processes the output. Allowing the programmer to embed SQL statements into programs.

Securing SQL Server is very important. With today's technology and the advancement of this technology the better the hackers and crackers are. This starts with limiting access to the server and hardware components. Next service packs and upgrades are installed. Firewalls are implemented to implement security. Components that are not used should be disabled. Always give people that need access the minimum access required.

Web databases are is designed to be access from the web. The web is usually where it is also managed. Site operators can be assigned to the access the data and get results of online activity. Web forms are used to look up data and update the data. Sometimes it is used to delete the data. Security is important because with the right permissions anyone can change the information.

To manage SQL Server reports, reporting services allow a user to use tools or services to manage reports, create reports, and deploy reports. This helps with organization and programming which allows the user to maintain functionality of reporting.

These reporting services manage, deliver reports, and create with a set of tools with allow data to be customized to the application. These reporting service tools work with other Microsoft products like Microsoft Visual Studio. A user can create graphical reports, interactive reports, tabular reports, or free form reports from data sources such as relational, XML, and multidimensional. Then reports on demand can be published, secured, or accessed.

Reporting Services also enables you to create ad hoc reports based on predefined models, and to interactively explore data within the model. You can select from a variety of viewing formats, export reports to other applications, and subscribe to published reports. The reports that you create can be viewed over a Web-based connection or as part of a Microsoft Windows application or SharePoint site. Reporting Services provides the key to your business data.

Common versions of Microsoft SQL

  • SQL Server 2000
  • SQL Server 2000 64-bit Edition (released in 2003)
  • SQL Server 2005
  • SQL Server 2008
  • SQL Azure DB
  • SQL Server 2008 R2 (released in 2010)
  • SQL Server 2012