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.
We get tested in a variety of ways before we take a job, but what should be open for examination besides our technical skills? Answer this week's poll with your opinion.
Data access is an important aspect of developing applications with the Microsoft® .NET Compact Framework for Windows Mobile® devices. By using the existing architecture to send and receive data between your mobile application and your application server, you can pass data with either DataSets, custom objects, or scalar values.
A weekly show from a few SQL Server MVPs that looks at a variety of technology items. This episode concentrates on SQL server.
This white paper describes how application developers can leverage the functionality of Microsoft SQL Server 2005 Integration Services to address the data integration challenges of Master Data Management applications.
Two big events this week captured Steve Jones' attention. A little MySQL and Apple commentary to break up the week.
Continuing on with his series on table partitioning, Andy Warren takes a look at some fo the advanced features available in SQL Server Enterprise Edition.
Two big events this week captured Steve Jones' attention. A little MySQL and Apple commentary to break up the week.
A common activity in applications is to page results or record sets from a database. This is usually done on the client using the client's paging functionality or on the server through a variety of methods. In SQL Server 2000 those server side methods typically used dynamic SQL or nested TOP clauses and weren't very efficient. Using Common Table Expressions in SQL Server 2005 we have a better way to page record sets on the server.
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Comments posted to this topic are about the item The Max PK Length
Comments posted to this topic are about the item My experience using the GitHub...
Comments posted to this topic are about the item The Microsoft SQL Year in...
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers