Hot answers tagged

13

Demonstrating ROI on hiring additional DBA's is hard since DBA's don't generate revenue by themselves. They do however allow the organization to function and generate revenue, just like any other supporting staff. A lack of staff in any department makes the organization function less optimal and lose money or lose opportunity. So there is a cost from lack of ...


9

I think sp_Blitz by good folks at Brent Ozar Unlimited is the best way to go with a new to me server. https://www.brentozar.com/blitz/ https://www.brentozar.com/first-aid/sql-server-downloads/


9

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


9

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 ...


8

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..


7

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.


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


6

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

Don't re-invent the wheel; just get a solution like Ola's in place now: Ola Hallengren's SQL Server Backup, Integrity Check, and Index and Statistics Maintenance You can tweak the settings and learn how it works over time.


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, ...


5

Do a back-up/ restore - takes longer but appears to be a favoured method. This is what we prefer. -- Backup and Restore. Safer Method. Option to detach the database using sp_detach_db and then attach it using CREATE DATABASE ... FOR ATTACH; or detach and attach using the GUI will actually detach the database from the source server. Many things can ...


4

You could use a logon trigger perhaps, going forward (see here and here). For historical information, by default, SQL Server doesn't even track successful logins (though this can be turned on - however it means you will need to parse the SQL Server log for some little bit of information). So while you might get some information (such as which workstations ...


4

I will try to help you. First if you want to work an BI and DBA Dev you need to learn: T-SQL if your with SQL Server or (PL / SQL) if you are working with Oracle. T-SQL Query is a great book to learn T-SQL. Learn to design databases this includes tables, typing the correct data type for the columns, table relationships, and so on. Beginning Database ...


4

NOT an answer - but too long for a comment. [opinion] Faced with (luckily for you) a choice between MySQL and PostgreSQL, I would unhesitatingly go with PostgreSQL. CHECK constraints - silently ignored by MySQL. Incredibly reported as a bug 8 years ago - at least it's documented! :-( "The CHECK clause is parsed but ignored by all storage engines". CTEs ...


4

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 ...


4

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 ...


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 ...


4

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 ...


4

Like you've already suggested, as soon as I got there I'd perform an inventory of all SQL Servers before then spending time running the latest version of sp_Blitz® – Free SQL Server Health Check Script and auditing the results. Depending on the results I'd then probably look to get in and standardise Ola Hallengrens SQL Server Maintenance Solution. You can ...


3

ORA-01102 cannot mount database in EXCLUSIVE mode Cause: Some other instance has the database mounted exclusive or shared. Action: Shut down the other instance or mount in a compatible mode. Find whether you have any running Oracle process. $ ps -ef | grep smon Kill the process then try to start again. Since I dont have the procedure which ...


3

Teradata only allows one level of role nesting, there's no workaround. Either role_2 or is already granted to another role or role_1 has been granted another role. role_a -- top level | role_b -- GRANT role_b TO role_a; this is ok, 1st nested level | role_c -- GRANT role_c T1O role_b; this will fail, 2nd nested level


3

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 ...


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

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

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 ...


3

The backup/restore method is generally my preferred way especially if you're on 2008R2 or higher due to backup compression. If you don't have access to that feature, the backup file generally is still a smaller file copy than the .mdf/.ldf file copy because a backup file removes any wasted space in those database files


3

The first thing you have to remember is that all transactions are logged to some degree. There are cases where an action can be minimally logged but there is still some entry in the log. The recovery modes just change how often the space in the log is freed for re-use. In all cases the log space is freed up once it is no longer needed. In the case of ...


3

Not only is it a best practice, it's mandatory to any major compliance requirements such as PCI V2 & V3, SOX, and almost any auditor will ask about it. Yes, having them on the same network is asking for major problem. Page 5 of the PCI DSS V2: For example, there must be a clear segmentation of functions and segregation of networks with different ...


3

One of the considerations implementing multiple databases is different RTP/RPO requirements. It seems this is the case in your situation because the RPO is different. Consider creating a separate databases for the ETL tables and historical data. Backup the historical data database as needed to meet your RPO. The ETL database can be backed up ...


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.



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