Category: 2011

2011, 2012, BI, Data Warehouse, Visualization3 Comments

2011 End-of-year Microsoft BI Wrap-up

mssqldude

Welcome to the final week of 2011 everyone! I have a couple of really quick loose ends to tie up here in the blogosphere for Microsoft Business Intelligence. Ever since Microsoft acquired Proclarity in 2006, they have shown a real commitment throughout the organization to business intelligence. Microsoft’s investments and focus on democratization of BI and BI for the masses has been a huge success, particularly with self-service for business decision makers and the decision to make BI accessible to Excel and business users. So, that being said, there are just 3 topics that I want to close up on … Continue reading 2011 End-of-year Microsoft BI Wrap-up

2011, BI, Data Management, sql magLeave a comment

Mid-July Updates

mssqldude

I just completed 2 weeks of prep and delivery of my new SQL Server 2008 R2 Security Audit workshop, so I’m catching up on the blogs and other publishing matters this week and next week. In the meantime, I’ve posted a new blog on SQL Server Magazine’s BI blog on using Change Tracking and CDC to reduce ETL load times here and a few updates on Twitter around announcements including a free Philly SQL Server User Group evening session on SQL Server PDW in our Malvern office on August 10: http://twitter.com/mssqldude. I am going to start a SQL Server security … Continue reading Mid-July Updates

2011, BI, VisualizationLeave a comment

Philly Code Camp 2011.1: BI Visualizations

mssqldude

Many thanks to all who came out on a beautiful spring Saturday here in Philly for the 1st of 2 Code Camps in 2011! First – many special thanks to Bill Wolff and the gang @ the Philly.NET user group. What a tremendous job these guys do and the work that they put into the UG and Code Camp is amazing. Second – Here is the link to my presentation on Microsoft BI data visualizations. There are links embedded in the slides that also point you to some of the demos that I showed around the Data Connector for GIS … Continue reading Philly Code Camp 2011.1: BI Visualizations

2010, 2011Leave a comment

Never a Fan of End-of-Year Top N Lists …

mssqldude

End-of-the-year top N lists are silly. The entire concept of a 365 calendar year creates a false sense of tidying-up anyhow and now provides us all with a time to be inundated with top-N lists for the past year. My friends @ TechTarget’s SearchDataManagement.com sent me 3 lists! A top 5, a top 7 and a top 10, making top N truly a variable number. Well, I read through them and I found them interesting, but as I often do with these lists, unsatisfying. For instance: Top BI stories of 2010: No Pentaho or open-source BI in general? And the … Continue reading Never a Fan of End-of-Year Top N Lists …

2011Leave a comment

What 2011 Will Bring in Microsoft SQL Server Land

mssqldude

I am going to continue in this blog, on SearchSQLServer, SQL Magazine BI Blog and Twitter (@MSSQLDUDE) to focus on these core areas that you should watch for in 2011 for those of you that follow Microsoft SQL Server: Oracle integration, best practices, BI visualizations and SQL 11 (Denali). But what are the new investment areas @ Microsoft and new & exciting outside of the classic SQL Server 2005/2008/2011 topics? Let’s focus on these for 2011 because it is clear this is the direction that Microsoft will take us: 1. Cloud Computing (SQL Azure & Windows Azure) 2. Database scale-out and … Continue reading What 2011 Will Bring in Microsoft SQL Server Land