This VBS script is easy to use and read.  It loops through the tabs in the spreadsheet and saves each sheet as a “Tab Delimited File”.  The script also creates the corresponding BCP command to upload to your Sybase Server.  You can modify if needed to suit another database platform.   ‘==================================== ‘Date Created: 2012_08_11

Read more…

Microsoft’s Management Data Warehouse Management Data Warehouse Terms are here check them out first as the article will use that terminology. Managed Instance Requirements: SQL Server must be version 10.50 or higher. The SQL Server instance type must be Database Engine. The SQL Server Utility must operate within a single Windows domain, or across domains

Read more…

Windows 2008 R2 Basic Cluster Administration Moving All resources to another node Cluster.exe commands Powershell cluster commands Mapping of commands. To move a all resources to another node use: C:>cluster . group “Cluster Group” /move:[nodename] To rename a cluster use: C:>cluster . group “Cluster Group” /Rename:[new cluster name] Read the rest of this article @

Read more…

To initialize a secondary database in a log shipping configuration use the code below. This will leave the database in a read_only state waiting for future logs from the primary database. Modify the areas in bold to fit your needs. USE MASTER GO RESTORE DATABASE [db_name] FROM DISK = N’D:LogShipping_tempdb_name_xxxxx.bak’ WITH FILE = 1, STANDBY

Read more…

Sometimes it’s handy to have a visual .NET Architecture Overview. Here are a few images I found. .NET Framework Concept < 4.0 .NET Framework Concept 4.0 http://msdn.microsoft.com/en-us/library/zw4w595w.aspx    

While working on my WordPress installation.  I modified a setting that made my site crash and give a 500 error after I removed the URL from the settings. After reading many posts and having tried updating permissions in htaccess files,  repairing the database and even creating htaccess files from scratch. The solution was actually right

Read more…