The Multifunctioning DBA:

SQL

1

September 16, 2009  4:37 PM

SQL Class



Posted by: Colin Smith
Education, SQL, T-SQL, Training

Found a nice article on some basic SQL. Check it out, it is never bad to have the knowledge even if you are not a DBA or SQL Developer. http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1368296,00.html?track=sy41

May 29, 2009  2:49 PM

Powershell SQL Load Script



Posted by: Colin Smith
Database Administration, MSSQL, Powershell, Scripting, SQL

In my environment we have some servers, test servers, that are loaded from the Production Servers on a regular basis. Since this is the case I have decided that I would like to attempt to script this. I just started but I am already well on my way to getting this done. I am pretty sure that I will...


May 29, 2009  2:36 PM

SQL Server Certs



Posted by: Colin Smith
Certifications, Education, MS SQL, SQL, SQL Server

I have been talking about what I would like to do to further my education and my carreer as a DBA. I started reading the books in order to study for my MCITP DBA certification and the other members of my team decided that they would like to do the same. They both ordered the books as well and now...


April 21, 2009  9:06 PM

SQL Server Education



Posted by: Colin Smith
Database Administration, DBA, Education, SQL, SQL Server

In an earlier post I said that I was about to start reading some books from the advanced Sybase Training course. I have changed course since then and I have decided to move on with some SQL Server education instead. I have decided that I would like to get my MCITP: Database Administrator...


February 20, 2009  9:20 PM

Sybase Kill Runaway Process



Posted by: Colin Smith
SQL, Sybase

I am working on a stored proc that will be launched by a threshold that I set up on the log segment of my databases. It is a bit of work but I think that it will be nice not to get the page that someone has written some poor SQL and is filling up the log segment. I will not be running this in...


January 27, 2009  8:58 PM

Learning SQL



Posted by: Colin Smith
SQL, SQL Server

I have been a DBA for about a year now and I still have not had to really do much SQL. I do other things such as backups, restores, indexing, and other things to make sure that our databases are in good shape and that our data is safe. I thought it would be a great idea to learn some SQL though so...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: