# Tag Info

7

You can use Ola Hallengren's - SQL Server Maintenance Solution This is much flexible than maintenance plans. We have 300+ servers and we are using it for all our backups. It just works flawless. To get you started : Automate and Improve Your Database Maintenance Using Ola Hallengren's Free Script

7

Judging from the activity on the PostgreSQL jobs mailing list I'd say it's not all that uncommon to find full-time PostgreSQL DBAs. http://www.google.com/search?q=full+time+site:postgresql.org/pgsql-jobs

7

We shouldn't forget to mention Yahoo! With a search engine and web portal of that size, we can only make rough estimates on the size of their PostgreSQL DBA teams..

5

Sure there are. Of course in many cases, you don't need a full time DBA for PostgreSQL, but on the other hand, places like Skype, myYearbook.com, and Afilias have teams of full-time PostgreSQL DBAs.

5

Separate the two tasks. One of the good ETL rules to follow is to get in and out of the source system as fast as possible. Dumping the Oracle data to flat files should be orders of magnitude faster than inserting direct, as should the subsequent import of those files to SQL Server. Export from Oracle to flat file. There are several approaches detailed at ...

5

"It just does". Its just meta data about the backup. The Books Online article http://msdn.microsoft.com/en-us/library/ms186299.aspx hints at it, albeit not very well in the "Remarks" section. From that article you'll see a reference to sp_delete_backuphistory. So yes you can safely remove it if you need to. The info that goes into that backupset table, ...

4

First, are you sure the data growth won't happen again? If there's a realistic chance it will and the empty space doesn't hurt you, leave it, do NOT shrink the database. However, if you're positive you want to reduce the data file size, then you should be aware of the pitfalls of data file shrinking: It causes massive index fragmentation. Affects ...

3

That is how it tends to work in small companies, but that is how it always used to work for small companies: at a small scale an expert database person was often seen as a grandiose expense when all the devs can do the basics. This is not really a factor of ORMs and noSQL becoming popular recently. ORMs still have datastores behind them that someone needs ...

3

Use the -e flag when you start psql. For example: psql -e mydatabase Or, in case of using a script, try the -a flag. Details in the manual.

3

This seems to be an open and shut case for placing the meaningful codes into another table with a foreign key to it from this column. It restricts the values that can be used and provides a meaning for the numbers.

3

Though your question might be closed as it is primarily opinion-based, I would suggest you to start actively participating on http://dba.stackexchange.com/ and stackexchange site along with SQLServerCentral.com and msdn forumns. This will help expose you with practical real world scenarios. If you have budget to go for in-person traning, then highly ...

3

Yes there are, and the numbers may be on the rise. In the last 3 months of this year, I have been contacted by 3 local companies looking for full time PostgreSQL professionals, in an area typically dominated by MSSQL and Oracle (SE United States). I took one of them, and now work mostly with PostgreSQL after working with SQL Server for 12+ years. I would ...

3

PG dbas are rare and hard to find. What does not make matters easier is that the going salaries can range from better than Oracle or SQL DBAs at companies that require PG for their most critical applications, and experienced difficulties finding the appropriate personnel. Others seem to try to hire on the cheap not making it worthwile for DBAs to stay or ...

3

Short answer: You can't disable the generation of transaction log records. See Avoiding logging for user operations by Paul Randal. Full recovery model fully logs all transactions. With simple and bulk-logged recovery model there are some operations that are minimally logged (like bulk loads and index (re)builds, see link below for details). Minimal logging ...

2

The roles in Oracle Database have no owner as well as directories have no owner. But whenever the new role is created (by user with SYSDBA role or CREATE ANY ROLE prvilege) it is automatically assigned to the user who created it. You can see what roles are assigned to which users querying DBA_ROLE_PRIVS view, or USER_ROLE_PRIVS if you want to know what roles ...

2

Regarding providing DBA access, you might be better-off creating an Active Directory group and adding the DBAs into that group. That way, you can provide group-level permissions and give sysadmin to the group rather than individual users, meaning that when a DBA leaves (or a new one gets hired), you just need to adjust Active Directory rights rather than ...

2

Your answer is right here in SO already: Restrict SQL Server Login access to only one database. Just in case the link is broken: 1. Connect to your SQL server instance using management studio 2. Goto Security -> Logins -> (RIGHT CLICK) New Login 3. fill in user details 4. Under User Mapping, select the databases you want the user to be able to access ...

2

How do you define the "tablespace size"? Are you interested in the total size of the data files on disk that comprise the tablespace? Or are you interested in the total size of all the segments that are part of the tablespace? Issuing a DELETE will not affect the size of the table's segment so it will have no impact on the size of the tablespace under ...

2

While the maintenance plans aren't the most flexable things in the world, for someone who is only managing just a couple of servers, maintenance plans are perfect for you. The code you show in your question will enable the SQL Agent, then you can configure and schedule your maintenance plans. You'll also need to go into the "SQL Server Configuration ...

2

You don't want your test database to retain the same internal id number as the production database. Hence it would be best to use RMAN's command DUPLICATE, because it sets a different id (and also a new database name). This command is specifically designed to do what you require.

2

If you've dropped all the tables, you could just drop the database and re-create it. It will be created with the default sizes and growth rates as defined by the model database. These may not be ideal (I don't find the defaults particularly useful in most scenarios), but you can change them. Unless you have a lot of things set up on this database (like ...

1

I recommend you use DBCC SHRINKFILE(). You can check the available space available by file using the query in the answer at this link How to determine used/free space within SQL database files? If you only have one data file and one log file it'll probably just be file #1 and file #2. You have to pass the file number to the SHRINKFILE command. It's not ...

1

Ask your boss to get you a pluralsight subscription. Additionally, read answers from people like Paul White, Aaron Bertrand, Remus, etc and try to answer questions on this site. Read blogs from sqlskills.com, brentozar.com, mssqltips.com, sqlperformance.com. Also folks from sqlskills and brentozar are giving inperson training in LD. Sqlbits event in UK ...

1

You use mysqldump. Step 1. Dump your original 32 bit database. mysqldump my32bitdb [options...] > mydb.sql Step 2. Copy the file mydb.sql to your new server Step 3. Load the 32 bit database mysql -u root -p my64bitdb < C:\path\to\mydb.sql With 10GB of data, it shouldn't take much more than ~ 1hr. For reference, see here and here.

1

Firstly, read the Wikipedia article that explains UTC/GMT. Time stamps with time zones are expressed as a date, a local time (eg: 08:00:00, which is 8am), and an offset (eg: -8, which would be 8 hours behind UTC). To convert a local time into UTC you use the offset. So, in your example of: TIMESTAMP '1999-04-15 8:00:00 -8:00' ... the local time is ...

1

Please do not change Sql Server's TCP port unless you know what you are doing. This needs to be done only in specific scenarios like manual SPN registrations with failover cluster setups or restricted environments. Sql Server installations contain a special service called Sql Browser Service. When a client tries to connect to a named instance, it will ask ...

1

For Oracle client you can use Installation using Response Files. Your C# program can generate response file and run installer with particular command line options.

1

Although a role does not have an owner, dba_role_privs shows both users and roles granted to a privilege. --This lists both users and roles SELECT * FROM dba_role_privs WHERE admin_option = 'YES' order by grantee, granted_role; Inner Join to dba_users to see only users with admin option on roles. --This lists only users with admin option on roles SELECT ...

1

The reason your index isn't being used is that the two following SELECT are fundamentally different to the optimizer: SELECT rows FROM table WHERE status = PROCESSED; SELECT rows FROM table WHERE status = 0; In the first case the database will interpret PROCESSED as a variable, and its value, even if constant won't be learned until execution time. An ...

1

You have 6 indexes PRIMARY KEY (UID), KEY FK_miii_data_miif_mapping (MODEL_INTEGRATION_IMPORT_FIELD_MAPPING_UID), KEY FK_miii_data_miif (MODEL_INTEGRATION_IMPORT_FIELD_UID), KEY FK_MIIIData_MIIInstance (MODEL_INTEGRATION_IMPORT_INSTANCE_UID,IMPORT_PAGE_NUMBER), KEY i_ticker (MODEL_INTEGRATION_IMPORT_INSTANCE_UID,TICKER_CODE), ...

Only top voted, non community-wiki answers of a minimum length are eligible