Robert Davis @SQLSoldier joins DB Best Team
26 Mar 2015

Please join us in welcoming Robert Davis (@sqlsoldier) to DB Best, who as of today, will be contributing to our team as a Principal Database Architect and will be based in our Redmond HQ. Robert is an experienced evangelist, a well-known speaker, trainer and SQL Server MVP. He brings over 15 years of SQL Server experience, and is a well published author and a Microsoft Certified Master. Robert is also a co-founder and co-leader of the PASS Security Virtual chapter, […]

Quickblog: How to install an MSI file unattended
21 Mar 2015

How to install an MSI file unattended MSIEXEC /a “product.msi” /qn Example: MSIEXEC /a “d:downloadsssdt.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 output installation progress to a log file. Other installation considerations – passive mode Another great option to consider is using the /passive parameter. This parameter will provide UI interaction and show progress graphically.

Installing SQL Server Data Tools (GUI or unattended)
21 Mar 2015

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 as Business Intelligence Development Studio. In this blog, we’ll focus on the Database Modeling and project add -ins for Visual Studio or Visual Studio Shell, which will allow you to easily perform database tooling, and publish to multiple platforms including SQL […]

Installing SQL Server Data Tools BI (and unattended install)
20 Mar 2015

About SQL Server Data Tools Have you ever tried Microsoft Business Intelligence using Analysis Services, SQL Reporting Services or even SSIS? If the answer is yes, you need to have SQL Server Data Tools for Business Intelligence installed. Now most people would think that’s easy because you can install it as part of the SQL Server Management tools right? Unfortunately it isn’t, you’ll find it right here in the installer under: How to get SQL Server Data Tools – Business […]

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

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 the cool features that was re-emphasized was the broad use of Tableau Public to bring rich data visualizations that can be used to display and embed interactive visualizations directly within a blog article. So it was about time that I […]

Quickblog: Is my Excel 2013 32bit or 64-bit?
11 Mar 2015

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 existing workbook in Excel Click on File | Account When the following screen displays click on About Excel And there it shows, if you have 64bit, it will show exactly where marked. Now the tricky part is, you thought Office […]

So, what’s your Data Strategy?
09 Mar 2015

Introduction Working with customers over the past many years, the question of Data Architecture and Data Strategy has come up a lot. ‘What should my data strategy be?’ or ‘How do I go around creating a Data Strategy or a Data Architecture and what are some of the critical elements of a Data Architecture?’ Let me address some of those questions and the importance of having a well-defined Data Strategy and a Data Architecture. First and foremost, why do you […]

Welcome to DB Best: Dandy Weyn
19 Feb 2015

DB Best is very excited to announce that Dandy Weyn has joined our team as a Director of Business Development and Strategy. Dandy comes to us from Nordstrom where he supported a team of database and business intelligence professionals. Prior to that Dandy worked at Microsoft as a Technical PM on SQL Server, Data Warehousing and Microsoft Business Intelligence. Combined with many years as an international consultant and trainer, he offers a unique combination of deep technical skills, extensive industry […]

News from our R&D Lab: Video Transitioning
11 Feb 2015

A video transition is a technique used in the post-production process of video editing by which frames are combined. Most commonly, this is through a normal cut to the next scene. Most videos will also include selective use of other transitions, usually to convey a tone or mood, suggest the passage of time, or separate parts of the story. These other transitions may include crossfading, wiping, scaling etc. ‘Video Transitioning’ is a prototype of an app for iOS, which is […]

DB Best at S4 Microsoft Solution Specialist Sales Summit
10 Feb 2015

Last week was marked by one of the most fascinating and educational semi-annual tech events – Microsoft S4 summit, which took place in Bellevue, WA last week. It was an invitation only event that had a high concentration of like-minded companies, Microsoft specialist sales and sales management community in particular. DB Best was proud to be a co-sponsor of the event. We were happy to support Microsoft in increasing solution and value selling skills through this unique collaborative and experiential […]