SQL Server
Recording SQL Server CPU utilization for later analysis
Since we are still on SQL Server 2005 (going to 2008 R2 in the next six months), we don’t currently have the performance repository that 2008 does. As such, we recently added a job to record CPU utilization for later analysis. We have a job that runs every five minutes and simply runs the... »
Query SQL Server stored procedure text with JDBC
I needed to quickly print the text associated with several stored procedures across multiple database servers to individual files. I used what is below. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30... »
Connecting to SQL Server using internal authentication
We use java for a lot of our jobs, and using it to access SQL Server is no exception. We wanted to have controlled access, and avoid “user sprawl” across servers. As such, we use Windows authentication from our java programs. Below is an example: 1 2 3 4 5 6 7 8 9... »