Tag Archives: Maintenance

How It Works: SQL Server I/O Presentation by Bob Dorr

Once upon a time, in a server farm far far away… enough talk. I was researching some warning messages on my SQL boxes and came to this 2010 paper by one of the ¬†Microsoft Customer Service and Support (CSS) SQL … Continue reading

Posted in SQLServer, Windows | Tagged , , , , | Leave a comment

Last post of the year: SQL Server 2014 Checklist for Performance

I would like to share these kind of things directly from SqlServerCentral, and not only posting links. But linking seems the best way to do it currently. Also I decided to increase that post count to 20 (yea, the yearly … Continue reading

Posted in SQLServer | Tagged , , | Leave a comment

Oracle: view Error Log and connection issues.

Usually I try not to mess with Oracle, and in return it tries not to mess with me. Relationships are difficult when both parties have pretty strong characters. But today Oracle was angry at me, and I needed to do … Continue reading

Posted in Linux, Oracle | Tagged , , , , | Leave a comment

What is the latest SQL Server Service Pack?

I don’t know. But it seems we won’t have as much SPs as once we did. I just read a great article at SSC (short for SqlServerCentral, a great source of research) with this same question. And I agree with … Continue reading

Posted in SQLServer, Windows | Tagged , , , , , | 1 Comment

SQL: Management Studio not saving changes to table

Having a blog about something you like is a great way to learn more things about it. If you keep an eye open for the other bloggers the term “community” really makes sense. This week while checking the recent activity¬†I … Continue reading

Posted in SQLServer | Tagged , , , | Leave a comment

SQL SERVER – Fix : Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved.

While dealing with older SQL versions sometimes you stumble upon some not-so-known error, and have to find a simple way to fix it. Pinal Dave points us to a simple solution if you have this error when maintaining some SQL … Continue reading

Posted in SQLServer | Tagged , , | Leave a comment

SQL – Determine which user deleted a SQL Server database

This is not too common, but usefull to know anyway. While searching for some answers to this question, I came to realize that the SQL default trace should be enough to find this information. If you are trying to find … Continue reading

Posted in SQLServer | Tagged , , , | Leave a comment

Monitoring SQL Agent jobs

And this is the second post of today, only a quick link to a great script from SQLFool. That girl is really a script junkie – and I love her scripts. http://sqlfool.com/2012/09/sql-agent-job-script-2/ It is extremely useful to be able to … Continue reading

Posted in SQLServer | Tagged , , , , | Leave a comment

SQL Job with Maintenance Plan misteriously failing

This post is to group details about one possible cause of failure on SQL Agent Jobs that have Maintenance Plans inside. Because the Job engine is not very clever when storing the messages returned from the SSIS Package (that is … Continue reading

Posted in SQLServer | Tagged , , , , | Leave a comment

Changes in maintenance plan overwriting SQL job ownership

Sometimes some things strange happens. Usually when you are trying to fix other things. This issue happened to me when revising some SQL Agent jobs to make sure all backups were running fine. I removed to old DBA account from … Continue reading

Posted in SQLServer | Tagged , , , , , , | Leave a comment