bigator

SSIS Configurations – Deep Dive Session

Hello everyone,

Here are the slides of my session of “SSIS Configurations – Deep Dive” – @ Microsoft SQL User Group, Singapore

Thank you very much for all your support :)
My apologies for machine issues and I could not show you demo.

I will talk to team and ask for 20 minutes to show you this demo during next sessions (if possible).

Event Info:
SG SQL User Group Meeting – Oct 2015
http://www.meetup.com/mssgug/events/228948056/

Kindly stay tuned for more upcoming events @ Meetup page.(Group Name: SG SQL User Group).

See you in again & thanks for coming.
Thanks, Khilit :)

bigatorFebruary 25, 2016 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , ,  · Posted in: Business Intelligence, SSIS

Power BI – Overview, Updates & Examples (Session 2)

Hello everyone,

Here are the slides of my session of Power BI – Session 2 – @ Microsoft SQL User Group, Singapore

Thank you very much for all your support :)

Event Info:
SG SQL User Group Meeting – Oct 2015
http://www.meetup.com/mssgug/events/226181209/

Kindly stay tuned for more upcoming events @ Meetup page.(Group Name: SG SQL User Group).

See you in again & thanks for coming.
Thanks, Khilit :)

bigatorOctober 29, 2015 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , ,  · Posted in: Business Intelligence, Power BI, SQL Azure

Power BI Desktop – Introduction & Overview (Session 1)

Hello everyone,

My apologies for delay in uploading the slides of my first session of Power BI. Thank you very much for all your support :)

Slides of Power BI – Session 1 @ Microsoft SQL User Group, Singapore

Event Info:
SG SQL User Group Meeting – Sept 2015
http://www.meetup.com/mssgug/events/225067757/

I will be speaking again on Power BI in October 2015. Dates will be declared on FB and MeetUp page. Kindly reserve/confirm your seats through Meetup page (Group: SG SQL User Group).

See you in October 2015 @ Microsoft, Singapore.
Thanks, Khilit :)

bigatorOctober 14, 2015 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , ,  · Posted in: Power BI

MERGE your knowledge from EXPERTS – “Project BOTTICELLI”

Hi guys,

I am just about to write an introduction of “Project Botticelli” for you; but they gave their introduction in very nice and precise manner so I decided to extract that and put it here for your quick reference.

(Excerpt from https://projectbotticelli.com/about-project-botticelli-ltd)

Project Botticelli Ltd is a small company offering online training by business intelligence experts and consulting services focused on advanced analytics, with a focus on data mining, predictive and statistical analysis.

I have seen couple of their videos and I am impressed with explanation & demonstrations. Please check out their contents on their website (https://projectbotticelli.com/). Currently there are many FREE previews/videos available. Also check out their membership plans (https://projectbotticelli.com/membership)

You can get some finer information on following five topics:

  1. Data Mining
  2. DAX
  3. Excel BI
  4. MDX
  5. SQL BI

You know what to do next.

Thanks, Khilit

bigatorJune 6, 2014 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , , , ,  · Posted in: Business Intelligence, Data Mining, DMX, Excel, MDX, Pivot Table, Power Pivot, SQL Server, SSAS, Suggestion, Training

T-SQL Tip : Finding Running Total Value

Hi Guys,

In one of my SSRS Reporting needs, I need to display RunningTotal in some funny colors. Here is the script that I have used. I hope it may help you somewhere too :)

RunningTotal_SQL_Script

Thanks, Khilit

bigatorMay 21, 2014 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , ,  · Posted in: General, Interview QA, SQL Server

FREE E-Books from Microsoft Press

Hi guys,

Check out these FREE ebooks from experts of MS Press.

http://www.microsoftvirtualacademy.com/ebooks

Thanks, Khilit

bigatorApril 9, 2014 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorPosted in: Uncategorized

Three Things I’ve Learned From Warren Buffett – By Bill Gates

Hi Friends,
Just wanted to share with you quickly… a good article by Bill Gates.

http://www.linkedin.com/today/post/article/20130612065727-251749025-three-things-i-ve-learned-from-warren-buffett?trk=eml-mktg-celeb-bg-title

Thanks, Khilit

bigatorJune 14, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags:  · Posted in: General

MDX and DAX Query Formatter …. is back :)

Hi Friends,
Just to share with you quickly that “MDX and DAX Query Formatter” site is back online.

Here is the link: http://formatmdx.azurewebsites.net/

Thanks, Khilit

bigatorMay 13, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , ,  · Posted in: Business Intelligence, Data Mining, DMX, General, Interview QA, MDX, Query Tuning, SQL Server 2012, SSAS

Recover Backed-up query files in SQL Server Management Studio

Hi guys,

I just want to share quickly very handy tip regarding your SQL query sessions. When you open SQL queries in SSMS, you generally go on and work in newly opened pane/window but sometimes dont save that work.

SSMS by default saves them in the event of pre-mature closure or crash of SSMS or PC restart etc. You can find your SQL queries from following lcoation.

C:\Users\<UserName>\Documents\SQL Server Management Studio\Backup Files\Solution1

FYI, I have found my queries here:

SQL_Queries

P.S. I am using Windows Server 2008 Operating System. This path could vary based on the Operating System. You can figure it out for sure :)

I hope you find this interesting and helpful.

Thanks, Khilit

bigatorMay 7, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , ,  · Posted in: Business Intelligence, General, Quick Tips, SQL Server 2012, Tutorial

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 of the case where you are inserting a record in table A and there is a trigger which fires as soon as there is a insert in table A which insert a record in table B. so in such case @@IDENTITY wont give you the correct id/pointer of inserted record.

So to deal with this issue you can use SCOPE_IDENTITY(). You will always get the last value you have inserted in table. However, it is noticed that sometimes in some scenarios SCOPE_IDENTITY() does not promise the correctness of results. May be due to parallelism or multiple inserts or bulk inserts in table(s). E.g. when you do … Insert Into Select <columns> from Table

Well, Microsoft recommends that “You do not use either of these functions in your queries when parallel plans are involved as they are not always reliable. Instead use the OUTPUT clause of INSERT statement to retrieve the identity value“.

Check out MS articles:
http://support.microsoft.com/default.aspx?scid=kb;en-US;2019779
http://msdn.microsoft.com/en-us/library/ms177564.aspx

I hope this will help you somewhere.
Thanks, Khilit

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


bigator