Tags » SQL

SQL code to check database connections

I had an issue today with an ASP.NET application not able to connect to my SQL database, it turned out to be an issue with connections not being closed down properly, I used the following SQL code to check for the open connections: 39 more words


SSIS MySQL to Azure SQL using Visual Studio 2015


Recently I had the pleasure of using SSIS (SQL Server Integration Services) to transfer a database from a remote MySQL database to an… 1,459 more words


Basic MongoDb

1. What is MongoDB

According to docs.mongodb.org “MongoDB is an open-source document database that provides high performance, high availability, and automatic scaling”. MongoDB follows NO-SQL structure(No schema). 694 more words


SQL - Views

In SQL, a view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table. 337 more words

SQL Server

May 2016 Meeting


Beginning BI with Microsoft Tools

First we’ll take a look at OLAP versus OLTP and then we’ll move into using Microsoft’s tools to implement beginner level business intelligence solutions. 18 more words


The best way of logging JDBC statements

Follow @vlad_mihalcea


Whenever you are using a data access framework that auto generates statements on your behalf, it is mandatory to log all statements to ensure their effectiveness, as well as to assert the possible performance implications. 776 more words


Lab 4 Learn SQL Server (Test Plan, Index, Stored Procedure)

Test Plan:

The test plan is create at the execution of the SQL Statement.

The Test plan defines how this SQL query is executed internally. The Test plan contains the Index Seek or Test scan. 680 more words

Learn SQL Server