Cody Konior Senior SQL Server Database Administrator Spider photographer, stand-up comedian, astronomer, and occasional beekeeper.

Apple Keyboard drivers under Windows

If you've installed the Apple Keyboard drivers with AppleKeyboardInstaller.exe (or AppleKeyboardInstaller64.exe) on a PC you'll quickly discover all the function keys are treated as special keys. To get the function keys working normally as you'd expect, it's controlled by a registry key:

Reporting Services crashes with a custom assembly

Yesterday while previewing a report I was having crashes in both the Reporting Services service (rshost) and Business Intelligence Design Studio. I was able to narrow it down to any call that involved my custom assembly code.

System.Security.Permissions.ReflectionPermission

While previewing a SQL Server Reporting Services (SSRS) report today a warning popped up in Business Intelligence Design Studio (BIDS) that access was denied to System.Security.Permissions.ReflectionPermission.

Error 7308 and 7303

While creating a linked server between two SQL Server 2008 x64 instances today, I received this error:

Parallels / VirtualBox using lots of CPU during idle

I recently set up a Parallels virtual machine running SQL Server and noticed lots of CPU usage even during idle. I found that people running VirtualBox had similar problems especially in conjunction with SQL Server.

How to fix obscured text when using scrolling tablix headers

I had a problem today when experimenting with FixedRowHeaders on a Tablix (and setting the static row groups FixedData property, of course). The headers would scroll with the rest of the report down the page, but be obscured by text underneath showing through.

Adding fonts to a running production server

I was adding fonts to a SQL Server Reporting Services (SSRS) server and testing out whether I could get them to show up on reports without rebooting the server.

Sum on groups and case sensitivity issues in Reporting Services

Two issues today.

Scared of supermarkets

It was a great night last night, after taking nearly a year off comedy, and coming back and getting some laughs. I feel super fat on stage, part of the reason I stopped, and I'll have to keep working on that:

Little quirk dealing with For Xml

I've been using For Xml in T-SQL for a long time to concatenate things without really investigating the ins and outs of it.

Reporting Services and the T-SQL Time datatype

Recently I was building a mini-database for personal use and was storing separate fields for Date and Time. It seemed like a good idea until I tried to display the time field in SSRS. I found that:

Obscure SSRS messages

Today as I was updating an embedded T-SQL query into a dataset:

Does T-SQL Between work back to front?

While I would usually use Between StartDate And EndDate properly, today I found one mistake where I'd used it back to front and needed to test if it would work:

Code.NUCase

Another thing I remembered today, is that I rarely use UCase(Fields!Something.Value) in my reports, because prior to 2008 SP1 or SP2 (I forget which), if you called that with a Nothing, it would return a small square character on your reports. If you instead used Fields!Something.Value.ToUpper() you'd get an error or a warning if it was a Nothing, too.

SSMS grey menu items

I've recently been trying out DBForge SQL Complete Express and RedGate SQL Prompt. But after uninstalling them I had grey menu items left over in SQL Server Management Studio 2008. I went through the registry, the file system, and could not find anything left over:

Code.NiceString

I tend to use StrConv(Fields!Field.Value, vbStrConv.ProperCase) a lot in my reports, but am generally unhappy that it forces characters in the middle of words into lowercase too. I recently came across some camelCase strings where I wanted to split the words and preserve acronym capitalisation, while also capitalising the first letter of each word.

Duh moments: Previous(), and Cross Apply

I came across two little learning experiences this week. Here's hoping someone else is stupid enough to make the same mistakes as me and look it up!

Common Dates For Reporting Services And T-SQL (Part 2)

Sometimes I need to get weeks ending on a certain day, like the week ending as if on Tuesday, or Saturday. It's pretty easy in SSRS expressions, but it's not so easy in T-SQL (if you want to account for @@Datefirst which jumbles the week starting date up). But I did finally work it out and have prepared samples below!

Carried Forward Page Totals

Reports that show financial data often require a carried forward amount, or per-page cumulative total, or running total, to show in the header or footer of the report. Reporting Services doesn't have a good (well described) way of handling this, until now. I'm going to lead you through a demonstration on how to make it really work, and some of the pitfalls (and the workarounds) I found along the way.

Porting VB6 Applications To VB.NET

Introduction

I took the lead in porting a small (few thousand lines of code) VB6 application to VB.NET and here are some notes I made during the process, in case they're useful for anyone else.