SQL 2008 R2 Express Hosting « SQL 2008 Hosting News (SuperBlogAds Network)

SQL 2008 Hosting :: Why I Cant Connect to SQL 2008 R2?

By Louise Lahm, on February 15th, 2012%

Exactly when Microsoft changed the setting, I could not understand exactly – when reinstalling a named SQL Server 2008 R2 Express instance was the effect on each case:

You try to connect from a client using SQL Server (native) to the client to the server and receives the error message:

Connection fail:
SQLState: 08001
SQL Server ERROR: 17
{Microsoft} {ODBC SQL . . . → Read More: SQL 2008 Hosting :: Why I Cant Connect to SQL 2008 R2?

SQL 2008 Hosting :: Importing SQL Server Data to an Access Database

By Jose Sharp, on August 2nd, 2011%

SQL Server data can be transferred to a Microsoft Access database via importing or linking. Importing essentially creates a copy of the SQL Server data in the Access database. Once the data is imported, changes made in either the SQL Server database or the Access database are not reflected in one another. In other words, think . . . → Read More: SQL 2008 Hosting :: Importing SQL Server Data to an Access Database

SQL Hosting :: How to Remove Special Characters from a String?

By ricardo, on July 6th, 2011%

The following summarizes the SQL code to remove Special Characters from a STRING.

CREATE FUNCTION dbo.RemoveSpecialChars ( @InputString VARCHAR(8000) )
RETURNS VARCHAR(8000) �
BEGIN
    IF @InputString IS NULL
        RETURN NULL
    DECLARE @OutputString VARCHAR(8000)
    SET @OutputString = ”
    DECLARE @l INT
    SET @l = LEN(@InputString)
    DECLARE @p INT
    SET @p = 1
    WHILE @p <= @l
        BEGIN
            DECLARE @c INT
            SET @c = ASCII(SUBSTRING(@InputString, @p, 1))
            IF @c BETWEEN 48 AND 57
                OR @c BETWEEN 65 AND 90
                OR @c BETWEEN 97 AND 122
                  –OR @c = 32
                SET @OutputString = @OutputString + CHAR(@c)
            SET @p = @p + 1
        END

    IF LEN(@OutputString) = 0
        RETURN NULL
    RETURN @OutputString
END

How to use it?

SELECT dbo.RemoveSpecialChars (‘This string contains special chracters:/ Which * & we % need @ to #remove’)

According to this function space is a special character and if you want to ignore spaces then uncomment “OR @c . . . → Read More: SQL Hosting :: How to Remove Special Characters from a String?

SQL 2008 R2 Hosting :: Making the most of your SQL 2008 R2 Cluster

By Louise Lahm, on May 30th, 2011%

Clustering your SQL 2008 R2 Server is a great way to gain high availability for your environment. The benefits are simple and powerful; seamless fail over of your SQL Server and all services that power it, within . . . → Read More: SQL 2008 R2 Hosting :: Making the most of your SQL 2008 R2 Cluster

SQL 2008 Hosting :: How to Configure and Create a Database in MS SQL 2008

By Jose Sharp, on April 13th, 2011%

First, it is important to note, that for security reasons, MS SQL comes with all connections via TCP/IP and Named Pipes disabled. Named pipes is a way for the connection to distinguish which instance of SQL you are trying to connect to (sort of like a port would act for TCP/IP). Named Pipes is not a . . . → Read More: SQL 2008 Hosting :: How to Configure and Create a Database in MS SQL 2008

SQL Server 2008 Hosting :: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server

By Jose Sharp, on April 1st, 2011%

When setting up a Microsoft Windows Server 2008 system, I went through the motions to set up IIS, MS SQL Server 2008, and Visual Studio 2010 to use as a test-bed.

One of the immediate benefits of setting up such a system is that most development can be done remotely: MS SQL Server Management Studio, Visual Studio’s . . . → Read More: SQL Server 2008 Hosting :: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server

SQL 2008 R2 Hosting – Top IMPORTANT Features in SQL 2008 R2

By ricardo, on March 31st, 2011%

With all the new features in SQL 2008 R2, here are the major ones getting all the press:

PowerPivot
Parallel Data Warehouse
Application and Multi-Server Management
StreamInsight
256 core support

There is so much written on the ones above, I wanted to concentrate on talking about other new features in SQL 2008 R2. So, in no particular order:

1. SMB support – . . . → Read More: SQL 2008 R2 Hosting – Top IMPORTANT Features in SQL 2008 R2

SQL 2008 R2 Hosting :: Working with Case Insensitive Data

By ricardo, on March 24th, 2011%

Today, I have faced a very simple but still annoying problem. I was asked by a client that queries are not working correctly with given WHERE clause. Actually database was design as case insensitive but SOMEHOW on application side there were some business logics which client needs case sensitive inputs (Just like password) and comparisons.

Here is . . . → Read More: SQL 2008 R2 Hosting :: Working with Case Insensitive Data

SQL 2008 R2 Hosting :: Setting Up Maintainance Plans in SQL 2008 R2

By ricardo, on March 16th, 2011%

One of the repetitive tasks that DBA need to perform is create maintenance plan for database. Maintenance plans enables you to automate maintenance activities for a database, backups, db integrity checks and index maintenance tasks. We can easily create a maintenance plan using a wizard in SQL Server 2008 R2

You can use the following steps to . . . → Read More: SQL 2008 R2 Hosting :: Setting Up Maintainance Plans in SQL 2008 R2

MSSQL 2008 R2 Web Hosting :: A Look Inside New Features in SQL Server 2008 R2

By ricardo, on January 26th, 2011%

If you are looking for SQL Server 2010 you are not going to find it. The version released this year is instead SQL Server 2008 R2 and while there aren’t any massive improvements aimed specifically at the developer you’ll find the general improvements make it easier to create applications that do what your users want.

Of the . . . → Read More: MSSQL 2008 R2 Web Hosting :: A Look Inside New Features in SQL Server 2008 R2

SQL 2008 Hosting News (SuperBlogAds Network)