(Arshad Ali) SQL Server Service Broker (SSBS), introduced with SQL Server 2005 and enhanced in SQL Server 2008, allows you to write queuing/message based applications within the database itself. This article discusses SSBS’ important features and how to use it in different scenarios.

(Ray Barley) I’m a DBA and the developers in my organization want to use the Entity Framework (EF) in their applications. While I understand the benefits of EF and the fact that you don’t need stored procedures, we have many existing stored procedures and I would like to be able to continue to use

(Deepak Palkar) In this we’ll continue to discuss how to go about the SQL Server Data Access using various technologies. This post will discuss Microsoft Language Integrated Query, otherwise known as LINQ. I will discuss how it can be used to accomplish the same tasks we have discussed in previous p

(Jason Thomas) One of the most irritating and common requirements that I faced as a developer in SSRS 2005 was when I had to colour words in the same line differently. Even though SSRS 2005 didn’t provide an inbuilt feature to do this, this could always be done by placing the words in different text

(Anu Chawla) In a recent post, we discussed index fill factor and what it is. We want to follow up that post with an explanation of when and why you may want to set a fill factor for an index or change the default fill factor on your instance of SQL Server.

(Matteo Lorini) Out of the box, SQL 2008 comes with 3 pre-canned data collection scripts. However, it is possible to create custom made data collection scripts that are fully integrated with SQL Server Data Management Warehouse. In this tip, we cover the process to create your own collection.

(Anu Chawla) In a recent post, we discussed index fill factor and what it is. We want to follow up that post with an explanation of when and why you may want to set a fill factor for an index or change the default fill factor on your instance of SQL Server.

(Il-Sung Lee and Art Rask) With SQL Server Audit, SQL Server 2008 introduces an important new feature that provides a true auditing solution for enterprise customers. While SQL Trace can be used to satisfy many auditing needs, SQL Server Audit offers a number of attractive advantages that may help D

(Roman Rehak) In past years, one criticism of Microsoft’s business intelligence (BI) offerings has been that while SQL Server Analysis Services (SSAS) was much simpler to use compared to competing products, the company still did not provide a solution to help business users easily pull data together

(Darren Green) The ExecutionValue execution value property and it’s friend ExecValueVariable are a much undervalued feature of SSIS, and many people I talk to are not even aware of their existence, so I thought I’d try and raise their profile a bit.