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…)...
Chief Technology Storyteller
Ok, my official title is Director of Technical Product Management. I also work on customer projects as a solution architect for projects related to SQL Server, Microsoft Azure, and AWS.
What makes DB Best great is the breadth of technologies and services they offer to their customers and partners. For example, how many people get to work with technology like the AWS Snowball Edge?
A brief history of Bill
To understand how I got here, I assembled a "blast from the past" tour of my 37 years in computing.
Semper Paratus "Always Ready"
The PC era and the start of client-server
In 1987, I landed at Ashton-Tate and eventually Borland as a developer working on the dBASE product line. At that time, I got my first exposure to the Microsoft, Ashton-Tate, Sybase SQL Server running on OS/2 where I wrote compatibility and performance test suites for the platform.
Start Me Up era
In 1995, I joined Microsoft as a program manager in Visual Studio working on database design tools for SQL Server and Oracle. I spent several years in Microsoft Office working integrating SharePoint and SQL Server with Access as part of the XP release. I then had the privilege of being a lead program manager for Excel, Access, and VBA for the Office 2003 release.
At the tail end of 2003, I had a chance to work with another great team in developing the manageability and performance troubleshooting tools for SQL Server Management Studio across the SQL Server 2005, 2008, and SQL Server 2008 R2 releases. I want to think I was part of the team that made SQL Server for the masses, but I might have been wrong based on this "Man on the street" interview.
In this role, I immersed myself in the world of Oracle with the goal of taking the best they offered, to make SQL Server better for DBAs. Plus, the intel helped spawn this video for a Microsoft sales event.
Entering the world of marketing
In 2010, I had a unique opportunity to join a technical marketing company, Indigo Slate – formally known as Advaiya Inc. As the VP of Technical Consulting, I got the chance to immerse myself in the world of technology marketing for a variety of large software vendors like Microsoft, VMware, Cisco, and SAP. Also, I consulted with Microsoft to develop technical content for helping Oracle DBAs better understand SQL Server technologies.
In recognition of the community involvement with SAP HANA, SAP awarded me the title of HANA Distinguished Engineer (HDE) in 2015. It was also where I refined my processes for evaluating technologies for customers. Check out my interview at 2 minutes and 37 seconds in the video below on what being an HDE meant to me.
That's my story!
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…)...
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 ...
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....