Sql Servers

Multiple SQL Servers
I have 4 data collection centres across Europe inputting live data into our SQL server hosted in the UK. The problem I have is when one of the data collection centres goes offline we have an issue of getting the live data into the SQL ...

Tutorial 3: Introduction for SQL Server
Here you'll find the main SQL server applications. We'll see only the SQL Server Configuration manager tool. This tools we'll allow us to stop and start the SQL servers. Click over SQL server 2005 services to see the installed servers ...

SQL Server - The Most Powerful Database Administration Tool
SQL servers have a large number of powerful tools that facilitate database maintenance, and administration. Among the most important ones are the Enterprise Manager, the Service Manager and the Query analyzer. ...

Uninstall SQL 2000 Workstation Components
Summary: control who logs into my SQL servers as administrator, ... that logs in as administrator doesn't have the ability to just open EM ...

SQL Injection: What is it?
Certain SQL Servers such as Microsoft SQL Server contain stored and extended procedures (database server functions). If an attacker can obtain access to these procedures, it could spell disaster. Unfortunately the impact of SQL ...

Uninstall SQL 2000 Workstation Components
control who logs into my SQL servers as administrator, so I'm looking for a way to uninstall the workstation components WITHOUT completely uninstalling all of my instances. Does anyone know how to do this? ...

SQL Server Database Administrator (7160B)
Our Database Administrator will be responsible for the management of several SQL Servers and data marts, all data being loaded into the database from external sources, as well as the distribution of that data to various data marts for ...

Installing a Second Copy of SQL Server 2005
Multiple instances of SQL Server are supported by SQL Server 2005. Previous versions of SQL Servers can also be upgraded to SQL Server 2005. In this section we shall see how to install a second copy of SQL Server 2005. ...

Other SQL optimization tips
I guess the reason is because since all database servers automatically create an index on the columns that you specify to make up the primary key, why shouldn’t it do the same for foreign keys? Well it doesn’t and this is why it’s the ...

Log Buffer #90: a Carnival of the Vanities for DBAs
Also looking at Katmai was Bob Beauchemin, with his tip on accessing multiple servers with the SQL Server 2008 PowerShell provider, something right out in the open that nonetheless you might have missed. ...