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

PowerShell: How to show all of an object's properties and values

I was scratching my head looking at a complex .NET object and wondering how to get all of the values out of it. For example:

Development Office Politics

This is a funny video I haven't published here before; illustrating what happens when the needs of developers butt heads with the policies of sysops and management. This doesn't reflect a single situation or company but generalises what we've all been through at one time or another.

PowerShell: How to search a list of objects with an array of wildcards in PowerShell

I have an array of objects and I want to pull out a set where a property matches any entry in an array of strings: with wildcards. I couldn't find a solution anywhere (or even others having the same issue), so here's the thought process I went through.

ODBC imports crashing SQL Server with exception 0xC0000005

When using Ace.OLEDB to load up files, I was having sporadic problems with the entire SQL Server process crashing with this exception. I believe it's because you shouldn't allow things to run in-process, so I tried to disable it:

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.