(Michael K. Campbell) Among other things, the SQL Server Agent provides SQL Server with a job scheduling engine (i.e., a daemon or bot) that can be used to schedule the execution of various tasks. Practically speaking, there are a number of different kinds of jobs that can executed on a given SQL Se

(David Dye) SSIS has a web service control flow task that allows you to call a web service and store the results. This can be very useful if you need to call data from a web service that will be stored in an OLTP or OLAP database.

(Daniel Farina) You have a pooring performing SQL Server query. After extensive research you find a KB article that describes the issue as a Query Optimizer bug. You download and apply the hotfix, but nothing seems to happen. In this tip we look at the possible issues and how to solve optimizer issu

(blakhani) While launching SQL Server Configuration Manager on one of my machine, I got below error

(Tim Ford) Once upon a time, there was a page verify setting known as TORN_PAGE_DETECTION. While it was a better option for checking for I/O write corruption in Microsoft SQL Server than nothing, it only served to do a lackluster job.

(Greg Robidoux) As the cloud becomes more and more widely used and the options for SQL Server continue to evolve, more SQL Server shops are looking at using cloud based services such as Azure and Amazon as a valid option for their high availability (HA) failover clustering and offsite disaster recov

(James Serra) You might be reading a lot about Cloud computing and see three acronyms frequently: IaaS, PaaS, Saas. Cloud providers offer their services according to these three fundamental models:

(Mike Walsh) Last Friday a long time employee set fire to the FAA’s Chicago Control Center. You can read about the fire and the 2,000+ flight cancellations that resulted here and here.

(blakhani) Sometimes we are very comfortable and used to with certain things that if they change, we become nervous and uneasy. I have a lovely daughter and she always greets me when I come back home from office. That one “hello” takes away all my worries and I feel alive.

(Don Boxley) A commonly used example of bimodality dates back to the late 19th century, when a storm killed a large number of sparrows. An ornithologist measured and plotted the wingspans of the dead birds and found that the birds killed in the storm had either shorter or longer wings than the media