Microsoft Solution Architect
Microsoft recently announced that June 1 will be the general availability release date for the highly anticipated SQL Server 2016. This release of SQL Server is unlike any other, as this version is truly a cloud-borne release with many features already developed and released within Microsoft’s Azure SQL Database cloud platform. SQL Server’s innovative functionality…
As we continue to discuss the looming end of support for SQL Server 2005, I want to share simple steps to upgrade a 2005 database to SQL Server 2014. By no means is this list complete, but my goal is to touch on the high-level points to plan and perform a successful upgrade. If you…
Microsoft SQL Server 2005 end of life is quickly approaching. Microsoft will reach end of support on April 12th, 2016. Just as we have recently seen support end for Windows XP and Windows Server 2003, it is now time to say goodbye to SQL Server 2005. What Does End of Support Mean? Microsoft’s support lifecycle…
Availability Groups is a great solution for providing both high availability and disaster recovery for SQL Server 2012 and 2014 deployments. But for many, the cost of a secondary site can be a roadblock to providing disaster recovery resiliency. With Microsoft Azure, we can leverage the efficiencies of the cloud to avoid a lot of…
Has your organization been hoping to utilize Power Pivot and Power View for your self-service BI needs but you haven’t been able to justify a deployment of SharePoint and SQL Server to support proper collaboration and management? If so, I have some good news for you! As Microsoft continues to drive new and innovative technologies…
Business Intelligence, and more specifically Big Data, are hot topics in the industry right now due to the vast potential organizations have to benefit from these capabilities. Two key factors include improving decision making and hopefully discovering new insights from this data. But for many, it can be hard to determine what is needed to…
In my last post I provided an overview of PowerPivot. I’d like to build upon the discussion in this post with a focus on Microsoft’s self-service business intelligence (BI) capabilities using Power View. You’ll see how to bring your data to life through rich visualization and interactivity. Visualizing Our Data Power View is the last…
As a follow up to my last post on Business Intelligence, which you can find at the below link, I want to dive deeper into the PowerPivot solution from Microsoft. Let’s explore how we can leverage the PowerPivot solution and improve our BI capabilities. Why PowerPivot? As I discussed in my last post, many organizations…
The Problem It’s very common these days to find organizations that have spent a lot of time and effort gathering data about their business, because data is valuable, but have yet to ask themselves, “How do we effectively use this data?” Some of the challenges we face when trying to leverage our data effectively include:…
