Last night I was trying to connect to SQL Server Reporting Services (SSRS) using SSMS and got the error Cannot connect to Servername\Instancename followed by additional information: The Reporting Services could not be found. (as shown below).
I figured it out later and could resolve it.. I shall write that in my next blog (tomorrow, Dec 27th 2011)..
— Bru Medishetty
I wanted to wish all readers a Merry Christmas and Happy Holidays. I hope you all are done with gift wrappings and ready to make presents to your dear ones and celebrate this year’s Christmas as good as any Christmas.
On a personal note, this is a special Christmas for me as we set our first Christmas tree in our home. Not much of decoration was done apart from assembling the tree and set the branches apart. I am sharing some of the pics below… (click on the images for larger images)
Though I am a Hindu, I have been celebrating Christmas since a decade or so. We used to go to a local Church on the birthday of Jesus Christ and have a fun filled rest of the day. I wish all readers once again a Merry Christmas and Happy Holidays…
— Bru Medishetty
sys.dm_server_memory_dumps is one of the new dmvs introduced in SQL Server 2008 R2 with Service Pack 1 and is also available in SQL Server 2012. This dynamic management view displays the list of all memory dump files generated by SQL Server storage engine. From what I have read on SQL Server Books Online, this dmv will give the details of the file name, location on the server and the size. I haven’t had a memory dump generated on my personal server, so when queried, this dmv returns no data on my server. (pic below)…
SELECT * FROM sys.dm_server_memory_dumps
In case of any dumps generated at your end, and if the server happens to be SQL Server 2012 or 2008 R2 with SP1, do not forget to run this script..
Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.
— Bru Medishetty