While trying to get the information he needed out of various SQL, MySQL and Oracle environments, Michael finally got tired of endlessly flicking through reference manuals and having to work so hard just to formulate his queries. So he decided to build a cross-platform Query Template solution to make his life easier, and he even went as far as building a .NET control to be integrated into applications. He's been kind enough to share the control, and the theory behind it, with us.

Introducing Microsoft’s Platform for Complex Event Processing

by Additional Articles

SQLServerCentral

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.

Sharepoint Growth is Good

by Steve Jones

SQLServerCentral.com

Editorial - MP3

Sharepoint is a product that many IT people despise, but it's a popular seller for Microsoft. Steve Jones thinks that Sharepoint's growth is a good thing for DBAs as well.

Sharepoint Growth is Good

by Steve Jones

SQLServerCentral.com

Editorial - WMV

Sharepoint is a product that many IT people despise, but it's a popular seller for Microsoft. Steve Jones thinks that Sharepoint's growth is a good thing for DBAs as well.

Sharepoint Growth is Good

by Steve Jones

SQLServerCentral.com

Editorial - iPod

Sharepoint is a product that many IT people despise, but it's a popular seller for Microsoft. Steve Jones thinks that Sharepoint's growth is a good thing for DBAs as well.

A Neural Network in SQL Server

by Silvia Cobialca

SQLServerCentral.com

SQL Server

Modeling and programming a neural Network in SQL Server from new author Silvia Cobialca. Learn how you might be able to implement this AI construct in SQL Server to make predictions.

The DBA Dilemma: How Many DBAs Does It Take to Manage an Infrastructure?

by Rodney-Landrum

SQLServerCentral.com

Editorial

Today we have a guest editorial from Rodney Landrum. Rodney and his team of DBAs manage 110 active servers, throughout a regionally dispersed organization. How many DBAs would you expect to be on Rodney's team...?

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.