(Michelle A. Poolet) Big data dudes and dudettes, and those folks who starting to assemble big data stores: Are you faced with issues of how to wrangle database design and data modeling in their big data world?

(Scott Murray) How can I manage and evaluate the performance of my SSRS report server? Do you recommend any native SQL Server tools?

(Jesus Aguilar) In a previous blog post, I described the implementation of full-text search capabilities for your Azure Mobile Services back-end. With the recent availability of Azure Search —search as a service in Azure— I thought it would be useful to revisit the idea and modify it using this cool

(Arshad Ali) Have you ever been in a situation where you needed to write a query that needed to do comparisons or access data from the subsequent rows along with the data from the current row?

(Vinoth N Manoharan) I have summarised basic concepts of In-Memory OLTP from various Microsoft articles which will help you to start up with the basics

(Kenneth Fisher) For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the rest of us who are still dealing with DTS packages I’m going to do a couple of posts on the subject.

(Pinal Dave) Well, if you search for this question on internet, you will find many different answers, today we will see my favorite method to flip value for the bit field.

(Richard_RP) Today I am going to talk about the stored proc sp_executesql and the benefits it has over EXEC @SQL. Microsoft actually recommend that you use the sp_executesql stored procedure instead of the EXECUTE statement.

(Arthur Olcot) Had a quick job the other day restoring a pair of databases under different names which is all straight forward enough, but each database in the pair uses quite a few synonyms to access objects in the other database.

(Feodor Georgiev) The Project Deployment Model introduced in SSIS 2012, which was explained in the first part of this series, speeds up the deployment of database projects in which there may be hundreds of SSIS packages per project. Not only that, but deployments can be configured differently for ea