A while before few weeks, I discussed about an error of replication “The row was not found at the Subscriber when applying the replicated command”. We had a tricks to get discrepancies for error table and resolved issue. Let me put another method (Actu...

In one of my recent blog post of SSIS Buffer Error , I have demonstrated how Union All transformation has caused error. I received a comment in the blog post, asking for the functionality of Union All task and why and how it is used. This blog post is f...

After installation of SQL Server 2012 SP1, one may encounter a situation where the CPU spikes to 100%, NGEN errors are encountered and Event Viewer has the error message: "Detection of product '{A7037EB2-F953-4B12-B843-195F4D988DA1}', feature 'SQL_Tools_Ans', Component '{0CECE655-2A0F-4593-AF4B-EFC31D622982}' failed." This post directs to the Microsoft KB article with the solution....

In this post I am going to explain about HTML Editor Enhancement in visual studio 2012. I have been writing few post about Visual studio 2012 new features and this post will also be part of that. You can read whole series at following link. Visual Stud...

I’ve blogged about the Properties()  function before. MDX #11 – How to get number of cars each customer owned using Properties() function? MDX #12 – Do not forget the TYPED flag in the Properties() function  The Properties()  function ...

Recently, i encounted an error on OLEDB Source "Error: A rowset based on the SQL command was not returned by the OLE DB provider."

The OLEDB Source in the Data Flow Task was using an SQL command. The command query was executing a stored procedu...

In this post, we take a look at the Full-Text and Semantic Search related Dynamic Management and Catalog Views - sys.fulltext_semantic_language_statistics_database, sys.fulltext_semantic_languages, sys.registered_search_properties, sys.registered_search_property_lists, sys.dm_fts_semantic_similarity_population...

Sometime in January, visualization expert Stephen Few expanded on Tufte’s idea of Sparklines and came up with this new visualization called Bandlines. Bandlines use horizontal bands of color in the background of the plot area to display information abou...

The request failed or the service did not respond in timely fashion. Consult the event log or other applicable error logs for details....

Previous posts on this series Exploring SSIS - Understanding the basics Exploring SSIS - Execute SQL task with simple parameter Exploring SSIS - Export to csv file Exploring SSIS - Rename file by suffixing current date I have started a series on Explori...