Author : All posts by ilikesql

20

Mar

Installing SQL Server Data Tools BI (and unattended install)

  About SQL Server Data Tools If you are anywhere involved with Microsoft Business Intelligence using Analysis Services, SQL Reporting Services or even SSIS you need to have SQL Server Data Tools for Business Intelligence installed. Now most people would READ MORE

Share

17

Mar

QuickBlog: Upgrading SQL Server
QuickBlog: Upgrading SQL Server

The end of SQL Server 2005 extended support is nearing on April 12, 2016. To accomplish a smooth and trouble-free upgrade to SQL Server 2014, you should plan for upgrade and address the complexity of upgrade for your applications. As READ MORE

Share

16

Mar

@SQLSoldier interpretive dance at Summit
@SQLSoldier interpretive dance at Summit

What started as some funny comments about @SQLSoldier doing an interpretive dance has rolled into a great initiative as additional support to the fundraising for my cousin Gunnar. And it looks like he was serious about his commitment to an READ MORE

Share

16

Mar

Office 2016 Preview for Windows available

Today Microsoft Announced the availability of Office 2016 Preview At Convergence 2015 today in Atlanta, Microsoft launched a technical preview of Office 2016 for Windows. To download , you’ll need to sign up on Microsoft Connect. http://blogs.office.com/2015/03/16/announcing-the-office-2016-it-pro-and-developer-preview/ Below is an READ MORE

Share

16

Mar

Embedding #PowerBI (Power View) in WordPress blog

As announced on the Power BI blog a while ago, and also very well described on how to Embed your Excel Workbook into a blog or web page, it is actually pretty cool to embed a Power BI workbook with READ MORE

Share

15

Mar

My first attempt on a #Tableau dashboard embedded in my blog

Well, I’ve done a lot of visualizations with Power BI, and pretty sure a lot of people out there are using Tableau based on the very well attended Tableau event I attended about a week ago in Seattle. One of READ MORE

Share

11

Mar

Quickblog: Is my Excel 2013 32bit or 64-bit? #powerbi

If you get close to Power BI or having to install Power Query, you probably have asked yourself the question: “Is my Excel 2013 32bit or 64bit?” Here is a very quick way to find out: Open a blank or READ MORE

Share

04

Mar

Quickblog: unattended install of Power Query #powerbi

PowerQuery_2.20.3945.242 (64-bit) [en-us].msi, was announced by the Excel Team on 03/05/2015, if you have an older version installed, the above command will uninstall the older version as part of the upgrade process. It might be good to follow both the READ MORE

Share

28

Feb

Reblog: SQLServer Firewall Configuration using command line

REBLOG from old ILIKESQL BLOG SQL Server Firewall Configuration using command line I’ve been asked the question many times, and you probably have seen it before … The “warning” message that displays during a SQL Server installation and warns you READ MORE

Share

23

Feb

Migrating from #sqlserver to #Azure SQL Database – Cookbook

The Azure SQL Server Migration Cookbook for Azure SQL Database describes how you can migrate an on-premises SQL Server Database to Azure and can be downloaded here. The cookbook describes engine compatibility, tools to use and how to approach migration READ MORE