MIgrating SQL Server 2000 to Active Directory
We recently migrated to Active Directory domains and we did not have to do anything with SQL 2000 sp3a to get it to work. As for the new tab on the properties display, I looked at it, but didn’t add SQL to Active Directory.
View Answer
| September 20, 2004 7:28 AM
Biometrics, Database Management Systems, Digital certificates, Identity & Access Management, provisioning, Security tokens, Single sign-on, SQL Server, Standard Edition 2000, Tech support
We recently migrated to Active Directory domains and we did not have to do anything with SQL 2000 sp3a to get it to work. As for the new tab on the properties display, I looked at it, but didn’t add SQL to Active Directory.
View Answer
| September 20, 2004 7:28 AM
Biometrics, Database Management Systems, Digital certificates, Identity & Access Management, provisioning, Security tokens, Single sign-on, SQL Server, Standard Edition 2000, Tech support
How to alter more than one existing columns in SQL 2000 Server?
this syntax gives me no errors in query analyzer: ALTER TABLE school ADD U int ALTER TABLE school ADD M int
View Answer
| September 14, 2004 12:04 PM
Database Management Systems, SQL Server
this syntax gives me no errors in query analyzer: ALTER TABLE school ADD U int ALTER TABLE school ADD M int
View Answer
| September 14, 2004 12:04 PM
Database Management Systems, SQL Server
OBJECTIVE comparison (with independant references) between MS SQL and Oracle 10g
Hello there, I am a DBA originally started with Oracle 5 and have 13 years of experience using Oracle database. For last five years, I have also been using and administring SQL Server. In my opinion both have pluses an minuses of their own. Here is the comparison between the two based on features you [...]
View Answer
| September 2, 2004 11:49 AM
Oracle, SQL Server
Hello there, I am a DBA originally started with Oracle 5 and have 13 years of experience using Oracle database. For last five years, I have also been using and administring SQL Server. In my opinion both have pluses an minuses of their own. Here is the comparison between the two based on features you [...]
View Answer
| September 2, 2004 11:49 AM
Oracle, SQL Server
Alternate way to stop Oracle Services on Win 2K Server
I would recommend that you use RMAN to create your backups. You can create a script that the operator can run that will generate hot full, hot incremental or cold backup. This is preferable to stopping the service especially if you are stopping the service through the windows interface. If you stop the service through [...]
View Answer
| August 2, 2004 6:14 PM
Database Management Systems, DataCenter, Desktop security, Hardware, Oracle, Oracle 8i, Oracle Application Server, Policies, Security, Servers, Software distribution, Standard Edition, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance
I would recommend that you use RMAN to create your backups. You can create a script that the operator can run that will generate hot full, hot incremental or cold backup. This is preferable to stopping the service especially if you are stopping the service through the windows interface. If you stop the service through [...]
View Answer
| August 2, 2004 6:14 PM
Database Management Systems, DataCenter, Desktop security, Hardware, Oracle, Oracle 8i, Oracle Application Server, Policies, Security, Servers, Software distribution, Standard Edition, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance
Alternate way to stop Oracle Services on Win 2K Server-2
You could set up a scheduled task to do the backups and use net stop to stop the service and net start to start the service. Set this up in a batch file and schedule it with the credentials of an admin or at least someone who belongs to the ora_dba group
View Answer
| August 2, 2004 3:04 PM
configuration, Database Management Systems, DataCenter, Desktop security, Hardware, Oracle, Oracle 8i, Oracle Application Server, patching, PEN testing, Platform Security, Policies, Security, Servers, Software distribution, Standard Edition, vulnerability management, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance
You could set up a scheduled task to do the backups and use net stop to stop the service and net start to start the service. Set this up in a batch file and schedule it with the credentials of an admin or at least someone who belongs to the ora_dba group
View Answer
| August 2, 2004 3:04 PM
configuration, Database Management Systems, DataCenter, Desktop security, Hardware, Oracle, Oracle 8i, Oracle Application Server, patching, PEN testing, Platform Security, Policies, Security, Servers, Software distribution, Standard Edition, vulnerability management, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance
Error when tried to update the SSOledbGrid connected to with Sybase Server Database
What is the error text? Do you have to use adlockpessimistic or can you use adlockbatchoptimistic or some other type of locking?
View Answer
| July 16, 2004 3:40 PM
ActiveX, Adaptive Server Enterprise, Database, DB2, Development, Oracle, Servers, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Sybase, Sybase EAServer, Visual Basic
What is the error text? Do you have to use adlockpessimistic or can you use adlockbatchoptimistic or some other type of locking?
View Answer
| July 16, 2004 3:40 PM
ActiveX, Adaptive Server Enterprise, Database, DB2, Development, Oracle, Servers, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Sybase, Sybase EAServer, Visual Basic
Uninstalling Oracle 9i products from a Window Server
Universal Installer is the best approach.
View Answer
| June 15, 2004 12:08 PM
Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Standard Edition
Universal Installer is the best approach.
View Answer
| June 15, 2004 12:08 PM
Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Standard Edition
SQL Server Install
Hello, hello … Some of Microsoft’s changes to enterprise level licensing include shipping said editions without product keys. This is, the SQL Server 2000 Enterprise Edition does not require a CD-Key. Persumably that is the edition you installed … ??? Eric
View Answer
| June 4, 2004 11:21 AM
SQL Server, Standard Edition 2000
Hello, hello … Some of Microsoft’s changes to enterprise level licensing include shipping said editions without product keys. This is, the SQL Server 2000 Enterprise Edition does not require a CD-Key. Persumably that is the edition you installed … ??? Eric
View Answer
| June 4, 2004 11:21 AM
SQL Server, Standard Edition 2000
best practice for SQL Agent account security
You or your network admin should do the following: 1) Create a “common” SQL Service domain account (e.g., Domain1SQLService). 2) Make the account a member of the local Admin group on each server. 3) Load any SQL Server AND SQL Agent services through that account. Such accounts can/should be allowed to log on locally. However, [...]
View Answer
| June 3, 2004 7:15 PM
SQL Server
You or your network admin should do the following: 1) Create a “common” SQL Service domain account (e.g., Domain1SQLService). 2) Make the account a member of the local Admin group on each server. 3) Load any SQL Server AND SQL Agent services through that account. Such accounts can/should be allowed to log on locally. However, [...]
View Answer
| June 3, 2004 7:15 PM
SQL Server
DTS FTP taks with proxy server
Yes, it does. If your connection settings in TCP/IP are set to always use the firewall, FTP will use it. If not, it doesn’t know the firewall.
View Answer
| June 3, 2004 4:32 PM
SQL Server
Yes, it does. If your connection settings in TCP/IP are set to always use the firewall, FTP will use it. If not, it doesn’t know the firewall.
View Answer
| June 3, 2004 4:32 PM
SQL Server
Creating a Sequence of Transaction Log Backups
My preference would be to go for individual files, whose names include the date and time of the backup. Advantages being: 1. If you look at the backup directory, you can see at a glance which backups you have without having to go to msdb or the Enterprise Manager GUI 2. If you’re short of [...]
View Answer
| May 19, 2004 5:59 PM
SQL Server
My preference would be to go for individual files, whose names include the date and time of the backup. Advantages being: 1. If you look at the backup directory, you can see at a glance which backups you have without having to go to msdb or the Enterprise Manager GUI 2. If you’re short of [...]
View Answer
| May 19, 2004 5:59 PM
SQL Server
SQL Server Books
Hi. Books Online. Just as the Oracle manuals are required reading, so is SQL’s Books Online. That said, I recently picked up Ken England’s “Performance Oprimization and Tuning” and found it a VERY useful addition to the Books Online. Ken Henderson has a couple of good T-SQL books (learn T-SQL… not hard, although a bit [...]
View Answer
| May 19, 2004 5:04 PM
SQL Server, Standard Edition 2000
Hi. Books Online. Just as the Oracle manuals are required reading, so is SQL’s Books Online. That said, I recently picked up Ken England’s “Performance Oprimization and Tuning” and found it a VERY useful addition to the Books Online. Ken Henderson has a couple of good T-SQL books (learn T-SQL… not hard, although a bit [...]
View Answer
| May 19, 2004 5:04 PM
SQL Server, Standard Edition 2000
SQK Server 2000 Database Size
One cheap way: in Query Analyzer, right click the database name -> Script to New Window -> Create. Wow, that’s really cheesy, but it does work. I’m sure there’s a sys table with this info though.
View Answer
| May 19, 2004 4:40 PM
SQL Server
One cheap way: in Query Analyzer, right click the database name -> Script to New Window -> Create. Wow, that’s really cheesy, but it does work. I’m sure there’s a sys table with this info though.
View Answer
| May 19, 2004 4:40 PM
SQL Server
SQL Server 2000 log shipping through a firewall
Yes. Used a VPN tunnel between the two firewall devices to ship the logs.
View Answer
| May 17, 2004 11:00 AM
SQL Server
Yes. Used a VPN tunnel between the two firewall devices to ship the logs.
View Answer
| May 17, 2004 11:00 AM
SQL Server
Encryption in the Database
Yes, in a ASP.Net application we encrypted CC info as the SQL server was located at a site we did not control. It was very straightforward to code (VB.net). We did not performance track it as we were only reading/writing one record at a time but I would think it would be minimal.
View Answer
| May 12, 2004 2:31 PM
Oracle, OS/390, SQL Server, UDB for mainframe, z/OS
Yes, in a ASP.Net application we encrypted CC info as the SQL server was located at a site we did not control. It was very straightforward to code (VB.net). We did not performance track it as we were only reading/writing one record at a time but I would think it would be minimal.
View Answer
| May 12, 2004 2:31 PM
Oracle, OS/390, SQL Server, UDB for mainframe, z/OS
SAP and database maintenance (SQL Server DBMS)
As per my experience, indexing can cause issues with the SAP database performance, Hence, indexing reorganization may be required in SAP. We did it in previous implementation. We faced with indexing problem with one of the big SAP table. The indexing created by us was causing conflicts with the indexing provided by SAP. The search [...]
View Answer
| May 12, 2004 1:17 PM
SAP, SQL Server
As per my experience, indexing can cause issues with the SAP database performance, Hence, indexing reorganization may be required in SAP. We did it in previous implementation. We faced with indexing problem with one of the big SAP table. The indexing created by us was causing conflicts with the indexing provided by SAP. The search [...]
View Answer
| May 12, 2004 1:17 PM
SAP, SQL Server
Hosting SMS in SQL Server
Its really just important to understand the security SMS requires between its services and the SQL database. Microsoft suggests keeping the SQL database on the SMS server simply for performance reasons (i.e., SMS is in constant contact with the SQL database for updates, changes, monitoring, etc.). A lot of companies choose to move the database [...]
View Answer
| May 12, 2004 11:23 AM
SQL Server
Its really just important to understand the security SMS requires between its services and the SQL database. Microsoft suggests keeping the SQL database on the SMS server simply for performance reasons (i.e., SMS is in constant contact with the SQL database for updates, changes, monitoring, etc.). A lot of companies choose to move the database [...]
View Answer
| May 12, 2004 11:23 AM
SQL Server
