Count the Number of Occurrence of Character in a String – SQL Server Challenge

DECLARE @longWord varchar(28)='AntiDisEstablishmentArianism'SELECT CountCharacters =DATALENGTH(@longWord)- DATALENGTH (REPLACE(REPLACE(LOWER(@longWord),'a',''),'i',''))

How to centralize your SQL Server Event Logs.

http://www.sqlservercentral.com/articles/Monitoring/71390/

SQL Azure – Free Technical Documents

Microsoft recently released a set of document that provides guidelines on how to sign up for SQL Azure, how to get started creating SQL Azure servers and databases, how to develop and deploy solutions with Azure, Security Guidelines, Query Troubleshooting, Performance and Scalability, SLA’s, Pricing and so on. Here are the download links for your reference:

Getting Started with SQL Azure

Accounts and Billing in SQL Azure

Developing and Deploying with SQL Azure

Security Guidelines for SQL Azure

Scaling out with SQL Azure

SQL Azure vs. SQL Server

SQL Azure SLA document

Troubleshooting and Optimizing Queries with SQL Azure

Windows Azure Platform Training Kit

What is a deadlock?

Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other’s piece. Each process would wait indefinitely for the other to release the lock, unless one of the user processes is terminated.
SQL Server detects deadlocks and terminates one user’s process.
A livelock is one, where a request for an exclusive lock is repeatedly denied because a series of overlapping shared locks keeps interfering.
SQL Server detects the situation after four denials and refuses further shared locks.
A livelock also occurs when read transactions monopolize a table or page, forcing a write transaction to wait indefinitely.

Two scripts to spell out numbers in words

http://www.sqlservercentral.com/scripts/function/65640/