Configuring

SQLServerCentral Article

Review of SQL Comparison and Synchronization Toolkit

  • Article

This week Andy takes a look at a new product from Red-Gate that gives you even more options than you get with their SQL Compare and SQL Data Compare tools - now you can build your own. Add the features you always wanted. Build automated processes instead of using the GUI. It's an interesting product - read the review and then maybe even enter the contest to win a free copy.

You rated this post out of 5. Change rating

2002-01-16

5,396 reads

Technical Article

nternet Data Center 1.5 - Reference Architecture Guide

  • Article

This document (divided in chapters for your convenience) describes how to design a secure, scalable, highly available, and manageable Internet data center that is based on Microsoft products. This documentation examines the major challenges to consider when designing an Internet data center architecture and how this design addresses these challenges.

2001-12-30

967 reads

Technical Article

Server logins and database users

  • Topic

We are currently using Oracle db for our apps, but in near future we could use SQL Server 2000 for some new apps we will develop. We have a lot of expirience with Oracle and we found using mulitiple owners in one database is very good database design. Because we are planning to use multiple […]

2001-11-29

1 reads

Technical Article

T-SQL

  • Topic

Can't I write a select statement that pulls data from two different tables even if the tables reside on two different dB's that are on the same server? I'm using SQL2K without the service pack. I get the following error when I try: Server: Msg 446, Level 16, State 9, Line 1 Cannot resolve collation […]

2001-11-21

1 reads

Technical Article

Starting Debugger with predefined system variables

  • Topic

Does anybody aware how to customize debugger from Query Analyser to make sure you it will track system variables like @@rowcount and etc. every time when you start debugging new stored procedure. Doing this manualy every time when you start debugging session is pretty annoying. Thanks, Alex

2001-11-21

Technical Article

Slow SQL Server

  • Topic

I am new to SQL server 7 and have just made a small database, the largest table at the moment is around 2000 rows. I am having major problems with the performance though. The problem i have is when i run enterprise manager and open a view/query that my web pages use, suddenly my web […]

2001-11-21

Technical Article

Do you know how to use SQL to make an 'indirection

  • Topic

Do you know how to use SQL to make an 'indirection'. You remember in the C language, how you can treat the contents of a variable as a pointer to another variable location, or in other 4th generation languages (& some OS stuff), you can use a 'handle' to hold an indirect reference to another […]

2001-11-20

273 reads

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers