(Serdar Yegulalp) SQL injection attacks are the bane of most admins responsible for databases that power Internet-facing sites. All it takes is one publicly-exposed page that doesn’t have its inputs sanitized and you can end up with a trashed database.

(Buck Woody) I’ve been working in a technical career for a very long time. While I’ve never “struck it rich” to the point where I could retire at 25, I’ve done quite well, and have enjoyed my work. I love working with database technology because it allows me to work in so many industries at once, sa

(Ray Barley) I have some SQL Server data that I need to export and load into an Oracle database. In this tip we cover how this can be done with SSIS.

SQL Server will report Msg 833 to the Eventlog (and text to the ERRORLOG file) when I/O requests have taken longer than 15 seconds:

(Pinalkumar Dave) In the recent Query Tuning project, one of the developers who were helping me out in the project asked me if there is any way that he could know how many pages are used by any Index, and if there is any way I could demonstrate the different levels of B-Tree.

(Adam W. Saxton) Every once in a while, I get asked the question about deploying Reporting Services on a Cluster. Usually it is tied to a scale out deployment, sometimes it is not. I just was asked the question again by an engineer in our group. So, I figured I should put this out there to have some

(Jugal Shah) When installing a SQL Server cluster, Services Packs, Hotfixes, etc.. there may be a need to reboot both the nodes for changes to take affect and to reboot the server we have to login to each node which is time consuming. Also, there may be a time when you are not able to login to the s

(Gaurav Srivastava) Below is one of the scenarios, I recently witnessed where a query was failing when executed from SSMS (SQL 2008) on windows client machine. There is no local SQL installation on the machine and had registered a remote SQL Server instance.

If you’ve ever wondered what happens to your queries if you’re not conscientious about creating indexes, then Fabiano Amorim has yet another nugget of Execution Plan wisdom for you. The Query Optimizer’s solution is to use the Nonclustered Index Spool, and we’re about to learn why.

(Arshad Ali) In my last article (SQL Server Service Broker Components – Message Types, Contracts and Queue), I discussed the Initiator, Target, Message Types, Contract and Queue components of SSBS. In this article I will be talking about the Service, Conversation, Conversation group, SEND and RECEIV