SQL Server Education (by the geeks, for the geeks)
Hi Friends, I do encounter this problem a number of times. Its a known bug. Visual Studio 2008 stops responding. When you leave a SQL Server 2008 Analysis Services-based database project …
Visual Studio 2008 stops responding when you leave a SQL Server 2008 Analysis Services-based database project idle for some time Read MoreHi Friends, There could be times when your SCSI tape drive not detected by SQL Server Management Studio. Even when the device is working successfully and you can see that in …
SCSI tape drive not detected by SQL Server Management Studio Read MoreHi Friends, In my previous post, I showed how you can backup your Analysis Services database using SQL Agent job and XMLA. In this post, I shall show you how you …
SQL Server: Scheduling OLAP Database backup using Integration Services – Part II Read MoreHi Friends, Backing up an Analysis Services database is one of the easiest things you can do while managing your OLAP databases. It is indeed very straight forward. Log on to …
SQL Server – Backing up Analysis Services Database automatically – Part 1 Read MoreSSRS 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” …
SQL Server: SSRS 2008- Underlying connection was closed – could not establish trust relationship for SSL/TLS 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 …
Reporting Services Unable to connect to Remote Server in SQL Server 2005 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. …
SQL Server: Which protocol is being used for client-server connectivity in SQL Server? 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 …
SQL Server: Plan Freezing & Plan Guides in SQL Server 2008 – Part III 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 …
SQL Server: Plan Freezing & Plan Guides in SQL Server 2008 – Part II 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 …
SQL Server: A query with an ORDER BY clause cannot be used as a table expression Read More