Launching Process Explorer elevated

Process Explorer is an excellent replacement for the default Windows Task Manager.  Process Explorer even automates this change via Options –> Replace Task Manager.  However, by default, this won’t launch Process Explorer elevated.  You can force it to run elevated by changing the registry (of course, the usual edit-the-registry-at-your-own-risk disclaimers apply). Under HKLM\Software\Microsoft\Windows NT\CurrentVersion\Image File…

0

Windows: Run elevated shortcut

You can launch any item shown in the Windows Start menu elevated by highlighting the item and either right-clicking and choosing Run as Administrator, or hitting Ctrl-Shift-Enter.  Note that this does not work when launching items from the Run window (Win-R).

0

Excel Tip #4: Adjust the Width of the Horizontal Scroll Bar

It’s not obvious unless you are looking for it, but you can change the width of the horizontal scroll bar in Excel.  On the left-hand side of the scroll bar there is an anchor you can use to resize. Can become This can be very useful in a workbook with lots of sheets or for…

0

Excel Tip #3: Worksheet Tab Color

For workbooks that contain more than one category of worksheet, you can use color to add visual distinction to the worksheet tabs along the bottom of the Excel window.  Right-click on the worksheet tab to bring up the dialog: Your tabs are now colorful:

0

Excel Tip #2: Identifying Precedent and Dependent Cells, Method 2

Excel can help you understand or troubleshoot cell references by identifying the cells dependent upon the selected cell and those that the selected cell depends upon. One way to accomplish this is via the Go To Special dialog.  It can be launched from the Find & Select menu of the Editing group in the Home…

1

Excel Tip #1: Identifying Precedent and Dependent Cells, Method 1

Excel can help you understand or troubleshoot cell references by identifying the cells dependent upon the selected cell and those that the selected cell depends upon. One method for doing this is via the Formula Auditing group in the Formulas tab. Let’s start by creating a simple worksheet:   Select A3 then click the Trace…

1

Complex scripts in PDF

There is currently a bug in our SQL Server 2005 PDF renderer which may cause it to generate incorrect glyphs for text in a complex left-to-right script.  The reason this occurs is that we need to embed font glyph indices and metric information into the PDF document.  For text in a right-to-left complex script, we…

1

SQL Server 2005 SP2 Cumulative Update 4 is available

The latest SQL Server 2005 SP2 Cumulative Update (CU4) is now available.  You can get it by calling into customer support or by making an online request.   There are two fixes in the feature areas I own that are included in this update: (Bug ID 50001816) When you export a SQL Server 2005 Reporting…

1

Rendering reports via Url Access

Querying Reporting Services for a report couldn’t be easier with Url Access (http://msdn2.microsoft.com/en-us/library/ms153586.aspx).  For example: String report = "/Folder/Report"; String filename = "Report.pdf"; List<KeyValuePair<String, String>> parameters =     new List<KeyValuePair<String, String>>(); parameters.Add(new KeyValuePair<String, String>("Param1", "Value1")); parameters.Add(new KeyValuePair<String, String>("Param2:isnull", "true")); System.Net.WebClient client = new System.Net.WebClient(); client.Credentials = System.Net.CredentialCache.DefaultCredentials; String url = "http://localhost/reportserver?" +     report +…

3

Unit testing a Katmai Reporting Services renderer

I am in the process of documenting the way my Katmai unit tests work.  There’s nothing inventive about them – they are straightforward and meant to get the job done.  I use the VSTS unit runner which works though not particularly well.  I do not go through the machinations of using and keeping up to…

1