Tracking UAVs with StreamInsight

Here is an interesting scenario:  You are monitoring UAVs in a particular region and you get some intel that correlates to a sector you want to investigate.  How do you paint the target?  How do you find out which UAV is closest to the target?  How do you track all of the UAVs in the…

0

Disappearing ATOM Feeds in SQL Server Reporting Services

One of the great new features of SQL Server 2008 R2 Reporting Services is the “Export to ATOM Feed” icon on the Report Viewer Toolbar.   With it, you can download the underlying data from a report in ATOM format and use it as an input source to another application; PowerPivot, for example.  See MSDN…

1

Extending Policy Based Management to earlier editions

SQL Server 2008 introduced the policy based management (PBM) feature which allows DBAs to create policies in SQL Server Management Studio (SSMS) to manage database entities.  These entities can be the SQL instance, databases, and SQL objects.  These set of policies can be evaluated in four different modes: –          On Demand  – where the is…

0

Tracking Changes in SQL Server

Microsoft offers two mechanisms for tracking changes:  Change Data Capture (CDC) and Change Tracking.    CDC is an asynchronous process which captures the exposed data from the Transaction log.  It not only captures the fact that data changed but it captures the actual data that changed.  It uses the same log reader as the Transactional Replication….

0

Updated SQL Server Protocol Specifications

Microsoft has committed itself to releasing product protocols through its’ Open Specifications program. To that end, the SQL Server team just released updates to 25 existing and new specifications on June 29th, 2010. These are a free download. Here is the list:   1.     Microsoft Complex Event Processing Engine Manageability Protocol Specification 2.     SharePoint Web…

0

System Center vs Application and Multi-Server Management?

The management of SQL is often performed  by different skillsets so there are tools for each audience.   It is not a question of System Center vs Application and Multi-Server Management (AMM) but rather what is your role and selecting the proper tool for that given role.  Both tools serve in the management of SQL.  System…

1

Breaking Down Microsoft BI

I get a lot of questions around what is Microsoft Business Intelligence and I wanted to explain the answer from several perspectives.  First, Microsoft BI is not a product, it is a set of capabilities delivered through core technologies that empower all of the users across your enterprise to deliver results.  From a technology perspective it is…

0

Federal Complex Event Processing Applications

SQL 2008 R2 comes with a new technology called StreamInsight.  StreamInsight is a development platform that allows you to develop complex event processing applications.  Its .NET Framework-based architecture allows you query high-throughput event streams as they happen without the need to store that data.  Typical uses for StreamInsight include manufacturing applications, financial trading applications, web…

0

Sync Frameworks versus Replication

There is often confusion as to when to use Sync Frameworks or Replication.  Sync Frameworks can be used to synchronize data stores whether they are databases or even a file store whereas replication is about synchronizing SQL databases.  These two synchronization mechanisms also target different audiences.  Sync Frameworks targets the developers and provides more flexibility. …

0

SQL Server R2 Management Studio simplifies multi-server management with dashboards

SQL Server Management Studio (SSMS) now has a new tab called the Utility Explorer which provides DBAs insights into how enrolled instances and data tier applications are using resources such as CPU and memory.  At a glance, a DBA can see the state of a multitude of instances as well as determining if they are…

0