Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Popular Tags...

Tags

SnowCovered Top Sellers

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

Installing SQL Server 2008


The new release of Microsoft SQL Server 2008 has been announced in August 2008. This version of SQL Server provides powerful new capabilities that were developed with the customer in mind. SQL Server is considered the leading database platform in both scalability and performance. SQL Server 2008 is available in the following versions:
  • SQL Server Compact Edition (SQL CE) – This is a free tool that should be considered as a perfect solution when building a stand-alone application that occasionally connects to a database.
  • SQL Server Express Edition – Another tool that is free for development and database deployment. It includes SQL Server 2008 and SQL Server 2008 Reporting Services.
  • SQL Server Workgroup Edition – This version is for companies that have remote offices and require local data instances.
  • SQL Server Standard Edition – According to Microsoft's website, this solution is suggested for small to medium scale online transaction processing applications.
  • SQL Server Enterprise Edition – This version allows you to consolidate many servers and operate large scale databases.
  • SQL Server Developer Edition - It has the functionality of the Enterprise version but can be used only for developing and testing applications.
  • SQL Server Web Edition – This version should be picked up when working with Internet applications. It includes new integration features in the .NET Framework.


Here are basic requirements for SQL Server 2008 installation:

Name

Requirement

Procesor

Minimum: 1.0 GHz, recommended: 2.0 GHz or faster

Operating system

Windows XP, Windows XP Media Center, Windows Server 2003,Windows Vista, Windows Server 2008

Framework

.NET Framework 3.5 SP1

Memory

Minimum: 512 MB Recommended: 2GB

Hard drive free space

Minimum 2 GB


Hard drive space usage may vary depending on type of server and size of databases.







SQL Server 2008 delivers on the Microsoft data platform vision by enabling organizations to run their most mission-critical applications while lowering the cost of managing the data infrastructure and delivering insights and information to all users. SQL Server 2008 (code named Katmai) includes following improvements :

· Transparent Data Encryption  TDE works at the file level with 5 different security level. It gives ability to encrypt the whole database.

· Backup Encryption  Provides very efficient way of encryption during backup process.

· External Key Management   Enables separating keys from data.

· Auditing  Monitoring of data access.

· Data Compression   Comparing to SQL SERVER 2005 we can find improvement of performance in that area

· Hot Plug CPU   Allows to Add CPUs on the fly.

· Performance Studio  Group of tools that provides server monitoring.

· Dynamic Development   Includes ADO and Visual Studio options.

· Entity Data Services   Line Of Business (LOB) framework and Entity Query Language (eSQL)

· LINQ   Development query language for access multiple types of data such as SQL and XML.

· Data Synchronizing  Development of frequently disconnected applications.

· Dates and Times   New data types:  Date, Time, Date Time Offset.

· File Stream   New data type VarBinary(Max) FileStream for managing binary data.

· Table Value Parameters   The ability to pass an entire table to a stored procedure.

· Spatial Data   This is data type for storing Latitude, Longitude, and GPS entries.

· Full Text Search   Microsoft has implement Native Indexes with thesaurus as metadata

· Reporting Server   Improved memory management.

· SQL Server Integration Service   Improved multi-processor support and faster lookups.

· MERGE   TSQL command combining Insert, Update, and Delete.

· SQL Server Analysis Server   Stack improvements, faster block computations.

· Resource Governor   It provides ways of restricting users from getting to many resources for their process.

· SQL Server Reporting Server   New version provides better memory management.

· Microsoft Office 2007   Allows the use of OFFICE document as an SSRS template and provides direct SSRS to WORD export.

 

There are two very interesting features (from a developer perspective). For a long time, developers wished that they could pass a table variable as a parameter to stored procedure. In my opinion, this will be one of the more integral tools for the developer in SQL Server 2008.


The second important aspect is multiple INSERT,UPDATE,DELETE usage. The purpose of the MERGE statement is to provide to the developer ability to construct TSQL data-manipulation language (DML) query in which DELETE ,UPDATE, or INSERT can exist in the same instruction depending on different criteria. In my personal opinion, this is a very good idea that will save a lot of time. The possibility to run multiple queries in one statement provides developer tools that can achieve the same result with less coding and increased performance. In addition, there is another great aspect that has been added in MYSQL SERVER 2008 to the INSERT function. Developer can now insert multiple rows without running a SELECT instruction with INSERT as statement source. Instead, the VALUE result of the INSERT instruction may be used to describe the set of values, separated by commas.


Installation


The first step of SQL SERVER 2008 installation is obtaining the correct version. In the following sample I will try to demonstrate how to download and install MICROSOFT SQL SERVER 2008 ENERPRISE EDITION – TRIAL. First of all go to :

http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx



 

You can download and use fully functional 180-day version from Microsoft site. After you choose the version that meets your requirements, you are able to choose language and edition. The following editions are available :

  • X86
  • X64
  • IA64


There is also a way to register and obtain DVD with installation files but it’s limited to a few countries.




In the following sample we decided to download the trial version. Microsoft requires to log in to Microsoft Technet. If you don’t have an account, you can create one for free.







After providing the correct login and password, you should be able to download files :


 

Files can be downloaded in two formats.  The first option is as a DVD image.  This one is recommend if you are going to burn image into DVD and then proceed with installation. Second option is self-extracting file.







In the next step, a small guide through main installation of SQL SERVER 2008 will be presented. On the first screen, we need to choose the distribution system. Most users should pick up option nr 1 : “New SQL SERVER stand-alone installation in non-clustered environment or to add features to an existing SQL SERVER 2008 instance” .







Installation agent will perform some checking to make sure that operating systems meet minimal requirements (that involves restarting operating system ).


 


After that step is completed, the product key will be required. You can omit this step if you are going to use trial version.





Please read license terms carefully. This is very important as there is one difference between trial and full version. You won’t get any support from Microsoft.






Another testing will be performed by installation agent :







Next step is quite important as we need to provide instance name. This is the name of the service that will be shown in system panel . I suggest to resign from default name and use custom one.







Our journey is coming closer and closer to the end.  At this moment we need to provide some security settings for each of the service that we are going to install. There are two ways of going through this step :

  1. Provide the same user account for each service
  2. Create separate accounts for each service



The choice depends on security settings on server. Usually using one account with appropriate settings is enough.






We should proceed with another part of setup and decide which way of authentication to choose. For testing purposes, I believe that Windows authentication is definitely enough.






For each of services like Analysis Service or Reporting Service, you need to provide the user that will have full administrative rights to that service. You can set up many administrator and restrict access to specified folder.





The Reporting Service can be set up in three ways :

  • default configuration -- recommended for standard users
  • share point integration -- setup will use default settings to integrate Report Services with SharePoint
  • installation without any configuration






Microsoft allows user to report errors directly to Microsoft customer service. As we are going to test only trial version there is no sense to use this option.






Next step generates some rules for setup application.


 


Now we are in the final part. 10 to 30 minutes and setup is finished.

 


Installation is complete.






Important features for system administrators :

  • DMF – Microsoft has implemented the Declarative Management Framework (DMF) in SQL SERVER 2008.
    • DMF can be considered as a security framework that provides policy-based management for one or more SQL Servers. The Framework consists of three components: policy management, policy creation and explicit administration.
    • In my opinion, the most important aspect of DMF is letting administrators enforce Policy across many servers In the Network. Changes can be applied to different machines simultaneously. That saves time and reduces number of errors and conflicts.
  • Performance – You can find many new tools prepared for managing and improving performance of SQL database. There are new metrics for collecting performance data. Notice also that there is a centralized repository for storing performance info. That makes planning and measuring performance easier, especially when working in a multi-database environment.
  • Compression - SQL Server 2008 offers two ways of handling compression : row-level compression or page-level compression. Both can be enabled on at the partition-level or at the table-level for all partitions.
  • Resource Governor – another interesting feature that might help controlling utilization of resources. This tool allows defining priorities and limits for different kind of jobs. Such kind of approach gives possibility to run multiple jobs without worrying about resources.


Working as DB-Admin you will probably enjoy many of the features mentioned above, mostly enhancements that will make our life easier! Improvements like Resource Governor or performance boost make SQL SERVER 2008 most powerful database Server.

 

 

Share the page?

Installing SQL Server 2008 - share this page - email email - del.icio.us del.icio.us - digg digg - reddit reddit

Feedback Comments

Feedback

SharePoint Web Parts


All Data Springs Web Parts Support WSS 3.0, SharePoint 2007, and SharePoint 2010 Frameworks

Please select license option for each web part you wish to purchase. We highly recommend the SharePoint Bundle to get all Data Springs Web Parts for maximum value!

 

 

      
Cart


Data Springs Sharepoint Bundle

Best Value! The Bundle gives you all 5 web parts in one package at a very attractive price! Best Value! We think you will be very happy with the SharePoint bundle and great price discounts you will receive. With your purchase all of the web parts below will be included.
 
 
 
 

Random Image Web Part

With Random Image for Sharepoint 2007, you can select multiple images to display randomly when the web part loads...
 
 
 
 

Stock Quote Web Part

Giving your site visitors relevant information is critical. With the Data Springs Stock Web Part you can provide your users with up to date financial information
 
 
 
 

Dynamic Image Rotator Web Part

Who would have thought? Adobe Flash® with Sharepoint! The FIRST and ONLY image rotation web part for Sharepoint using Flash Technology from Adobe! The Dynamic Image Rotator displays selected images and then rotates between the images. Several extended and optional features allow you to select the time to rotate each image, fade between
 
 
 
 

SharePoint Charts Web Part

The MOSS Chart Web Part is a web part built by Data Springs for the purpose of rendering several chart types based on data from a SharePoint list on a MOSS 2007 or WSS 3.0 Site
 
 
 
 

Dynamic News Ticker Web Part

Provide current news items with a user-friendly news ticker for your Sharepoint Portal. With millions of web sites offering information you need a fun way to display information and the solution is Flash News Ticker....
 
 
 
 

Tailored Text Web Part

 Tailored Text Web Part allows you to add text/html to your web site that can be different for anonymous users, registered users,  and even individual users specifically.

 
 
 
 

Dynamic Views Web Part

Dynamic Views is an excellent tool to:
Personalization allows you to go the extra mile in communicating or connecting one to one with your clients. When it comes to technology and web site content, you now have the power to leverage this personalization directly with your users on your DotNetNuke® site

 
 
 
 

Dynamic Login Web Part

Your site content isn't vanilla, so why is your portal's login?

Add pizazz and functionality with Dynamic Login! Use custom templates, localization, redirection rules for various roles and many more features!
 
 
 
 


DNN Modules

DotNetNuke Modules


Data Springs offers cost-saving packages that fit your needs:

Purchase the Collection 6.0

Data Springs Collection 6.0

An entire tool chest to quickly build websites and construct complex, powerful, and relevant workflow. Elevate your design with custom registration, forms, displays, reports, user management, payments, Google maps,, SQL updates, and so much more!

Best Value!  Includes all DotNetNuke modules by Data Springs.

$ 495.00

Data Springs User Management Suite 3.0

All the tools you need to enhance user & profile management from A to Z!.  A comprehensive package with 5 feature-packed modules that offer extensive admin controls and easy user interface geared towards an effective and growth-oriented site!  .... more

 

Includes:  Dynamic Registration     Dynamic Login   ♦   Interactive User Import     Dynamic User Directory   ♦   Renewal Reminder    A value of more than $630.00!

 $ 369.00

 

 

Check out all our individual modules!

 

 View Dynamic Registration

Dynamic Registration 5.0 (new release on 6/12/2013)

Need custom fields and workflow for your registration? Get all the power and ease of use to create the registration and profile management just the way you want it... more

$ 199.00

View Dynamic Forms

Dynamic Forms 4.1 (released 5/16/2012)

Whether it's for marketing, sales, contact forms, scheduling, information requests, surveys, or to simply better understand your customer needs, the possibilities for creating powerfully effective forms are now easy and endless! ... more

$ 195.00

 

Dynamic Views 3.1 (new on 2/7/2013)

Now have an easy yet feature-rich reporting module with custom defined display templates and unlimited search options from  Dynamic Forms or any data source like a table, view or custom query!  ... more

$ 169.00

 View Dynamic Login Module

Dynamic Login 4.1 (released 10/19/2011)

Add pizazz and functionality to your site login! Dynamic Login gives you custom templates, localization, redirection rules, SQL Validation, and Single SignOn. Want more? How about Facebook Connect, LinkedIN, and Twitter, too? Your login has never been so exciting!.   ... more

$ 149.00

 View Interactive User Import

Interactive User Import 3.0 (released 8/17/2011)

Interactive User Import provides you with the functionality to easily and quickly import users into DotNetNuke and Dynamic Registration, through a streamlined and well-documented wizard that includes many advanced features... more

$ 149.00

 View Dynamic User Directory

Dynamic User Directory 4.1 (released 4/26/2012)

The perfect compliment for extending your portals users and community! An essential ingredient for managing dynamic user information, is being able to sort key fields and create useful user directories and custom report information... more

$ 179.00

 View Renewal Reminder

Renewal Reminder 1.3

Renewal Reminder provides you with the functionality to setup email notifications for users that their security role will soon expire. After installing your renewal / security role reminder module you can now setup scheduled notifications to be distributed to your users... more

$ 129.99
 View Opt In Email

Opt In Email 5.0 (new on 4/17/2013)

'Relationship Building' and 'Communication' are two essential nuts and bolts for a business to prosper. This module allows you to bridge both of these and easily generate continuous awareness of your web site, products and services. Your prospects and customers will greatly appreciate this feature... more

$ 179.00

 View Tailored Text

Tailored Text 3.0

Personalization allows you to go the extra mile in communicating or connecting one to one with your clients. Leverage the power personalized content on your DotNetNuke site... more

$ 109.99
 View Stock Quote

Stock Quote 1.2

Giving your site visitors relevant information is critical. With the Data Springs Stock Module you can provide your users with up to date financial information... more

$ 109.99
 View Presentation Archive

Presentation Archive 2.0

With so much content on your web site, its important to give users an easy method for finding and retrieving content. Presentation Archive allows you to categorize, organize and present content within your DotNetNuke site for presentations, educational material, videos, and almost any document... more

$ 124.99
 View Real Estate

Real Estate 2.3

Real Estate 2.3 is a feature rich and user-friendly module that allows your portal users the ability to create real estate listings on your site... more

$ 149.99
 View Dynamic Image Rotator

Dynamic Image Rotator 3.3

Dynamic Image Rotator displays selected images and then rotates between the images using the Adobe® Flash® platform.  Several extended and optional features allow you to select the time to rotate each image, fade between images, and also display the images in either sequental or random order... more

$49.99
 View Info Pics Gallery

Info Pics Gallery

The Info Pics Gallery Module allows you to display thumbnail pictures with information to the user about each picture, along with a detailed description regarding the set of pictures and several other optional links... more

 $ 69.99
 View Testimonials Module

Testimonials

The Testimonials Module allows you to display customer testimonials on your site, as well as an easy method for users to submit testimonials about your web site, services, or products... more

 $ 49.99
 View Dynamic Info Cube

Dynamic Info Cube

Take your web site out of the box! Looking for a creative and interesting way to showcase information and content on your site? With millions of web sites offering information you need a fun way to display information and the solution is Dynamic Info Cube... more

$ 99.95
 Search Engine Optimization Cloud Module for DotNetNuke

Dynamic Tags

Nearly every web site developer would agree that search engine optimization is one of key aspects to a successful web site. Part of search engine optimization requires providing search engines that crawl your web site with appropriate and meaningful content... more

$ 69.99
 View Page Tags

Page Tags

'Page Tags' pulls in search terms that users searched to find the current page. There are many benefits to displaying these search words that delivered the user to the site, find our more details ... more

$ 59.99
 Random Rounded Images

Random Rounded Images

Random Rounded Images is an easy to use upgraded version of the images module included with DNN. With RRI, you can select multiple images to display randomly when the module loads. For example, you can add 10 images to the module, and each time you refresh or load the page one of those images will... more

$ 49.99
 View Back on Track

Back on Track

Giving your site visitors fast access to areas of interest is vital to your web site's ease of use and ultimately - sales potential... more

$ 99.99
 

Dynamic News Ticker 2.0

Dynamic News Ticker allows you to scroll through news items in a horizontal or veritical direction with administrative features that allow you to easily customize the look of your news ticker. Each instance of Dynamic News Ticker can be set up to have different sizes, scroll directions, scroll speed... more

$ 39.00
 View Quick Poll

Quick Poll

Give your users a voice, while also providing an important way for you to gather opinions from your users and measure visitors' responses to questions on your site! Polls are significant because they can provide a way for your web site visitors to share ideas and vote on topics of your choosing... more

$ 39.99
 View Flash Contacts

Dynamic Contacts 2.0

Dynamic Contacts is the fastest and easiest way you can help visitors of your website connect with your key personnel... more

$ 79.99
     

 

 

 
 

Join our mailing list...

Get current news and events the easy way
 
 
   
Subscribe Me

Recent Blogs...

 
Copyright 2005 - 2011 by Data Springs, Inc.