(Edwin Sarmiento) I was trying to install SQL Server 2008 R2 on a Windows Server 2008 R2 Failover Cluster, but the setup did not complete successfully. Upon further investigation, the issue seems to be caused by a DNS entry that was then fixed by the systems administrator.

(Madhivanan) Continuing on my SQL Server vs MySQL series, we will see how same things can be done differently in SQL Server and MySQL.

(Marcin Policht) In the recent articles published on this forum, we have been presenting new features of SQL Server 2012 Integration Services. Our presentations have been based so far on the Release Candidate 0 (RC0) of the product, offered as a free download since mid-November 2011.

(Buck Woody) Microsoft is working on a new Windows Azure service called “Trust Services”. Trust Services takes a certificate you upload and uses it to encrypt and decrypt sensitive data in the cloud. Of course, like any security service, there’s a bit more to it than that. I’ll give you a quick over

(Pinal Dave) I am very excited to learn that there is a new version of expressor’s data integration platform coming out in March of this year. It will be version 3.6, and I look forward to using it and telling everyone about it. Let me describe a little bit more about what will be so great in expr

(William Sheldon) When business applications with database back ends don’t work as expected, the problem can lie with the application, the database, or something in between. Most application developers are familiar with using the debugger built into Visual Studio to debug application logic.

(HarshDeep_Singh) I ran into a very interesting issue with temp tables recently, when working on a case. The issue description goes something like this. We have an application preparing some SQL statements, and sending them to the SQL Database engine for execution. However, the “issue” is easily rep

(Diana Moldovan) Table Value Functions (TVF) are great if you need to return multiple rows and/or multiple columns, because table valued user defined functions return their result as a table. Since result set acts like a table, you can just return the data or you can join the results to other tables

(Denny Lee) With the upcoming release of SQL Server 2012, the new and cooler way to connect to a PowerPivot workbook within SharePoint is to use Power View which addresses the concept of Self Service Reporting (similar to how PowerPivot addresses Self Service BI).

(Vadivel) We might have heard that always we need to create our CLUSTERED index first then NONCLUSTERED indexes.