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. Accept

Analytics & BI

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

Subscribe

SQL Server 附加没有日志文件ldf的数据库mdf的方法

829 views   0 comments last modified about 10 years ago

Keywords: how to attach database without log file

View detail

因为数据库正在使用,所以未能获得对数据库的排它访问权 解决办法

273 views   0 comments last modified about 11 years ago

恢复数据库的时候遇到这个错误解决办法

View detail

数据库设计有关范式点滴摘录

230 views   0 comments last modified about 10 years ago

Note1:满足范式要求的数据库设计是结构清晰的,同时可避免数据冗余和操作异常。这并意味着不符合范式要求的设计一定是错误的,在数据库表中存在1:1或1:N关系这种较特殊的情况下,合并导致的不符合范式要求反而是合理的。

View detail

SQL Server Denali_Exception has been thrown by the target of an invocation Solution

2498 views   3 comments last modified about 8 years ago

Issue After I installed Visual Studio 2011 Developer Preview, the error “Exception has been thrown by the target of an invocation” will be thrown when I try to lunch SQL Server Management Studio. Microsoft Connect site has a relevant issue: ...

View detail

Useful T-SQLs (Part I)

359 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

11840 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

10158 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

981 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

2770 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

730 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

Contacts

  • enquiry[at]kontext.tech

Subscribe