SQL Server

All about SQL Server...

rss_feed Subscribe RSS

local_offer SQL Server local_offer t-sql

visibility 18
thumb_up 0
access_time 3 months ago

SQL Server has built-in function HASHBYTES that can be used to calculate hash values. The supported hash algorithms include MD2, MD4, MD5, SHA, SHA1, SHA2_256 and SHA2_512. The signature of this function is: HASHBYTES ( '<algorithm>', { @input | 'input' } ) ...

visibility 15180
thumb_up 0
access_time 7 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 only ...

local_offer SSIS local_offer mssql

visibility 13493
thumb_up 0
access_time 7 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 ...

visibility 1240
thumb_up 0
access_time 7 years ago

Serial: An Introduction to SQL Server Features In the previous articles of this serial, I’ve introduced how to use SQL Server as database for online transaction processing, build ETL packages for data integration and create reports. SSAS is another important feature supporting online ...

visibility 5016
thumb_up 2
access_time 7 years ago

Serial: An Introduction to SQL Server Features For this ETL project, the requirements are listed below: Sales data will be pushed to specified shared folder regularly. Data is stored in CSV files with columns: Sale Number, Product Name, Product Color, Sale Amount, Sale Area and date.

Create Business Reports using SSRS

local_offer plot

visibility 943
thumb_up 0
access_time 7 years ago

Serial: An Introduction to SQL Server Features After the data is loaded into the database, reports can be built using SSRS (SQL Server Reporting Service). The general requirements for in this scenario are: Sales performance in different areas Sales amount for different products ...

visibility 1102
thumb_up 0
access_time 7 years ago

Serial: An Introduction to SQL Server Features All the samples in this serial will focus on one virtual company that produces and sales mobile phones. Three business subjects are covered: products, area (sales areas) and sales data. Follow the steps below to create one sample database. 1) ...

visibility 700
thumb_up 0
access_time 7 years ago

SQL Server provides a batch of great features to build robust, high-performance and scalable data solutions. It supports on-line transaction processing (OLTP), data integration, namely extract, transform and load, reporting and on-line analytical processing (OLAP). In this serial, I will ...

visibility 366
thumb_up 0
access_time 8 years ago

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

visibility 398
thumb_up 0
access_time 8 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.