Installation

All about the 'Case'

  • Article

When installing SQL Server, regardless of versions and editions, SQL Server database administrators tend to choose the default collation and sort-order, which is SQL_Latin1_General_CP1_CI_AS. Though case insensitiveness makes the life of the database developers and database administrator's easy, there are situations where case sensitivity should be enforced just as password checking is enforced.

In this article, I would like to discuss different methods for achieving case sensitivity in a case insensitive database/server.

2005-03-25

2,616 reads

Is Windows 2003 Really Faster?

  • Article

Is Windows 2003 really faster for a SQL Server/IIS environment? Let us do all the leg work for you! We are about to upgrade the SQLServerCentral.com web and SQL Server from Windows 2000 to Windows 2003. As part of the case study, we are going to capture a baseline of the server's overall performance before the upgrade and then again after the upgrade. We will then document the experience and benchmark numbers.

2003-06-10

12,868 reads

Troubleshooting Cannot Generate SSPI Context Errors

  • Article

As a DBA you do not need to know how to setup an Active Directory domain or a DNS server, but you still need to know how Kerberos, Service Principle Names, and hostnames are used to perform integrated authentication to a SQL Server. This article by new columnist Chad Miller shows you some of the more integral parts of troubleshooting running Windows Authentication security in a SQL Server environmnet.

4.89 (9)

2005-08-19 (first published: )

66,125 reads

Step-by-Step Guide to Clustering Windows 2000 and SQL Server 2000

  • Article

In this next article of the SQL Server in the Enterprise Series, we'll explore how to cluster Windows 2000 and SQL Server 2000 in a step-by-step manner. After this article, you should be able to cluster a SQL Server 2000 machine for failover availability in an Active/Active cluster.

3.63 (8)

2008-01-18 (first published: )

153,140 reads

Blogs

Graph – Shortest Path

By

‘Shortest path’ is by far the most feature of SQL Graph for now. What...

Last Week Reading (2019-09-22)

By

Hello #datafolks! Let’s review what happened last week in Data World. It’s hard to...

Simple Graph Queries

By

In this post we saw how to create some graph tables with data. In...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

memory not getting released to OS

By vsamantha35

Hi All, Need help here. Why is sql server is not releasing memory to...

Will the principal wait for acknowledgement from mirror?

By coolchaitu

Good Morning Experts, A transaction was sent to mirror database and immediately failover occured....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers