Category Archives: Database
How to create a linked server
ERD – Entity relations diagram
Big Data / NoSql
Opensource – free Charts / Reports / BI / Analytics platforms / packages
Graph database

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.
SQLite – References

Top 5 Sqlite management tools:
http://www.ginktage.com/2013/08/5-popular-and-free-sqlite-management-tools/
http://sqliteadmin.orbmu2k.de/
Youtube Video tutorial:
http://www.ginktage.com/2013/08/5-popular-and-free-sqlite-management-tools/
How to install PhpMyAdmin on C9.IO
How to setup PhpMyAdmin at your website

1. Download PhpMyAdmin.
2. Upload it to your Server/Domain.
3. Browse to www.your-domain.com/phpMyAdmin/Setup
4. Click on “New Server” button:
5. Under “Server hostname” write your host name.
6. Under “User for config auth” (might be under authentication tab) write MySql username.
7. Under “Password for config auth” write MySql password.
8. Under PhpMyAdmin top level directory create a directory called “config”:
www.your-domain.com/phpMyAdmin/config
8.1 Click on Apply.
8.2 config direcotry suppose to have RW permissions.
9. Under PhpMyAdmin setup page click on “Save” button:
10. Configuration saved to file config/config.inc.php in phpMyAdmin top level directory, copy it to top level one and delete directory config to use it.
11. Login to your PhpMyAdmin at www.your-domain.com/phpMyAdmin
Based on the following Video:
SSMS / Visual Studio Sql server database project
The Connection Strings Reference
The Connection Strings Reference
ConnectionStrings.com help developers connect software to data. It’s a straight to the point reference with connection strings, a knowledge base of articles and database connectivity content and a host of Q & A forums where developers help each other in finding solutions.
http://www.connectionstrings.com/
MS SQL Server Editions
MS SQL Server Editions
Also include Express editions
http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx
Step by step of executing SSIS 2012 package through stored procedure
Step by step of executing SSIS 2012 package through stored procedure
http://blogs.msdn.com/b/biblog/archive/2013/05/07/step-by-step-of-executing-ssis-2012-package-through-stored-procedure.aspx
Differences between Delete and Truncate
How to find Object ID by name at SQL Server
How to find Object ID by name at SQL Server
Example of how to find ID of tables at database according to tables name:
SELECT * FROM sys.columns WHERE object_id = Object_id('employees')
Multiplication Table – Stored Procedure
ALTER PROCEDURE [dbo].[Mulsp] @Size INT
AS
BEGIN
DECLARE @X INT=2
DECLARE @Y INT=1
BEGIN try
DROP TABLE [dbo].[multable]
END try
BEGIN catch
END catch
CREATE TABLE [dbo].[multable]
(
c1 INT
)
–create the rows
DECLARE @CN NVARCHAR(max)=”
DECLARE @TSql NVARCHAR(max)
WHILE @x <= @Size
BEGIN
SELECT @cn = ‘c’ + Cast(@x AS NVARCHAR)
PRINT @cn
SET @TSql=‘alter table MulTable add ‘ + @cn + ‘ int’
PRINT @Tsql
EXEC sys.Sp_sqlexec
@Tsql
SET @x=@x + 1
END
–at this point build each line query
SET @X=1
DECLARE @EachLineQuery NVARCHAR(max)
WHILE @Y <= @Size
BEGIN
SET @EachLineQuery=‘insert into MulTable values (‘
WHILE @x < @Size
BEGIN
SET @EachLineQuery=@EachLineQuery + Cast(@x*@y AS NVARCHAR)
+ ‘,’
SET @x=@x + 1
END
SET @EachLineQuery=@EachLineQuery + Cast(@x*@y AS NVARCHAR)
+ ‘)’
EXEC sys.Sp_sqlexec
@EachLineQuery
PRINT @EachLineQuery
SET @EachLineQuery=”
SET @y=@y + 1
SET @x=1
END
SELECT *
FROM multable
END
Can’t browse SDF files in Visual Studio 2013
In Visual Studio 2013 you could double click a SDF database file within Solution Explorer and it would automatically open the database file and allow you to view the database tables, add tables, edit data etc.
In Visual Studio 2013 this native support seems to have ‘fallen off’, double clicking an SDF file simply assumes it is yet another binary object:
go to the MSDN Gallery and get the SQL Server Compact Toolbox, here:
http://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1/
once installed you can drag the new “SQL Server Compact Toolbox” window and dock it where it used to be:
(It suppose to be At Main Menu->Tools->Server Compact)