This site uses cookies to deliver our services. By using this site, you acknowledge that you have read and understand our Cookie and Privacy policy. Your use of Kontext website is subject to this policy. Allow Cookies and Dismiss

Analytics & BI

Data Analytics,Big Data,Data Storage and Business Intelligence.

Subscribe

Useful T-SQLs (Part I)

323 views   0 comments last modified about 6 years ago

There are a lot of useful T-SQLs we can use in daily work to make things simple. Check transaction log files space usage DBCC SQLPERF (LOGSPACE); Backup Server Certificate ...

View detail

Working with SQL Server Compact 4.0 using Entity Framework 6 and ADO.NET

11410 views   0 comments last modified about 5 years ago

SQL Server Compact 4.0 (CE 4.0) is a free SQL Server embedded database ideal for building standalone and occasionally connected applications for mobile devices, desktops, Web clients and others. In one of my projects, I used it as the database for logging errors, which assumes the errors will onl...

View detail

Generate Formatted Excel Destination (Output) in SSIS Data Flow Task

9350 views   0 comments last modified about 5 years ago

SSIS (SQL Server Integration Service) provides a number of convenient tasks to enable data integration. Exporting data from database to Excel file is a common task in ETL (Extract, Transform, Load) projects. Constantly the users/customers may raise format request regarding the Excel extract. To g...

View detail

Create OLAP Project using SSAS

905 views   0 comments last modified about 5 years ago

Serial: An Introduction to SQL Server Features Case Scenario In the previous articles of this serial, I’ve introduced how to use SQL Server as database for online transaction proces...

View detail

Create ETL Project for Collecting Sales Data using SSIS

2122 views   0 comments last modified about 5 years ago

Serial: An Introduction to SQL Server Features Case Scenario For this ETL project, the requirements are listed below: Sales data will be pushed to specified shared fold...

View detail

Create Business Reports using SSRS

669 views   0 comments last modified about 5 years ago

Serial: An Introduction to SQL Server Features Case Scenario After the data is loaded into the database, reports can be built using SSRS (SQL Server Reporting Service). The g...

View detail

An Introduction to SQL Server Features

570 views   0 comments last modified about 5 years ago

SQL Server provides a batch of great features to build robust, high-performance and scalable data solutions. ...

View detail

Build Online Product Management Website using MVC 3 + Entity Framework + SQL Server

881 views   1 comments last modified about 5 years ago

Serial: An Introduction to SQL Server Features Case Scenario All the samples in this serial will focus on one virtual company that produces and sales mobile phone...

View detail

Hands on SQL Server 2012 Serial

295 views   0 comments last modified about 6 years ago

In this article, I am going to summarize some topics regarding SQL Server 2012 together, including T-SQL, Programing, Database Maintenance, Performance Tuning, Data Types, CLR Integration, Business Intelligence, and Applications and so on. The page will be updated continuously with new blog links.

View detail

[Hands on SQL Server 2012] Using CLR Types and Functions

263 views   0 comments last modified about 6 years ago

In this article, I am going to demonstrate how to use CLR (Common Language Runtime) data types and functions in SQL Server.

View detail