Welcome to DB Best: Rick Heiges
31 Mar 2015

DB Best is very excited to announce that Rick Heiges has joined our team as a Principal Solutions Architect and will be based in North Carolina, USA. Rick has spent the past 10 years in the consulting world as a Sr. Solutions Architect working with enterprise customers mainly in the US, but also as far south as South Africa and as far North as Iceland. He served 9 years on the Board of Directors for PASS, including 2 years as VP of Marketing, where he created the popular 24 Hours of PASS Events; he continues to serve the organization on special projects and lately the program committee for the annual summit. Rick is also a SQL Server MVP and ...

Running Any Of The Following ISV Applications On Oracle Or Sybase? You Might Qualify For A Free 3 Day Migration Workshop!
30 Mar 2015

You are running any of the following applications on Oracle or Sybase, and you are wondering what it would take to get them migrated to SQL Server? Well you probably qualify to join us for a by-invitation only 3 day hands on workshop with leading technical experts, prior to MS Ignite, at zero-cost* to you. So if you are running: Team Center, PTC, Sungard, Kronos, SAP on a non-SQL Server platform, contact us and apply to take part in the 3 day workshop -> email [email protected] As a valued customer, you could qualify for this program based on expressing your interest in moving to your application to SQL Server. This exclusive three-day han...

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, and has previously worked as PM for Certification and production DB at Microsoft, Outerwall, Idera. That’s right- Robert lives and breathes SQL and we are incredibly happy to...

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. (more…)...

INSTALLING SQL SERVER DATA TOOLS (GUI OR UNATTENDED)
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 Database which runs on Azure. (more…)...

INSTALLING SQL SERVER DATA TOOLS BI (AND UNATTENDED INSTALL
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 Intelligence (more…)...

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 started building something myself right? One of the first things I came to realize as I was building out a Tableau Viz, I need to spend more time using Tableau to really become productive with it. Before ...

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 Pro Plus would automatically install in 64bit if you had a 64 bit OS right? Well it doesn’t, in order to get the 64bit version you need to click Advanced to download it specifically from the download URL or portal.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 need a Data Strategy and a Data Architecture? Well, the answer is simple: to bring some standardization, consistency, and an Architecture or a Plan to your world of data. The fundame...