Categories
- Active Directory
- Apache
- ASP.Net
- Attributes
- Batch Files
- C#
- FireFox
- Generics
- IIS
- Internet Explorer
- JavaScript
- jQuery
- LINQ
- Microsoft AJAX
- Microsoft Office
- Microsoft TechNet
- MS Build
- MS SQL Server
- MVC
- Regular Expressions
- SSIS
- Subversion
- T-SQL
- Team Foundation Server
- This and that
- Visual Studio
- WCF
- Web Services
- Windows 7
- Windows Server 2008 R2
- WinForms
- WordPress
Archives
- January 2012
- October 2011
- September 2011
- August 2011
- June 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- May 2006
- March 2006
- January 2006
Meta
Monthly Archives: August 2010
IT Toolbox: TechNet Magazine August 2010
The new August 2010 IT Toolbox posts are on the TechNet Magazine site. Continue reading
Posted in Microsoft TechNet
Leave a comment
T-SQL: Backup All User Databases
Here’s an easy, generic way to back up all user databases on a SQL Server instance: DECLARE @name VARCHAR(50) — database name DECLARE @path VARCHAR(256) — path for backup files DECLARE @fileName VARCHAR(256) — filename for backup DECLARE @fileDate VARCHAR(20) — … Continue reading
Posted in MS SQL Server, T-SQL
Leave a comment
Stored Procedure to Export a Table via BCP
If you are looking for a generic way to export table data via BCP, here’s how: CREATE PROCEDURE [dbo].[u_ExportDataViaBcp] ( @name VARCHAR(100), — this is the table (or table function) name to export @file VARCHAR(200), — output file @fmt_date INT … Continue reading
Posted in T-SQL
Leave a comment