Submitted by northben on Tue, 12/21/2010 - 08:54
Recently I needed to list all of the files in a large directory tree. Each line needed to include the full path to the file, and I didn't want to include the directories themselves in the list, just the files. Here's how I did it:
dir /a:-d /s /b > files.txt
The dir command, as you probably know, lists files in the current directory, but the default settings are not useful here - it does not include file path, for one thing.
Submitted by northben on Mon, 11/08/2010 - 15:37
Here is how to use the SQL convert function to extract just the date portion of a SQL datetime field.
convert(varchar(10), eventdate, 101)
It will result in something like this:
04/20/2010
You can change the syntax slightly if you want a different date format. Here is the full documentation on the convert function: http://msdn.microsoft.com/en-us/library/aa226054%28SQL.80%29.aspx
Submitted by northben on Thu, 10/28/2010 - 12:54
Here's how to control Window's Application Compatibility settings through the registry. This is normally controlled by right-clicking on an executable, clicking on the Compatibility tab, and making a selection in the Compatibility mode area. However, you can easily control Application Compatibility for all computers in a domain or network environment through the registry.
The registry key is HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags
Submitted by northben on Fri, 04/09/2010 - 15:46
Submitted by northben on Fri, 11/13/2009 - 08:53
Submitted by northben on Fri, 10/30/2009 - 11:30
If you use Group Policy, this is easy. Here's how:
Submitted by northben on Tue, 09/01/2009 - 10:21
If you want to open two Excel 2007 windows, each with different spreadsheets, you'll need to check out this tip. I have two monitors, and I need to use two spreadsheets at the same time. By default, you can't open two excel instances at the same time. Here's how to change that.
http://blog.sadasystems.com/2009/07/open-multiple-excel-2007-windows.html
In case that site or file is unavailable, I am hosting it here myself. Thanks for the tip!
Submitted by northben on Wed, 06/17/2009 - 00:06
Submitted by northben on Tue, 06/16/2009 - 13:42
If you are sure you've typed your filter condition correctly, to either include or exclude data based on a string match, try this.
Submitted by northben on Mon, 06/15/2009 - 15:11
Here's how to change the name of your SQL Server report.
To rename a report in SSRS (SQL Server Reporting Services), from the Visual Studio environment, fire up the Solution Explorer sidebar. Then, you should see your report(s) in the tree view. Right click the report to rename, and choose "rename". Easy as pie, but hard to figure out.
Pages