How to setup a server to read log files nightly.
So you’ve been tasked with setting up a quick and dirty reporting server. The goal is to restore the log files from the production server to the reporting server nightly. The backups are simple, use the SQL Maintenance plan to backup the logs, and then copy them to the remote machine. But how do you […]
SoCal Code Camp Sessions are posted
I and many of the other presenters have begun entering our sessions for the next SoCal Code Camp on on October 25th and 26th at USC in Los Angeles, CA.
The Code Camp is the weekend before PDC, and right near where PDC will be held. So if you are coming to PDC this year, come a couple of days early and check out what is hoped to be the largest SoCal Code Camp ever.
I had a great talk with the NJ SQL User Group last night
Last night was my talk with the NJ SQL User Group. I would jut like to thank them for the invite, I had a great time coming and speaking with them. It was a very interactive night, with a lot of questions. Quest Software was nice enough to not just send me out there, but […]
Tuning SQL Server performance via disk arrays and disk partitioning
I’ve published another tips on SearchSQLServer.com called “Tuning SQL Server performance via disk arrays and disk partitioning“. This is sort of a part one of a two part series of tips on tuning the database server at the hardware level. In this tip I’m focusing on getting the disks setup just right. I also show how […]