Full Trust European Hosting

BLOG about Full Trust Hosting and Its Technology - Dedicated to European Windows Hosting Customer

Europe SQL 2012 Hosting - HostForLIFE.eu :: Delete Duplicate Rows From a Table in MSSQL 2012

clock October 30, 2014 07:57 by author Peter

For every table, we tend to use a primary key or distinctive key for distinct values, however generally we'll encounter a problem with duplicate records. it's a significant issue with duplicate rows. thus we want to delete duplicate records to resolve it. So here i'll make an example to explain delete duplicate rows in MSSQL 2012 Hosting.

Example:
First we create a simple database with one table for membership that contains: a Member's ID, Membership type, Firstname,  Lastname and Birthday:
CREATE TABLE [dbo].[Membership](
[MemberID] [varchar](20) NOT NULL,
[MemberType] [int] NOT NULL,
[Firstname] [varchar](80) NOT NULL,
[Lastname] [varchar](80) NOT NULL,
[Birthday] [date] NOT NULL
) ON [PRIMARY]

Now, insert the following rows into this table:

INSERT INTO dbo.Membership (MemberID, Firstname, Lastname, MemberType, Birthday) VALUES
('001', 'Peter', 'Smith', 1, convert(datetime, '05/23/1988', 0))
INSERT INTO dbo.Membership (MemberID, Firstname, Lastname, MemberType, Birthday) VALUES
('002', 'Scott', 'Davidson', 1, convert(datetime, '07/10/1983', 0))
INSERT INTO dbo.Membership (MemberID, Firstname, Lastname, MemberType, Birthday) VALUES
('002', 'Scott', 'Davidson', 1, convert(datetime, '07/10/1983', 0))

INSERT INTO dbo.Membership (MemberID, Firstname, Lastname, MemberType, Birthday) VALUES
('003', 'Kevin', 'Richard', 1, convert(datetime, '04/24/1985', 0))

We currently have duplicated Scott Davidson’s entry (MemberID 2), with no clearly safe method of removing the duplicate, whereas leaving at least one entry intact. Now, imagine if you had a complete databse of information with a whole lot or thousands of duplicates. Fixing this by hand quickly becomes an impossible task!

To solve this, first we can add an column using the IDENTITY keyword so we currently have a unique method of addressing every row:
ALTER TABLE dbo.Membership ADD AUTOID INT IDENTITY(1,1)

We can then we can use:
SELECT * FROM dbo.Membership WHERE AUTOID NOT IN (SELECT MIN(AUTOID) _
FROM dbo.Membership GROUP BY MemberID)

Which will properly choose all duplicated records in our database (always worth checking before running the delete query!).  Once we are happy this is working for us, we can then run the delete query:

DELETE FROM dbo.Membership WHERE AUTOID NOT IN (SELECT MIN(AUTOID) _
FROM dbo.Membership GROUP BY MemberID)



SQL Server 2014 Hosting UK - HostForLIFE.eu :: How to Change Configuration Settings With sp_configure

clock October 23, 2014 08:03 by author Peter

I was recently asked where to go in Configuration Manager to vary the settings for xp_cmdshell on MSSQL 2014 Hosting. it was then that i spotted that the existence of sp_configure is maybe not universal data. I used to be actually afraid. for a few reason I had thought that DBA’s were born with this data. As this seems to not be the case, I felt it might be an honest plan to allow sp_configure a quick run through. Note: This keep procedure modifies system settings. Make certain you understand the setting that you're changing and the need for the change before you creating it.

The system keep procedure sp_configure is used to view or modify variefty of various system settings. These settings will include the default MAXDOP for the server, whether or not SMOs is enabled, whether xp_cmdshell is enabled and an extended list of others. to urge a whole list you'll either question sys.configurations or run sp_configure with no parameters.

Why is that the list from sp_configure shorter than the list on sys.configurations? If I will modify xp_cmdshell victimisation sp_configure. Some configurations are thought-about Advanced. If you would like to see them you may need to change the setting show advanced choices (using of course sp_configure).
EXEC sp_configure 'show advanced options', 1
RECONFIGURE

The Reason why you're adding during this RECONFIGURE command, because sp_configure solely changes the configured value. RECONFIGURE updates the running value with the configured value (there are some exceptions wherever a reboot or instance restart is required). thus in order to actually modification the currently running configuration value you have got to use each commands. as luck would have it RECONFIGURE checks that the configured value is valid before setting it because the running value.

If you're fully bound you recognize what you're doing and want to update one of the configuration values with one thing outside of its allowed vary you'll be able to embrace the WITH OVERRIDE choice of the RECONFIGURE command. So here’s the factor, if you're aiming to be administrating SQL Server you would like to have at least a passing familiarity of the sp_configure and RECONFIGURE commands and a reasonable idea of what settings they modify.



European HostForLIFE.eu Proudly Launches PrestaShop 1.6 Hosting

clock October 16, 2014 09:20 by author Peter

HostForLIFE.eu, a leading Windows web hosting provider with innovative technology solutions and a dedicated professional services team, today announced the support for PrestaShop 1.6 Hosting plan due to high demand of PrestaShop 1.6 users in Europe. HostForLIFE.eu hosts its servers in top class data centers that is located in Amsterdam, London and Seattle (US) to guarantee 99.9% network uptime. All data center feature redundancies in network connectivity, power, HVAC, security, and fire suppression. All hosting plans from HostForLIFE.eu include 24×7 support and 30 days money back guarantee.

PrestaShop 1.6 is a free and open-source e-commerce web application, committed to providing the best shopping cart experience for both merchants and customers. It is written in PHP, is highly customizable, supports all the major payment services, is translated in many languages and localized for many countries, is fully responsive (both front- and back-office), etc. PrestaShop 1.6 offers new and improved navigation elements making navigating your online shop easier and more effective than ever.

PrestaShop 1.6 presents a comprehensive, intuitive user administration panel, and gives you hundreds of standard functions that can be adapted or personalized in order to respond to all of customer needs. The front office template on PrestaShop 1.6 is now mobile responsive, allowing customer online shop to display perfectly when accessed from a mobile and tablet device.

At the forefront of the latest innovative web technology, PrestaShop 1.6 integrates with Bootstrap 3.0, FontAwesome, Sass Compass and D3 Data Driven Documents. Online Shopping has never been so technologically brilliant. A unique e-commerce feature you will only find in PrestaShop 1.6, Net Profit Margin is automatically updated in real-time.

Further information and the full range of features PrestaShop 1.6 Hosting can be viewed here http://hostforlife.eu/European-PrestaShop-16-Hosting

About HostForLIFE.eu
HostForLIFE.eu is an European Windows Hosting Provider which focuses on the Windows Platform only. HostForLIFE.eu deliver on-demand hosting solutions including Shared hosting, Reseller Hosting, Cloud Hosting, Dedicated Servers, and IT as a Service for companies of all sizes.

HostForLIFE.eu is awarded Top No#1 SPOTLIGHT Recommended Hosting Partner by Microsoft (see http://www.microsoft.com/web/hosting/HostingProvider/Details/953). Their service is ranked the highest top #1 spot in several European countries, such as: Germany, Italy, Netherlands, France, Belgium, United Kingdom, Sweden, Finland, Switzerland and other European countries. Besides this award, they have also won several awards from reputable organizations in the hosting industry and the detail can be found on their official website.



Joomla 3.4 Hosting UK - HostForLIFE.eu :: Joomla 3.4 Overview

clock October 9, 2014 12:12 by author Peter

Joomla 3.4 Hosting UK focuses on 4 main new features, though most average users will only be able to notice 3 of them. The main idea of this release is not to extend Joomla, but to begin the transition to the new release cycle and provide core improvements in the Joomla package. Joomla 3.4 Hosting are going to begin the process of creating a lightweight and powerful application which can be adapted easily for a variety of use cases. In the 3.4 release, the PLT aims to begin working on creating a lighter core distribution and establish a workflow for providing optional extensions outside the main distribution by removing com_weblinks from the core distribution.

Joomla 3.4 Features

1. De-couple weblinks from new installs – Joomla 3.4 includes the first de-coupling of an extension package. The weblinks component and all associated modules and plugins will be removed from the default installation.
2. Composer Integration - Composer is a dependency manager. You will be able to instruct Composer to pull in all the required extensions you need in your site using a single JSON file.
3. Continue Microdata Implementation - Joomla 3.4 will improve the microdata added in 3.3 by adding in additional flexibility to the newly added microdata library as well as providing greater integration with core layouts.
4. Front-end Module Editing - this release will include module editing from the front-end based on the standard Joomla ACL settings.



HostForLIFE.eu Proudly Launches Hosting with SiteLock Malware Detector

clock October 6, 2014 06:23 by author Peter

HostForLIFE.eu, a leading Windows web hosting provider with innovative technology solutions and a dedicated professional services team, today announced the support of SiteLock Malware Detector on all their newest hosting environments. HostForLIFE.eu Hosting with SiteLock Malware Detector plan starts from just as low as $36.00 / year only and this plan has supported daily malware scan, trust seal, application scan, TrueSpeed CDN, etc.

HostForLIFE.eu offers the greatest performance and flexibility hosting with SiteLock Malware Detector at an economical price. HostForLIFE.eu provides flexible hosting solutions that enable their company to give maximum uptime to customer. SiteLock monitors your website 24x7 for vulnerabilities and attacks, which means you can worry less about your website and more about your business.

SiteLock is a cloud-based, website security solution for small businesses. It works as an early detection alarm for common online threats like malware injections, bot attacks etc. It not only protects websites from potential online threats, but also fixes vulnerabilities. With the presence of SiteLock, your website will be protected and scanned against viruses, spyware, malware, identity theft and other online scams. Note that, as they rely more and more on internet technology, these online viruses and scams become bigger and smarter to handle.

Over 70% Customers look for a sign of security before providing personal details online. The SiteLock Trust Seal not only re-assures customers, but also boosts sales. The customer doesn’t need technical ability to install and set up SiteLock for their website. SiteLock is cloud-based and starts scanning website and email instantly.
With this SiteLock feature, you can be assured that you will always be one step ahead of online hackers and swindlers’ illegal intentions. With more than 6 years in the web hosting business, HostForLIFE’s technical staff is more than ready on its feet to develop and tackle viruses, malware and the likes to sustain the safe and reliable use of your website.

Further information and the full range of features hosting with SiteLock Malware Detector can be viewed here http://www.hostforlife.eu/Hosting-with-Sitelock-Malware-Detector-in-Europe



European Drupal 7 Hosting - HostForLIFE.eu :: How to Fix Bootstrap Theme Error on Drupal 7

clock October 2, 2014 08:27 by author Peter

I installed Bootstrap Framework theme on Drupal 7 hosting site and enabled it to be my default theme. I noticed my firebug printing errors on my console and all my .js related features are disabled after the page reload,  which I started to suspect on my jQuery file version and eventually I confirmed that version of my file is the culprit.  Drupal 7.x installation comes with the jquery version 1.4.x but as per date 05/2014 it is version 1.11.x so obviously you know why you get that error! And here’s the step how to Fix How to Fix Bootstrap Theme Error on Drupal 7:

1. The preferred method to accomplish this task is to install the jQuery Update module. If using jQuery Update, you must also configure the jQuery Update setting to the appropriate version after it is installed. You must configure (admin/config/development/jquery_update) the version you need to make use of. Selecting from cdn i.e(jquery, google) will fix the error for sure, if not follow the other steps down.
2. Install Libraries API module and enable it , Install Bootstrap Libraries module and enable it.
3. Then download the latest version of bootstrap files from http://getbootstrap.com/ and extract the files in sites/all/libraries directory by renaming the folder “bootstrap”

4. Make any configurations you need in the page /admin/config/development/bootstrap_library and click save

The steps above will override all the old/existing jquery version and will be compatible with your bootstrap files.



About HostForLIFE.eu

HostForLIFE.eu is European Windows Hosting Provider which focuses on Windows Platform only. We deliver on-demand hosting solutions including Shared hosting, Reseller Hosting, Cloud Hosting, Dedicated Servers, and IT as a Service for companies of all sizes.

We have offered the latest Windows 2012 Hosting, ASP.NET 4.5 Hosting, ASP.NET MVC 4 Hosting, and SQL 2014 Hosting.

Free ASP.NET Hosting - Europe

Tag cloud

Sign in