Posts Tagged ‘SQL Database’

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 […]

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, […]

As with “All Things Cloud” for the last year or so, Cloud BI is a subject of much buzz. But if you look around, aside from a few niche vendors that have developed Software as a Service (SaaS)  and Platform as a Service (PaaS) BI packages, there’s not a lot of clear information or even thinking. Something close […]

With the July updates to Windows Azure, some great enhancements have been made to SQL Database. I already talked about one of the great features, “Automated SQL Export.” So now I’ll let you know about another great feature, “Premium Databases.” Since the “Premium” feature is a preview feature you will need to specifically sign up […]

Over the past few years, I have had the privilege of working with some of the world’s largest companies in a variety of industries. One thing in common with all of these engagements was using SQL Server Integration Services (SSIS) as the tool of migrating data for the companies’ business intelligence collateral. I have developed […]

With the July updates/enhancements of Windows Azure some changes have been made to SQL Database. In this article I’m going to talk about Automated SQL Export. Previously you had to manually export your database for backup. Now you can automate the export/backup schedule. If you need a Windows Azure subscription here is the link for […]