Today Steve Jones talks about the tipping point of cloud computing.

Purging Old Database Mail Items

by Additional Articles

Database Journal

Database Mail

Are you purging the old database mail items stored in msdb? In this tip, Greg Larsen shows you how to purge database mail.

Interviews: What is ACID?

by Steve Jones

SQLServerCentral.com

Editorial

While thinking about interviews, Steve Jones shares a story of a job situation he encountered.

Stairway to U-SQL Level 17: Executing U-SQL Jobs with PowerShell

by Mike McQuillan

SQLServerCentral.com

Automate your Data Lake with PowerShell! Learn how PowerShell can be used to execute U-SQL scripts, as well as a few other little tricks.

Investigating the Cause of SQL Server High CPU Load Conditions When They Happen

by Additional Articles

SimpleTalk

Performance

Any DBA who is trying to find the cause of an intermittent problem with a server or database dreams of being able to use a query or procedure take a snap of the relevant variables at the point when the problem occurred. Laerte takes an example of a slow-running query hogging resources to show that you can run queries when a WMI alert is fired, and save the results for later inspection, whenever it happens.

The Library Job Hunt

by Steve Jones

SQLServerCentral.com

Editorial

Find a new career in the library.

Searching and finding a string value in all columns in a SQL Server table

by Additional Articles

MSSQLTips.com

SQL Server

Sometimes there is a need to find if a string value exists in any column in your table. Although there are system stored procedures that do a "for each database" or a "for each table", there is not a system stored procedure that does a "for each column".

Avoiding the Hell of having to Remember DDL syntax

by Phil Factor

SQLServerCentral.com

Editorial

What's your favorite productivity tool when writing SQL? Phil Factor has has flirted with most of them, from templates and snippets to a programmer's clipboard and back again.