Posts Tagged ‘SQL Server’

Windows Azure is a great environment for your applications. It can also house applications that aren’t ready to be consumed by your clients whether internal or external to your organization. What makes this more compelling is that as of June you now pay by the minute vs. by the hour for compute as well as […]

You may hear this from almost any vendor whose original software was built for an on-premise installation.  “Look, we are on the cloud. Our product has an image on Amazon AWS. It takes just minutes to provision this pre-existing image and you are off and running.” I love the concept of that. I love the […]

Being primarily a developer, I would prefer not having to manage infrastructure. With SQL Database I don’t have too. SQL Database provides most of the features I need when working with a relational database. If SQL Database doesn’t suit your needs, you can have SQL Server running in a VM within Windows Azure. Though again […]

There’s a lot of talk surrounding the cloud lately. Combine that with business intelligence, and you’ve got a topic worthy of discussion. Are substantial cost savings and greater ease of implementation just around the corner? Looking to distinguish what’s “pie-in-the-sky” from what truly works? To find out, join us on Wednesday, September 11th at 1 […]

Before I started blogging for Perficient, I had a few posts on a personal blog. One of the post, though outdated, is still referenced quite often. So I thought it might be a good idea to update the post for use with SQL Reporting. The original post was created for SQL Server Reporting Services (SSRS). […]

Previously, we addressed the specifics of data services in Azure, and what paths might be valid for SQL Server BI.   Today, we’ll look at delivering data to users — the “last mile” of Microsoft’s cloud BI story — via SharePoint. Whenever you talk about delivery of Microsoft BI, the first point of discussion is logically […]

In the last post in this series, we looked at why Azure Machines are the most likely candidate for workable SQL Server-based cloud BI implementations.   Today, we talk turkey about actual limitations and things you need to know as you look at a potential solution in this environment. The first thing to know is that Azure […]

I’m not sure why exactly, but I have always loved SQL Server Reporting Services (SSRS). If you didn’t already know it, I’m here to let you know that Windows Azure has a similar version called SQL Reporting. In everything I see about Windows Azure, SQL Reporting doesn’t seem to be talked about much. SQL Reporting doesn’t […]

In my last post in this series, I described the basics of Data Services within Microsoft’s Windows Azure public cloud platform.   Basically, we were able to somewhat exclude the majority of PaaS offerings in Azure and home in on the IaaS offering:  Azure Virtual Machines. Azure VM’s are effectively the only real path to full-fledged […]

The velocity of release for Microsoft development and infrastructure products can be at times overwhelming, especially if you’re trying to keep up. Microsoft has done something to help reduce the time to get the new offerings up and running. On Windows Azure they provide several pre-configured images to allow you to get started using the […]

When SQL Server 2008 was released, two of the features added were Change Data Capture and Change Tracking. Both features are essentially designed to allow users to query a database and determine what data has changed. However, they go about it in two very different ways. Some of the differences are obvious while others are […]

This is part two in a series of extending SSIS for the enterprise with complementary Microsoft products. Specifically, we are going to look at how we can extend an SSIS solution to go through DMZs and firewalls across the Internet to reach and capture data regardless of the SQL Server schema type. In this scenario, […]