A few times in the past I ran into a situation with SQL Server’s SSRS, were I needed to download all the RDL files off the server, while also maintaining the folder hierarchy information.
There are many off-the-shelf scripts out-there online to help you download all your RDL files (along with security settings and other configuration files), this article goes through a couple of simple methods that can be used to retrieve the RDLs.
Recently one of our Data Warehouse SQL server instances started throwing a bunch of alerts (severity level: 20), the alert error message looked like this:
The client was unable to reuse a session with SPID [SPID], which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing
In this post I will go through the initial steps to diagnosing this issue, as well as introduce the new (SQL Server 2008+) Connectivity Ring Buffer feature, which lives in the sys.dm_os_ring_buffers DMV, and captures any server-side initiated SQL Server connection closures.
A cheeky wee demo of SQL Server’s PowerPivot Excel Plugin, this introduction video quickly goes through how easy it is to connect to a data-source using PowerPivot, build the relationships between different tables, write a simple DAX query, and eventually use your newly created “mini” model in a Pivot Table with some vertical and horizontal sliders.
This post describes an interesting situation were SQL Server locking might occur on a table that has not been indexed carefully, and how you can resolve this issue.
SQL Server offers Full Text Search capabilities integrated within it’s framework, Full-Text Search offers very fast search capabilities over large text columns, along with advance search features such as Stemming or Thesaurus, as well as Infection (tense) Searches and Proximity Search, to name a few.
Out of the box, SQL Server’s FullText Search currently does not ship with a thesaurus for any language, here I present an English thesaurus that can be used to stem English language searches.
Mobile is a growing platform for BI integration, there are many out of the box BI solutions that offer some (sometimes limited) BI integration, I have yet to trial a full BI platform that has mobile OS compatibility natively integrated in its rendering engine
In this post I will show you a quick example of how to write an on-the-fly table in SQL Server.
SSRS is an awesome framework as part of a whole BI solution for report authoring, delivery and interaction. One problem though is that the reports produced through Visual Studio or Report Builder are too static, there is no hover-over effect in SSRS reports, and you cannot do dynamic filtering once the report finished rendering.
This posts goes through building a converter that takes the ATOM output of an SSRS chart (1 y-axis Line Graph), and returns a dynamic Highcharts graph the represent the same data points.
A simple T-SQL command that checks the progress of a particular SQL request, such as the progress of DBCC SHRINKDATABASE.
Breaking SQL queries up into temporary physical or virtual “units” is done for many reasons, including performing complex SQL logic, re-using data for multiple DML/ETL operations (for example, multiple INSERTs), or simply just for better SQL code readability/maintainability.
This posts discusses the 3 available options in SQL Server for holding temporary data, these are SQL Table Variable, SQL Temporary Table and the CTE (Common Table Expression) SQL Syntax
Hi Sreehari,
SSIS service will run on a separate process...June 28, 6:30 pm by Links Naji
Hi,
Suppose my system has 8GB RAM and I have installed...June 28, 6:30 pm by sreehari
Any idea if we can use the keywordTokenizer along with stemming....August 2, 12:30 pm by kanishka
I think you have remarked some very interesting points...January 21, 1:06 pm by Johnc511
Hi, good article!
Can you help me with one thing.
I'm...August 13, 7:22 pm by Alex