Free ebook: Introducing Microsoft SQL Server 2012
Ross Mistry and Stacia Misner’s book “Introducing Microsoft SQL Server 2012” is available from Microsoft: http://blogs.msdn.com/b/microsoft_press/archive/2012/03/15/free-ebook-introducing-microsoft-sql-server-2012.aspx Stacia Misner has a whole part of the book dedicated to BI.
Read MoreWhat is the cost of cloudspamming?
Being of curious nature, I wanted to test if spam traffic would affect cloud services in a typical “pay as you go” scenario. I ordered an introductory SQL Azure package from Microsoft with a pay as you go pricing plan. By creating a plain, empty, SQL server instance with a random public access name I managed to get a monthly …
Read MoreHow to: Enable larger reports in Reporting Services
When deploying large reports to SharePoint or Reporting Services from BIDS (Visual Studio) something like the following message might appear: Error 1 System.Web.Services.Protocols.SoapException: There was an exception running the extensions specified in the config file. —> System.Web.HttpException: Maximum request length exceeded. at System.Web.HttpRequest.GetEntireRawContent() at System.Web.HttpRequest.get_InputStream() at System.Web.Services.Protocols.SoapServerProtocol.Initialize() — End of inner exception stack trace — at System.Web.Services.Protocols.SoapServerProtocol.Initialize() at System.Web.Services.Protocols.ServerProtocol.SetContext(Type type, …
Read MoreSQL Server Agent job status web part for SharePoint
I have released a small web part for SharePoint that displays the current status of a SQL Server Agent job as a colored icon and displays status messages as text. The solution and the source code is available at: http://jobstatus.codeplex.com Here is a screenshot of how it might look in a standard SharePoint 2007 team site. Why would anyone want …
Read More