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.
PowerView (project name: Crescent) is one of the most anticipated reporting suites, bringing features that are long lacking from SSRS, such as hover-over effects, dynamic slicing and dicing of data, and generally interactive and visually striking reporting.
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.
Ah Battlefield 3, an awesome game, but geez it is buggy.
This evening PC users are being greeted with the following notice on the Battlefield 3 Battlelog page:
“NOTICE: The “Game disconnected: you were kicked by Punkbuster errors” are being looked into right now.”
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
This is more of a rant rather than anything useful, although I do give a link to an awesome JQuery library for zipping and unzipping files, so stick around!
In this post I will show you a quick example of how to write an on-the-fly table in SQL Server.
Thanks for the script. It is very helpful. Do i need to...November 3, 9:36 pm by vishal dandge
Dear sir ,
Can you please provide me a dataset that containing...September 22, 5:13 pm by Sithara Fernando
Hi
I am working on twitter sentiment analysis for course...September 22, 5:13 pm by Sarker Monojit Asish
Yes I too need this dataset. I have a question that how...September 22, 5:13 pm by kush shrivastava
I need necessary to arabic sentment analysis dataset It...September 22, 5:13 pm by mona