bigator

Archive for the ‘Free’ Category

Retrieving id of inserted record: What to use @@IDENTITY or SCOPE_IDENTITY() or OUTPUT

Hi guys, This seems very basic information but need to know properly. Issue: I need to find out or have the id of the records which I inserted in table. Analysis: This requirement seems very simple but there could be various cases where you would not get the correct id just by using @@IDENTITY function. Think […]

bigatorFebruary 6, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , , , ,  · Posted in: Business Intelligence, Free, General, Interview QA, Quick Fix, Quick Tips, Script, SQL Server, SQL Server 2012, SQLServerPedia, T-SQL, Training, Tutorial

The Story of Precision, Scale, and Length in SQL Server

Hi guys, Did you ever faced issues with BIG mathematical figures – related to either overflow or any  other arithmetic errors. This may be applicable to SQL arithmetic operations or arithmetic  operations you do with SQL table in SSIS etc. Well, check 1 more time, if you have any issues in your database design related […]

bigatorJanuary 28, 2013 · bigatorKhilitchandra Prajapati · bigatorOne Comment
bigatorTags: , , , , ,  · Posted in: Business Intelligence, Free, General, Interview QA, Quick Fix, Quick Tips, Script, SQL Server, SQL Server 2012, SQLServerPedia, SSAS, SSIS, SSRS, T-SQL, Tutorial

Tracking Down Ghost Characters: WHERE Clause Does Not Work Properly In T-SQL Query

Hi guys, I would like to share an experience with you when I was working on 1 SSIS related issue. Scenario was: I have to exclude some records from Table A by matching some keys of Table B.  Table A Year Month CustomerCode <Extra Columns> 2012 JAN CX1000   2012 JAN CX2000   2012 JAN […]

bigatorJanuary 25, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , , , , , , ,  · Posted in: Business Intelligence, Free, General, Interview QA, Quick Fix, Quick Tips, Script, SQL Server, SQL Server 2012, SSIS, T-SQL, Tutorial

SQL Server User Group Event on 4th Oct 2012, Singapore

Hello friends, how are you doing? There is an event (SQL User Group, Singapore) on 4th October 2012. Following is the detail about the event. Send an email to “Chen Liang <liangchen@dataraid.info>” with your name, working place and contact number for reservation of your seat. There is no charge for all members of SQL Server […]

bigatorSeptember 19, 2012 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , ,  · Posted in: Business Intelligence, Free, General, Microsoft Event, SQL Server, SSIS

E-Book Gallery for Microsoft Technologies

Hi guys, good morning !!! here is the list of cool FREE E-Books from Microsoft Press.

bigatorSeptember 7, 2012 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , , , , , , , , , , ,  · Posted in: Business Intelligence, E-Book, Free, General, Interview QA, New Features, Quick Tips, SharePoint, SQL Azure, SQL Server, SQL Server 2012, SSIS, SSRS, Training, Tutorial, Windows

Free E-Book Offer from Microsoft Press: Introducing Windows Server 2012

Hi all, Good morning!!! Microsoft Press launches FREE EBook of “Windows Server 2012”. For IT professionals looking for an early, high-level view of Windows Server 2012, there’s no better resource than the Microsoft Press e-book. Based on the beta release, this guide introduces its new features and capabilities, with scenario-based insights demonstrating how the platform […]

bigatorJune 21, 2012 · bigatorKhilitchandra Prajapati · bigatorOne Comment
bigatorTags: , , ,  · Posted in: E-Book, Free, General, Windows

FREE EBook from Microsoft Press – Introducing Microsoft SQL Server 2012

Hello guys, Go and grab an opportunity to download latest & FREE eBook from Microsoft Press on SQL Server 2012. you can download it here. Or you can simply Google it to find out more sources 🙂

bigatorMarch 25, 2012 · bigatorKhilitchandra Prajapati · bigatorOne Comment
bigatorTags: , , ,  · Posted in: E-Book, Free, SQL Server

Learn SharePoint Quickly and FREE

Hi all, please check-out FREE SharePoint tutorial Here: http://www.sharepointhosting.com/video_tutorials.html Following is the list of videos available. So if you find anything helpful, just hit the URL given above. SharePoint Tutorial – List: ——————————————————————————————————————————– Adding Documents to a SharePoint Site Create a new SharePoint Site Collection Administrator Add Links to a SharePoint List Add SharePoint Site […]

bigatorFebruary 1, 2012 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: ,  · Posted in: Free, SharePoint


bigator