How to Use Microsoft SQL 2012 to Connect to Your Server

Last Updated on Monday, 21 January 2013 02:19 Written by Rodolfo Hernandez Tuesday, 29 January 2013 12:00

In this video, brought to you by Arvixe, I will give you a step by step guide on how to use Microsoft SQL 2012 to connect to your server:

Looking for quality ASP Web Hosting? Look no further than Arvixe Web Hosting!

Happy Hosting!

Rodolfo Hernandez

Managing SQL Server 2012 Databases with WebsitePanel

Last Updated on Friday, 25 January 2013 12:00 Written by Anand Narayanaswamy Friday, 25 January 2013 12:00

Unlike other hosting control panels, WebsitePanel not only enables you to create Microsoft SQL Server 2012 databases but also provides an ability to backup and restore databases.

Creating Databases

• Login to WebsitePanel
• Select Databases | SQL Server 2012

How to Check if a Record Exists in SQL Database Table with PHP

Last Updated on Saturday, 12 January 2013 12:01 Written by Richi González Saturday, 12 January 2013 12:00

Hello,

Have you been in a situation where you need to check if either a phone number or a user, for example, exists in your database? When I didn’t know how to do that, I looked through several articles looking for the best and most efficient way of doing it until I found this one.

1. Let’s say we have a table called ‘users’ and it has two columns: id, name. This is our table:

How to Efficiently Count Records of an SQL Table with PHP

Last Updated on Friday, 4 January 2013 12:00 Written by Richi González Friday, 4 January 2013 12:00

Hello,

For the last website I made, I created a really flexible and friendly administration panel where there were a lot of statistics to analyze how the website was performing. I came across different ways of counting records in a table, yet stuck with this one, the most efficient:

The query is really simple, we will use SELECT COUNT(1), then mysql_fetch_row() that count. The code would look like this:

How to Use Toad for SQL to Connect to an Arvixe SQL Database

Last Updated on Wednesday, 19 December 2012 12:00 Written by David Bauernschmidt Wednesday, 19 December 2012 12:00

There are many tools available to connect to SQL server databases but the one that I find the easiest to use is Toad for SQL. The product has many features and options that make it an asset to any developer’s arsenal. Obviously Dell thought the same thing and with the purchase of Quest they received a great product. This article is not to try and sell a product, but to show you how to use the product in connecting to an Arvixe SQL Server database. If you want to try the product then you can get it here.

After you create the database and user from the Control Panel then start Toad for SQL Server and select File –> New –> Connection (See figure 1)