August 2008 Entries
The September issue of TechNet Magazine is out on the website. Check out my IT Toolbox column here:
http://technet.microsoft.com/en-us/magazine/cc788739.aspx
In this issue I covered:
Mastering SQL Server 2005 Reporting Services Infrastructure Design (book)
Alloy Discovery Professional Edition
Password Corral
File System Auditor
Here's a quick way to get some timing statistics on your T-SQL:
DBCC FREEPROCCACHE
GO
DBCC DROPCLEANBUFFERS
GO
SET STATISTICS TIME ON
GO
-- Insert your query here
SET STATISTICS TIME OFF
GO
After you run the statements in query analyzer, check the messages tab to see how it went.
Yeah, this really has nothing to do with programming, but wow, was this annoying. Some how, Outlook shrunk itself down to just the title bar and I couldn't find a way to restore it to a useful size (it was either just the title bar or fully maximized).
Lo and behold, there is a handy-dandy way to resize your windows.
First, Restore the window. Next, right-click on the title bar and choose "Size". This allows you to customize (and fix whatever borked it) the window size.
Always check your context menu is the moral of the story I guess...
The August 2008 issue of TechNet Magazine is out on the website. Check out my IT Toolbox column here:
http://technet.microsoft.com/magazine/da0803cb-63a4-4d08-84a4-b8f977909b2e
In this issue I covered:
PA Server Monitor Pro Monitor Your Servers
dupeGuru Clean Up Duplicate Files
pt360 Tool Suite PRO Keep Tabs on Your Environment
TreeSize Professional Manage Disk Usage