Power BI Desktop


Power BI is the latest hot top in the BI community in recent days. I download and install the Power BI Desktop tool in my machine and exploring now. I am amazed with the performance of this tool. As always Microsoft has done a wonder job. It is lighter and faster. Having ability to connect with different data source, transformation feature and report. I would say, it is all in one tool.

pic1

This is the final dialog box before entering into a new world.

Download a free copy of desktop powerbi

I have created a quick map report using Power BI desktop

map

I am planning to write more about this tool in coming days.

Categories: PowerBI Tags:

Get the File Last Modified datetime from HTTP Header – SSIS


This VB.Net code can be used to get the Last modified date of a file from HTTP header. It can be used to check the file date before the actual file is downloaded to out computer. It save some time and network resources. You can pass different header key to get its value.

But, this example is to get the last modified date of a file from Houstontx.gov website.

Dim request As HttpWebRequest = HttpWebRequest.Create _
(“http://gisdata.houstontx.gov/cohgis/cohgis2011_2010census10.zip“)
Dim response As HttpWebResponse

response = request.GetResponse()

Dim HTTPHeader_LastModified_Datetime As String
HTTPHeader_LastModified_Datetime = response.GetResponseHeader(“Last-Modified”)

MsgBox(HTTPHeader_LastModified_Datetime)

Hope you will like it.

Categories: SQL Server

Get the File Last Modified datetime from FTP Server – SSIS


There are many ways to get the file modified date from the FTP server. But, I like to write a VB.net code to do that task simpler. Script Task is used in SSIS.

Code: To fetch the file last modified datetime

Imports System.Net

Dim reqFTP As FtpWebRequest = DirectCast(FtpWebRequest.Create(New Uri(“ftp://SERVERName/FileName”)),  FtpWebRequest)

reqFTP.Method = WebRequestMethods.Ftp.GetDateTimestamp

reqFTP.Credentials = New NetworkCredential(“USER NAME”, “PASSWORD”)

response = DirectCast(reqFTP.GetResponse(), FtpWebResponse)

MsgBox(response.LastModified.ToString)

reqFTP.Abort()

Using Credentials is based on the server requirement. In this script, file date time is just displayed using Message box. We can use package variable to store the value.

Categories: SQL Server

Read and Write to Text file – VB.Net


I created this snippet to save my search time in future. So, you can also make use of this if needed.

The main objective of this code is to read a text file line by line and write it into another file. I know, it looks silly. because, why do we need to read a file and write to others without doing anything. But, The actual purpose is to read a text file and do some operations like update or remove. Using this method I can keep my original file unchanged. does it make sense now?

Code snippet

Imports System.IO

Dim strLine As String
Dim objStreamReader As StreamReader
Dim objStreamWriter As StreamWriter

objStreamReader = New StreamReader(“C:\test\source.txt”)
objStreamWriter = New StreamWriter(“C:\test\destination.txt”)

strLine = objStreamReader.ReadLine

Do While Not strLine Is Nothing
objStreamWriter.WriteLine(strLine)
strLine = objStreamReader.ReadLine
Loop

‘Close the file.
objStreamWriter.Close()
objStreamReader.Close()

I know there are millions of ways to do something. But, I choose this method and if you have a new logic please share it in the comment section.

Reference

Categories: SQL Server

SQL SERVER – Hotfixes for SQL Server 2014


Microsoft released the hotfixes for the latest version of MS SQL Server – SQL Server 2014 CU 4. The new build number for this cumulative update 4 (CU 4)  is 12.0.2430.0

The full list of hotfixes provided in this release are compiled in the excel file. Download SQL Server 2014 CU 4 hot fixes excel file.

Hotfixes Statistics

Fix area No Of Fixes
SQL Service 13
Analysis Services 10
Reporting Services 8
Management Tools 7
SQL performance 5
DQS 3
Integration Services 3
Data Quality Services (DQS) 1
SQL connectivity 1
High Availability 1
BI Azure 1
In-Memory OLTP 1
Grand Total 54

Download Hotfix now

Source: http://support.microsoft.com/kb/2999197

Categories: SQL Server

SQL SERVER – Fix the Report Builder bug in SQL Server 2008 R2 SP 3


Microsoft recently send this workaround to fix the issue in SQL Server 2008 R2 SP 3 for Report Builder launch

Issue:
If you installed SQL Server 2008 R2, have upgraded it to Service Pack 2 and then applied Service Pack 3, then Report Builder will fail to launch.

workarounds:

Client side workaround:
Install and run Report Builder 3.0 of SQL Server 2008 R2 RTM from the following location: http://www.microsoft.com/en-pk/download/details.aspx?id=6116
Or
Install and run Report Builder of SQL Server 2014 from the following location:
http://www.microsoft.com/en-us/download/details.aspx?id=42301

Server side workaround:
Uninstall Service Pack 3 then uninstall Service Pack 2 and then reinstall Service Pack 3.

Full detail is in Here

Categories: SQL Server

SQL SERVER – Declare Mulitple Variables in Single Line


This may be a simple thing, but sometime new developers are difficult to find this information readily. So, thought of adding it in this website.

Question
How to declare and initialize variables in single or multiple lines?

Answer:

Declaring variables – Multiple lines

DECLARE @int_i AS INT;
DECLARE @chr_Name AS VARCHAR(50);

Declare and Initialize variables – Multiple lines

DECLARE @int_i AS INT = 1;
DECLARE @chr_Name AS VARCHAR(50) = ‘Test';

Declare variables in single line

DECLARE @int_i AS INT, @chr_Name AS VARCHAR(50);

Declare and Initialize variables in single line

DECLARE @int_i AS INT = 1, @chr_Name AS VARCHAR(50) = ‘Test';

That is it, You have learned to declare and initialize variables in MS SQL Server.

Categories: SQL Server Tags:
Follow

Get every new post delivered to your Inbox.

Join 1,605 other followers

%d bloggers like this: