Posts Tagged ‘SQL Server’

I read an article this week about Big Data. The article is based on a Microsoft survey and states that the most dominate users of Big Data are Sales, Marketing and Customer Support. You can view the full details of the eWeek article here. The obvious interface for a lot of this data would be […]

I often use the SQL Server (MSDB) Database to store and execute SSIS packages.  However, I found it cumbersome to migrate multiple packages back and forth from network locations to the MSDB or from the various environments (DEV, QA, PROD).  So, I created a simple script to generate the dtutil commands necessary to quickly migrate […]

The database centric solutions created by the National Microsoft Business Intelligence Practice often require a sequence of events that must run in a certain order. An example of a sequence of events is loading a data warehouse and there are multiple jobs to do the load that need to occur in a certain order. Often […]

This is the final post in the Twelve Days of Lync’mas series, to see an index of all twelve posts, click here. On the twelfth day of Lync’mas my UC team gave to me: Support for Windows and SQL Server 2012. Introduction Windows Server 2012 and SQL Server 2012 for the 12th day of Lync’mas… […]

This is part three of a twelve post series, to see an index of all twelve posts click here. On the third day of Lync’mas my UC Team gave to me:  three SQL Servers

I am sure you are familiar with the old holiday tune, “The Twelve Days of Christmas.”  My favorite rendition as a child was by John Denver and the Muppets.  We had the record- yes, actual vinyl- and would play it over and over again while decorating the Christmas tree.  Growing up, I never really knew what was […]

Below are step by step instructions that will show you how to install SQL Server 2012 Management Studio Express on a Windows 7 PC client, and also create your very own local SQL Server on a Windows 7 PC.

I was recently introduced to SQL Server 2012 and discovered Data Quality Services (DQS); a new feature of SQL Server 2012.  I wanted to use this blog as an introduction to DQS, define key terms, and present a simple example of the tool.  According to MSDN, The data-quality solution provided by Data Quality Services (DQS) […]

I’m always fascinated by the power of Social to connect people and information quickly. I’m also intrigued by the sense of community that can be driven by social collaboration, and how that community can drive crowd-sourced content curation. Here’s an example of that community collaboration at work.  ZDNet‘s MaryJo Foley published a post yesterday on […]

Although the term “Business Intelligence” has only been around for a couple of decades, the concept of business intelligence (BI) goes back much further, to the early days of data processing. Today, BI describes a category of software tools and business practices used to manage data, providing insight to support better business decision making. Have […]

I’ll be speaking at a brand new cloud & virtualization conference for IT professionals, systems administrators, developers and consultants – Cloud & Virtualization Live!, December 10-14 in Orlando, FL. http://bit.ly/CVSPEAK25 I’ll be presenting the following sessions: · Developing Mobile Solutions with Azure and Windows Phone · Pushing Data to and from the Cloud with SQL […]

Microsoft SQL Server 2012 (Code Name Denali) was just released. It has a new Business Intelligence (BI) edition, a new licensing model, and some new BI features that business users as well as developers should find interesting. Users will be happy to find that Microsoft has moved a step closer to true self service BI […]