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: )

67,054 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,591 reads

Blogs

Getting the Proc Code–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Running SQL Server in Google Cloud Platform

By

On a few occasions I’ve referred to GCP (Google Cloud Platform) as the “Windows...

More ADLS Gen2 enhancements

By

On the heels of More Azure Blob Storage enhancements come more enhancements for Azure...

Read the latest Blogs

Forums

How to change the Scan to Seek and optimize

By sizal0234

Hello, Attached sample query and actual plan, I want to further optimize the query...

Availability Groups with Docker Containers

By rafaelrodrigues

Comments posted to this topic are about the item Availability Groups with Docker Containers

Daily Coping 6 Jun 2020

By Steve Jones - SSC Editor

Today’s tip is to think of something you’ve always wanted to do and never...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers