ILIKESQL

The joy of online shopping versus trying to find a parking spot at the mall Just like many other people do around the holidays, we decided to order some items online to avoid busy shopping lines at stores and getRead More

SQL Server Data Tools While its name might be confusing, there are actually 2 versions of SQL Server Data Tools, one that focuses on Data Modeling and Tooling, another one that purely focuses on BI and was previously known asRead More

How to install an MSI file unattended MSIEXEC /a “product.msi” /qn Example: MSIEXEC /a “d:\downloads\ssdt.msi)” /qn Typically this installation will not show any user interaction or verbose logging. Combine with the Full MSI Syntax options as listed below to outputRead More

  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 wouldRead More

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. AsRead More

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 anRead More

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 anRead More

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 withRead More

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 ofRead More

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 orRead More