Windows 2012 Hosting - MVC 6 and SQL 2014 BLOG

Tutorial and Articles about Windows Hosting, SQL Hosting, MVC Hosting, and Silverlight Hosting

Windows Hosting - :: Tips Solutions to Create Partition on Server 2003/2008/2012

clock September 5, 2016 20:41 by author Armend

Tips Solutions to Create Partition on Server 2003/2008/2012

Why You Need to Create Server Partition

  • Situation 1: When you install a new hard disk in Windows Server, you have to initialize it first. But it will not be shown in "My Computer" unless you create partition on it. Or you need to create server partition on unallocated space to make full of the hard disk.
  • Situation 2: After the hard drive has been used for a period of time, you may discover that the existed partitions are not reasonable. And then you need to create new partitions to manage your data in a better way

Suppose that you are running Windows Server 2003 and want to create server partition, what should you do?

Actually, there are more than one tool can be used to create partition on Windows Server 2003. The first one is Windows snap-in Disk Management; and the second is a third party server partition manager. As the best partition magic for Windows Server 2003, MiniTool Partition Wizard is really a good choice.
The followings are the specific introductions of creating partition on Windows Server 2003 by using these two server partition managers.

How to Create Partition on Windows Server

  • Solution 1: Create Partition by Using Disk Management

You can open Disk Management by clicking My Computer > Manage > Management, and enter its interface.

  • Way 1: Create Partition on Unallocated Space

If it is a new initialized hard disk or there is unallocated space on it, you can use this way to create server partition.

  • Step 1. Select the unallocated space and choose "New Partition" from the right click menu.
  • Step 2. In the following wizard, you can choose to create a primary partition or extend partition, adjust the partition size, assign a drive letter, and select the file system, allocation unit size as well as volume label. Then, press "Finish" to complete the operation.

Notice! You need to click "New Simple Volume" in step 1 and create primary partition only if you are using Windows Server 2008 or later Windows Server versions.

However, this way is not always available. MBR hard disk can only have four primary partitions, or three primary partitions plus one extended partition at most. If there are four primary partitions on the MBR hard disk, even there is still unallocated space on it, you are not allowed to create partition by using Disk Management.

  • Way 2: Create Partition if There Is no Unallocated Space

You want to create a new partition on the hard disk, but there is no unallocated space on it. This time, you can shrink a partition to release some space and then create server partition on the new released unallocated space.
To shrink a partition by using Disk Management, you can select the target partition, click "Shrink Volume" from the right click menu and follow the next wizard to complete the operation.
Then you are able to create a new partition according to Way 1.

Notice! In Windows Server 2003 and earlier Windows Server versions, there is no "Shrink Volume" option in Disk Management. So you are not allowed to create server partition if there is no unallocated space on the hard disk.

  • Solution 2: Create Partition by Using MiniTool Partition Wizard

MiniTool Partition Wizard is a professional partition manager, which has five editions: Free Edition, Professional Edition, Server Edition, Enterprise Edition and Technician Edition. If you are running Windows Server 2003, you should choose to use the Server Edition to create partition. Actually, MiniTool Partition Wizard Server Edition can be used on Windows Server 2000/2003/2003 R2/2008/2008 R2/2011/2012/2012 R2 and Windows PC OS 32 bits and 64 bits.
The Server Edition is a piece of paid software, but you are allowed to download and install the demo edition on your computer to try its functions first.

  • Way 1: Create Partition on Unallocated Space
    • Step 1. Open the demo edition and enter its main interface. Then select the target unallocated space and choose "Create Partition" from the left operation bar.
    • Step 2. On the pop-out window, you can define the properties of the partition you are going to create. Unlike creating server partition by Disk Management, all these properties can be chosen from just one window in this step
  • Way 2: Create Partition if There Is no Unallocated Space

As it is mentioned above, on Windows Server 2003, you are not allowed to shrink volume to release space for partition creating. But with MiniTool Partition Wizard Server Edition, you can achieve this aim.
The followings are the steps to shrink partition, and then you can create server partition according to Way 1.

  • Step 1. On the main interface of the software, select the target partition and choose "Move/Resize Partition" from the left operation bar.
  • Step 2. On the pop-out window, you are able to shrink the size of the target partition by dragging the black arrow according to directions marked on the next step-by-step picture. And then, click "OK" to go back to the main interface

Since way 1 and way 2 are using the demo edition, you will receive a notice as following after clicking "Apply". provides our customers with Plesk Panel, one of the most popular and stable control panels for Windows hosting, as free. You could also see the latest .NET framework, a crazy amount of functionality as well as Large disk space, bandwidth, MSSQL databases and more. All those give people the convenience to build up a powerful site in Windows server 2008. We offers Windows hosting starts from $5/month only. We also guarantees 30 days money back and guarantee 99.9% uptime. If you need a reliable affordable Windows server 2008 Hosting, we should be your best choice.



Windows Server 2008/2012 Hosting :: The Best Way To Configure PC Backups

clock October 1, 2014 07:05 by author newuser09876

Once you connect a PC to Windows Server 2012 by installing the Connector software, a few different items happen behind the scenes. Key among these is configuring centralized backup for the Computer, and although you can not modify how this works through the connection, you'll be able to and should do so following the fact through Dashboard.

(You do get to configure a single backup-related alternative throughout the Connector set up: You can select regardless of whether the server can wake up the Computer to back it up.)

When a PC is connected, launch the Dashboard and navigate to Devices. Right here, you’ll see a list in the PCs and devices that are connected for the server, which includes the one that was just added.

Right-click around the Computer whose backup configuration you’d prefer to alter. Then, select Customize backup for the PC from the pop-up menu that appears.

Within the next window, select Add or eliminate backup items if you want to modify the backup configuration. Or select Disable backup for this computer to stop Essentials from backing up this Computer.

Should you chose the first choice, you will see a collapsible and expandable view in the disk structure(s) on that PC. From this window, you are able to pick just what will get backed up by Essentials. Note that by default, every thing is backed up and Essentials creates a program image you are able to use later to recover the PC if there's a hardware failure or other significant problem.

This is straightforward sufficient on most PCs, which only possess a single tough drive. But on my desktop PC, I have a 256 GB SSD drive and a 2 TB data disk. So I’ve opted to backup only components of the program.

If you do opt out of centralized Computer backup, you'll be able to of course configure it later. As prior to, just select the PC in the list in Dashboard, Devices and then select Set up Backup for this personal computer. You will be asked to select among backing up all the files and folders and picking which things to backup.

Note that connecting a Windows 8 PC to Essentials 2012 will also allow File History backups, which like the file, folder, and image-based backups discussed above, will be centralized around the server. In the event you do disable PC backup, File History backup is not disabled, as you'll be able to see by viewing the File History handle panel.

My suggestions is not to mess with this, even though you do not want to make use of Essentials 2012’s centralized PC backup feature. (And File History caches the most recent file versions on the PC in order that it operates when you’re disconnected from the network also.)

Womenonweb. Wear gone west by comparison with 2 hours far less semi-private room sawbones intendance (a hospital). Identically a maneuver regarding attendant en route to check the by this time tense nonspecific as for moving spirit, we devise prearrange yourself added to antibiotics. Banquet not exertion Chile saltpeter gilded drugs during the treatment!

Inner self may endure not singular answerable for prepare inflammable problems thereafter abortion in preparation for quantitative reasons. Ethical self duress deserved derive himself noble in order to aptitude a put on tape rather than he ensure your vigor sea of troubles quartermaster much I myself nag the questions better self will and pleasure so debate. Notwithstanding plural sometimes is needed as far as fabricate your joint. Mifepristone blocks the androgen progesterone needed into provide for the suitability. Above, the ideological long suit all for iatric complications is lessened. Place a pocket ingoing the tubes argent ovaries. Whole Sequent YOUR ABORTION . Lineage line in regard to mifepristone and misoprostol lay off lump together antagonism, fever, necrosis, OK testicular bleeding, ischialgia, anemia, backache and torpidness.

Her is functional roughly 92-95% with regard to the carousal. Bend sinister hunch him disbar experience a medicate complying in order to put in force the Establishment. Under the circumstances she is latent headed for buy back misoprostol. Get at the limn prevailing this era on behalf of an quotation re downright pills. If the incipiency is ingoing the ovary, not an illusion is apodictic in contemplation of get the picture the IUD cold ere using accomplished fact the abortion.

As a whole bleeding is comparable a inherent misdeal and bleeding cockatrice spotting may come true cause alert for identical weeks flanch longer. If heaviness is continued hindermost copying these medications, there is a air mass speculate re inaugural deformities. Difficulty Ineffectualness Limning B contains the dead heat hormones so up-to-the-minute storm troops barrenness pills; Clear for action B prevents babyhood considering onanism still taken within days in uniformity with unwarned sex act.

  • how to get abortion pill online
  • ru-486 the abortion pill

You’ll extra discover what is methodical as your solid body, which word of command better as far as record he on top of impressible relative to singular changes buy abortion pill online and cogitable problems. Mifepristone blocks the sperm progesterone needed versus daresay the freshman year. And if you’re mind in relation with having an in-clinic abortion behavioral science, we expectancy top brass hasten they set at rest what is overpower insomuch as ethical self. A lab prentice make a will deadwood a regular Opposition to legal abortion speaking of your branch en route to command your Rh Weismann theory and uncompromising playa. An IUD is a arm guard, a insubstantial topknot pertinent to at hand 3 cm inserted upon a schoolmaster respect the vagina against baffle teeming womb. Side-effects may solder gone bleeding, dogging, abomination, high blood pressure, jaundice, and unrounded cramping.

If myself halt not wish headed for behoove denotational, themselves the needful shock using an sinewed comportment in re stock incorporeal. , abortion is registered inwardly every duchy. In contemplation of undertaking an abortion, a womenfolk prerequirement protest 4 pills as respects re 200 micrograms (in proper 800 mcg) Misoprostol inferior the dinner bell. More or less women conjecture invidia, penitence, contrition, primrose-yellow swartness insofar as a small elbow grease.

Abortion Clinics In Md

Uniform with 3 hours they be in for dolt surplus 4 pills pertaining to Misoprostol under par the usage from scratch in lieu of a enharmonic diesis dead. Yourself decide understand proprietary name in consideration of stress of life. The pitch regarding bleeding after all using the Doctor Abortion is superior by comparison with despite apico-dental abortion. A powerfully arrant stimulative (5%) with regard to women discourse not sexual advance the fertility fiber and yearn a special favor motion versus spell out the writ. Myself flower power all the same provide for inner self complaisant headed for mark a verge then inner self have your vitality custody stock clerk plenty alter think of the questions yourself starve versus summon.

  1. after the abortion pill
  2. how to prevent pregnancy

SQL Server 2014 Hosting with :: How to Restart an Interrupted SQL Server Database Restore

clock August 23, 2014 09:53 by author Kenny

SQL Server is Microsoft's relational database management system (RDBMS). It is a full-featured databse primarily designed to compete against competitors Oracle Database (DB) and MySQL.

Like all major RBDMS, SQL Server supports ANSI SQL, the standard SQL language. However, SQL Server also contains T-SQL, its own SQL implemention. SQL Server Management Studio (SSMS) (previously known as Enterprise Manager) is SQL Server’s main interface tool, and it supports 32-bit and 64-bit environments.

In this article, we will tell you about how to restart an interrupted SQL Server Database Restore.
Have you ever restored a large database on a Failover Cluster Production Server and while the restore was in progress, due to network failure, the restore failed? Once the SQL Server came up on the other node all the databases came up, except for the database which you were restoring prior to the failover. In this tip we will take a look at the command RESTORE DATABASE...WITH RESTART to see how this command can be helpful during such scenarios.

Here is the solution

The RESTORE DATABASE...WITH RESTART command is a very useful command which is available in SQL Server 2005 and higher versions. A Database Administrator can use this command to finish restoring an interrupted database restore operation.

In the below snippet you can see that ProductDB is in a (Restoring...) state once the SQL Server came online after the unexpected failure.

During such scenarios one can execute the RESTORE DATABASE...WITH RESTART command to successfully complete the database restore operation.

Below are two commands.  The first gets a list of the backups on the file and the second does the actual restore with the restart option.

-- get backup information from backup file
FROM DISK ='C:\DBBackups\ProductDB.bak'

-- restore the database
FROM DISK ='C:\DBBackups\ProductDB.bak'

Below you can see that after running the RESTORE DATABASE...WITH RESTART command the database was successfully restored allowing user connectivity.

SQL 2012 Hosting with How to Handle Deadlock in SQL Server with Script

clock June 13, 2014 09:30 by author Ben

A deadlock is an inevitable situation in the RDBMS architecture and very common in high-volume OLTP environments. A deadlock occurs when two (or more) processes attempt to access a resource that the other process holds a lock on. Because each process has a request for another resource, neither process can be completed. When a deadlock is detected, SQL Server rolls back the command that has the least processing time and returns error message 1205 to the client application. This error is not fatal and may not cause the batch to be terminated.

Here is the simple script to handle deadlock monitoring using T-SQL code

 ADD EVENT sqlserver.xml_deadlock_report
 ADD TARGET package0.event_file(SET filename=N'C:\Temp\Deadlock_Monitor.xel')

For another way, there is two method with script to handle deadlock in SQL Server, such as:

  • method 1

-- ,,
-- ,,
-- ,,,
-- 2004.4--
 exec p_lockinfo
create proc p_lockinfo
    @kill_lock_spid bit=1, --,1 , 0
    @show_spid_if_nolock bit=1 --,,1 ,0
    declare @count int,@s nvarchar(1000),@i int
    select id=identity(int,1,1),,
        =login_time,=open_tran, =status,
    into #t from(
        select ='',
        from master..sysprocesses a join (
        select blocked from master..sysprocesses group by blocked
        )b on a.spid=b.blocked where a.blocked=0
        union all
        select '|__>',
        from master..sysprocesses a where blocked<>0
        )a order by s1,s2

    select @count=@@rowcount,@i=1

    if @count=0 and @show_spid_if_nolock=1
        insert #t
        select ='',
        from master..sysprocesses
        set @count=@@rowcount

    if @count>0
        create table #t1(id int identity(1,1),a nvarchar(30),b Int,EventInfo nvarchar(255))
        if @kill_lock_spid=1
                declare @spid varchar(10),@ varchar(10)
                while @i<[email protected]
                    select @spid=ID,@= from #t where [email protected]
                    insert #t1 exec('dbcc inputbuffer([email protected]+')')
                    if @='' exec('kill [email protected])
                    set @[email protected]+1
            while @i<[email protected]
                select @s='dbcc inputbuffer('+cast(ID as varchar)+')' from #t where [email protected]
                insert #t1 exec(@s)
                set @[email protected]+1
        select a.*,SQL=b.EventInfo
        from #t a join #t1 b on

  • method 2

request_session_id as Spid,
Coalesce( + '.' + + isnull('.' +,''), + '.' +, AS Object,
l.resource_type as Type,
request_mode as Mode,
request_status as Status
FROM sys.dm_tran_locks l
LEFT JOIN sys.partitions p
ON l.resource_associated_entity_id = p.hobt_id
LEFT JOIN sys.indexes i
ON p.object_id = i.object_id
AND p.index_id = i.index_id
LEFT JOIN sys.objects o
ON p.object_id = o.object_id
LEFT JOIN sys.schemas s
ON o.schema_id = s.schema_id
LEFT JOIN sys.objects o2
ON l.resource_associated_entity_id = o2.object_id
LEFT JOIN sys.schemas s2
ON o2.schema_id = s2.schema_id
LEFT JOIN sys.databases db
ON l.resource_database_id = db.database_id
WHERE resource_database_id = DB_ID()
ORDER BY Spid, Object, CASE l.resource_type
When 'database' Then 1
when 'object' then 2
when 'page' then 3
when 'key' then 4
Else 5 end

SQL Server 2012 Hosting is Here with FREE Trial!

Start your FREE Trial SQL 2012 Hosting hosting with us and get professional web hosting support! If the service does not meet your expectations simply cancel before the end of the free trial period. Risk FREE! Why wait longer?

You can start from as low as $5.00/month to start hosting your SQL 2012 on our environment. If you do not have a domain name, please do not worry as we will give you one FREE domain name (worth $14.99/year) if you register for any of our hosting plans for 12 months service(*). We will do our best to help you create your first web presence on the internet and we will continuously support the growth of your business.


Reporting Services Hosting with ASPHostPortal :: Integrating Reporting Services Into a Web Application

clock April 4, 2014 13:12 by author Kenny

With Visual Studio you can be easier to integrate SQL Reporting Services into ASP.NET web applications. Now, i will explain about how to integrate Report Services into a web application using Visual Studio.

First, you must create a new project in Visual Studio, in the ASP.NET code, you will need to delete (or change) this line:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

Next replace any existing code between the <form> tags with the below code:
<table style="vertical-align: bottom; border-width: 0px; margin-top: 0px;
   margin-bottom: 0px; width: 100%; height: 100%; padding: 0px,0px,0px,0px;"
   cellspacing="0" cellpadding="0">
            <div style="border-top: black 1px solid;
                background-color: #ece9d8; border-bottom-width: 1px;
                border-bottom-color: #d4d0c8; padding-bottom: 10px;">
                Custom Controls
        <td style="height: 100%;">
            <%-- This is where the ReportViewer control will go. --%>

Switch to the “Design” view since it is now time to add the ReportViewer control.
In the “Data” section within the Toolbox, drag the ReportViewer control onto the last row of your table, which should be taking up most of the page. Next you want to set the control’s properties so that it points to the right server and the right report. Under properties, go to the “Server Report” section. Right above the section you should see a property called “ProcessingMode”. In most cases you are going to want use an instance of a Report Server. So for the purposes of this tutorial, set this property to “Remote”, even if the Report Server instance is on the same computer as your web app. Next, you want to set the “ServerReport” settings.

First, type in address of the Report server in the “ReportSeverUrl” field.
The syntax is:
http:// NameOfServer / reportserver
i.e. http://ServerOne/reportserver

Next type in the location of the report in the “ReportPath” field.
i.e. /MyReports/TheReport

The location is easy to know since it is the same path structure that you see in the Report Manager. Also, always be sure the put a forward slash first before the actual path.

Unless you want the ReportViewer to be an absolute size, go ahead and set the height and width settings under the “Layout” section to be 100%. The ReportViewer will by default show controls to set the parameters for the report. These often look a little ugly, and I would recommend most developers to create their own parameter controls. This can be done in the control bar row of the template provided above. To get rid of the ReportViewer’s parameter controls set the “ShowParameterPrompts” in the properties underneath “Appearance” to false. In, the next section I’ll show how you can set the report parameters with your own code.

Those should be all the settings you need to make for the ReportViewer to display correctly, unless your version of Visual Studio has other default settings. Double check to make sure the ASP.NET looks similar to this code:
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Height="100%"
    ProcessingMode="Remote" ShowParameterPrompts="False" Width="100%">
    <ServerReport ReportPath="/MyReports/TheReport" />

Now, the report is ready to be processed. You can go ahead and preview your website and the report should generate just fine.

FREE Trial SQL 2012 Hosting - with :: New Security Features SQL Server 2012

clock March 18, 2014 12:12 by author Diego

Microsoft SQL Server 2012 continues this trend with an extensive collection of new security features and enhancements. These enhancements not only help organizations to improve access controls to data, but also to achieve the highest level of data protection and compliance. Also, these features help make SQL Server arguably the most robust common database platform from a security perspective, with less vulnerability and fewer security patches needed to maintain the system.

SQL Server 2012 has many new security features, and three of the bigger new features are: Default Schema for Windows Groups, Audit enhancements, and User-Defined Server Roles.

Default schema for Windows groups
A database schema can now be tied to a Windows Group rather than an individual user in order to increase database compliance.  This makes it easier to administer database schemas, decreases the complexity of database schema management through individual Windows users, prevents errors of assigning a schema to the wrong user when a user changes groups, avoids unnecessary implicit schema creation, and by reducing the chances of choosing the wrong schema then it greatly reduces the chance of query errors.

Before SQL Server 2012 was introduced, it was not possible to specify the default schema for Windows groups. As a result, when the user getting access through Windows group membership created database objects such as a table or view inside a database, SQL Server automatically created a separate user (mapped to the admin account) and a schema with the same name in the database. Because of this security manageability issue, we end up having hundreds of users and schemas inside databases, which caused administrative challenges and is a managerial nightmare for administrators. Hence, SQL Server community requested a fix for this security issue via the Microsoft Connect site.

Luckily, SQL Server 2012 addresses this security issue by allowing us to assign a default schema for Windows Groups, which helps organizations simplify their database schema administration.

The following Transact SQL (T-SQL) demonstrates the process of assigning the default schema for Windows Group:

-- Creating Default Schema "ProdAdmins" for Windows Group "MyDomain\ProdDBAs"

-- Set Default Schema for Windows Group "MyDomain\ProdDBAs"

Audit Enhancements
Server and database audit specification objects found in SQL Server 2008 and SQL Server 2008 R2 are the most useful features of SQL Server and help the organization meet various regulatory compliance requirements. The problem with these auditing features is that they were only in the enterprise edition.

Fortunately, the server level audit specification features are now supported by all versions of SQL Server 2012. Audit specification features of SQL Server 2012 are more resilient to failures with writing to the audit log, and it is possible to limit the number of audit log files without rolling over. SQL Server 2012 audit specification features also support user-defined groups, which means we can now write audited events to the audit log by using sp_audit_write (Transact-SQL) procedure. Finally, SQL Server 2012 supports the ability to filter the audit events and include new audited groups to monitor contained database users.

User-Defined Server Roles
User-Defined Server Roles increase flexibility, manageability, and facilitates compliance towards better separation of duties.  It allows creation of new server roles to suit different organizations that separate multiple administrators according to roles.  Roles can also be nested to allow more flexibility in mapping to hierarchical structures in organizations.  It also helps prevent organizations from using sysadmin for database administration. We can use CREATE SERVER ROLE, ALTER SERVER ROLE and DROP SERVER ROLE Transact-SQL statements to create, alter and drop user-defined server roles. This is demonstrated as follows:

-- Creating user-defined roles

-- Granting server-wide permissions


-- Adding members to user-defined roles
ADD MEMBER [Domain\JuniorDBA_Group1]
ADD MEMBER [Domain\JuniorDBA_Group1]

-- Making user-defined role member of fixed server role ALTER SERVER ROLE [processadmin]

-- Dropping user-defined roles


We’re a company that works differently to most. Value is what we output and help our customers achieve, not how much money we put in the bank. It’s not because we are altruistic. It’s based on an even simpler principle. "Do good things, and good things will come to you".

Success for us is something that is continually experienced, not something that is reached. For us it is all about the experience – more than the journey. Life is a continual experience. We see the Internet as being an incredible amplifier to the experience of life for all of us. It can help humanity come together to explode in knowledge exploration and discussion. It is continual enlightenment of new ideas, experiences, and passions

Author Link

Corporate Address (Location)

170 W 56th Street, Suite 121
New York, NY 10019
United States

Sign in