The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog



No Ads ever, except search!
Sunday, June 23, 2024 Login

Blog posts for the month of December,2008.
Move the Reporting Services Log files and Dump Files12/31/2008 12:38:59 PM

Moving the log files in reporting services is an often overlooked step, until after 10-14 months when suddenly your 8gb c drive is full !

Add the following line of code to the listed config files.


<add name="Directory" value="E:\Reporting Services Dump Files\" />


C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\bin\ReportingServicesService.exe.config

C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\web.config

C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\web.config

Thanks to Tom Reeves for solving this problem.

The Buick gets Heat !12/26/2008 8:37:02 AM

1989 Buick Century Thermostat replacement.


Thermostats are a simple replacement on most cars.  After a week of 5-10 degree temperatures it became apparrent that something was wrong with the Buick, no heat at all unless the vehicle is idling, at highway speeds the temperature just dropped. 


Thermostats are cheap and easy to replace, so it was a good starting point, of course the easy part did not hold true.  Most vehicles have the thermostat easily accessible at the top of the engine on head, just follow the large hose from the top of the radiator, but on the 3.3 liter buick century, the large hose attaches to a filler pipe that goes underneath the mass air flow sensor and intake throttle body, joy.... But wait it gets even better.


After finally wiggling and working my fingers between the exahaust and under the mass air-flow sensor, a new surprise, there is a bracket on one of the bolts going to the air-intake, and it was welded on !  Nothing a good hack-saw can't fix, as there was no way I was going to remove all that stuff.  After cutting the bracket, it was just a job of removing the bolts, which was not hard, but not easy, as there was not enough room to get a socket in there, so I had to use box wrenches with about 1/8 of a turn, argh.  Eventually both bolts came out, pipe removed, thermostat replaced, than the frustrating task of getting the bolts back in and putting here back together.


A close inspection of the old thermostat shows that it is in a stuck open position, which when it's 10 degrees outside and your moving at 70 mph, means no heat.  Now the Buick has heat.


Bracket Holding the thermostat on:


The Bracket now cut:

Finally the Thermostat can be reached and removed.

Old and New Thermostat, Don't forget a new gasket.

Old Thermostat, notice it is stuck in the open position!

Putting it all back together !
dw20.exe12/15/2008 11:07:50 AM

I've got a development box, old dev box, windows 2000, sql 2000, that runs a restore script daily.   This Restore script is a vbs file, it restores a file ftp'd from the production box.  It has run for many years with no issues, now every 3-4 days it hangs and runs forever.  So far the only solution has been to reboot the box.

I've dug around a bit and found many instances (10, 15, sometimes 20+) of dw20.exe running in the process / task list.

This is listed as the windows error reporting tool.  Not sure what is erroring or being reported on, but since this server is shared with devlopers who have local admin access to the server, i'd bet someone did something that than began causing this error...either configuration changes or installed some software, difficult to determine.

So far I've only found a two easy solutions, put the box on a daily reboot, or disable the windows error reporting tool.

I'm going to try and disable the tool and see what happens: 

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

To disable the Application Error Reporting tool, add a DWReportee value of 1 to following registry keys:

Modified date of stored procedures12/12/2008 12:34:38 PM

I've always wanted the ability to see the modified date (alter procedured) of a stored procedure.

Recently "SQL Cricket" - Rick Mcintosh, showed me a Dynamic Management View (DMV) that shows you the modified date of a stored procedure.  In SQL Server 2008 you can add a column in object explorer to see this (date modified), though in sql server 2005 you can not add columns in object explorer, but the DMV works in sql 2k5.  Too bad it doesn't work for all other objects, like tables.

So get your SQL2K8 Management studio up and running, it provides more information, even for sql server 2005.

DMV is below.  Thanks to "SQL Cricket".

SELECT name, create_date, modify_date

FROM sys.objects

WHERE type = 'P'

State of SQL Server12/7/2008 4:14:08 PM

An election has come and gone.

SQL PASS is completed.

SQL Server 2008 is out.

It's time to prepare for the "State of SQL Server".  This was an idea of mine, to create a report and corresponding presentation to Senior leaders of my company on the "State of SQL Server", analogous to the Presidents State of the Union Address. 

It won't be in-depth as the Presidents address, but my job isn't either !

The goal of the report is to inform the Senior leaders of where the company is with SQL Server and where we are going with SQL Server, bringing together the knowledge from PASS and our unique knowledge of working with SQL Server at our company.  It also provides an opportunity to talk about where Microsoft is going with SQL Server and how our strategies are aligning or differing from that.

As DBA's we have the choice, we can present this information, or you can wait for the Microsoft Technincal Account manager (TAM) or sales representative to talk about.  I prefer to have these conversations with the Senior leaders before Microsoft does.

I can not share the report as it is proprietary.

An outline might be:

I.  SQL Server today

   A.  Provide an Overview of the environment

   B.  Used for What

II.  SQL Server 6-12 months

III.  SQL Server - The business intelligence platform

IV.  Other DBMS's

Blog Home