SQL Server Education (by the geeks, for the geeks)
SSRS 2008- Underlying connection was closed – could not establish trust relationship for SSL/TLS… Hi Friends, In my previous blog, I wrote about SSRS 2005 “unable to connect to remote server” …
Read MoreHi Friends, I was installing & setting up SQL Server 2005 Reporting Services on my new laptop 🙂 – OS being Windows Server 2008 R2. After SSRS 2005 setup, I setup …
Read MoreHi Friends, We all know that there are 4 protocols that can be used to connect a SQL Server instance from a client; namely Share Memory, TCP/IP, Named Pipes & VIA. …
Read MoreHi Friends, This is my 3rd post in this series, “Plan Freezing & Plan Guides”. Last 2 posts can be found here: Part I; Part II; In my last 2 posts …
Read MoreHi All, In my last post, I talked about the basics of Plan Freezing. And i gave an example of a query that gets migrated from SQL 2005 environment to SQL …
Read MoreHi Friends, Assume an Orders table with 2 columns (OrderID, customerID) and we try to write the following query: USE NORTHWIND GO SELECT * FROM (SELECT orderid, customerid FROM dbo.Orders ORDER …
Read MoreHi Friends, Resource Governor is a good feature giving tremendous power and flexibility to DBAs to control resource usage, primarily CPU & Memory. As of this writing, in SQL Server 2008 …
Read MoreHi Friends, I recently delivered a session on SQL Server 2008 plan guides to a bunch of DBAs at my client’s location. This session was very well appreciated by the attendees …
Read MoreHi Friends, I wrote a blog post sometime back where I talked about observing the data cache, database-wise. I showed how you can monitor the amount of memory consumed by the …
Read MoreHi Friends, In a multi-valued, self-conatined subquery, the inner query (also called as the inner select) returns multiple values. The outer query consumes and validates the list of values returned by …
Read More