Wordpress - cavemansblog.wordpress.com - Caveman's Blog
General Information:
Latest News:
SQL Server: Data transfer for Excel using Linked Server 29 Jul 2012 | 06:47 am
Introduction I will demonstrate yet another way to perform data transfer to and from an excel file using a Linked Server in SQL Server 2008. In this demo I will show you how to: Create a Linked Server...
Sample Code: Xml validation using XSD 7 Jul 2012 | 12:17 am
Starting today I will post some useful code snippets, samples to perform simple coding tasks. First in this series is a code sample on how to validate an XML file using an XSD file. Import the follow...
SQL Server: Incorrect SET options on a stored procedure error 6 Jul 2012 | 03:00 am
We had to put out a another fire at work when a Stored Procedure that was not modified in ages started to fail. Following is the error that was caught by the application. INSERT failed because the fol...
Dependency Injection: Unity Application Block 5 Jul 2012 | 12:43 pm
In this post I will show you how to use Microsoft Unit Application Block to achieve Dependency Injection. We will see the two methods of configuring the IOC container, firstly the “.config” way and th...
PSExec: Execute batch files remotely 23 Jun 2012 | 11:32 am
PsExec is a light-weight telnet-replacement that lets you execute processes on other systems, complete with full interactivity for console applications, without having to manually install client softw...
EF4: Searching Japanese text won’t work 23 Jun 2012 | 09:56 am
Problem: EF4 does not to return any data when searching for Japanese names from a user table. Setup: The web application layers use the following technologies ASP.Net <—-> Business Layer <—-> EF 4 <—-...
SQL Server: Get only the date and/or only the time part 22 Jun 2012 | 09:28 am
In this post I want to highlight some very useful Microsoft SQL Server System functions that can used to fetch datetime, only the date and only the time. Fetch various date and times Fetch only the da...
Microsoft Surface Tablet – Impressive Ad 19 Jun 2012 | 10:06 am
I hope that this tablet is as good as the Ad. Productivity would be the key for this tablets success. Go Microsoft ! Filed under: Sudheer Reddy Battula Tagged: Microsoft surface, microsoft Surface tab...
SQL Server: Restore a database from a .mdf file. 7 May 2012 | 06:10 pm
In this blog post I will show you how to restore a database from a .mdf file alone. I am working with the AdventureWorks database in this demonstration. Download the .mdf file for the AdventureWorks d...
SQL Server: How to select data from a stored procedure? 15 Apr 2012 | 05:43 am
In his post I will show you two ways of using SQL to query the data that is generated by the execution of a stored procedure. Method 1: Using OPENQUERY [1] to be able to select the intended data. OPEN...