Here you will find related issues to Ms Sql and SSRS

Downloads

Steps

  • Configure shared data source
    • Go to SSRS configuration tool
    • Open Web portal URL
    • Click on New->Data source
  • Report builder
    • New blank report
    • Create data source
      •  Select shared data source
Posted in BI.

MongoDB

  • show dbs – show all dababases
  • show collections – show all collections in database.
  • use [db name] – switch to the specific database.
  • db.[collection].find() – find records in the collection.
  • db.[collection].find({email:”ints-ints@mail.ru”}) – find specific value
  • db.[collection].findOne() – find one record in the collection.
  • db.[collection].findOne({email:”ints-ints@mail.ru”},{password:”12345″}) – find specific values
  • db.[collection].countDocuments() – count all records in a table/collection
  • w3schools

Learnng resources

Keywords

  • Big data, Bigdata, Big-data, MongoDB, Mongo DB
  • NoSql, No sql, No-sql
  • Training, Train, Learning programming, learn, 
  • Programming languages

In computing, a graph database is a database that uses graph structures for semantic queries with nodes, edges and properties to represent and store data. A key concept of the system is the graph (or edge or relationship), which directly relates data items in the store. This contrasts with conventional relational databases, where links between data are ad hocand based on the data itself, and related items are gathered by searching for this data within the store. Graph databases are designed to allow simple and rapid retrieval of complex hierarchical structures, whereas a relational database would use a complex query to achieve the same end, generally with far less performance (from wikipedia).

http://neo4j.com/

Neo4j is a highly scalable native graph database that leverages data relationships as first-class entities, helping enterprises build intelligent applications to meet today’s evolving data challenges.

Dashing is a Sinatra based framework that lets you build beautiful dashboards. Check out a demo over here. Here’s another one, optimized for 1080p screens. Key features:
  • Use premade widgets, or fully create your own with scss, html, and coffeescript.
  • Widgets harness the power of data bindings to keep things DRY and simple. Powered by batman.js.
  • Use the API to push data to your dashboards, or make use of a simple ruby DSL for fetching data.
  • Drag & Drop interface for re-arranging your widgets.
  • Host your dashboards on Heroku in less than 30 seconds.
This project was created at Shopify for displaying custom dashboards on TVs around the office.

Demo: http://dashingdemo.herokuapp.com/sample

Site: http://dashing.io/

Keywords

Dashboards, Dashboard, Chart, Charts, Graph, Graphs

Posted in BI.

Temporary Tables

The simple answer is yes you can. Let look at a simple CREATE TABLE statement:

CREATE TABLE #Yaks (
YakID int,
YakName char(30) )

Temporary tables are created in tempdb. If you run this query:

CREATE TABLE #Yaks (
YakID int,
YakName char(30) )

select name
from tempdb..sysobjects 
where name like '#yak%'

drop table #yaks

Another Example

CREATE TABLE #TibetanYaks(
YakID int,
YakName char(30) )

INSERT INTO #TibetanYaks (YakID, YakName)
SELECT 	YakID, YakName
FROM 	dbo.Yaks
WHERE 	YakType = 'Tibetan'

-- Do some stuff with the table

drop table #TibetanYaks

Table Variables

If you are using SQL Server 2000 or higher, you can take advantage of the new TABLE variable type. These are similar to temporary tables except with more flexibility and they always stay in memory.  The code above using a table variable might look like this:

DECLARE @TibetanYaks TABLE (
YakID int,
YakName char(30) )

INSERT INTO @TibetanYaks (YakID, YakName)
SELECT 	YakID, YakName
FROM 	dbo.Yaks
WHERE 	YakType = 'Tibetan'

-- Do some stuff with the table

Example

DECLARE @TibetanYaks TABLE (
YakID int,
YakName char(30) )

INSERT INTO @TibetanYaks (YakID, YakName)
SELECT 	YakID, YakName
FROM 	dbo.Yaks
WHERE 	YakType = 'Tibetan'

UPDATE 	@TibetanYaks
SET 	YakName = UPPER(YakName)

SELECT *
FROM @TibetanYaks

Global Temporary Tables

You can also create global temporary tables. These are named with two pound signs. For example, ##YakHerders is a global temporary table. Global temporary tables are visible to all SQL Server connections. When you create one of these, all the users can see it.  These are rarely used in SQL Server.

Summary

That shows you an example of creating a temporary table, modifying it, and returning the values to the calling program. I hope this gives you what you were looking for.

Based on: http://www.sqlteam.com/article/temporary-tables