When using an O/RM, poor performing SQL statements are often not discovered until you (or your DBA) find that a particular query is slowing down your database server. At this point, it becomes hard to identify which piece of application code is causing that SQL to be executed. An interceptor to log slow/failed SQL … Continue reading EF6.x Correlating Poor Performing SQL to Application Code
SQL Server
EF6.1–Workaround Trailing Blanks Issue in String Joins
A semi-common issue that folks hit with Entity Framework is that the in-memory semantics for “relationship fixup” are different than how SQL Server performs joins with regard to trailing spaces in strings. Relationship fixup is the process where EF looks at primary and foreign key values and populates navigation properties when they match. The … Continue reading EF6.1–Workaround Trailing Blanks Issue in String Joins
How to Drop a Database from Visual Studio 2012
Seems like it should be easy right? It depends which SKU of Visual Studio you have… Option 1: SQL Server Object Explorer If you have a SKU of Visual Studio that includes SQL Server Object Explorer (SSOE) then it’s pretty easy. You’ve probably only got this if you parted with some hard earned cash … Continue reading How to Drop a Database from Visual Studio 2012
Emailing an SSRS Report using ReportViewer
Introduction SQL Server Reporting Services (SSRS) is Microsoft’s offering in the reporting space, if you install SSRS as part of a SQL Server install you get a nice web front end through which users can navigate and view reports. But SSRS is not restricted to this online portal style access, reports can be embedded into … Continue reading Emailing an SSRS Report using ReportViewer
Searchable / Dependant Parameters in SSRS
Introduction The idea behind this post came from a question from a colleague, they wanted an SSRS report where they could select from a list of employees but the list could be filtered by searching on the surname (i.e. you enter ‘S’ and it would load a dropdown of all employees whose surname start with … Continue reading Searchable / Dependant Parameters in SSRS
SSRS Custom Code (Expressions, Embedded Code & External Assemblies)
Introduction In this article we will look at the options for using custom .Net code in our Microsoft SQL Server Reporting Services (SSRS) reports. This post assumes you have a working knowledge of SSRS. There are three main ways to use code to help generate our reports, in increasing order of complexity (and therefore flexibility) … Continue reading SSRS Custom Code (Expressions, Embedded Code & External Assemblies)
Horizontally Centred Dynamic Images in SSRS
Centring Dynamic Logos in SSRS This was an interesting problem I ran into the other day, basically I have a report that displays data on a range of businesses. The report then needed a dynamic header to display the logos for each of the businesses that feature in the report. The number of businesses could … Continue reading Horizontally Centred Dynamic Images in SSRS