Analysis

External Article

The BI Journey: The Analyst

  • Article

Most organizations today understand the value of analysing their data. In some cases, they haven’t realized the value or are just getting started. This article, by Data Platform MVP Gogula Aryalingam, describes how analytics can start small – with just one Power BI dashboard – and grow from there.

2019-02-21

3,439 reads

Technical Article

RE: Including Sl.No column with the record set

  • Reply

Does your S.No column correspond directly to the empno (1, 1001; 2, 1002...)?If not, you probably want an identity column which will automatically increment.  Otherwise, you could use substring to pull the last digit from empno.  By the way, I wouldn't name the new column "S.No", "S_No" would be better.  Stuff like spaces, periods, quote marks, etc can cause […]

You rated this post out of 5. Change rating

2004-07-28

Blogs

So You Want to Deploy Power BI Project files (PBIPs)?

By

Have you heard the news about the new Power BI Project files? Okay, maybe...

DBAs, Organizing Your SQL Scripts in Git

By

I wrote an article that was published on SQL Server Central on how to...

Only Capture Extended Events For a Given Time

By

It’s a great question. Let’s say you want to capture stored procedure completions. But,...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers