Horkay Blog
The postings on this site are my own and do not represent my Employer's positions, advice or strategies.
Wednesday, December 31, 2008

This is a custom report developed to list user permissions.

Often DBA's need a consolidated list of permissions for a user, this custom report does this.  Developed by Tom Reeves.

Here's a report you can use to see permissions for a given user or role in SQL2005.

Save the attached file to the following location. This is where custom reports have to reside for them to work. Where you see "{user}" should be changed to whatever your username is.

C:\Documents and Settings\{user}\My Documents\SQL Server Management Studio\Custom Reports

User_Permissions.txt - Right click and save with a RDL Extension. (37.25 KB)

Wednesday, December 31, 2008 1:27:21 PM (Central Standard Time, UTC-06:00) |  | SQL Server#

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.

Wednesday, December 31, 2008 12:38:59 PM (Central Standard Time, UTC-06:00) |  | SQL Server#

Just a quick placeholder on the progress of SQL Server 2005 service pack 3.

This update is important, if nothing else to ensure your on the latest patch which addresses some security vulnerabilities.

There is also a cumulative update for service pack 3, generally I don't go down the cumulative update path unless i've been advise by Microsoft (ie, it addresses a problem being experienced) or the SQL Community in general highly recommends a specific CU.

I always start with patching my local developer edition, x86 Instance.

Slowly working through a few boxes, so far we've patched the following with no issues:

  • 64 Bit named instances running under Polyserve 3.6.1 - both dev, qa and production, no issues, Enterprise Edition.
  • 64 Bit named instance stand-alone server, Enterprise Edition.
  • 64 Bit named instance stand-alone server, Standard Edition.
  • 64 Bit Clustered SQL Server, Active / Active Configuration, no issues, did require reboot of both nodes and fail over, Enterprise Edition.
  • 32 Bit SSIS stand alone installations (no dbms) no issues.
  • 32 Bit Reporting Services Web Farm, authentication issues afterwards.

I had an issue with the Reporting Services Web Farm, which uses SQL Authentication for connectivity, caused the login to be disabled.  I had quite a difficult time getting it re-enabled and changing the password, but no errors in applying the service pack.

Wednesday, December 31, 2008 11:07:16 AM (Central Standard Time, UTC-06:00) |  | SQL Server#
Monday, December 29, 2008

Aaron James becomes the first to make the Emergency Room visit to get stiches.

Pushing a bike or running and trying to jump over a bike is how the story goes.

Oddly he seems to have actually enjoyed the experience!


Monday, December 29, 2008 10:43:19 AM (Central Standard Time, UTC-06:00) |  | Web_Blog#
Friday, December 26, 2008

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 !
Friday, December 26, 2008 8:37:02 AM (Central Standard Time, UTC-06:00) |  | Cars#
Monday, December 15, 2008

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:

Monday, December 15, 2008 11:07:50 AM (Central Standard Time, UTC-06:00) |  | General Technology | SQL Server#
Friday, December 12, 2008

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'

Friday, December 12, 2008 12:34:38 PM (Central Standard Time, UTC-06:00) |  | SQL Server#
Sunday, December 07, 2008

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

Sunday, December 07, 2008 4:14:08 PM (Central Standard Time, UTC-06:00) |  | SQL Server#
Popular Posts
Unpatched Vulnerabiltiy discovered ...
Spring Fornicator brewed...
SQL Agent will not start when a use...
SQL Instance will not fail back to ...
Hash Join vs. Merge Join
Recent Posts
May, 2019 (1)
April, 2019 (1)
March, 2019 (1)
February, 2019 (1)
January, 2019 (1)
December, 2018 (1)
November, 2018 (3)
October, 2018 (1)
June, 2018 (1)
May, 2018 (3)
April, 2018 (2)
February, 2018 (3)
January, 2018 (3)
November, 2017 (1)
October, 2017 (1)
August, 2017 (1)
June, 2017 (2)
May, 2017 (2)
April, 2017 (2)
March, 2017 (1)
February, 2017 (1)
December, 2016 (2)
October, 2016 (2)
September, 2016 (1)
August, 2016 (1)
July, 2016 (1)
March, 2016 (2)
February, 2016 (3)
December, 2015 (4)
November, 2015 (6)
September, 2015 (1)
August, 2015 (2)
July, 2015 (1)
March, 2015 (2)
January, 2015 (1)
December, 2014 (3)
November, 2014 (1)
July, 2014 (2)
June, 2014 (2)
May, 2014 (3)
April, 2014 (3)
March, 2014 (1)
December, 2013 (1)
October, 2013 (1)
August, 2013 (1)
July, 2013 (1)
June, 2013 (2)
May, 2013 (1)
March, 2013 (3)
February, 2013 (3)
January, 2013 (1)
December, 2012 (3)
November, 2012 (1)
October, 2012 (1)
September, 2012 (1)
August, 2012 (1)
July, 2012 (4)
June, 2012 (3)
April, 2012 (1)
March, 2012 (3)
February, 2012 (3)
January, 2012 (4)
December, 2011 (3)
October, 2011 (2)
September, 2011 (2)
August, 2011 (8)
July, 2011 (4)
June, 2011 (3)
May, 2011 (3)
April, 2011 (1)
March, 2011 (2)
February, 2011 (3)
January, 2011 (1)
September, 2010 (1)
August, 2010 (2)
May, 2010 (2)
April, 2010 (3)
March, 2010 (1)
February, 2010 (4)
January, 2010 (1)
December, 2009 (3)
November, 2009 (2)
October, 2009 (2)
September, 2009 (5)
August, 2009 (4)
July, 2009 (8)
June, 2009 (2)
May, 2009 (3)
April, 2009 (9)
March, 2009 (6)
February, 2009 (3)
January, 2009 (8)
December, 2008 (8)
November, 2008 (4)
October, 2008 (14)
September, 2008 (10)
August, 2008 (7)
July, 2008 (7)
June, 2008 (11)
May, 2008 (14)
April, 2008 (12)
March, 2008 (17)
February, 2008 (10)
January, 2008 (13)
December, 2007 (7)
November, 2007 (8)
Admin Login
Sign In