SQL


PS Reference App – PowerShell Cmdlet and About Topic reference app for iOS

My first iOS app is now available in the App Store: PS Reference Pro The PS Reference Pro app is quick reference for PowerShell Cmdlets and About Topics for iPhone and iPad devices. The app includes Cmdlets from Windows PowerShell (4.0, 3.0, and 2.0), Windows Server (2012 R2, 2012, and 2008 R2), SharePoint (2013 and […]

[SharePoint 2010 / SQL Server 2008] Query the SharePoint Object Model from a .NET SQL Server CLR Function

There are times when there is some SharePoint list data that needs to be accessed from a SQL Server query. However, it is unsupported by Microsoft to query the SharePoint Content Database directly and doing so can cause performance or other issues. The question then becomes: How do you query SharePoint data from SQL without […]

[SharePoint 2010] Getting “Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’” When Trying to Connect to SQL from Your Custom SharePoint 2010 Web Parts?

When writing web parts and such for SharePoint 2010 it is common to have the need to access external SQL databases. Since SharePoint 2010 runs with ASP.NET Impersonation enabled (required for many of the web services and social features to work), it will not use the Application Pool user account when logging into SQL. This […]

[SharePoint 2010] SQL Reporting Services Report Builder Cannot Connect in SharePoint Integrated Mode

One thing that I discovered the hard way about SQL Reporting Services running in SharePoint integrated mode is that it DOES NOT SUPPORT HAVING ANONYMOUS ACCESS ENABLED IN SHAREPOINT. After setting up and configuring SharePoint 2010 and SSRS, everything was peachy until I enabled anonymous access on the SharePoint web application. When doing so, SSRS […]

[Windows Server 2008] SQL Linked Server Queries Running Slow

A colleague of mine discovered that many of our linked-server SQL queries were running very slowly on SQL Servers running Windows Server 2008 and Windows Server 2008 R2. Since the linked-server SQL queries ran perfectly on Windows Server 2003 servers, the issue had to be Windows Server 2008+ specific. The culprit ended up being the […]

[SQL Reporting Services 2008 R2] Hide Header, Toolbar, or Parameters When Viewing in SharePoint Integrated Mode

I have a number of instances where SSRS reports are displayed through Page Viewer Web Parts in SharePoint. When doing so, I like to only display the report, not the header, toolbar, or parameters section. You can hide them by appending these query strings to the URL: For example: That’s it. Source John ChapmanHello, I’m […]

[SQL Reporting Services 2008 R2] Enable Remote Errors

When encountering errors with reports on Microsoft SQL Server Reporting Services (SSRS) 2008 and 2008 R2 the generic error message isn’t very meaningful: Thanks to this blog post we have a couple of ways to turn on SSRS Remote Errors. Method 1 – Enable Remote Errors Via SQL Query Connect to the ReportServer database in […]