As I mentioned in my last post I’ve begun investigating the SQL Server CLR. I decided after getting warmed up to commit to an entire series of articles and I’ve just finished the first one on security. I figured it would be the best place to start as »
Well after a long absence due to a crazy workload, I’m baaaack! Keepin’ it simple at this point. I’ve resumed studying for MCTS exams and I’ve been reading about dynamic management views. I love them. What’s more, I love the detail they provide and the »
I have been working on a “load balancing” application for OLAP applications and one or two of my previous posts touch on some things I’ve learned in the process. But now that I’ve got a working beta version I’ve decided to write my first “formal” article »
SQL Server 2005 has introduced an exciting new feature - data mirroring. And the timing couldn’t be better. This summer as we upgrade our infrastructure we’re working to increase our uptime and start doing some things right. Since we don’t have a DBA »
As always I try and post about my experiences which cause my biggest headaches. So today’s topic is about setting up an unattended install for SQL Server 2005. I have spent the entire day trying to create an unattended install to a Virtual Server installation »
SQL Profiler has been aptly referred to as the “poor man’s load tester”. 3 months ago I captured trace logs spanning 1 week. My intent was over the summer (our companies “off-season”) to use the trace logs to stress test the database to determine the »