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
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…
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); …
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…
File location: /wp-content/themes/Parallax-One-child/sections/parallax_one_header_section.php At the bottom: (site: handyraymond.com) 1,839 total views
