Category Archives: SQL Server

Important Fact: Default Logging in SSIS which store log entries in SQL Server

Khilitchandra's Business Intelligence Blog Posted on by

Hi all, Few days back I have posted an article on “Default Logging in SSIS“. You can refer that here. In that article I have forgotten to mention a behavior of “enabling a default logging in SSIS package“. Let me show you what you need to know about this fact. Fact: When you enable a “Default Logging” with SQL Server in SSIS package, it does not create any table (i.e. dbo.sysssislog) or stored proc (i.e. dbo.sp_ssis_addlogentry) at the same time of setting-up in SSIS package. But when you run your package first time, these objects gets created automatically.

Continue reading →

Spot/Highlight Minimum and Maximum value(s) in each row in Matrix report in SSRS :)

Khilitchandra's Business Intelligence Blog Posted on by

Hi all, How are you doing? Today I would show you; how you can highlight minimum and maximum values in an each row of matrix report in SSRS. Again, “there are lots of ways“, but that depends on what is your solution framework. If you are using standard T-SQL queries for reporting, then it’s easier to write this min-max logic in query itself. But if you are using SSAS cube then you have to write custom MDX (i.e. calculated column/”Member” in Cube’s term) and do comparison in SSRS report in each row. I can show you even simpler way where … Continue reading →

The History of SQL Server

Khilitchandra's Business Intelligence Blog Posted on by

Hi Guys, A nice video on “SQL Server History” 🙂 SQL Server provides all organizations with a highly secure and trusted data platform on which to efficiently develop and use a broad array of feature-rich solutions to address customers business imperatives, including business intelligence applications, server consolidation and compliance. Thanks, Khilit

Continue reading →

Singapore SQL User Group – Special Meet Up: “SQL Server for Private Cloud”

Khilitchandra's Business Intelligence Blog Posted on by

Hi Guys, Singapore SQL User Group is running a special meet up with Microsoft’s visiting speaker from U.S. Topic: SQL Server for Private Cloud Primary Focus: Many customers are deploying virtualized SQL Server in production environment. Join this session to find out about “SQL Server for Private Cloud“, a solution that is part of overall Microsoft Hybrid IT story. It will cover new features & functionalities of SQL Server 2012, System Center 2012, and Windows Server “8” that greatly enhance the capabilities of database applications running in Microsoft Private Cloud and the steps on putting this solution in your customer … Continue reading →

Rocking “Catalog Views” in SQL Server 2012

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, Today I came across an article on MSDN regarding the meta-data of SQL Server objects which led me to the “Catalog Views“. What is it? “Catalog View” provides the information which is used by SQL Server Database Engine. So one thing is – “you can definitely trust this method“. Moreover, Microsoft recommends this method for information retrieval because it is the most efficient way to obtain, transform, and present customized forms of this information. To make the information retrieval easier, Microsoft has categorized almost every object available in SQL Server in following catalog categories. (Pls see below). You … Continue reading →

SQL Server Database Keys: PrimaryKey, NaturalKey, ForeignKey, UniqueKey, CandidateKey, AlternateKey, CompositeKey, SuperKey, SurrogateKey

Khilitchandra's Business Intelligence Blog Posted on by

Hi Guys, How are you doing? Many a times during interviews I notice that candidates know lots of things but they really hesitate while talking about “SQL Server Database Keys“. And even if they know about keys, they fail to provide proper answers with examples. So, today I would like to summarize few definitions which every database developer should be aware of. I am not going to explain each in details but this will sure give you enough confidence to generate your own examples during interviews 🙂 I am going to use the following table for example reference in below … Continue reading →

What ?? There is a “Ghost” in SQL Server !!!

Khilitchandra's Business Intelligence Blog Posted on by

Yes, it’s a cleanup process available as a part of SQL Server Storage Engine. It runs in background to cleanup ghost records. If you can remember … “When we create a clustered index then it stores actual data/records at the leaf level of the index.” And SQL Server marks/declares a record as a ghost records when they are deleted from leaf level of index. Why just mark and not to delete at once even though SQL Server knows that user does not need that record anymore ?? Well, to achieve better performance SQL Server runs “Ghost Cleanup Task” asynchronously to … Continue reading →

What happens to IDENTITY Column Value When SQL Transaction Fails??

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, I would like to share a simple interview question. This is very simple yet many developers overlooks or not taking care of it. Do you know what happens to identity value if transaction fails? Do you think that identity value of table is unchanged after failure? Before looking at the solution below, try to memorize ACID properties of transaction and answer it. Check-out the POC shown below & wobble your mind 🙂

Continue reading →