Well it has been a while since I posted anything here, it seems that finding stuff to write about or stuff that I learn while
Execution Plan Basics
Just read article explaining SQL Query plans and how to understand them. I find many people don’t know what these plans mean or if they
To SP or not to SP in SQL Server
Just read this article, I am stronge following to SPs. Of of the points highlighted in this were a bit of suprise to me. Using
WIP: MCITP: Database Administrator
Getting ready for the test, I finished reading the SQL Server 2005 – Designing a Database Server Infrastructure (Self-Paced Training Kit). I used the same
WIP: Mirroring Issues
We have a SQL Server 2005 EE 64x mirror enviornment set up; but even though the SQL Servers looks like they are performing their duties
WIP: SQL Server Security Development, Testing, and Production
Currently I have multiple SQL Server instances; with almost no standards to speak of. So trying to figure out what standards I want to define.