Articles

External Article

A Unified Approach to Multi-DataBase Query Templates

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.

2009-10-28

1,971 reads

Technical Article

Introducing Microsoft’s Platform for Complex Event Processing

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-10-28

2,185 reads

External Article

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

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

Blogs

PostgreSQL Support in the Data API Builder

By

Next week I’m at VS Live in San Diego (register and join me) and...

Ten Years of PowerShell

By

Ten years ago today, I filmed a Pluralsight Play by Play on open source...

T-SQL Tuesday #202: 100 Hours

By

It’s time for T-SQL Tuesday again and this is a great prompt to start...

Read the latest Blogs

Forums

Squared Values

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Squared Values

I Don't Want To Do XX

By Steve Jones - SSC Editor

Comments posted to this topic are about the item I Don't Want To Do...

Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server

By john.martin

Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...

Visit the forum

Question of the Day

Squared Values

What happens when I run this code in SQL Server 2022? 

SELECT SQUARE('12')

See possible answers