Additional Articles

Introducing Microsoft’s Platform for Complex Event Processing

by Additional Articles

Microsoft MSDN

StreamInsight

While typical relational database applications are query-driven, event-driven applications have become increasingly important. Event-driven applications are characterized by high event data rates, continuous queries, and millisecond latency requirements that make it impractical to persist the data in a relational database for processing. These requirements are shared by vertical markets such as manufacturing, oil and gas, utilities, financial services, health care, web analytics, and IT and data center monitoring. Event-driven applications use complex event processing (CEP) technology with the goal of identifying meaningful patterns, relationships and data abstractions from among seemingly unrelated events and trigger immediate response actions.

2009-10-28

2,185 reads

How to identify when a database was restored, the source of the backup and the date of the backup

by Additional Articles

MSSQLTips.com

Backup and restore

After restoring a database your users will typically run some queries to verify the data is as expected. However, there are times when your users may question whether the restore was done using the correct backup file. In this tip I will show you how you can identify the file(s) that was used for the restore, when the backup actually occured and when the database was restored.

2009-10-27

4,162 reads

TechNet Magazine - Oct Q&A

by Additional Articles

TechNet Blogs

DBCC

Unexpected Consistency Checks, Troubleshooting Memory Usage, More from Paul Randal.

2009-10-27

2,044 reads

The Query Optimizer: Date Correlation Optimisation

by Additional Articles

SimpleTalk

Query Optimization

In SQL Server 2005, a feature was introduced that was hardly noticed, but which might make a great difference to anyone doing queries involving temporal data. For anyone doing Data Warehousing, timetabling, or time-based pricing, this could speed up your queries considerably. Who better to introduce this than Query Optimizer expert, Fabiano Amorim?

2009-10-26

3,485 reads

Troubleshooting Reporting Services

by Additional Articles

Database Journal

SQL Server Express

Marcin Policht continues his discussion of implementing Reporting Services on SQL Server 2005 Express Edition. In this article, we will turn our attention to troubleshooting methods that can be employed to identify and resolve problems affecting reporting functionality and performance.

2009-10-26

2,719 reads

Cube Storage: Introduction to Partitions

by Additional Articles

Database Journal

Analysis Services (SSAS)

Join BI Architect Bill Pearson in this introduction to Partitions in Analysis Services 2008. Here we explore partitioning concepts and advantages, and look forward to hands-on practice with partitions in subsequent articles.

2009-10-23

3,760 reads

SQL Server Monitoring Scripts with the DMVs

by Additional Articles

MSSQLTips.com

Monitoring

If you do not have a third party monitoring tool in place, the only way is to constantly monitor SQL Server. To do this without being overly intrusive, we need to rely on the SQL Server DMVs.

2009-10-23

5,101 reads

Calling Stored Procedures from .NET Applications

by Additional Articles

SimpleTalk

.Net

Everybody knows how to call stored procedures from a .NET application. Right? But then, how often do you see stored procedures used to their full advantage in database applications? William Brewer goes through some of the basics, but uses PowerShell as the example .NET application, and avoids all mention of Northwind or AdventureWorks!

2009-10-22

5,661 reads