IT Blog

  • Blog
  • Technology
    • Technology
    • Architecture
    • CMS
    • CRM
    • Web
    • DotNET
    • Python
    • Database
    • BI
    • Program Language
  • Users
    • Login
    • Register
    • Forgot Password?
  • ENEN
    • 中文中文
    • ENEN
Experience IT
In a World of Technology, People Make the Difference.
BI

Power BI First Taste

Power BI is the latest Microsoft BI tool. It was originated from Excel plug-ins, e.g. Power Query, Power Pivot, Power View, and rolled out last year (2015.7). Therefore, it is very similar to working on Excel. It is visualized self-service business intelligence tool for everyone.    Power BI provides 4 components. Power BI services     – you can create a real time online dashboard that can be accessed by anyone from everywhere in the world or by anyone in your organization. Power BI desktop      – run power BI on your desktop Power BI Mobile        – run power BI app on your mobile device Power BI Embedded – allow you to embed the interactive visuals into your app using REST APIs and Power BI SDK. Power BI accept lots of data sources, such as database, files, web page, cloud service…   Power BI allows you to quickly create interactive, responsive, pretty dashboard easily. Here is the sample dashboard.       Power BI provides lots of visualization styles that you can choose.     Power BI is a powerful and the simplest BI tool in current market. Everyone, especially Excel users can use it easily and build powerful, attractive dashboard. Can't wait to try ...  2,924 total views,  5 views today

2016-12-07 0 Comments 1132 Views 0 Like IT Team Read more
Program Language

WP UI Design - Language Selection on Menu Bar

WP UI Design - Language Selection on Menu Bar Recently, I was requested to help for changing the language selection display style on the menu. Currently the website shows English on the menu by default, and the second language, which is Chinese, is hidden on the drop-down menu. Due to the website only support two languages, English and Chinese. Therefore, the owner want to display the second language right on the menu instead of hiding on the drop-down, so that user can switch the language easily. This is reasonable requirement for bilingual website. Website Language Selection UI Design It is common approach to place language selection on the menu bar for those websites support more than one language.     1. Bilingual language support For English as the first language website, we could place the second language button on the menu bar, as shown on Image 1.  When user click on the second language the page will display in the second language, and show first language button on the menu bar. Image 1     2. Multi-language support In the case of supporting multi-lingual, the first approach is not appropriate due to there are more than one language could be selected. In this case, we have to put all other languages on the dropdown list, so that user can pick one of the other languages as preferred, as shown on image 2. Image 2 However, I discovered that the website is using WPGlobus plug-in for WordPress. WPGlobus is a great plug-in for supporting multi-language on WordPress site. By design, the…

2016-11-24 0 Comments 944 Views 0 Like IT Team Read more
Database

Sending mail from SSIS

SSIS toolbox provides Send Mail Task for sending emails from integration service. It allows only sending text mail with SMTP Connection Manager. SMTP Connection Manager supports only anonymous and windows authentication. If you use mail server outside of the organization boundary or need to send html format mail this task is useless. Here's the screenshots to describe this limitation. Send Mail Task   SMTP Connection Manager The alternative way, we could use Script Task to send mail directly or use Execute Process Task to trigger another process to send mails. 1. Send Mail using Script Task a) First we create a few variables to pass mail information to the task. Note that some ISPs block port 25, in this case you should use alternative port instead. b) Pass variables to the task. c) Scripts to be executed is as following. The namespace System.Net.Mail is needed in order to send mail.         using System.Net.Mail;         public void Main()         {             var smtpCredential = Dts.Variables["smtpCredential"].Value.ToString();             var mailServer = Dts.Variables["mailServer"].Value.ToString();             var mailPort = Dts.Variables["mailPort"].Value;             var mailSender = Dts.Variables["mailSender"].Value.ToString();             var mailRecepients = Dts.Variables["mailRecepients"].Value.ToString();             var mailSubject = Dts.Variables["mailSubject"].Value.ToString();             var mailBody = Dts.Variables["mailBody"].Value.ToString();                         var credential = smtpCredential.Split(',');             var receipients = mailRecepients.Split(',');             var user = credential[0];             var pwd = credential[1];             bool isHtml = true;             MailMessage mail = new MailMessage();             mail.IsBodyHtml = isHtml;             mail.Subject = mailSubject;             mail.Body = mailBody;             mail.From = new MailAddress(mailSender);             foreach (var m in receipients)             {                 mail.To.Add(m);            …

2016-11-19 0 Comments 1437 Views 0 Like IT Team Read more
Database

SQL Server Database Backup - 3 Methods

Database backup is not the DBA-only work. Most of developers and even small business owners also need to perform this task. This article will introduce 3 methods to back up database from SQL Server. Method 1 – from management studio Connect to database server Expend Databases folder Right click on the database that you want to backup from Context menu click Task from sub menu click on Back Up… on the popup window click on Add  on Select Backup Destination window you could enter file location and file name directly or click on … button to specify a backup file. Click on OK button to close the window, then click on OK again and wait for the completion. Method 2 – using T-SQL script You could either to execute the script on Management Studio or store it as stored procedure to execute. Here’s the script for backing up all user databases: DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- filename for backup DECLARE @fileDate VARCHAR(20) -- used for file name --specify database backup directory SET @path = 'C:\DB\MSSQL11.MSSQLSERVER\MSSQL\Backup\' SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) DECLARE db_cursor CURSOR FOR SELECT name FROM master.dbo.sysdatabases WHERE name NOT IN ('master','model','msdb','tempdb') -- exclude system db OPEN db_cursor FETCH NEXT FROM db_cursor INTO @name WHILE @@FETCH_STATUS = 0 BEGIN SET @fileName = @path + @name + '_' + @fileDate + '.BAK' BACKUP DATABASE @name TO DISK = @fileName FETCH NEXT FROM db_cursor INTO @name END CLOSE db_cursor DEALLOCATE db_cursor Method 3 – using SSIS Service In order to use…

2016-11-01 0 Comments 1064 Views 0 Like IT Team Read more
Theme

Add slideshow on homepage for Parallax One theme

File location: /wp-content/themes/Parallax-One-child/sections/parallax_one_header_section.php At the bottom: (site: handyraymond.com)  1,839 total views

2011-11-23 0 Comments 772 Views 0 Like IT Team Read more
1…1415161718
Chinese (Simplified) Chinese (Simplified) Chinese (Traditional) Chinese (Traditional) English English French French German German Japanese Japanese Korean Korean Russian Russian
Newest Hotspots Random
Newest Hotspots Random
Rich editor not working Making web page scroll down automatically Getting data from Dapper result All Unicode Chars How to keep and display contact form 7 data Common Regular Expressions
WordPress EventCalendar visibility PHP - Delete folder Scientific format problem Duplicator - backup & restore Parallax One analysis Sending email using gmail SMTP
Categories
  • Architecture
  • BI
  • C#
  • CSS
  • Database
  • DotNET
  • Hosting
  • HTML
  • JavaScript
  • PHP
  • Program Language
  • Python
  • Security
  • SEO
  • Technology
  • Web
  • Wordpress

COPYRIGHT © 2021 Hostlike IT Blog. All rights reserved.

This site is supported by Hostlike.com