I was flying home from the PASS summit today and I had to change planes in Dallas. I went from a real jet to the the dreaded commuter plane. They sent us down the jetway where we climbed down the steps and stepped on to the tarmac.
Read more →
I assume everyone understands the need for a unique clustered index. on almost every table. Without a clustered index the table is just heap. You have no easy way to cleanup fragementation without a clustered index.
Read more →
Gordon Mangione showed off a lot of features for Yukon in the key note this morning. DTS has been completeley rewriten and integrated into the Workbench (SQL Ent Manager) No more modal windows in the work bench.
Read more →
I spent all day Tuesday attending a session on indexing with Kim Tripp. I really learned how much I did not know about indexing for sql server. It really gave me some things to think about.
Read more →
We are trying what's up gold's new sql monitor plug in. It allows me to monitor basic sql server statuses and also sql alerts. So far it works great, but it does not handle named instances yet.
Read more →
I have been working on a VB and SQL DMO application to script out all the objects in a database. I am using this to get snapshots of our development databases.
Read more →
I was recently asked to block or deny access to 2 columns in our reporting database. I noticed that you can only deny 1 column permission at a time.
This command will deny select on the table and update on the columns.
Read more →
This company has a new idea for outsourcing the entire IT staff.
http://www.newtechusa.com/ppi/main.asp
Legacy Comments
Brett
2003-10-01
re: New concept for outsourcing IT needs.
Read more →
I have been working to reduce the amount of data that could be lost in the event of a crash. This amounts to more frequent log backups and log backups right up to the nighlty backup.
Read more →
I read Rocket Scientists cluster blog and I can synpathize with him.
We updated our Compaq cluster to the latest firmware so we could install SP4 for Win2k. 12 hours after install transient error 823 began to occur.
Read more →