(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 how EF can dynamically generate the SQL for queries, we have many existing views that I would like to be able to continue to use. How can I do this with the

(Buck Woody) This is part two of a tutorial in a series where I’m covering two new features introduced in SQL Server 2008 R2 Called the Utility Control Point (UCP) and the Data Access Component (DAC). In part one, I explained the UCP, since the two features work more or less hand-in-hand, meaning on

(Pinalkumar Dave) This is followup post of my earlier article SQL SERVER – Convert IN to EXISTS – Performance Talk, after reading all the comments I have received I felt that I could write more on the same subject to clear few things out.

(Darren Green) About five years ago I developed my own expression editor control. It first got used in our custom tasks as the MS editor didn’t become available until SQL 2005 SP1, but even then it had some handy features I preferred. For example resizable panes so that if your expression result was

(Brian Swan) The Interoperability team here at Microsoft recently released the SSRS SDK for PHP (SSRS = SQL Server Reporting Services). At the time of the announcement, I was very excited to check out this SDK, but I was so busy that I’ve just recently had a chance to dig in. Since I had only a high

(John Magnabosco) Have you ever restored a database from a production environment on Server A into a development environment on Server B and had some items, such as Service Broker, mysteriously cease functioning? You might want to consider reviewing the database owner property of the database.

We had discussed caching options in SSRS in one of our articles before – here. In today’s post, we are going to look into the cache refresh functionality that has been introduced in R2 version of SQL Server 2008. Prior to R2, if the cache expires and a request is made to render the report, the req

(Andy Novick) SQL Azure provides relational database capability in the cloud. One of the features that is missing is a way to move databases up or down from your in-house SQL server. So how do you move a database schema and data up to the cloud? In this tip I will walk through a utility that will

(Richard Waymire) In the third post about the SQL Server error logs, we examined the CPU, locking, and memory messages. In this fourth post, we’ll examine database startup and recovery.

(Ken Simmons) The DBCC CHECKDB command checks the integrity of the objects in a database and should be run on a regular basis. One thing that this command does not check in databases created in versions prior to SQL Server 2005 is the integrity of the data in the columns until it has been run once w